Workbook::close Workbook::&addFormat
Spreadsheet_Excel_Writer
PEAR Manual

Workbook::&addWorksheet

Workbook::&addWorksheet -- Add a new worksheet to the Excel workbook.

Synopsis


      require_once "Spreadsheet/Excel/Writer.php";

object reference Workbook::&addWorksheet ( string $name='' )

Description

Add a new worksheet to the Excel workbook. If no name is given the name of the worksheet will be Sheeti with i in [1..].

Parameter

  • string $name - the optional name of the worksheet. Can not be longer than 31 characters.

Return value

returns a reference to a worksheet object on success, PEAR_Error on failure

Note

This function can not be called statically.

Example

Using &addWorksheet()


     
<?php

require_once 'Spreadsheet/Excel/Writer.php';

$workbook = new Spreadsheet_Excel_Writer('test.xls');

$worksheet =& $workbook->addWorksheet('My first worksheet');

if (PEAR::isError($worksheet)) {

    die($worksheet->getMessage());

}

$workbook->close();

?>
Workbook::close Workbook::&addFormat
Spreadsheet_Excel_Writer
PEAR Manual