Skip to main content
https://travis-ci.org/sonofeft/ODSCharts.svg?branch=master https://img.shields.io/pypi/v/ODSCharts.svg https://img.shields.io/pypi/pyversions/ODSCharts.svg https://img.shields.io/pypi/l/ODSCharts.svg

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

./_static/alt_vs_tp_excel.png ./_static/alt_vs_tp_oo.png

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.

Metadata

Release files for odscharts 0.0.11

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for odscharts 0.0.11
File Size Uploaded
odscharts-0.0.11.zip 104.7 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for odscharts 0.0.11
File Interpreter ABI Platform
odscharts-0.0.11.win32.exe Details

Total release size: 534.0 kB

Release files / odscharts-0.0.11.zip

Download URL odscharts-0.0.11.zip
Size 104.7 kB
Tags Source
SHA-256 checksum
How to use checksums
0bfc2f71bc0f60ce822d659475651fad78d39a65025b447834069d281694ce16
BLAKE2b-256 checksum
How to use checksums
0d119a152d2700f01625303dc466b8419a35af8e949ba7b3452d15efacb07e3b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release files / odscharts-0.0.11.win32.exe

Download URL odscharts-0.0.11.win32.exe
Size 429.3 kB
Tags Source
SHA-256 checksum
How to use checksums
816f7d8b4387b1bafb1ad1a95938fa697f6f14b3bf19ca87e6bb8e354ac8b82c
BLAKE2b-256 checksum
How to use checksums
7be53d6c8e6640b7c0c4f15fb855e86dee55e626a28fe0a0a025ac8a885135d2
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

0.0.11 This release

2 release files

0.0.9

2 release files

0.0.8

2 release files

0.0.7

2 release files

0.0.6

2 release files

0.0.5

2 release files

0.0.4

2 release files

0.0.3

2 release files

0.0.2

2 release files

0.0.1

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page