ColdFusion 9.0 Resources |
SpreadsheetSetColumnWidthDescriptionSets the width of a column in a worksheet. ReturnsNothing CategoryMicrosoft Office Integration Function syntaxSpreadSheetSetColumnWidth(spreadhsheetobj, column number, width) See alsoSpreadsheetGetCellComment, SpreadsheetFormatCell, SpreadsheetGetCellFormula, SpreadsheetGetCellValue, SpreadsheetMergeCells, SpreadsheetSetCellFormula, SpreadsheetSetCellValue HistoryColdFusion 9: Added the function. Parameters
UsageExampleThe 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"> |