NAME¶

   xlsx2csv - convert spreadsheet to CSV(s)

SYNOPSIS¶

   xlsx2csv [ -A [ -N || -J str ] | -o file.csv ] [-f] [-i] file.xls
   xlsx2csv   --help | --man | --info

DESCRIPTION¶

Convert a spreadsheet (all formats supported by Spreadsheet::Read) to CSV (using Text::CSV_XS).

OPTIONS¶

-?

--help

Print short usage and exit.

--man

Print this help using nroff and exit.

--info

Print this help and exit.

-V

--version

Print the version and exit.

-f

--force

Overwrite existing output file.

-A

--all

Output data from all sheets.

Each sheet will go to extra file with name built from output CSV-file and sheet name.

-N

--no-pfx

If specified, dump all will not use output CSV-file but sheet name only.

-J str

--join=str

If specified, output file names under "-A" will join on "str" instead of the default "-".

-o CSV-file

-c CSV-file

--out=CSV-file

Output file name (used only with "--all" and without "--no-pfx").

Default value is derived from XLS-file.

-i XLS-file

-s XLS-file

--in=XLS-file

Allows to specify input xls file.

Default: Last ARGUMENT file that exists.

SEE ALSO¶

Spreadsheet::Read, Text::CSV_XS, xlscat

AUTHOR¶

H.Merijn Brand <perl5@tux.freedom.nl>

COPYRIGHT AND LICENSE¶

Copyright (C) 2008-2024 H.Merijn Brand

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.