Headless convert html to xls AND name worksheet

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

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

  1. 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.

use OS functions, like mv/move.