User Guide Cancel

SpreadsheetSetRowHeight

 

Note:

You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.

Click the button below to launch CFFiddle.

To copy the project in your workspace in CFFiddle, follow the steps below:

  1. Log in with your Gmail or Facebook credentials.
  2. Navigate to the project in the left pane.
  3. Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
  4. Give the project a suitable name and click Save.

Description

Sets the height of a row in a worksheet.

Returns

Nothing

Category

Microsoft Office Integration

Function syntax

SpreadSheetSetRowHeight(spreadhsheetobj, row number, height)

See also

SpreadsheetGetCellCommentSpreadsheetFormatCellSpreadsheetGetCellFormulaSpreadsheetGetCellValue

SpreadsheetMergeCellsSpreadsheetSetCellFormulaSpreadsheetSetCellValue

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetobj

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

row number

Specifies the row to set the height.

height

Specifies the height in points.

Usage

Example

The 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">

Get help faster and easier

New user?