Help-Site Computer Manuals
Software
Hardware
Programming
Networking
  Algorithms & Data Structures   Programming Languages   Revision Control
  Protocols
  Cameras   Computers   Displays   Keyboards & Mice   Motherboards   Networking   Printers & Scanners   Storage
  Windows   Linux & Unix   Mac

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

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


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. Some 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

The name of each spreadsheet checked is printed followed by any matches. The following is a typical run output


 C:> perl xlsgrep.pl 7:45

 Checking ITTS-GNG-040830.xls

 ./ITTS-GNG-040830.xls : Sheet=Sheet1, Row=12, Col=2, Value=7:45

 Checking ITTS-GNG-040906.xls

 Checking ITTS-GNG-040920.xls

Here all spreadsheets in the current and sub directories were searched for the string '7:45' which was found in the spreadsheet 'ITTS-GNG-040830.xls'.


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.




=head1 CVS ID

$Id: xlsgrep.pl,v 1.4 2004/10/08 22:35:20 Greg Exp $


CVS LOG


 $Log: xlsgrep.pl,v $

 Revision 1.4  2004/10/08 22:35:20  Greg

 - Wrap the open of each spreadsheet in an eval to trap the die

 - Add printing the name of each spreadsheet checked

 - Correct the printing of the column number

 - Added sample run output to POD

 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
Programminig
Wy
Wy
yW
Wy
Programming
Wy
Wy
Wy
Wy