used Spreadsheet::ParseExcel_XLHTML instead of Spreadsheet::ParseExcel because of slow speed of ParseExcel.
But ParseExcel_XLHTML shows "Ambiguous use of *{Spreadsheet::ParseExcel::new} resolved to *Spreadsheet::ParseExcel::new a C:/Perl/site/lib/Spreadsheet/ParseExcel_XLHTML.pm lime 107. ... whith the perl code in the SYNOPSIS,
use Spreadsheet::ParseExcel_XLHTML;
my $excel = new Spreadsheet::ParseExcel_XLHTML;
my $book = $excel->Parse('/some/excel/file.xls');
# Cheesy CSV printer...
for my $sheet (@{$book->{Worksheet}}) {
print STDERR "Worksheet: ", $sheet->{Name}, "\n";
for my $i ($sheet->{MinRow}..$sheet->
{MaxRow}) {
print join ',', map { qq|"$_"| }
map { defined $_ ?
$_->Value : "" }
@{$sheet->{Cells}
$i};
print "\n";
}
}
Can anyone tell me how I can fix this problem?
Thanks