Headless convert html to xls AND name worksheet

asked 2018-01-23 22:53:25 +0200

wj_mceachran gravatar image

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?'

2) 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.

edit retag flag offensive close merge delete

Comments

use OS functions, like mv/move.

Mike Kaganski gravatar imageMike Kaganski ( 2018-01-24 05:59:36 +0200 )edit