previousWorksheet::setHeader (Previous) (Next) Worksheet::setMergenext
View this page in Last updated: Sun, 18 Oct 2009
English | Brazilian Portuguese | Chinese | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Turkish

Worksheet::setFooter

Worksheet::setFooter – Set the page footer caption and optional margin.

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::setFooter ( string $string , float $margin=0.5 )

Description

Set the page footer caption and optional margin.

Parameter

  • string $string - The footer text

  • float $margin - optional foot margin in inches.

Note

This function can not be called statically.

Example

Using setFooter()

<?php

?>
previousWorksheet::setHeader (Previous) (Next) Worksheet::setMergenext
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: Oliver Fust
2007-09-27 00:46 UTC
Excel constants:

&A = &[Tab] = Tab Name
&D = &[Date] = Date
&F = &[File] = File Name
&N = &[Pages] = Total # of Pages
&P = &[Page] = Page Number
&T = &[Time] = Time
&W = &[Path] = Working Directory (Path)


example:

$worksheet->setFooter('Page &P of &N');
Note by: Oliver Fust
2007-09-27 00:46 UTC
For the left/right header:

&L for Left header
&C for Center header
&R for Right header

example:
$worksheet->setHeader('&LConfidential&C&F&RPage &P of &N');