Worksheet::writeFormula

ïÐÉÓÁÎÉÅ

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.

ðÁÒÁÍÅÔÒ

• integer $row - Zero indexed row

• integer $col - Zero indexed column

• string $formula - The formula text string

• mixed $format - The optional XF format

÷ÏÚ×ÒÁÝÁÅÍÏÅ ÚÎÁÞÅÎÉÅ

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

úÁÍÅÔËÁ

üÔÁ ÆÕÎËÃÉÑ ÎÅ ÄÏÌÖÎÁ ×ÙÚÙ×ÁÔØÓÑ ÓÔÁÔÉÞÅÓËÉ.

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

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

ðÒÉÍÅÒ

<?php
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();
?>