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.
  • Comment on Re: Re: Spreadsheet::ParseExcel Multiple Sheets behaving strangely.