Re: Re: PEAR Spreadsheet_Excel_Writer
| From: | Sabine Seipel | Date: | Tue, 13 Jul 2004 20:52:54 +0000 |
| Subject: | Re: Re: PEAR Spreadsheet_Excel_Writer | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-13687@lists.php.net to get a copy of this message | ||
Hi Justin,
> 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.
well I try it with the following code:
$sheet4->writeFormula(18, 9, "sheet1!J19", $profit);
$sheet4 is valid worksheet handle from the fourth worksheet doc, there i
want to write the data from cell J19 from worksheet "sheet1".
but it doesn't work "Unrecognised character for formula"
what have I made wrong?
Best regards
Sabine