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" >}} |
