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