Feature Proposal: Ability to export Foswiki table to CSV
Motivation
Allow for non-technical users to export a table to csv format for use with MS Excel or other spreadsheet software
Description and Documentation
Most not technical users like to use Ms Excel for creating any sort of tables, lists.. On any given Foswiki installation there are a large number of tables or forms (especially with Wiki Applications). For them to have the ability to export these tables to an application they are familiar with would be beneficial.
Examples
Impact
Implementation
--
Contributors: PadraigLennon - 27 Apr 2009
Discussion
You should be able to use the
SpreadSheetPlugin to do this, surely? Failing that, selecting a table in a browser and copy-pasting it into Excel probably works.
--
CrawfordCurrie - 27 Apr 2009
I'm thinking more of an export button that could be made viewable in the definition of the Table. Much like the
Edit Table button of ETP. The user would then click on this to export to csv.. How would it be done using the
SpreadSheetPlugin?
--
PadraigLennon - 27 Apr 2009
This can also be accomplished with the
RenderTableDataPlugin Unfortunately it has not been converted to Foswiki yet. And the author has requested that he do the work.
%TABLEDATA{ topic="PageWithTable" format="\"$C2\",\"$C3\",\"$C4\",\"$C5\",\"$C6\",\"$C7\",\"$C8\",\"$C9\"" separator="$n()" }%
--
GeorgeClark - 27 Apr 2009
I came across this by
SimonLatham which uses the
FilterPlugin to accomplish the same result:
TestingGenerationOfCommaDelimitedTextBoxes.
--
AndrewJones - 27 Apr 2009
Isn't this handled by the
ExcelImportExportPlugin? It has the feature to export foswiki tables to excel files (called table2excel). If that is your ambition you shoud give it a try.
--
SvenHess - 04 Jun 2009
Thanks Sven This is probably the best solution.. I like your proposal
ExcelImportExportPluginNoFormsFeature
Thanks to all for the feedback
--
PadraigLennon - 05 Jun 2009
Changing this to
RejectedProposal - seems consensus has been reached that this can already be done by multiple methods.
--
GeorgeClark - 23 Feb 2012