Spreadsheets to Mediawiki: Difference between revisions
From artserver wiki
m (Text replacement - "Section::(.*)\" to "Section::$1") |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
==== 2015.05.19 ==== | ==== 2015.05.19 ==== | ||
[[File:Tables.png]] I use wikis quite often for the documentation of different projects. They are quite useful, simple and powerful, but in some specific cases Mediawiki syntax is just horrendous. One of such cases are tables. Therefore I been using Libreoffice to create the sheets/tables and then convert them to Mediawiki syntax using [http://pandoc.org/ | [[File:Tables.png]] I use wikis quite often for the documentation of different projects. They are quite useful, simple and powerful, but in some specific cases Mediawiki syntax is just horrendous. One of such cases are tables. Therefore I been using Libreoffice to create the sheets/tables and then convert them to Mediawiki syntax using [http://pandoc.org/ Pandoc]. | ||
The main trick is to export the sheet to an HTML file. Then you simply have to use [http://pandoc.org/ | The main trick is to export the sheet to an HTML file. Then you simply have to use [http://pandoc.org/ Pandoc] to convert the HTML table to Mediawiki, with the command | ||
<pre> pandoc -f html -t mediawiki sheet.html</pre> | <pre> pandoc -f html -t mediawiki sheet.html</pre> | ||
| Line 29: | Line 29: | ||
[[Date:: | [[Date::2015]] | ||
[[Section:: | [[Section::Code Notes]] | ||
Latest revision as of 13:51, 25 August 2022
Convert Spreadsheets to Mediawiki Tables
2015.05.19
I use wikis quite often for the documentation of different projects. They are quite useful, simple and powerful, but in some specific cases Mediawiki syntax is just horrendous. One of such cases are tables. Therefore I been using Libreoffice to create the sheets/tables and then convert them to Mediawiki syntax using Pandoc.
The main trick is to export the sheet to an HTML file. Then you simply have to use Pandoc to convert the HTML table to Mediawiki, with the command
pandoc -f html -t mediawiki sheet.html
The result will be a Mediawiki table:
{|
|id
|model
|user
|location
|notes
|-
|1
|Mac Pro 2.26
|All students
|Study
|archive machine
|-
|2
|Mac Pro A1481
|All students
|}
2015
Code Notes
... more about "Spreadsheets to Mediawiki"
