Description
Sets the width of a column in a worksheet.
Returns
Nothing
Category
Microsoft Office Integration
Function syntax
SpreadSheetSetColumnWidth(spreadhsheetobj, column number, width) |
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. |
column number |
Specifies the column to set the width. The |
width |
Specifies the width in points. |
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"> |
