PEAR Manual
Prev |  | Next

# Spreadsheet_Excel_Writer::rowcolToCell

Spreadsheet_Excel_Writer::rowcolToCell -- Utility function for writing formulas.

## Synopsis

    require_once "Spreadsheet/Excel/Writer.php";

``void Spreadsheet_Excel_Writer::rowcolToCell` (integer $row, integer $col)`

## Description

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

Example 37-1. Using rowcolToCell()
    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();

Prev | Home | Next
Spreadsheet_Excel_Writer::send | Up | Format::setAlign