ColdFusion 9.0 Resources |
SpreadsheetSetRowHeightDescriptionSets the height of a row in a worksheet. ReturnsNothing CategoryMicrosoft Office Integration Function syntaxSpreadSheetSetRowHeight(spreadhsheetobj, row number, height) See alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellFormula, SpreadsheetSetCellValue HistoryColdFusion 9: Added the function. Parameters
UsageExampleThe following example creates a spreadsheet, adds rows to the spreadsheet, and sets the row height for the newly added rows. <cfscript> a=SpreadSheetNew(); SpreadSheetAddRow(a,"1,2,3,4,5,6,7,8"); SpreadSheetAddRow(a,"1,2,3,4,5,6,7,8",2,1); </cfscript> <cfset SpreadSheetSetRowHeight(a,2,10)> <cfset SpreadSheetSetRowHeight(a,3,25)> <cfspreadsheet action="write" filename="#expandpath('.')#/b.xls" name="a" overwrite="true"> |