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.
  1. CFDocs
  2. Functions
  3. Spreadsheet Manipulation Functions
  4. spreadsheetSetRowHeight
  5. CF
  6. 0 Issue
  7. Edit

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)>

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub