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-2020 H.Merijn Brand

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