SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / setColumnWidth Method
The column index.
The width in pixels, or use the string with "*" to represent the dynamic size.
The sheet area. If this parameter is not given, it defaults to viewport.
In This Topic
    setColumnWidth Method
    In This Topic
    Sets the width in pixels or dynamic size for the specified column in the specified sheet area.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var returnValue; // Type: any
    returnValue = instance.setColumnWidth(col, value, sheetArea);
    function setColumnWidth( 
       col : number,
       value : undefined,
       (optional) sheetArea : SheetArea
    ) : any;

    Parameters

    col
    The column index.
    value
    The width in pixels, or use the string with "*" to represent the dynamic size.
    sheetArea
    The sheet area. If this parameter is not given, it defaults to viewport.
    Example
    This example sets the column width.
    sheet.setValue(0, 0, "value");
    sheet.addRows(0, 2);
    sheet.addColumns(0, 2);
    sheet.setRowHeight(0, 50.0,GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnWidth(0, 150.0,GC.Spread.Sheets.SheetArea.viewport);
    sheet.getRange(0, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).backColor("Gray");
    sheet.getRange(-1, 0, -1, 1, GC.Spread.Sheets.SheetArea.viewport).backColor ("Brown");
    See Also

    Reference

    Worksheet type