Hi,
Can anybody tell me how to read an excel file.
I have written a script, it is not working with multi sheets. And also i want to print all workshet present in the excel file.
use Spreadsheet::ParseExcel::Simple;
use strict;
my $xls = Spreadsheet::ParseExcel::Simple->read('file.xls');
foreach my $sheet($xls->sheets)
{
while ($sheet->has_data)
{
my @data = $sheet->next_row;
print "@data\n";
}
}
~Thanks.