1
With Libreoffice/Openoffice it is rather straightforward to do these steps:
- Import csv file
- Copy macro from another file
- Run macro
- Remove macro
- Save file in csv and xls formats (no macros, just data)
Is it possible to do that on the command line?
Roland Seuhs
Posted 2015-04-26T09:48:27.027
Reputation: 165
Cannot you create an empty file with that macro, adding the export as csv file in the last line of the macro and recall it from command line? Maybe you can find interesting some example on how to access macro by commandline here
– Hastur – 2015-04-26T09:58:36.317@Hastur: I still need the data as input for the macro. – Roland Seuhs – 2015-04-27T06:07:53.787
Can't you save the macro in the "My Macros" container instead of inside the file? That way you could skip the "copy macro" and "remove macro" steps. – Lyrl – 2015-04-28T14:42:20.077
@Lyrl: True - any pure command-line solution will be fine – Roland Seuhs – 2015-04-29T08:38:41.620