Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / GetColumnWidth Method
Column index
Example


In This Topic
    GetColumnWidth Method
    In This Topic
    Gets the width of the specified column in pixels.
    Syntax
    '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
    Remarks

    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.

    Example
    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.
    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)));
    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))
    See Also