Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
14 lines (6 sloc) 625 Bytes

I often have the problem that I have a table in OpenOffice/LibreOffice, but need to do deeper analysis than the software allows.

So, I wrote this script which generates a series of SQL statements that you can then import into your own database.

Usage is pretty simple: Pipe the ODS file into STDIN, and SQL comes out of STDOUT:

$ python < data.ods | sqlite data.db

Every sheet in your ODS file becomes a table in your DB, the fields are named after the column names (A, B, C, ...)

Note that this is highly experimental and I don't even know if I want to invest more time. Patches are welcome however :D

Jump to Line
Something went wrong with that request. Please try again.