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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

exceltowiki-0.1.2.tar.gz (34.5 kB view details)

Uploaded Source

exceltowiki-0.1.1.tar.gz (34.2 kB view details)

Uploaded Source

File details

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

File metadata

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

File hashes

Hashes for exceltowiki-0.1.2.tar.gz
Algorithm Hash digest
SHA256 6dbd48c77a64ac91ff444312a50649300e9b39ede9e9feadb53da53d6b7369a9
MD5 f6c693d50dcb1c0534333d825220322e
BLAKE2b-256 3f74209efb88229748dc85c356614fe5ef67e107cd36d2d986fe5e05dc5c2d75

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for exceltowiki-0.1.1.tar.gz
Algorithm Hash digest
SHA256 a5c69b68bc48b7b97a2e38333791eef397074d9a856aceb5450916b92d9ba8d5
MD5 7b8b4dee509bebc7650911da2fc5ed84
BLAKE2b-256 1daac3fadc7211b29d3250995e327bd6cb9e7332469c941d94dd9fe03f518dd0

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