Ask Your Question
0

Convert ODS to CSV from command line

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

cexij 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
0

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

Lupp gravatar image

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

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 https://ask.libreoffice.org/en/questi... and chapter 12.4.6 of "OpenOffice.org 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)": https://forum.openoffice.org/en/forum....
See also: https://ask.libreoffice.org/en/questi... (No specific FilterOptions set here.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 243 times

Last updated: Jan 07