Re: Re: PEAR Spreadsheet_Excel_Writer

On Tue, 13 Jul 2004 22:34:29 +0200 (MEST), Sabine Seipel <s.seipel@gmx.de> wrote: > > 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. > > Hi Jeff, > > yes of course I have the value when I want to write it into a worksheet. But > that's not the point. With this and some other values I calculate with > writeFormula() some financial results inside three worksheets. each > worksheet represent a company quarter asset. with the last worksheet (and > genereal overview of the complete year) I want to sum up these values which > I already calculate with wirteFormula(). you understand? instead of this I > must be able to read from a cell to process the value... > If you're really trying to read the value from the formulas into PHP to then use elsewhere, that can't be done. There is no (AFAIK) PHP app which will actually parse and run Excel formulas. If you want this value to write back into the Excel file, use an excel formula to copy the values. Use the sheet!cell format I gave you earlier. -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--