search

doy / spreadsheet-parsexlsx

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

Can not parse some files #48

Closed runrig closed 8 years ago

runrig commented 8 years ago

Found a file which is not being parsed by this library. Opens in Excel, and can be parsed by python's xlrd library (maybe you can use that as a guideline here). First issue I found is when 'Target' attributes start with '/' this lib doesn't handle that. Have not worked through all the issues. Trying to attach sample file...is not letting me attach file here. Got file from anonymous ftp: ftp.pjm.com file: /operations/wind-web-posting/2015-hourly-wind.xls (file is really an xlsx file). Issue just started happening for the last few days, and file is updated daily, so hope you can get the file before format changes again.

runrig commented 8 years ago

See commit in my fork.

doy commented 8 years ago

This should be fixed by #46.