I’ve created several html files in a legacy application that I’m able to nicely convert automatically with libreoffice thanks to the --headless and --convert-to options.
My syntax is:
scalc --headless --convert-to xls
[my_html_file.htm]
Works great!
I want to take this one step further by combining various files produced in this way with gnumeric’s ‘ssconvert’ or with Perl (or anything else that works nicely … I’d love a suggestion!).
Each program I’ve attempted balks at my worksheet data. The worksheets are all named ‘Sheet1’ --all the programs I’ve encountered thus far balk at the 2nd file (containing one worksheet called ‘Sheet1’ also).
So … couple of questions:
1 ) Can I do something in the original html file to cause the Worksheet to be named during the --convert-to operation?’
- Failing that … can I run another --headless operation that will change the name of the worksheet? I’ve tried
creating a macro but I’ve had no luck thus far with it (and it may just be a bad macro … I’m new to macros).
Any responses appreciated.