create new tag
, view all tags
It would be cool to be able to export a Twiki table to a CSV file.

-- NateDrake - 15 Dec 2003

Do you mean a simple twiki table (ie using | | | ) ? or a WebForm Table as on this topic, or a set of WebForms like all topics with the same WebForm?

either way, yes, that would be an interesting Plugin, and being able to import a cvs file into a topic to create a pipe based table would be trully cool smile

(i do think this is a plugins idea)

-- SvenDowideit - 16 Dec 2003

Just a simple twiki table (| | |). We currently use simple tables, the TablePlugin, and a search to display a list of tasks for a project. Other people in the company want to see spreadsheets. It is a pain to cut/paste into Excel/OpenOffice. I found a temporary solution by using html2csv (http://coscorrosa.com/programs/cgi/html2csv/), which converts HTML tables to CSVs.

-- NateDrake - 19 Dec 2003

If we're feaure voting here, then 'Me Too'. Just a simple export of the table as a .csv, preserving the header row and appropriately quoting commas and quotes (and with the right content-type, so a spreadsheet can startup automatically if required).

-- CrisBailiff - 24 Feb 2004

Were you aware that you can automatically import tables into Excel from a URL? (i.e. you don't need to go via CSV). I used this extensively in the past in conjunction with the FormQueryPlugin to pull project data into spreadsheets and presentations. I don't know if it can be done in Open Office.

-- CrawfordCurrie - 24 Feb 2004

OpenOffice has a nice feature for getting external data. Insert/external data and past your url. Does not seem to handle https at the moment.

-- OleCMeldahl - 21 Feb 2005

Crawford, how do you do this import from a URL to Excel?

-- ThomasWeigert - 22 Feb 2005

Just paste the URL into the File > Open dialog (it grabs the whole web page). Sometimes, depending on the browser and Windows version I think, you can also copy and paste the table intact.

-- MattWilkie - 22 Feb 2005

Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r10 - 2005-02-22 - MattWilkie
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.