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

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