Friday, August 28, 2015

Why markup when you can excel? :)

What-a-concept.. first I write a bit of glue code to make Excel-to-Wiki, now the other way around
This was, however, a bit trickier.
The path followed was to convert wiki markup to HTML and parse HTML table elements to generate Excel.
I am using a fine library called py-wikimarkup which appears to work quite well in the conversion to HTML.

Note that this is now trivially wrapped in a web service that can round trip between Excel and Wiki markup all day long.
If anyone has any interest in the webservice I can post that up here as well.

Wiki To Excel project: https://github.com/venkman69/WikiToExcel

Enjoy!
N
PS: The other direction: http://techybabble.blogspot.com/2015/07/excel-to-wiki-markup.html