spreadsheetSetRowHeight

Sets the height of a row in a worksheet.

spreadsheetSetRowHeight(spreadsheetObj, rowNumber, height) → returns void

This function requires Adobe ColdFusion.  Not supported on Lucee, etc.

spreadsheetSetRowHeight Argument Reference

spreadsheetObj variableName
Required

The Excel spreadsheet object to which to set the column width.

rowNumber numeric
Required

Specifies the row to set the height.

height numeric
Required

Specifies the height in points.

Examples
Sample code invoking the spreadsheetSetRowHeight function

Here,we've example to set the height for particular row in excel. It is supported only in adobe coldfusion.

<cfset Detail=SpreadsheetNew("student",false)>
<cfset SpreadSheetAddRow(Detail,"id,Name,Department")>
<cfset SpreadSheetAddRow(Detail,"1,Dhar,CS")>
<cfset spreadsheetSetRowHeight(Detail,2,50)>
<cfset SpreadsheetWrite(Detail,expandPath("./Detail.xls"),true)>

Fork me on GitHub