SpreadsheetSetRowHeight

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