Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

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

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