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.

Requirements:	No special requirements
Platforms:	Linux
Keyword:	Allows,  Excel,  Libraries,  Microsoft,  Microsoft Excel Files,  One-liners,  Options,  Perl,  Programming,  Xlsperl
Users rating:	0/10