[Libreoffice-qa] Testing: Exporting multiple spreadsheet sheets -> CSV on the command line

[Robinson Tryon]

On Mon, Dec 9, 2013 at 9:32 AM, Pedro <pedlino at gmail.com> wrote:
> Hi Robinson
>
> If I understand correctly your libreconverter script, the user needs to
> specify the file name, the sheet name and the output name.

That's one way to use this tool, yes.

> I think that the idea to use an automatic (headless) export is that you
> don't need to know the number of sheets and much less the name of the
> Sheets.

Sure. Another way to use the tool is to just pass-in the filename and
a format code, to get out numbered sheets:

$ /path/to/libreoffice/program/python libreconverter.py
many-sheets.xls output-%d.csv

output-1.csv
output-2.csv
output-3.csv
etc..

https://github.com/colonelqubit/libreconverter

> I use a Freeware (for Windows only) named XLS2CSV Converter (by GenX Crowd)
> which simply exports one csv per sheet giving automatic names like
> file1_sheet1.csv, file1_sheet2.csv, etc
> The user just needs to select a file or a whole folder.

Right. That sounds similar to how this tool works. The nice thing
about the libreconverter tool is that it's:
- Cross-platform
- FOSS

So it's quite suited for any power users who ask us for help with this
type of problem

Best,
--R