Comma Separated Value (CSV) Tables

  1. Create a spreadsheet using your favorite spreadsheet tool (Microsoft Excel or OpenOffice) and export it as text (CSV) format.  The important thing is that cells should be separated by commas (,) and delimited by double quotes (").
  2. On some wiki page, add mark-up to include the CSV table.  The simplest format is [:attachcsv <csvfilename>:].
  3. Save the page to see an unresolved Attach:<csvfilename> link, which will take you to the file upload page.
  4. Upload the CSV file.
  5. Click the page title link at the top of the upload page to get back to the original page.
  6. View your table as part of the wiki page.

The full-markup is: [:attachcsv <csvfilename>' <table attributes>' :]

Examples:

[:attachcsv test.csv:] - Include the test table in the page.
[:attachcsv test.csv'border=1 cellpadding=3 cellspacing=0':] - Include the test table in the page and render with a thin border around the cells.
[:attachcsv test.csv'class=MyTable':] - Include the test table in the page and apply the "MyTable" CSS class to the table appearance.

For more information about including CSV tables, see http://www.pmwiki.org/wiki/Cookbook/CSVInclude.

<< Pasting Tables From Microsoft Excel | DocumentationIndex | Uploads >>

  edit    upload    history    page-lock    group-lock    admin

Designed and built by Emergency Digital. | Hosted by Steadfast Networks