python3 -m venv venv
source venv/bin/activate

pip install odio

>>> import odio
>>> import datetime
>>>
>>>
>>> # Create the spreadsheet.
>>> # Version is ODF version. Can be '1.1' or '1.2'. The default is '1.2'.
>>> # Default for 'compressed' is True.
>>> with open('test.ods', 'wb') as f, odio.create_spreadsheet(f, version='1.2', compressed=True) as sheet:
...
...	# Add a table (tab) to the spreadsheet
... 	sheet.append_table(
...         'Plan',
...         [
...             [
...                 "veni, vidi, vici", 0.3, 5, odio.Formula('=B1 + C1'),
...                 datetime.datetime(2015, 6, 30, 16, 38)]])

>>> import odio
>>>
>>>
>>> # Parse the document we just created.
>>> # Version is ODF version. Can be '1.1' or '1.2'. The default is '1.2'.
>>> with open('test.ods', 'rb') as f:
...     sheet = odio.parse_spreadsheet(f)
>>>
>>> table = sheet.tables[0]
>>> print(table.name)
Plan
>>> for row in table.rows:
...     print(row)
['veni, vidi, vici', 0.3, 5.0, odio.Formula('=B1 + C1'), datetime.datetime(2015, 6, 30, 16, 38)]

>>> from odio import create_text, P, H, Span
>>>
>>>
>>> # Create the text document. The ODF version string can be '1.2' or '1.1'
>>> with open('test.odt', 'wb') as f, create_text(f, '1.2') as txt:
...
...     txt.append(
...         P("The Meditations", text_style_name='Title'),
...         H("Book One", text_style_name='Heading 1'),
...         P(
...             "From my grandfather ",
...             Span("Verus", text_style_name='Strong Emphasis'),
...             " I learned good morals and the government of my temper."),
...         P(
...             "From the reputation and remembrance of my father, "
...             "modesty and a ", Span("manly", text_style_name='Emphasis'),
...             " character."))

>>> import odio
>>>
>>>
>>> # Parse the text document we just created. Can be ODF 1.1 or 1.2 format.
>>> txt = odio.parse_text(open('test.odt', "rb"))
>>>
>>> # Find a subnode
>>> subnode = txt.nodes[2]
>>> print(subnode.name)
text:p
>>> print(subnode.attributes['text_style_name'])
Text Body
>>> print(subnode)
odio.P(' From my grandfather ', odio.Span('Verus', text_style_name='Strong Emphasis'), ' I learned good morals and the government of my temper. ')

pip install tox

tox

git tag -a x.y.z -m "Version x.y.z"
rm -r build
rm -r dist
python setup.py sdist bdist_wheel --python-tag py3
for f in dist/*; do gpg --detach-sign -a $f; done
twine upload dist/*

• Substitute <text:line-break/> for line breaks.

• Finding text should never result in a None.

• Text should appear in the content of a <text:p> element within a cell.

• Where line breaks appear in a text element’s content, they are now replaced by a <text:line-break/> element. This means that line breaks appear in the spreadsheet, whereas before they didn’t.

• Performance improvement: rather than use the xml.sax.saxutils versions of escape and quoteattr I’ve copied them into the source of odio, but removing the code for entities that aren’t needed.

• When parsing a spreadsheet cell of text type, if the value isn’t contained in the attribute, recursively use the next nodes in the element contents.

• Support the boolean type.

• Fix bug where XML attribute values aren’t escaped.

• Use a streaming approach to file processing rather than an in-memory approach. This uses much less memory.

• Bug where a file was closed when it was passed into a create_spreadsheet for ODF version 1.2.

• The file-like object passed into the parse_* and create_* functions are no longer closed when the returned object is closed.

• Support the table:number-columns-repeated attribute.

• Spreadsheet: Python None corresponds to a table-cell with no attributes.

• Automate continuous integration with TravisCI.

• Passes tests with Python 3.5.

• Can now export uncompressed spreadsheets.

• Change read_spreadsheet to parse_spreadsheet.

• Add support for formulas.

• Can now read ODS spreadsheets. See Quickstart section for details.

• The append_row() method now accepts a single sequence type, rather than an arbitrary number of positional parameters.

• API changed so that only the top level odio package needs to be imported. The create_spreadsheet() function is new, and accepts an ODF version string ('1.1', '1.2').

• Fixed links on readme file.

• Renamed OdsOut to Spreadsheet to make things more intuitive.

• Added support for ODF 1.2.

• Make wheel setting 'universal'.

• Initial release, nothing to see yet.