Ask Your Question

Convert ODS to CSV from command line

asked 2019-01-07 14:32:25 +0100

cexij gravatar image

updated 2020-08-10 22:29:28 +0100

Alex Kemp gravatar image

Hi, im trying to run a simple script in AHK to convert ODS file to SCV one, and i dont understand where to get parameers from..

what would be the correct syntax to convert test.ods to test.csv ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-07 15:38:53 +0100

Lupp gravatar image

updated 2019-01-07 16:29:48 +0100

First of all you need to know that you cannot actually convert ods to csv, but only export one single sheet at a link texttime without its calculating functionality. For cells containing formulae you only have the choice to export the formulae or the results.
Then you need to specify (at least) the field delimiter and the text quotation character, if any.
Start reading and chapter 12.4.6 of " Macros Explained" by Andrew Pitonyak.
As I dont't know how to select the one sheet to export via the commandline, I would prefer to create one special LibO spreadsheet document with a "macro" as a kind of batch processor for the task. By that I can open the files to process, and get full access to them via the API.(E.g. I can export all the sheets one by one to split files.) This batch processor sheet can then in turn be called with a commandline like you find it here (post "by antekg » Mon Dec 04, 2017 5:18 pm)":
See also: (No specific FilterOptions set here.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-07 14:32:25 +0100

Seen: 1,263 times

Last updated: Jan 07 '19