SpreadsheetSetColumnWidth

Description

Sets the width of a column in a worksheet.

Returns

Nothing

Category

Microsoft Office Integration

Function syntax

SpreadSheetSetColumnWidth(spreadhsheetobj, column number, width)

History

ColdFusion 9: Added the function.

Parameters

Parameter

Description

spreadsheetobj

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

column number

Specifies the column to set the width. The

width

Specifies the width in points.

Usage

Example

The following example creates a spreadsheet, adds columns to the spreadsheet, and sets the column width for the newly added columns.

<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 SpreadSheetSetColumnWidth(a,2,10)> 
<cfset SpreadSheetSetColumnWidth(a,3,25)> 
<cfspreadsheet action="write" filename="#expandpath('.')#/b.xls" name="a" overwrite="true">