Thursday 16 June 2011

Perl Script for Excel File read

How to access excel with perl?

While i was wandering How to read from excel file using perl, I found that it is easy


With perl its very simple to assess excel file.
Excel data will come as array
most simple way to get excel data..........
only 3 line of code.....


#-------------------------------------------------
use Spreadsheet::DataFromExcel;
my $xls_file = Spreadsheet::DataFromExcel->new;
my $xls_data = $xls_file->load( "excel_file.xls" ) or die $xls_file ->error;

#$xls_data is the pointer to the 2D array
#-------------------------------------------------


you have to use Spreadsheet::DataFromExcel.
http://search.cpan.org/~zoffix/Spreadsheet-DataFromExcel-0.0101/lib/Spreadsheet/DataFromExcel.pm