Importing results from Excel/CSV into page

Using a special filter format (very akin to the one used in the old Restructured Text) you can now very quickly embed race results from an Excel file into your page.

From Excel, save the file as a Comma Separated Variable file (CSV), which will look a little bit like this:

      "Position","Name","Result"
      1,"Samalya", 9.58
      2,"Abhinabha", 10.01
      3,"Alexey", 10.02

To convert this to a table, just add [CSV][/CSV] tags at either end as shown below:

[CSV]
      "Position","Name","Result"
      1,"Samalya", 9.58
      2,"Abhinabha", 10.01
      3,"Alexey", 10.02
[/CSV]

This creates a table with no border (see first table on right). To add border and padding, use

[CSV border=1 padding=10]
      "Position","Name","Result"
      1,"Samalya", 9.58
      2,"Abhinabha", 10.01
      3,"Alexey", 10.02
[/CSV]

This gives you the second table on the right. Sometimes people use tabs, slashes to separate variables instead of commas.

      [CSV border=1 padding=10 sep=/ ]
      "Position"/"Name"/"Result"
      1/"Samalya"/9.58
      2/"Abhinabha"/10.01
      3/"Alexey"/10.02[/CSV]

This gives you the same result as the second table.

One of the nice things about these CSV tables is the user can sort by column entries by clicking on the header - For example if you clicked on the "Result" header the entries will sort themselves out in order of increasing/decreasing time.