Re: PEAR Spreadsheet_Excel_Writer

Sabine Seipel wrote:

Hi, I create four worksheets which I use for financial data which come from $_POST..within three worksheets I used writeFormula() to calculate something. in the fourth I want to sum up one cell from the previous three worksheets concerning assets calucation for a company. exist a Function in the Spreadsheet_Excel_Writer Class which can only read a value from a already filled cell (with write()) inside a worksheet? Ì only found function which could write data to cells, but not read. I would be very happy if anyone could answer!

Well the only thing I can think of, is that if you previously were able to 'write' the value from PHP to the excel file, you have to already have the value. If you already have the file, isn't it kind of round-about to try to read the value from the file? Personally I would just store the values somewhere that you are interested in, and calculate the value later. Or, as someone else suggested, just put a formula into the excel file and let the spreadsheet app do the calculation. Jeff