Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You can add options. I'm using LO 4.3.2.2 and the convert-to has the following syntax:

--convert-to output_file_extension[:output_filter_name[:output_filter_options]] [--outdir ouput_dir] files

In the case of converting to csv from xls, like I had to, you would do:

-convert-to csv:"Text - text - csv (StarCalc)":#,#,#,#,# [-outdir ouput_dir] files

The option syntax is found here:

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

The filter option has 5 tokens separated by commas. You HAVE to use all 5 or none. I know semi-colons are 59, so I tried just:

...(StarCalc)":59 -outdir...

and that did not work. If you are not sure what to use for the fifth token, just put a "1", no need for "1/1" or anything like that. I used 59,34,0,1,1 and that worked just fine.

You can add options. I'm using LO 4.3.2.2 and the convert-to has the following syntax:

--convert-to output_file_extension[:output_filter_name[:output_filter_options]] [--outdir ouput_dir] files

In the case of converting to csv from xls, like I had to, you would do:

-convert-to csv:"Text - text - csv (StarCalc)":#,#,#,#,# [-outdir ouput_dir] files

files

The option syntax is found here:

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

The filter option has 5 tokens separated by commas. You HAVE to use all 5 or none. I know semi-colons are 59, so I tried just:

...(StarCalc)":59 -outdir...

and that did not work. If you are not sure what to use for the fifth token, just put a "1", no need for "1/1" or anything like that. I used 59,34,0,1,1 and that worked just fine.

You can add options. I'm using LO 4.3.2.2 and the convert-to has the following syntax:

--convert-to output_file_extension[:output_filter_name[:output_filter_options]] [--outdir ouput_dir] files

In the case of converting to csv from xls, like I had to, you would do:

-convert-to csv:"Text - text - csv (StarCalc)":#,#,#,#,# [-outdir ouput_dir] files

The option syntax is found here:

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options

The filter option has 5 tokens separated by commas. You HAVE to use all 5 or none. I know semi-colons are 59, so I tried just:

...(StarCalc)":59 -outdir...

and that did not work. If you are not sure what to use for the fifth token, just put a "1", no need for "1/1" or anything like that. I used 59,34,0,1,1 and that worked just fine.

So for me:

"C:\Program Files (x86)\LibreOffice 4\program\scalc.exe" -convert-to csv:"Text - txt - csv (StarCalc)":59,34,0,1,1 -outdir "C:\somepath\" "C:\anotherpath\File.xls"