xlsx2csv - convert spreadsheet to CSV(s)
xlsx2csv [ -A [ -N || -J str ] | -o file.csv ] [-f] [-i] file.xls
xlsx2csv --help | --man | --info
Convert a spreadsheet (all formats supported by Spreadsheet::Read) to CSV (using
Text::CSV_XS).
- -?
- --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.
Spreadsheet::Read, Text::CSV_XS, xlscat
H.Merijn Brand <perl5@tux.freedom.nl>
Copyright (C) 2008-2021 H.Merijn Brand
This library is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.