Wiki source for PLG-Csv


Show raw source

===== CSV 2 Table formatter =====
>>==See Also==
~- [[OnegWRNoDefaultCodeClass | NoDefaultCodeClass]] - CSS class workaround.
~- ShowCsv - HandleCsvData - More advanced code by NilsLindenberg.
>>//NOT Included in any Wikka version yet//{{lastedit}}

This formatter converts inline csv data into a table.

==Features==
~- Rows of the table alternate background color
~- Column alignment: left, right, center or default
~- Table headers/footers using wiki style heading markers
~- Add comments in between data by starting a line with (#); blank lines are ignored
~- Cells can be surrounded in double quotes (")
~- It is possible to escape semi-colons with a backslash (\), that should appear in text
~- Camel links in cell text are linked to their wiki internal pages

----

|!|{border: 0px solid white;}||
||{border: 0px solid white;}##""%%(csv)""##||
||{border: 0px solid white;}##"";""##||{border: 0px solid white;}##""==/First Name/==;""##||{border: 0px solid white;}##""==\Last Name\==;""##||{border: 0px solid white;}##""==|Address|==;""##||{border: 0px solid white;}##""== Age ==""##||
||{border: 0px solid white;}##""==Norwegian==;""##||{border: 0px solid white;}##""Sigurd;""##||{border: 0px solid white;}##""Nordmo;""##||{border: 0px solid white;}##""[[Viggo]] Hansteens allé 119\; 1524 MOSS;""##||{border: 0px solid white;}##"" 38""##||
||{border: 0px solid white;}##""==Swede==;""##||{border: 0px solid white;}##"" Chanelle;""##||{border: 0px solid white;}##"" Blomqvist;""##||{border: 0px solid white;}##"" Överhogdal 95\; 282 02 HÖRJA;""##||{border: 0px solid white;}##"" 61""##||
||{border: 0px solid white;}##""==German==;""##||{border: 0px solid white;}##"" Leah;""##||{border: 0px solid white;}##"" Ackermann;""##||{border: 0px solid white;}##"" Landhausstraße 73\; 15702 Königs Wusterhausen;""##||{border: 0px solid white;}##"" 25""##||
||(x:5){border: 0px solid white;}##""# Comments are possible. Yes, the following person is a Hobbit!""##||
||{border: 0px solid white;}##""==Hobbit==;""##||{border: 0px solid white;}##""Celendine;""##||{border: 0px solid white;}##"" "Gam gee";""##||{border: 0px solid white;}##"" ;""##||{border: 0px solid white;}##"" 216""##||
||{border: 0px solid white;}##""%%""##||

""<table><tbody>
<tr bgcolor="#eeeeee"><td> </td><th style="background-color:#ccc;padding: 1px 10px 1px 10px; text-align:right; ">First Name</th><th style="background-color:#ccc;padding: 1px 10px 1px 10px; text-align:left; ">Last Name</th><th style="background-color:#ccc;padding: 1px 10px 1px 10px; text-align:center; ">Address</th><th style="background-color:#ccc;padding: 1px 10px 1px 10px; "> Age </th></tr>
<tr bgcolor="#ffffee"><th style="background-color:#ccc;padding: 1px 10px 1px 10px; ">Norwegian</th><td style="padding: 1px 10px 1px 10px; text-align:right; "> Sigurd</td><td style="padding: 1px 10px 1px 10px; text-align:left; "> Nordmo</td><td style="padding: 1px 10px 1px 10px; text-align:center; "> Viggo Hansteens allé 119; 1524 MOSS</td><td style="padding: 1px 10px 1px 10px; "> 38</td></tr>
<tr bgcolor="#eeeeee"><th style="background-color:#ccc;padding: 1px 10px 1px 10px; ">Swede</th><td style="padding: 1px 10px 1px 10px; text-align:right; "> Chanelle</td><td style="padding: 1px 10px 1px 10px; text-align:left; "> Blomqvist</td><td style="padding: 1px 10px 1px 10px; text-align:center; "> Överhogdal 95; 282 02 HÖRJA</td><td style="padding: 1px 10px 1px 10px; "> 61</td></tr>
<tr bgcolor="#ffffee"><th style="background-color:#ccc;padding: 1px 10px 1px 10px; ">German</th><td style="padding: 1px 10px 1px 10px; text-align:right; "> Leah</td><td style="padding: 1px 10px 1px 10px; text-align:left; "> Ackermann</td><td style="padding: 1px 10px 1px 10px; text-align:center; "> "Landhausstraße 73; 15702 Königs Wusterhausen"</td><td style="padding: 1px 10px 1px 10px; "> 25</td></tr>
<tr bgcolor="#eeeeee"><th style="background-color:#ccc;padding: 1px 10px 1px 10px; ">Hobbit</th><td style="padding: 1px 10px 1px 10px; text-align:right; "> Celendine</td><td style="padding: 1px 10px 1px 10px; text-align:left; "> "Gam gee"</td><td> </td><td style="padding: 1px 10px 1px 10px; "> 216</td></tr>
</tbody></table>""

==Installation==
~- Copy the code below into a file named ##formatters/csv.php##
~- And give it the same file permissions as the other files in that directory.

==Code==
%%(php)
%%

==History==
~- 2005-05-09 Published on main site - OnegWR
~- 2019-09-03 Code clean-up, remove deprecated code, more features, fix bugs - ThePLG

==TODO==
~- text in quotes needs to be preserved e.g., whitespace, no splitting on semi-colons
~- camel links are really hard to see
~- Add more cell formatting options: text/background color, alignment, bold, italic, ...
~- Find a way to implement a "\n" in a cell (every call to ""$this->Format()"" is another include of formatters/wakka.php, so I would like to find another way...)
~- Use more CSS classes

----
CategoryUserContributions
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki