4.6.4.6 SetFooter

SetFooter procedure

Prototype:	procedure SetFooter(const Footer :string);
Description:	Sets page footer on the active sheet (the same footer for the all the pages). By default, central alignment is selected. Special codes can be included as a part of the footer to specify options or to insert specific elements Page number is printed automatically as footer if no Footer procedure is called.
Syntax:	xls.SetFooter(Footer);
	Part	Description
	xls	Variable declared as an instance of the TExcelWrapper class
	Footer	Variable declared as string that contains the text for the footer
Return value:	none

See also:

Landscape , SetPrintMargins , SetHeader , SetFooter , SetHeaderAndFooter , SetFirstHeaderAndFooter , SetTitleRows , SetTitleRowsAndCols , InsertHPageBreak , InsertVPageBreak , CreateHeaderOfTableContent , CreateTableOfContent , AddBackToTableOfContent , SetPrintArea , RowCount , ColCount , Header and footer codes , Predefined paper sizes, KeepColsTogether, KeepRowsTogether, AutoPageBreaks, PrintNumberOfHorizontalPages, PrintNumberOfVerticalPages, PrintToFit, Complex example

Example:

Var
  Row, Rows, Cols:integer;
  xls :TExcelWrapper;
Begin
  {document preparation}
  //...
  {managing worksheets}
  //...

  {header and footer}
  xls.SetHeader('&L&"Calibri,Italic"&9My header');
  xls.SetFooter('&C&"Calibri,Italic"&9My footer');
  
  {setting cell values}
  //...  
  
  {document saving / previewing}
  //...
End.

Soo also complex header and footer example.