Skip to main content

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.


Release Notes: 0.1.6
--------------------
Minor: black was being ignored for bg color as well. Instead of only the fg color

Release Notes: 0.1.5
--------------------
* Added border as default.
* Removed font color from markup when color is black

Project details


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.6.tar.gz (34.7 kB view details)

Uploaded Source

File details

Details for the file exceltowiki-0.1.6.tar.gz.

File metadata

  • Download URL: exceltowiki-0.1.6.tar.gz
  • Upload date:
  • Size: 34.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for exceltowiki-0.1.6.tar.gz
Algorithm Hash digest
SHA256 4b9fbdfc9ba68b0da232745a73a4af5ce382ebebd0eb0bb2a0a21b4f1a72611f
MD5 a0e9258169bb654817b3f2ac3d5aa94d
BLAKE2b-256 d7284283f2adf41d648da0eaf202dca5cc7b3bc0b94559086e903d86e5f19e6c

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page