I've been using
csvtools to read data from CSV files. Is there any way to read data directly from a ODS file, to put the data into a LaTeX document?
migrated from stackoverflow.com Jul 8 '11 at 9:29
I don't think there is a LaTeX package for reading ODS (OpenDocument Spreadsheet) files directly. CSV files are text-based are therefore readable and parse-able by (La)TeX. However, ODS are (AFAIK) ZIP-ed XML files, which are a lot more complicated. You need to convert the ODS files first to CSV and then include it as such. This might be possible in the command line. More complex sheets (which don't fit in the CSV format) are not supported I guess.
In general LaTeX and OpenOffice/MS Office do not work well together and you can't simply move freely from one to the other.
[EDIT: removed non-answer] Maybe the way to go would be to use oo/libreoffice or something similar to convert osd to csv first. You can do this on the command line, so build it into scripts etc.
|show 1 more comment|