XLSperl 0.4

XLSperl module allows you to use Perl "one-liners" with Microsoft Excel files.

SYNOPSYS

XLSperl [options] -e ... file1.xls file2.xls ... fileX.xls
cat file.txt | XLSperl [options] -e ...

Perl "one-liners" have a great many uses for quick data processing tasks, often replacing the UNIX tools grep, sed, and awk. For example, a simple "grep" function can be written as:

perl -lne /pattern/ and print file.txt

which improves on the standard grep function by allowing the extended features of Perl regular expressions to be used.
However, this form of processing is only suitable for data that can be read (or needs to be written) in plain text format. XLSperl lets you use the same commands to process and create Microsoft Excel files, e.g. the following command will "grep" an Excel document:

XLSperl -lne /pattern/ and print file.xls

Usage:

Basic usage of XLSperl is as follows:

XLSperl [options] -e perl_code file1.xls file2.xls ... fileX.xls

Additionally Microsoft Excel files can be piped in to XLSperl

cat file.xls | XLSperl [options] -e perl_code