• NAME
• SYNOPSIS
• DESCRIPTION
• OPTIONS
• SEE ALSO
• AUTHOR
• COPYRIGHT AND LICENSE

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

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