Perl: the Markov chain saw | |
PerlMonks |
Opening bad Excel filesby Arik123 (Beadle) |
on Feb 21, 2018 at 07:30 UTC ( [id://1209625]=perlquestion: print w/replies, xml ) | Need Help?? |
Arik123 has asked for the wisdom of the Perl Monks concerning the following question: I have an excel file which I need to extract data from. When I open it (with Spreadsheet::XLSX) it reports an empty file - no worksheets. This is not correct. Opening it with Excel itself shows that there is data. The problem might be that the file wasn't created by Excel itself - it may have been created by another program, which pretends to create 100% compatible Excel files. Is there any way to convert such files to valid Excel files, or is there another Perl module that can open and process them? I need a permanent solution, to process many such files automatically. The file can be found here: https://ufile.io/f06gn Thank you very much!
Back to
Seekers of Perl Wisdom
|
|