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...