When applying the unoconvo and headless mode to do a batch conversion of multiple .ods files to .csv, I am still finding that only the first spreadsheet of an .ods file gets converted. The following are several different combinations I have tried:
libreoffice --headless --invisible --convert-to csv filename.ods
unoconv -f csv filename.ods
Can anyone provide any feedback on what could be the problem?
I figured this out for anyone who needs to know how to do this. Use Gnumeric which is included in the Unbuntu software package and you can use the Linux command line to write:
ssconvert -S --export-type=Gnumeric_stf:stf_csv filename.gnumeric filename.csv
which will convert all spreadsheets to .csv files in the same directory
Thank you for posting back and providing a solution. I’m glad that Gnumeric does that. But it would be nice to find out how to do it in LibreOffice (or report a bug to fix it if is not a deliberate limitation by the TDF developers)
Flash forward to 2020: Unfortunately Gnumeric is no longer always able to convert spreadsheets created with Libre Office 7.x. ssconvert --export-type=Gnumeric_stf:stf_csv sometimes hangs after complaining about unexpected internal content.
I wish unoconv worked reliably (it fails if LibreOffice is currently open with an unrelated document). Hrrmph.