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
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
No comments:
Post a Comment