PERL CGI Beginners

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

excel

Dave Digregorio

2004-05-22, 11:32 am

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

Sponsored Links