NAME

xlsgrep.pl - Grep spreadsheet files in the current directory and any subdirectories.

SYNOPSIS

xlsgrep.pl some_regex_pattern

DESCRIPTION

xlsgrep utilises the power of perls regular expressions to search every cell, on every sheet in any spreadsheets files found in the current directory or subdirectories.

There are currently no switches supports. Sum of the standard grep switches can be handled using perls regular expression syntax. The equivalent of the ignore case grep switch (-i) can be applied to pattern by prefixing with (?i) to give (?i)pattern

SEE ALSO

perlre, perlrequick and perlretut man pages for regualar expression details.

Spreadsheet::BasicRead and Spreadsheet:ParseExcel on CPAN

AUTHOR

 Greg George, IT Technology Solutions P/L, Australia
 Mobile: +61-404-892-159, Email: gng@cpan.org

LICENSE

Copyright (c) 1999- Greg George. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

CVS ID

$Id: xlsgrep.pl,v 1.3 2004/10/03 04:58:20 Greg Exp $

CVS LOG

$Log: xlsgrep.pl,v $ Revision 1.3 2004/10/03 04:58:20 Greg - Test of open of spreadsheet and return if failure

Revision 1.2 2004/10/01 10:59:30 Greg - Replaced the die with print to STDERR when you can't open a spreadsheet

Revision 1.1 2004/09/30 12:31:26 Greg - Initial development