Worksheet::writeBlank (Previous)

(Next) Worksheet::writeUrl

View this page in	Last updated: Mon, 02 Jul 2007
English \| Dutch \| French \| German \| Hungarian \| Japanese \| Polish \| Russian \| Spanish \| Plain HTML

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])

Описание

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 (';').

Пример

Пример 39-1. Using writeFormula()


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

Worksheet::writeBlank (Previous)

(Next) Worksheet::writeUrl

Download Documentation	Last updated: Mon, 02 Jul 2007
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
Note by: woehlken@quadracom.de 2007-07-20 19:58 UTC As excel columns range from A to ZZ this may be an even simpler approach: function excel_column($col_number) { if( ($col_number < 0) \|\| ($col_number > 701)) die('Column must be between 0(A) and 701(ZZ)'); if($col_number < 26) { return(chr(ord('A') + $col_number)); } else { $remainder = floor($col_number / 26) - 1; return(chr(ord('A') + $remainder) . excel_column($col_number % 26)); } } Regards Marc Note by: luis.sv@gmail.com 2007-06-27 13:46 UTC Function to convert a column number to the Excel column format. For example: 0 = 'A'; 1 = 'B'; 2 = 'C'; ... 10 = 'K'; ... I wrote it until 'NZ', but you can continue... function excel_column($col_number){ $xls_columns=array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P', 'Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ', 'AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ', 'BA','BB','BC','BD','BE','BF','BG','BH','BI','BJ', 'BK','BL','BM','BN','BO','BP','BQ','BR','BS','BT','BU','BV','BW','BX','BY','BZ', 'CA','CB','CC','CD','CE','CF','CG','CH','CI','CJ', 'CK','CL','CM','CN','CO','CP','CQ','CR','CS','CT','CU','CV','CW','CX','CY','CZ', 'DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ', 'DK','DL','DM','DN','DO','DP','DQ','DR','DS','DT','DU','DV','DW','DX','DY','DZ', 'EA','EB','EC','ED','EE','EF','EG','EH','EI','EJ', 'EK','EL','EM','EN','EO','EP','EQ','ER','ES','ET','EU','EV','EW','EX','EY','EZ', 'FA','FB','FC','FD','FE','FF','FG','FH','FI','FJ', 'FK','FL','FM','FN','FO','FP','FQ','FR','FS','FT','FU','FV','FW','FX','FY','FZ', 'GA','GB','GC','GD','GE','GF','GG','GH','GI','GJ', 'GK','GL','GM','GN','GO','GP','GQ','GR','GS','GT','GU','GV','GW','GX','GY','GZ', 'HA','HB','HC','HD','HE','HF','HG','HH','HI','HJ', 'HK','HL','HM','HN','HO','HP','HQ','HR','HS','HT','HU','HV','HW','HX','HY','HZ', 'IA','IB','IC','ID','IE','IF','IG','IH','II','IJ', 'IK','IL','IM','IN','IO','IP','IQ','IR','IS','IT','IU','IV','IW','IX','IY','IZ', 'KA','KB','KC','KD','KE','KF','KG','KH','KI','KJ', 'KK','KL','KM','KN','KO','KP','KQ','KR','KS','KT','KU','KV','KW','KX','KY','KZ', 'LA','LB','LC','LD','LE','LF','LG','LH','LI','LJ', 'LK','LL','LM','LN','LO','LP','LQ','LR','LS','LT','LU','LV','LW','LX','LY','LZ', 'MA','MB','MC','MD','ME','MF','MG','MH','MI','MJ', 'MK','ML','MM','MN','MO','MP','MQ','MR','MS','MT','MU','MV','MW','MX','MY','MZ', 'NA','NB','NC','ND','NE','NF','NG','NH','NI','NJ', 'NK','NL','NM','NN','NO','NP','NQ','NR','NS','NT','NU','NV','NW','NX','NY','NZ'); return $xls_columns[$col_number]; }