libreoffice command line convert to xlsx
 

Hello everyone,

At the command line I'm converting csv files to xlsx files using:

soffice --headless --convert-to xlsx:"Calc MS Excel 2007 XML" thefile.csv

That works great. What I'd like to get a column in the spreadsheet in date format.

Is it possible?

The soffice command doesn't seem to have that many options but a quick search turned up this .. if you try unoconv please let us know how you go.

hmm, i was converting from xls/xlsx to csv, but this is interesting indeed, if i ever want to convert something back to xls or xlsx