This question about Using an extension: Asked

ExportXlsBasedOnTableData

I find this plugin poorly documented.

I'd like to be able to export an XLS from a table or table + SEARCH stored in a topic.

This seems to be covered by:
Generate an Excel spreadsheet from a table returned as the result of a FormattedSearch, such that each row in the table corresponds to a row in the resultant spreadsheet.

And documentation:
* Syntax: %TABLE2EXCEL{...}% * Synopsis: Generates an Excel spreadsheet file from the first table found in this topic, such that each row in the table will result in a row of the generated spreadsheet. * Supported parameters:

Parameter: Description: Default: topic="..." Default parameter: The topic at which the spreadsheet is attached Current topic file="..." The name of the generated spreadsheet file (without the extension) Current topic template="..." A form definition (see DataForms); it defines the columns of the table to be generated. Must match column headers of the attached spreadsheet. map="..." The topic which contains additional mapping information between the columns of the table and the columns in the generated Excel file.

And then we have the random note:
You can now skip the creating of a foswiki form. Now the plug-In is able to render every content of an excel file as a Foswiki table without defining a correlated Foswiki form first

However, if I put a table on a page and write %TABLE2EXCEL{...}% next to it I just get an empty spreadsheet.

The documentation is unclear and code somewhat fragile...

QuestionForm edit

Subject Using an extension
Extension ExcelImportExportPlugin
Version
Status Asked
Topic revision: r1 - 05 Feb 2010, MartinCleaver
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy