NAME
excel2csv - dump all worksheets from an Excel file to CSV files
SYNOPSIS
excel2csv -h
excel2csv --man
rename [ -s ] [ -S ] [ -v ] file.xls [ file2.xls file3.xls ... ]
DESCRIPTION
excel2csv
takes any number of Excel files on the command line, reads them, and dumps each worksheet therein to a separate CSV file, named after the worksheet.
ARGUMENTS
OPTIONS
- -s, --suffix
-
The suffix for the CSV files generated. Default is
.csv
. - -S, --separator
-
The field separator used in the generated CSV files. Default is
;
. - -v, --verbose
-
Print additional information about the operations (not) executed.
BUGS
CSV generation is fudged -- no quoting issues are taken into consideration. SV generation should rely on one of the modules available for the purpose instead.
AUTHORS
Drew Broadley, with contributions from Aristotle Pagaltzis, cleaned up and packaged by Leo Charre.
LICENSE
This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself, i.e., under the terms of the "Artistic License" or the "GNU General Public License".
DISCLAIMER
This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the "GNU General Public License" for more details.