I have had plenty of success both reading and writing excel files using Spreadsheet::Parseexcel and Spreadsheet::WriteExcel. I am currently trying read an excel file that uses macros, but I cant seem to even open it. I am getting the following error:
substr outside of string at C:/Perl/site/lib/Spreadsheet/ParseExcel.pm
+ line 1855.
I looked at the code, but its over my head.
When you open the file in excel you are prompted to either enable the macros or disable...with this file I need to enable them.
Any help would be appreciaited