dumpSS.pl - Sample application to dump the entire contents of a spreadsheet
dumpSS.pl some_spreadsheet.xls
Print the sheet name, surrounded by '***' followed by the the contents of each row printed on a single line with the pipe character '|' as a separator between each cell.
Note: There is nothing special done here to cater for pipe characters in the contents of a cell.
Spreadsheet::BasicRead and Spreadsheet:ParseExcel on CPAN
Greg George, IT Technology Solutions P/L, Australia Mobile: +61-404-892-159, Email: gng@cpan.org
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.
$Id: dumpSS.pl,v 1.1 2004/09/30 10:22:13 Greg Exp $
$Log: dumpSS.pl,v $ Revision 1.1 2004/09/30 10:22:13 Greg - Initial development as a CPAN example
To install Spreadsheet::BasicRead, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Spreadsheet::BasicRead
CPAN shell
perl -MCPAN -e shell install Spreadsheet::BasicRead
For more information on module installation, please visit the detailed CPAN module installation guide.