Spreadsheets to Mediawiki: Difference between revisions
From artserver wiki
m (Text replacement - "Section::(.*)" to "Section::$1") |
m (Text replacement - "Section::(.*)\" to "Section::Section::$1") |
||
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/ Pando[[Section::|:]]. | [[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/ Pando[[Section::|[[Section::]]]. | ||
The main trick is to export the sheet to an HTML file. Then you simply have to use [http://pandoc.org/ Pando[[Section::|:]] to convert the HTML table to Mediawiki, with the command | The main trick is to export the sheet to an HTML file. Then you simply have to use [http://pandoc.org/ Pando[[Section::|[[Section::]]] 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> |
Revision as of 13:37, 5 January 2018
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 Pando[[Section::|Section::.
The main trick is to export the sheet to an HTML file. Then you simply have to use Pando[[Section::|Section:: 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_05_19
Cookbook
... more about "Spreadsheets to Mediawiki"