Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Converting to csv using libreoffice


I'm using the following command for converting xls or xslx to csv :
libreoffice --headless --convert-to csv [filename] --outdir [path]

Assume that I am xls/xslx created by user in Windows environment and sometime has the has date-time written by user like this : dd/mm/yyyy.

When I convert to csv I get the date format change to mm/dd/yyyy. How can avoid it, isn't it possible just to spit out the xls/xslx data as the same string to the csv with interpreting date-times?