GetColumnWidth Method

Visual Basic
C#

'Declaration
 
Public Function GetColumnWidth( _
   ByVal column As Integer _
) As Integer

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim value As Integer
 
value = instance.GetColumnWidth(column)

public int GetColumnWidth( 
   int column
)

Parameters

column: Column index

Return Value

Integer number of pixels in the column width

To specify the width for a column, use the SetColumnWidth method.

Note: The value returned by the this method does not include the width of the adjacent grid line.

The default width for columns in the sheet is determined by the DefaultColumnWidth property.

If you prefer, you can allow users to resize columns by using the SetColumnSizeable method.

To see the height for a row, use the GetRowHeight method.

This example creates a SheetView object and a Column object. Values are inserted into the second column and the column width is adjusted so all of the text is visible. The width of the column is returned to a list box using the SheetView object.

C#

FarPoint.Web.Spread.SheetView sv=FpSpread1.ActiveSheetView;
FarPoint.Web.Spread.Column mycol;
mycol=sv.Columns[1];
mycol.Width=160;
sv.SetValue(0,1,"Tire/WheelAlignment");
sv.SetValue(1,1,"FuelInjectorsCleaned");
sv.SetValue(2,1,"BrakesAdjusted");
ListBox1.Items.Add(Convert.ToString(sv.GetColumnWidth(1)));

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv=FpSpread1.ActiveSheetView
Dim mycol As FarPoint.Web.Spread.Column
mycol=sv.Columns(1)
mycol.Width=160
sv.SetValue(0,1,"Tire/WheelAlignment")
sv.SetValue(1,1,"FuelInjectorsCleaned")
sv.SetValue(2,1,"BrakesAdjusted")
ListBox1.Items.Add(sv.GetColumnWidth(1))

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
SetColumnWidth Method
GetRowHeight Method
DefaultColumnWidth Property
Width Property

User-Task Documentation

Setting the Row Height or Column Width