Skip to main content

Creates OpenDocument Spreadsheets with charts for Microsoft Excel and OpenOffice

Project description

Creates Opendocument Spreadsheets With Charts For Microsoft Excel And Openoffice

See the Code at:

See the Docs at:

See PyPI page at:

ODSCharts will create ods files readable by either Microsoft Excel or OpenOffice.

The format is a very narrow subset of full spreadsheet support. There is no attempt to supply a full API interface:

#. All sheets contain either a table of numbers or a chart object
    - A table of numbers:
        - starts at "A1"
        - row 1 is labels
        - row 2 is units
        - row 3 through N is float or string entries
    - Chart objects are scatter plots
        - Each series is a column from a table
        - Each x axis is a column from a table
./_static/alt_vs_tp_excel.png ./_static/alt_vs_tp_oo.png

What I Know About ODF

  • Matplotlib is very good when you want to publish a chart without the data.
  • Spreadsheets are very good when you want to publish both the chart and the data.
  • I got motivated to make a cross-platform, open-source, python solution to generate *.odf files.
  • OpenOffice reads *.odf files created by Excel much better than Excel reads *.odf files created by OpenOffice.
  • Excel *.odf files are more simple than OpenOffice *.odf files (Excel only partially supports odf)
  • ODSCharts generates *.odf files by reverse-engineering *.odf files created by Excel.

That’s It… That’s pretty much all I know.

Project details

Download files

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

Files for odscharts, version 0.0.6
Filename, size File type Python version Upload date Hashes
Filename, size (95.1 kB) File type Source Python version None Upload date Hashes View
Filename, size odscharts-0.0.6.win32.exe (391.7 kB) File type Windows Installer Python version any Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page