Excel Export as TWiki Table Addon

We had a number of tables that were kept as excel spreadsheerts, and I needed a fast way to convert the spreadsheet into a TWiki table.

The attached .bas file is a macro for Microsoft Excel 2000, and I believe earlier versions. To install it:

• Download the file ExportToTwiki.bas
• Start Excel
• In excel choose: Tools -> Macros -> "Visual Basic Editor"
• Right click on "VBA Project (Personal.XLS)"
• Choose "Import File", and import the ExportToTwiki.bas file
• Choose Tools -> References, ensure 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.)
• Exit the window by clicking on the X decoration at the upper right, or use Alt-Q, or choose File -> return to excel.

Because you added this macro to your personal.XLS, it will be available for all the spreadsheets you open.

To export the current spreadsheet in 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.

This macro works for me, your mileage may vary etc. Make sure you look at the file for changes after I have uploaded this in case somebody thinks about playing games.

Add-On Info

• Set SHORTDESCRIPTION = Excel macro to convert Excel spreadsheerts into TWiki table format

Related Topic: TWikiAddOns

-- TWiki:Main.BrankoBange - 06 Jan 2006