ColdFusion 9.0 Resources |
SpreadsheetSetFooterDescriptionAdds a footer to the specified worksheet. ReturnsNothing CategoryMicrosoft Office Integration Function syntaxSpreadsheetSetHeader(spreadhsheetobj, left footer, center footer, right footer) See alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellFormula, SpreadsheetSetCellValue HistoryColdFusion 9: Added the function. Parameters
UsageThe footer that you add appears on the printed worksheet document. ExampleThe 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" > |