Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Creates OpenDocument Spreadsheets with charts for Microsoft Excel and OpenOffice

Project Description

ODSCharts For Microsoft Excel And OpenOffice

ODSCharts creates Opendocument spreadsheets (*.ods files) with scatter charts that either Microsoft Excel or OpenOffice can open and manipulate.

See the Code at: https://github.com/sonofeft/ODSCharts

See the Docs at: http://odscharts.readthedocs.org/en/latest/

See PyPI page at:https://pypi.python.org/pypi/odscharts

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

Click images to see full size

What I Think I Know

  • 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.
  • Python is a great general-purpose programming language for science and engineering
  • Therefore the world needs a cross-platform, open-source, python solution to generate cross-platform, open-source spreadsheet files.

What I Know About ODS

  • *.ods files are cross-platform, open-source spreadsheet files.
  • OpenOffice reads *.ods files created by Excel much better than Excel reads *.ods files created by OpenOffice.
  • Excel *.ods files are more simple than OpenOffice *.ods files (Excel only partially supports ods)
  • It makes sense to reverse-engineer Excel-generated *.ods files as cross-platform, open-source spreadsheet files.
  • ODSCharts generates *.ods files by reverse-engineering *.ods files created by Excel.

That’s It… That’s how ODSCharts was born.

Release History

Release History

This version
History Node

0.0.11

History Node

0.0.10

History Node

0.0.9

History Node

0.0.8

History Node

0.0.7

History Node

0.0.6

History Node

0.0.5

History Node

0.0.4

History Node

0.0.3

History Node

0.0.2

History Node

0.0.1

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
odscharts-0.0.11.win32.exe (429.3 kB) Copy SHA256 Checksum SHA256 any Windows Installer Oct 8, 2015
odscharts-0.0.11.zip (104.7 kB) Copy SHA256 Checksum SHA256 Source Oct 8, 2015

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting