export1Add my vote for this tag import2Add my vote for this tag spreadsheet1Add my vote for this tag create new tag
, view all tags

Copy Microsoft Office Table to/from TWiki Table Add-On

Convert Microsoft Office tables or tab-separated files to/from TWiki tables and vice versa


Use this program to copy a table from an office program (or a tabs separated file) to TWiki with some layout functions, or to copy it back from TWiki for simple and fast editing.

To install, download CopyTwiki.zip (attached to this topic), unzip the Windows executable CopyTwiki.exe, and copy the executable to a folder of choice. Run the program to convert tables.


Table Conversion


  • Tables in TWiki format
  • Office applications (OpenOffice.org, MS Office and more)
  • HTML Tables (from the generated view not the source)
  • Tab-separated files


  • TWiki in TWiki format
  • Spreadsheet programs

Usage Version 0.5

  • The Cells to be copied have to be selected.
  • Moving rows or columns: select a row or column at the gray part and move it to the desired location.
  • The mouse menu

To Do

  • PastFromTwiki is not working perfectly:
Copy and Paste
CopyToTwiki Copies the selected cells to paste it to TWiki
Copy Copies the selected cells to paste it to an program with tables
PastFromTwiki Paste a table in TWiki format to CopyTwiki
Past Paste the coped cells from an program with cells
Cut Clears the selected cells
Left Align the selected cells to the left
Right Align the selected cells to the right
Center Align the selected cells to the middle
Bold Makes the text in the cell bold
Itallic Makes the text in the cell italic
Clean Cleans aligning, bold and italic

  • Table setting menu (Select "Table setting" for this menu)
Sort Set sort option on true
Inisort Defines the default sort column
Up of Down Set sort on up or down
Border Define the border of the table
Cell padding ? I don't know what it does...
Cell spacing ? I don't know what it does...
User Sets this option on true
headerbg Defines the background color of the header/footer
databg Defines the background color of the cells
Headerrows Defines amount of headerrows
Footerrows Defines amount of footerrows

Source Code

The Delphi 4 source code is attached, CopyTwikiSource.zip.

The program is written in Delphi 4, so for the time being it works only on Windows, but with wine it will run on Linux. And maybe it is compilable with Lazarus (open source cross-platform Delphi clone) or Kylix on Linux http://www.lazarus.freepascal.org.

Add-On Installation Instructions

  • Download the CopyTwiki.zip from the Add-on page.
  • Unzip CopyTwiki.zip to a folder of choice. Content:
    File: Description:
    CopyTwiki.exe Windows executable

Note: The following instructions are for the administrator who installs the add-on on the server where TWiki is running. As a user you can safely ignore these steps:

  • For an automated installation, run the configure script and follow "Find More Extensions" in the in the Extensions section.

  • Or, follow these manual installation steps:
    • Download the ZIP file from the Plugins home (see below).
    • Unzip CopyMsOfficeTableAddOn.zip in your twiki installation directory. Content:
      File: Description:
      data/TWiki/CopyMsOfficeTableAddOn.txt Add-on topic
      pub/TWiki/CopyMsOfficeTableAddOn/CopyToTwiki.png Screenshot
      pub/TWiki/CopyMsOfficeTableAddOn/CopyTwiki.zip ZIP file containing the executable
      pub/TWiki/CopyMsOfficeTableAddOn/CopyTwikiSource.zip ZIP file containing the Delphi 4 source code
      lib/TWiki/Contrib/CopyMsOfficeTableAddOn.pm Add-on Perl module
    • Set the ownership of the extracted directories and files to the webserver user.

Add-On Info

  • Set SHORTDESCRIPTION = Convert Microsoft Office tables or tab-separated files to/from TWiki tables and vice versa

Add-on Author: TWiki:Main.FrankPauw
Copyright: © 2003-2004 TWiki:Main.FrankPauw
© 2008-2011 TWiki:TWiki.TWikiContributor
License: GPL (GNU General Public License)
Add-on Version: 2011-05-12
Change History:  
2011-05-12: TWikibug:Item6701: Doc improvements; import into SVN -- TWiki:Main.PeterThoeny
27 June 2004: Fix
-inisort notation
16 Jan 2004: Add
-Clean cells
-Title headerrows and footerrows
-Sort notation
-header footer notation
08 Aug 2003: Initial version
CPAN Dependencies: none
Other Dependencies: Windows
Perl Version: N/A
Add-on Home: http://TWiki.org/cgi-bin/view/Plugins/CopyMsOfficeTableAddOn
Feedback: http://TWiki.org/cgi-bin/view/Plugins/CopyMsOfficeTableAddOnDev

Related Topic: TWikiAddOns

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatmd5 CopyMsOfficeTableAddOn.md5 r1 manage 0.2 K 2011-05-12 - 07:03 PeterThoeny  
Compressed Zip archivetgz CopyMsOfficeTableAddOn.tgz r1 manage 234.1 K 2011-05-12 - 07:03 PeterThoeny  
Compressed Zip archivezip CopyMsOfficeTableAddOn.zip r1 manage 241.3 K 2011-05-12 - 07:03 PeterThoeny  
Unknown file formatEXT CopyMsOfficeTableAddOn_installer r1 manage 3.6 K 2011-05-12 - 07:03 PeterThoeny  
Edit | Attach | Watch | Print version | History: r15 < r14 < r13 < r12 < r11 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r15 - 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-2015 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.