Рекурсивный акроним словосочетания «PHP: Hypertext Preprocessor»
Добро пожаловать на форум PHP программистов!
За последние 24 часа нас посетили 17226 программистов и 1834 робота. Сейчас ищут 1668 программистов ...
Spreadsheet_Excel_Writer::rowcolToCell
Вернуться к: Spreadsheet_Excel_Writer
Spreadsheet_Excel_Writer::rowcolToCell
Spreadsheet_Excel_Writer::rowcolToCell – Utility function for writing formulas.
Synopsis
require_once "Spreadsheet/Excel/Writer.php";
string Spreadsheet_Excel_Writer::rowcolToCell ( integer $row , integer $col )
Utility function for writing formulas. Converts a cell's coordinates to the A1 format.
Parameter
-
integer $row - Row for the cell to convert (0-indexed).
-
integer $col - Column for the cell to convert (0-indexed).
Return value
returns The cell identifier in A1 format on success, PEAR_Error on failure
Example
Using rowcolToCell()
<?php
require_once 'Spreadsheet/Excel/Writer.php';
$workbook = new Spreadsheet_Excel_Writer('rowcol.xls');
$worksheet1 =& $workbook->addWorksheet("rowcol");
$first = 1;
$last = 10;
for ($i = $first; $i <= $last; $i++) {
$worksheet1->write($i, 1, $i);
}
$cell1 = Spreadsheet_Excel_Writer::rowcolToCell($first, 1);
$cell2 = Spreadsheet_Excel_Writer::rowcolToCell($last, 1);
$worksheet1->write($last + 1, 0, "Total =");
$worksheet1->writeFormula($last + 1, 1, "=SUM($cell1:$cell2)");
$workbook->close();
?> Вернуться к: Spreadsheet_Excel_Writer