Spreadsheets to Mediawiki

From artserver wiki
Revision as of 12:37, 5 January 2018 by Andre (talk | contribs) (Text replacement - "Section::(.*)\" to "Section::$1")

Convert Spreadsheets to Mediawiki Tables

2015.05.19

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 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"
Cookbook +
Date"Date" is a type and predefined property provided by Semantic MediaWiki to represent date values.
2015 +