search

doy / spreadsheet-parsexlsx

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

Use of uninitialized value error #61

Closed dgiordano closed 8 years ago

dgiordano commented 8 years ago

Dear Experts, I use this module without problems with some files but sometime I encountered this error:

Use of uninitialized value $cell in pattern match (m//) at /usr/local/share/perl5/Spreadsheet/ParseXLSX.pm line 1001. Use of uninitialized value $col in split at /usr/local/share/perl5/Spreadsheet/ParseXLSX.pm line 1004. Use of uninitialized value $row in subtraction (-) at /usr/local/share/perl5/Spreadsheet/ParseXLSX.pm line 1010. Modification of non-creatable array value attempted, subscript -1 at /usr/local/share/perl5/Spreadsheet/ParseXLSX.pm line 410. at /usr/local/share/perl5/Spreadsheet/ParseXLSX.pm line 418

I've attached the problematic file. Can you kindly investigate into this matter? Thanks in advance for your cooperation.

Regards.

doy commented 8 years ago

Fixed in 0.27, thanks!

mzavoloka commented 7 years ago

I'm experiencing it as well:

Use of uninitialized value $col in split at /usr/local/share/perl/5.22.1/Spreadsheet/ParseXLSX.pm line 1015.
Use of uninitialized value $row in subtraction (-) at /usr/local/share/perl/5.22.1/Spreadsheet/ParseXLSX.pm line 1021.
Use of uninitialized value $col in split at /usr/local/share/perl/5.22.1/Spreadsheet/ParseXLSX.pm line 1015.
Use of uninitialized value $row in subtraction (-) at /usr/local/share/perl/5.22.1/Spreadsheet/ParseXLSX.pm line 1021.
zavoloka@ptt-zavoloka:~/dev/tests/xls-parsing$ perl -MSpreadsheet::ParseXLSX -le 'print $Spreadsheet::ParseXLSX::VERSION'
0.27
mzavoloka commented 7 years ago

The module continues to work, but these notifications appear every time I run it with this file: problematic-file.xlsx