Thursday, July 30, 2015

Excel to Wiki Markup

After some digging, it looks like openpyxl and some slightly unorthodox inspection of the excel file's structure (gleaned from internet searches) offer a way to extract cell and font styling information.
The wiki markup being what it is, still feels like writing on a stone tablet considering tools we have nowadays. To make life slightly more liveable in the wiki world, I wrote a converter that supports the styling information.

Guess what, I am yet to see one excel to wiki converter that maintains the styling information. I know my code has a ways to go, but it is a far better effort than treating it just as data. Seriously, without simple background colors etc, excel sheets just look like matrix. And that thrown into wiki shows up even more ugly.

Anyhoo, cutting to chase, here's the github link: https://github.com/venkman69/ExcelToWiki
And it is also available from PyPi so you should be able to pip install it as well: https://pypi.python.org/pypi/exceltowiki

Enjoy,
N
PS: The other direction: http://techybabble.blogspot.com/2015/08/why-markup-when-you-can-excel.html