Convert Excel to Wiki while maintaining formatting
Project description
ExcelToWiki
-----------
Use is trivial as shown below::
>>> from exceltowiki import excelToWiki
>>> e2w = excelToWiki("./test.xlsx")
>>> # print sheet names in the excel workbook
>>> print e2w.sheetnames
>>> # print wiki text for sheet named Sheet1
>>> print e2w.getSheet("Sheet1")
>>> # print wiki text for entire workbook
>>> print e2w.getWorkbook()
Options are::
>>> exceltowiki(excelworkbook, [list of sheet names to process], caption foreground color, caption background color)
Caption is the sheet name.
Features
--------
exceltowiki can capture:
- Font styling: bold, underline, strikethrough
- Cell styling: foregroudn color, background color
- Sheet features: merged cells are captured, sheet name is captured as caption to the wiki table
exceltowiki currently cannot capture anything more complex than the above list. Features such as 'format as table', conditional formatting, and other advanced items are not inspected or captured. For these, only the data value in the cells will be captured.
-----------
Use is trivial as shown below::
>>> from exceltowiki import excelToWiki
>>> e2w = excelToWiki("./test.xlsx")
>>> # print sheet names in the excel workbook
>>> print e2w.sheetnames
>>> # print wiki text for sheet named Sheet1
>>> print e2w.getSheet("Sheet1")
>>> # print wiki text for entire workbook
>>> print e2w.getWorkbook()
Options are::
>>> exceltowiki(excelworkbook, [list of sheet names to process], caption foreground color, caption background color)
Caption is the sheet name.
Features
--------
exceltowiki can capture:
- Font styling: bold, underline, strikethrough
- Cell styling: foregroudn color, background color
- Sheet features: merged cells are captured, sheet name is captured as caption to the wiki table
exceltowiki currently cannot capture anything more complex than the above list. Features such as 'format as table', conditional formatting, and other advanced items are not inspected or captured. For these, only the data value in the cells will be captured.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
exceltowiki-0.1.3.tar.gz
(34.5 kB
view hashes)