Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I'm working on the same issue. These websites might be helpful:

http://www.linuxjournal.com/content/convert-spreadsheets-csv-files-python-and-pyuno-part-1v2 http://www.jpstacey.info/blog/2014-09-12/exporting-all-libreoffice-worksheets-csv

I'm working on the same issue. These websites might be helpful:This worked for me to convert multiple ODS spreadsheet files with multiple sheets to separate CSV files:

http://www.linuxjournal.com/content/convert-spreadsheets-csv-files-python-and-pyuno-part-1v2 http://www.jpstacey.info/blog/2014-09-12/exporting-all-libreoffice-worksheets-csvConvert ODS to XLSX

libreoffice --headless --convert-to xlsx ./* --outdir ./spreadsheet-xlsx/

Convert XLSX to CSV

cd ./spreadsheet-xlsx/

for i in 2 3 4; do
    for j in $(ls -1 | sed -e 's/\..*$//'); do
    xlsx2csv -s $i $j.xlsx ../spreadsheet-csv/$j-$i.csv
    done
done