PEAR Manual
Prev		Next

Worksheet::writeFormula

Worksheet::writeFormula -- Write a formula to the specified row and column (zero indexed).

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

integer Worksheet::writeFormula (integer $row, integer $col, string $formula [, mixed $format=0])

Description

Write a formula to the specified row and column (zero indexed). In case of error it will write the error message (instead of the formula) in the corresponding row and column.

Parameter

integer $row - Zero indexed row
integer $col - Zero indexed column
string $formula - The formula text string
mixed $format - The optional XF format

Return value

integer - 0 for normal termination, -1 for an error in the formula, -2 for row or column out of range.

Note

This function can not be called statically.

Formulas must start with an equal sign ('=').

Arguments given to an Excel function should be separated by comas (','), not by semicolons (';').

Example

Example 24-1. Using writeFormula()

require_once 'Spreadsheet/Excel/Writer.php';$workbook = new Spreadsheet_Excel_Writer('formula.xls');$worksheet =& $workbook->addWorksheet();$worksheet->write(0, 0, 2);$worksheet->write(0, 1, "and");$worksheet->write(0, 2, 2);$worksheet->write(0, 3, "makes");$worksheet->writeFormula(0, 4, "=SUM(A1,C1)");$workbook->close();

Prev	Home	Next
Worksheet::writeBlank	Up	Worksheet::writeUrl

Who's Online
Guest Users: 5

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General