Does anyone know, what is the best way to retrieve text data from an Excel Spreadsheet? I have tried the code below and it returns errors. I can not even get the name of the file to print!
#! usr/bin/perl -w
use strict ;
use Spreadsheet::ParseExcel ;
my $oExcel = new Spreadsheet::ParseExcel::Workbook ;
my $oBook = $oExcel->Parse('Excel/Test.xls') ;
print "File :" , $oBook->{File} , "\n" ;
print "Count :" , $oBook->{SheetCount} , "\n" ;
print "Author :" , $oBook->{Author} , "\n" ;
I
Thanks
David
