wikitoexcel 0.1.7

Convert wiki table markup to excel

WikiToExcel

Use is trivial as shown below:

from wikitoexcel import wikiToExcel
w2e = wikiToExcel(infile="./wikitbl.txt")
# print the html representation of wiki markup
print w2e.getHTML()
# save excel file to out.xlsx
w2e.saveExcel(fileName="out.xlsx")

Options are:

wikiToExcel(wikiContent=<wikistr>, infile=<wikiTextFile>)

Features

wikitoexcel can capture:

• Font styling: bold, underline, strikethrough

• Cell styling: foreground color, background color

• Supports merged cells

• Sheet name is captured as caption of the wiki table

• Multiline cell contents are styled with ‘wrap’ in excel

• span and div elements are converted to their inner text representation

• HyperLinks are addressed in a way that the hyperlink and display text are presented side by side. This facilitates round-trip between exceltowiki and wikitoexcel. Such as: http://yahoo.com Yahoo!

• Support for saving intermediate html representation

wikitoexcel currently cannot capture anything more complex than the above list. Features such as a font styling within a paragraph is not captured.

Notes

If implementing this as a web.py call:

• You can construct a simple HTML form post with a textarea (below assumes textarea name is ‘wikitoexcel’)

• Add the following class

class wikitoexcel():
            def POST(self):
                    formdata=web.input()
                    w2e=wikiToExcel(wikiContent= formdata['wikitoexcel'])
                    sbuf= StringIO.StringIO()
                    w2e.saveExcel(fileObj=sbuf)
                    web.header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
                    return sbuf.getvalue()

Release Notes: 0.1.7

Minor update to handling empty cells or with  . And some cleanup

Release Notes: 0.1.6

Bug found and fixed for creating a worksheet.

Release Notes: 0.1.5

Clean up of setup.py and minor changes

Release Notes: 0.1.4

• Added option to output in inline format using double pipe separator notation vs line by line format.

• Set the package level variable: wikitoexcel.INLINE_FMT=True (default)

• To allow multiline text, a BR tag is replaced for each return character

Release Notes: 0.1.3

Added license file Rewrote parser to retain wikimarkup within cells. This allows an excel user to passthrough wiki markup.

Release Notes: 0.1.2

Packaging was not following best practice of examples within the package.

Release Notes: 0.1.1

Initial Release