Re: PEAR Spreadsheet_Excel_Writer

On Tue, 13 Jul 2004 22:27:10 +0200 (MEST), Sabine Seipel <s.seipel@gmx.de> 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. > Exactly...so why don't you use an Excel Formula in that worksheet? If you're asking how to access a cell in another worksheet from within an Excel formula, here's the syntax: sheetName!cell e.g. Sheet1!D34 > 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... > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin--