Re: PEAR Spreadsheet_Excel_Writer

Sabine Seipel wrote:

Hi Justin,

You could just write a formula into the cell and view it in Excel. I honestly don't know why you'd need to calculate it yourself if you're writing to an Excel file in the first place.

well I don't want to calucate the financial values (assets etc.) in the application, because I want to use the power of Excel formula. So I only want to know if is possible to read a already written value from a worksheet? when this is possible it would be great, then I could calculate with this value something inside the fourth worksheet... Best regards Sabine

Hmmm, I think I get the gist of what you are asking now. I think you are just confused, maybe. What I would recommend, is that you can write formulas to the worksheet file, and those formulas can reference other cells in the current sheet, or one of the other worksheets. I don't remeber the syntax right now, but any excel book or tutorial website should have an explanation of the syntax in the section on formulas. Jeff Schmidt