Spread.Sheets Documentation
setColumnWidth Method
The column index.
The width in pixels.
The sheet area. If this parameter is not given, it defaults to viewport.
Sets the width in pixels 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 : number,
   sheetArea : SheetArea
) : any;

Parameters

col
The column index.
value
The width in pixels.
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.