How do I... Convert a spreadsheet into a wiki table
There are two parts to this How do I...Setup Excel Export Macro in MS Excel
| STEP | ACTION |
|---|---|
| 1 | Download the file 'ExportToTwiki.bas' attached to this page |
| 2 | Open Excel |
| 3 | In excel choose: Tools > Macros > "Visual Basic Editor" |
| 4 | Right click on "VBA Project (Personal.XLS)" |
| 5 | Click on "Import File", and import the 'ExportToTwiki.bas' file |
| 6 | Click on Tools > References on the top menu bar. Check that "Microsoft Forms 2.0 Object Library" is checked and click OK. (Note: If there is no "Microsoft Forms 2.0 Object Library" on the list, then click on "Browse" and choose the file FM20.dll, and it should appear. Enabling the Analysis ToolPak? add-in will also make this reference available.) |
| 7 | Exit the window and return to excel |
Converting spreadsheet into a wiki table
| STEP | ACTION |
|---|---|
| 1 | To export the current spreadsheet into TWiki format, type Alt+F8 and choose ExportDBToTWiki? . The exported table is now in the clipboard and can be pasted into the TWiki edit window. |
| 2 | In the Twiki edit window, click on the'Edit Twiki markup' button (it is next to the HTML button and looks like a pick) |
| 3 | Paste the table into the page at the appropriate location. |
| I | Attachment | Action | Size | Date | Who | Comment |
|---|---|---|---|---|---|---|
 txt |
ExportToWiki.bas.txt | manage | 5.5 K | 11 Apr 2009 - 09:51 | SheridanNelmsKeegel | This is the VB script to be imported into Excel to convert your spreadsheet into a wiki table |
Topic revision: r3 - 11 Apr 2009 - 09:51:14 - SheridanNelmsKeegel
Support Web
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
DnD |
|
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback