Search code examples
excelperlxlsparseexcel

Spreadsheet::ParseExcel won't read the file

I have a Perl script that I wrote and ran in windows that reads the contents of a .xls file using Spreadsheet::ParseExcel. When I transfer the xls file and the perl script over to a linux server to run it, it can't read any of the data in the xls file.

I've created an xls file on the linux server using Spreadsheet::WriteExcel and then once it creates a file I can read it in with my other script that uses parse. So essentially if it's created on linux it works, however I can't create a spreadsheet in windows and then drag it over and parse it in linux.

Seems to be some kind of format issue but I'm wondering if there are any workarounds?

Solution

  • It works now. I had tried so many different things and ended up uncommenting something that shouldn't have been. Stupid mistake.