Learn about DokuWiki
Learn about DokuWiki
Compatible with DokuWiki
This plugin was originally written by Steven Danz. The current version fixes security bugs and incorporates several patches by other contributors.
This is a simple plugin that will display CSV data in table form. The data can either be inline between
<csv> Number,Name,Details 1,Power Man,Blue 2,Red Book,"Yellow, but blue" </csv>
or be read from a file in the media area using
You can also give an HTTP URL to a CSV file instead of an uploaded media file.
If you are planning to use csv files in the media area, you will most likely need to include the .csv file extension in mime.local.conf so you can upload .csv files. Something like this should get you started:
<csv> tag allows for additional options to be specified as well as a file reference.
| || where ||
| ||Format the first <n> rows of data from the CSV as column headers||
| ||Format the first <n> columns of each row as column headers||
| ||Create colspans for each empty (two adjacent commas) cell following a cell with content||
| || The delimiter used between cells. Specify ||
| ||limiting the result set to a certain number of rows||
| ||skipping the given number of rows before output||
| || Allows you to filter the rows. <n> is the column number you want to filter on. The first column is 1. t can either be an |
Cells that include a comma as part of the data are expected to be contained between double quotes, which is the typical behaviour of most systems when exporting .csv files.
Empty lines in the csv file or data are displayed as horizontal separators in the table.
Example for a table using a filter. This will look for values beginning with “P” in the third column. It will show the second line.
<csv hdr_rows=0 filter[g]="P*"> ABC,DEF,GHI JKL,MNO,PQR </csv>
There is a second syntax mode to grab a single value from a CSV. This mode does not support inline CSV data!
<csvval some.csv output=3,1>
In addition to all the options supported in the
<csv> syntax, you have to specify which column and (optionally) which row you want to output.
The HTTP URL can be a shared Google Docs Spreadsheet. The following explains how to export a spreadsheet in CSV format via a URL.
To link to a Google spreadsheet:
Outline of steps adapted from: