my $excel_obj = Spreadsheet::ParseExcel->new(); my $workbook = $excel_obj->Parse($outfile); die "Workbook did not return worksheets!\n" unless ref $workbook->{Worksheet} eq 'ARRAY'; for my $worksheet ( @{$workbook->{Worksheet}} ) { print OUT_HTML_FILE "\n"; for my $row ( 0 .. $worksheet->{MaxRow} ) { print OUT_HTML_FILE "\n"; for my $col ( 0 .. $worksheet->{MaxCol} ) { my $cell = $worksheet->{Cells}[$row][$col]; print OUT_HTML_FILE "\n"; } print OUT_HTML_FILE "\n"; # record ends } print OUT_HTML_FILE "
"; print OUT_HTML_FILE ref $cell ? $cell->Value : ''; print OUT_HTML_FILE "
\n"; # worksheet ends }