in reply to Re: Spreadsheet::ParseExcel Multiple Sheets behaving strangely.
in thread Spreadsheet::ParseExcel Multiple Sheets behaving strangely.
Thanks!
This is what I think happened:
The xls file contained losts of formulas and reverences between diffent sheets in the same file. Spreadsheet::ParseExcel only reads the value that was previously computed by excel and not the formula itself.
When I used Spreadsheet::ParseExcel::Saveparser that interacts with Spreadsheet::WriteExcel it could not write the formulas to the xls file and I got a mixed up xls file with some of the other sheets data apearing on one sheet.
I supose I must wait for Spreadsheet::ParseExcel to support formulas properly. I wanted to do this in Linux, but now I suppose I must use Win32::OLE.
Thanks again.