Python, OpenOffice: Programmatically Manipulating spreadsheets

You can use PyUNO, a Python library to use UNO API.

Here is a Python example to do some manipulations in a Calc document.