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

%WHATDOESITAFFECT%
edit

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
Topic revision: r9 - 23 Feb 2012, GeorgeClark
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