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:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- 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
SpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue,
SpreadsheetMergeCells, SpreadsheetSetCellFormula, SpreadsheetSetCellValue
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"> |
Sign in to your account