SpreadsheetSetFooter

Description

Adds a footer to the specified worksheet.

Category

Microsoft Office Integration

Function syntax

SpreadsheetSetFooter(spreadhsheetobj, left footer, center footer, right footer)

See also

SpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellFormula, SpreadsheetSetCellValue

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetobj

The Excel spreadsheet object to which to add the footer.

left footer

Adds the footer in the left side of the worksheet.

center footer

Adds the footer in the center of the worksheet.

right footer

Adds the footer in the right side of the worksheet.

Usage

The footer that you add appears on the printed worksheet document.

Example

The following example adds a footer in the left side of the worksheet.

<cfspreadsheet action="read" src="#dirname#SingleSheet.xls" sheet="2" name="SpreadsheetObj" > 
<cfset spreadsheetSetHeader(SpreadsheetObj,"left header","center header","right header")> 
<cfset spreadsheetSetFooter(SpreadsheetObj,"left footer","center footer","right footer")> 
<cfspreadsheet action="write" filename="#dirname#MySheet.xls"  name="SpreadsheetObj" overwrite="true" >