in reply to Spreadsheet::ParseExcel Multiple Sheets behaving strangely.


I cannot say what is going wrong. But as a sanity check I created a 246k file with 17 worksheets and it was parsed correctly by your program.

Perhaps, there is some entity on "sheet3" that is causing the problem. Try deleting "sheet3" and run the program again and/or try deleting the sheets preceding it.

--
John.

  • Comment on Re: Spreadsheet::ParseExcel Multiple Sheets behaving strangely.

Replies are listed 'Best First'.
Re: Re: Spreadsheet::ParseExcel Multiple Sheets behaving strangely.
by jbooysen (Initiate) on Jul 23, 2002 at 13:28 UTC
    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.
[reply]

In Section Seekers of Perl Wisdom