NAME

excel2txt - convert Excel data to delimited text files

SYNOPSIS

excel2txt [options] File1.xls [File2.xls ...]

Options:

-d|-ofs                 Output field delimiter (default is Tab)
-q|--quiet              Do not print any status messages
-o|--out-dir            Where to place output file (defaults to CWD)
-n|--normalize-headers  Normalize column headers (see below)
--help                  Show brief help and exit
--man                   Show full documentation
--version               Show version and exit

DESCRIPTION

For each worksheet within an Excel spreadsheet, creates a delimited file. By default, the output files will use a Tab character as the delimiter. Use the "-d" switch to specify something else.

The output file names will be normalized such that they will consist of only lowercase letters with spaces replaced by underscores and non-ASCII characters deleted. The "-n" option will also apply this transformation the column headers. If there is only one worksheet in an spreadsheet, then the output file will simply be the spreadsheet's name; if there is more than one worksheet, then a separate output file will be created using the spreadsheet's name plus the worksheet's name. In any event where the default output file exists and is of a non-zero size, then a "-1" (or "-2," etc.) will be added until a file name is found that is not in use.

SEE ALSO

Spreadsheet::ParseExcel, http://code.google.com/p/perl-excel2txt/.

AUTHOR

Ken Youens-Clark <kclark@cpan.org>.

COPYRIGHT

Copyright (c) 2005-8 Ken Youens-Clark

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