Showing posts with label how to read excel from perl. Show all posts
Showing posts with label how to read excel from perl. Show all posts

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