Class: Spreadsheet_Excel_Writer_Workbook

Spreadsheet_Excel_Writer_Workbook Spreadsheet_Excel_Writer_Workbook( string $filename)

Class constructor

Parameters:

&Spreadsheet_Excel_Writer_Format &addFormat( [array $properties = array()])

Add a new format to the Excel workbook.

Also, pass any properties to the Format constructor.

Parameters:

&Spreadsheet_Excel_Writer_Validator &addValidator( )

Create new validator.

mixed &addWorksheet( [string $name = ''])

Add a new worksheet to the Excel workbook.

If no name is given the name of the worksheet will be Sheeti$i, with $i in [1..].

Parameters:

mixed close( )

Calls finalization methods.

This method should always be the last one to be called on every workbook

void setCountry( integer $code)

Set the country identifier for the workbook

Parameters:

integer setCustomColor( integer $index, integer $red, integer $green, integer $blue)

Change the RGB components of the elements in the colour palette.

Parameters:

void setVersion( integer $version)

Sets the BIFF version.

This method exists just to access experimental functionality from BIFF8. It will be deprecated ! Only possible value is 8 (Excel 97/2000). For any other value it fails silently.

Parameters:

array sheets( )

An accessor for the _worksheets[] array Returns an array of the worksheet objects in a workbook It actually calls to worksheets()

array worksheets( )

An accessor for the _worksheets[] array.

Returns an array of the worksheet objects in a workbook