[Libreoffice-qa] Testing: Exporting multiple spreadsheet sheets -> CSV on the command line
bishop.robinson at gmail.com
Mon Dec 9 06:48:46 PST 2013
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
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
> 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:
So it's quite suited for any power users who ask us for help with this
type of problem
More information about the Libreoffice-qa