Help:Lists and tables
(→Spreadsheet to wiki table format) |
(→Spreadsheet to wiki table format) |
||
| Line 3: | Line 3: | ||
To convert from spreadsheets such as Gnumeric, MS Excel or OpenOffice.org Calc, go [http://people.fas.harvard.edu/~sdouglas/table.cgi here]. Here you find a perfect converter that gives you wiki syntax back. Just copy the wikitext into the editor and you have your table. | To convert from spreadsheets such as Gnumeric, MS Excel or OpenOffice.org Calc, go [http://people.fas.harvard.edu/~sdouglas/table.cgi here]. Here you find a perfect converter that gives you wiki syntax back. Just copy the wikitext into the editor and you have your table. | ||
You can save a lot of time compared to start formatting your table directly in the editor and this method is suitable to cover a wide range of reqirements. | You can save a lot of time compared to start formatting your table directly in the editor and this method is suitable to cover a wide range of reqirements. | ||
| + | For more special cases, e.g. if you need to conect cells, you need at least some practice with the pipe syntax. | ||
==Pipe syntax tutorial== | ==Pipe syntax tutorial== | ||
Revision as of 10:18, 12 December 2008
The formatting of tables is unfortunately not easy in MediaWiki. Tables are build up with a pipe syntax defining the single rows and cells. Before you start to learn that, please consider the possibility to transform spreadsheet formats to wiki-syntax!
Spreadsheet to wiki table format
To convert from spreadsheets such as Gnumeric, MS Excel or OpenOffice.org Calc, go here. Here you find a perfect converter that gives you wiki syntax back. Just copy the wikitext into the editor and you have your table. You can save a lot of time compared to start formatting your table directly in the editor and this method is suitable to cover a wide range of reqirements. For more special cases, e.g. if you need to conect cells, you need at least some practice with the pipe syntax.
Pipe syntax tutorial
Here you can see an example of wiki-syntax for a simple table and the resulting outcome below it:
{| class="wikitable"
|-
! header 1
! header 2
! header 3
|-
| row 1, cell 1
| row 1, cell 2
| row 1, cell 3
|-
| row 2, cell 1
| row 2, cell 2
| row 2, cell 3
|}
| header 1 | header 2 | header 3 |
|---|---|---|
| row 1, cell 1 | row 1, cell 2 | row 1, cell 3 |
| row 2, cell 1 | row 2, cell 2 | row 2, cell 3 |
 |
sorry: |
This section is still under construction! This article was last modified on 12/12/2008. If you have comments please use the Discussion page or contribute to the article! |
