View this page in	Last updated: Sun, 18 Oct 2009
English \| Brazilian Portuguese \| Chinese \| Dutch \| French \| German \| Hungarian \| Japanese \| Polish \| Russian \| Spanish \| Turkish

Workbook::&addFormat

Workbook::&addFormat – Ajoute un nouveau format au manuel de travail Excel

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

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

Description

Ajoute un nouveau format au manuel de travail Excel. Passe également toutes les propriétés au constructeur du format. Les propriétés valides sont :

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

Parameter

array $properties - tableau contenant les propriétés pour l'initialisation du format.

Return value

Retourne un objet de référence d'un format Excel.

Note

This function can not be called statically.

Example

Exemple avec &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, "Bonjour en Magenta !", $format);
$workbook->close();
?>

Workbook::&addWorksheet (Previous)

(Next) Workbook::&setTempDir

Download Documentation	Last updated: Sun, 18 Oct 2009
Do you think that something on this page is wrong? Please file a bug report or add a note.
User Notes:
Note by: alex@angelov.co.uk 2008-01-10 07:19 UTC You can also set the 'locked' format property using &addFormat(). This can be done in the same way like 'bold' by assigning to 'locked' a value of 1. $format =& $workbook->addFormat(array('locked' => 1)); Note by: Elliott Brueggeman 2007-06-14 15:19 UTC Properties that don't have obvious arguments, such as bold and underline, require a value of 1 in the array to make them function properly. Example: (to make a format bold and underlined) $myFormat=&$workbook->addFormat( array('bold'=>1, 'underline'=>1 ));