create new tag
, view all tags

ExcelExportTwikiTableAddOnDev Discussion: Page for developer collaboration, enhancement requests, patches and improved versions on ExcelExportTwikiTableAddOn contributed by the TWikiCommunity.
• Please let us know what you think of this extension.
• For support, check the existing questions, or ask a new support question in the Support web!
• Please report bugs below

A place to discuss: ExcelExportTwikiTableAddOn

I have no intention of further developing this addon, but I can see a nice addition as saving the converted contents of the spreadsheet to the clipboard rather than a file.

-- JohnRouillard - 11 Aug 2003

Neat add-on.

From the usability point of view I'd love to see this:

  • Highlight an excel spreadsheet table or a table in MS-Word
  • Run the convert macro (alt-something)
  • Paste the clipboard content into a TWiki edit box.

For this to work, the macro would need to generate TWiki tables and put it into the clipboard. I do not know if this is possible.

This could be enhanced to a ConvertOfficeTextToTWikiAddOn which understands the basic Word formatting and converts it into the TextFormattingRules. Now, that would be cool smile

-- PeterThoeny - 11 Aug 2003

TobyCabot did something similar for converting MS-Word format to twiki, see MsOfficeIntegration. His approach is three steps, word > xml > twiki, using wvWare, xsltproc and xml transformation sheet of his devising.

-- MattWilkie - 11 Aug 2003

I did run into a wierd deal where Excel cells with word-wrapped text got a hardreturn inserted into the exported TWiki-fied text. Since I am not a VBas expert I had to pull the resulting file into Notepad, search for the char, then substitute a space. Anyway that the macro could be updated to look for these chars? If not, I guess I can figure VBas out.


-- SteveRJones - 14 Aug 2003

Ok, I got industrious tonight and modified the code so that it brute force went through and found every occurrance of a CHR$(10) and substituted a " ". What is our practice - upload the rev'd code into the appropropriate page?

-- SteveRJones - 15 Aug 2003

John, I hope you don't mind - I took your code and modified it as I needed the macro to remove ALT-ENTER chars used to format Excel cells with large amounts of text. Seems some people like to use Excel as their favorite wordprocessor roll eyes (sarcastic)

Anyway, I've rev'd the table, commented the code, and uploaded it as Ver 1.1.

-- SteveRJones - 15 Aug 2003

SteveRJones feel free to add a section to the ExcelExportTwikiTableAdd to track changes to the latest uploaded plugin, and upload the new file over my version.

-- JohnRouillard - 16 Aug 2003

It's great to save time!! e.g. to publish in TWiki and through excel my tasks managed on my PDA with outlook.

-- BenoitFauvel - 18 Aug 2003

I did upload the code and added a rev number. I think I did this Aug 15th, no matter - it's there!

-- SteveRJones - 24 Oct 2003

I added support so that the script recognizes a bold cell, and will put asterisks around the text from the cell as it exports to Twiki.

I uploaded it as Version 1.2.

-- ElliotSchwartz - 04 Nov 2004

There are now three versions attached to the Add-on topic. Better to merge them into one, ExportToTwiki.bas. TWiki version controls attachments, so locally, rename ExportToTwiki1.1.bas to ExportToTwiki.bas, and attach it over ExportToTwiki.bas. Do the same for ExportToTwiki1.2.bas, then remove the two obsolete attachments. Also the topic text can be changed to reflect the latest version.

-- PeterThoeny - 04 Nov 2004

The reverse operation is to ImportTwikiTablesIntoSpreadSheets.

-- WarwickAllison - 15 Apr 2005

I added support so that the script recognizes an italic cell, and will put underscores around the text from the cell as it exports to Twiki. Just because it was so easy to add wink

I uploaded it as Version 1.3.

-- JosMaccabiani - 10 Jul 2005

Jos, thanks for updating the Add-On. I moved all comments from the Add-On topic to this Dev topic.

-- PeterThoeny - 10 Jul 2005

I'm using office xp and the Microsoft Forms 2.0 Object Library does not show up in my tools > references menu. the compiler kept throwing up errors with the DataObject class. I found a tip from Peter Jorgensen that has a fix at http://www.dicks-blog.com/archives/2004/12/02/putting-text-into-the-windows-clipboard/ you can select browse > C:\Windows\System32\FM20.DLL and that will let you include the forms 2.0 library

-- CharlieReverte - 06 Feb 2006

I would like to see this be able to right justify numbers (and if you're really industrious, add commas).

-- DustinWallace - 04 Apr 2006

Is there a similar macro for OpenOffice or StarOffice?

-- DustinWallace - 21 Apr 2006

I was using this today, and made a change to support the conversion of hyperlinks into the TWiki linking markup. This macro works quite nicely. Sometimes, it will add "extra" columns or rows, but re-selecting and deleting (the apparently empty cells) in Excel fixes the problem. I will upload the new version tomorrow (from work).

-- CraigMeyer - 17 May 2006

I added a SHORTDESCRIPTION to the "Add-On Info" section so that this add-on is represented properly in the AddOnPackage topic and query topics. Please feel free to take this into the next release.

-- PeterThoeny - 07 Oct 2006

For an approach that does not rely on installing additional macros in Excel and which should be compatible with OpenOffice and StarOffice (not tested) please see ExcelImportExportPlugin.

-- ThomasWeigert - 07 Oct 2006

Rocky, thanks for publishing a new version. Could you package this as a ExcelExportTwikiTableAddOn.zip file? This is needed since the AddOnPackage topic and query topics have a link to <addon>.zip. All older .bas packages should be hidden, so that there is only one zip file to download.

-- PeterThoeny - 05 Nov 2006

I tried this Addon and it works great when i added it to the xls file. But then i closed that excel workbook and opened another one, and tried to run the macro by pressing Alt+F8 and it was not there. So it seems like every time i need to use this macro in any xls file, i have to open the original file as well (in which i imported the macro) so that the macro becomes available in other open workbooks. Is there a way to import macros globaly across the xls files

-- PrashantRanade - 28 Feb 2007

I was having some issues using version 1.6 of this add-on with my Excel 2003 spreadsheets so I've created an updated version with the following changes/enhancements:

  • fixed issues with merged cells
  • added coloured text conversion
  • added replacement of pipe character (prevent issues in TWiki tables)
  • added handling of strikethrough text
  • tidied variable usage
It's attached as "ExportToTwiki_1v6_mod_ChrisWrigley.bas"

-- ChrisWrigley - 05 Jun 2007

Chris, your version works great. Are you planning to add it to ExcelExportTwikiTableAddOn ?

-- RandyJankin - 12 Feb 2008

I'm running Vista and Office 2007, and a little wrinkle was having to create a personal.xlsm workbook in C:\Program Files\Microsoft Office\Office12\XLSTART. In order to create this file, I had to browse to Excel.exe and Run as administrator, create the file and save as a Macro-Enabled workbook.

-- ByronIgoe - 06 Jun 2008

Thank you GeorgeDias for sharing this enhancement with the community!

Suggestion: There is no need to add a version number to the package name, TWiki versions file attachments where it is possible to access previous versions. The reports in the plugin web assume a .zip package name attached to the add-on topic using the same name as the extension, e.g. download links point to the (currently non-existing) ExcelExportTwikiTableAddOn.zip file. It would be helpful to zip the .bas according to AddOnPackageHowTo. And to avoid confusion, to hide all .bas files attached to the add-on topic.

-- PeterThoeny - 2009-11-24

Can someone please tell me o how to use this. I am able to generate the code. Does that code need to be pasted into to the HTML edit window or the editor. Thanks

-- DarshanBhatia - 2011-10-13

I have not tried this add-on, but it most likely generates TML (TWiki Markup Language), e.g. use the Raw Edit to paste it in.

-- PeterThoeny - 2011-10-13

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatbas ExportToTWiki_1v6_mod_ChrisWrigley.bas r1 manage 5.3 K 2007-06-05 - 09:32 ChrisWrigley Fixed merged cell issues, added some formatting - see comment in topic body
Edit | Attach | Watch | Print version | History: r28 < r27 < r26 < r25 < r24 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r28 - 2011-10-13 - 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-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.