Tags:
import2Add my vote for this tag spreadsheet2Add my vote for this tag create new tag
, view all tags

Excel Export as TWiki Table Addon

If you have a number of tables that you keep as Excel spreadsheets, this macro provides a fast way to convert from Excel to a TWiki table in TML (TWiki Markup Language) format.

Once the macro is installed you can export the current Excel spreadsheet in TWiki format by typing Alt-F8 and choosing ExportDBToTWiki. The exported table is now in the clipboard and can be pasted into the TWiki edit window.

Add-On Installation Instructions

Note: Contrary to many TWiki Add Ons this is not installed on the server but is a macro to be installed in MS Excel.

  • Download and extract the attached ExcelExportTwikiTableAddOn.zip file
  • Start Excel
  • Click on the "Developer" tab and click "Visual Basic Editor" (Note: If there is no Developer menu, open Excel Options and add the Developer menu. (see http://office.microsoft.com/en-us/excel-help/find-help-on-using-the-visual-basic-editor-HA010173655.aspx?CTT=1#BM11 for help). In earlier versions of Excel select the Tools -> Macros -> "Visual Basic Editor" menu option.
  • In the 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, that should do the job of loading it. 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.

-- VictorHora - 2011-07-22

Add-On Info

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

Add-on Author: TWiki:Main.JohnRouillard, TWiki:Main.SteveRJones, TWiki:Main.ElliotSchwartz, TWiki:Main.JosMaccabiani, TWiki:Main.BrankoBange, TWiki:Main.GeorgeDias
Add-on Version: V 1.9, 24 Nov 2009
Change History:
26 Jan 2011: Repackaged Version 1.9 as a zip file
24 Nov 2009: Version 1.9 - Added numerous capabilities, and code comments
20 Aug 2008: Version 1.8 - For merge cells,use of multi-span for rows
05 May 2008: Version 1.7 - Added more formatting support
04 Nov 2006: Version 1.6 - Added hyperlink support
06 Jan 2006: Version 1.4 - Direct export to clipboard; added support for horizontally joined cells
10 Jul 2005: Version 1.3 - Added export of italic cells with underscores
03 Nov 2004: Version 1.2 - Added export of bold cells with asterisks
14 Aug 2003: Version 1.1 - Added ALT-ENTER (hard carriage return) removal code
11 Aug 2003: Initial version
CPAN Dependencies: none
Other Dependencies: Excel
Perl Version: N/A
License: ???
Add-on Home: http://TWiki.org/cgi-bin/view/Plugins/ExcelExportTwikiTableAddOn
Feedback: http://TWiki.org/cgi-bin/view/Plugins/ExcelExportTwikiTableAddOnDev
Appraisal: http://TWiki.org/cgi-bin/view/Plugins/ExcelExportTwikiTableAddOnAppraisal

Related Topic: TWikiAddOns

-- TWiki:Main.BrankoBange - 06 Jan 2006

Topic attachments
I Attachment History Action Size Date Who Comment
Compressed Zip archivezip ExcelExportTwikiTableAddOn.zip r1 manage 4.5 K 2012-01-25 - 22:39 ChrisWerry Version 1.9 repackaged as a zip file. Earlier non-zip versions are still attached to this topic but are now hidden
Edit | Attach | Watch | Print version | History: r25 < r24 < r23 < r22 < r21 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r25 - 2013-10-16 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2016 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.