Hi,
I've used Spreadsheet::ParseExcel on and off for a while, but recently came across a problem that I can't seem to figure out.
I'm trying to parse a workbook with many tabs (worksheets), but only a few of the worksheets are returning valid data.
In particular, I'm not getting values for $worksheet->{MinRow}, $worksheet->{MaxRow}, etc, even though the cells in these sheets are fully populated with data. When I try to access known cells using $worksheet->{Cells}[0][0]->{Val}, no value is returned (NULL). Of the 22 worksheets in the workbook, the first 4 return valid data, but the rest don't.
Could this be a memory problem or a spreadsheet format problem? The workbook I'm parsing has macros and other stuff embedded, but I don't think that should make a difference. Anyone have an idea on how I could troubleshoot this further? Thanks!