OOSheet

Macros can be created as well.

Create the code in Python and then insert the script inside the document to run it as a macro.

OOSheet API was inspired by JQuery. It uses selectors in same way that you would use in OpenOffice.org, with cascading method calls for quick development.

Part of the API was also inspired by Django’s object-relational mapper.

What is new in this release:

• New:
• Support for LibreOffice.
• find() methods searches selection for matching cells.

What is new in version 1.0:

• NEW:
• Iterators for cells, rows and columns.
• MOD:
• Refactor for working with all types of documents.

What is new in version 0.9.7:

• Fix:
• Works with default Python interpreter in Windows Vista.

What is new in version 0.9.7:

• Fix:
• Works with default Python interpreter in Windows Vista.

What is new in version 0.9.6:

• data_array property returns selection's values as 2d-tuple.

What is new in version 0.9.5:

• [FIX] flatten() breaking fields with formulas based on zero values formatted as strings (ex: R$ 0,00).

What is new in version 0.9.4:

• S() now gets user's selection.
• Date format is not automatically set if current format is already a date.

What is new in version 0.9.3.1:

• Fixes packaging problem.

What is new in version 0.9.3:

• [NEW] flatten() method.
• [NEW] sheet and cell protection.

Requirements:

• OpenOffice