doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

col_range() / row_range() and empty sheets #8

Closed rolaf closed 11 years ago

rolaf commented 11 years ago

And my 2nd issue:

Spreadsheet::ParseExcel returns (0, -1) from col_range() and row_range() for empty sheets in a workbook. Spreadsheet::ParseXLSX returns (0, 0) instead which is basically equal to the situation in which cell A1 is present.

Testcase is again https://dl.dropboxusercontent.com/u/80321078/ParseXLSX/ParseXLSX-NA.tgz

How Spreadsheet::ParseExcel behaves: script: test_na_xls.pl (uses spreadsheet NA.xls as input), prints min/max row & column for every sheet

How Spreadsheet::ParseXLSX behaves: script: test_na_xlsx.pl (uses spreadsheet NA.xlsx as input), prints min/max row & column for every sheet

So far I wasn't able to find a workaround for that.

doy commented 11 years ago

Released in 0.09.