PEAR Manual
Prev		Next

Workbook::&addFormat

Workbook::&addFormat -- Add a new format to the Excel workbook.

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

object reference Workbook::&addFormat ([array $properties=array()])

Description

Add a new format to the Excel workbook. Also, pass any properties to the Format constructor. Valid properties are:

Align
Bold
Bottom
Top
Left
Right
Border
BorderColor
BottomColor
TopColor
RightColor
LeftColor
FgColor
BgColor
Color
Pattern
Underline
TextRotation
Size
NumFormat
Script

Parameter

array $properties - array with properties for initializing the format.

Return value

object reference - to an Excel Format

Note

This function can not be called statically.

Example

Example 24-1. Using &addFormat()

<?php require_once "Spreadsheet/Excel/Writer.php"; $workbook = new Spreadsheet_Excel_Writer(); $format =& $workbook->addFormat(array('Size' => 10,                                       'Align' => 'center',                                       'Color' => 'white',                                       'Pattern' => 1,                                       'FgColor' => 'magenta')); $worksheet =& $workbook->addWorksheet(); $worksheet->writeString(1, 0, "Magenta Hello", $format); $workbook->close(); ?>

Prev	Home	Next
Workbook::&addWorksheet	Up	Workbook::&setTempDir

Who's Online
Guest Users: 4

Free Sample Chapters
	Deliver First Class Web Sites: 101 Essential Checklists Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?
More Sample Chapters

PHP General