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 - This page was cached on 09 Jan 2018 - 11:30.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License