Width Property (Column)

Visual Basic
C#

'Declaration
 
Public Property Width As Integer

'Usage
 
Dim instance As Column
Dim value As Integer
 
instance.Width = value
 
value = instance.Width

public int Width {get; set;}

Property Value

Integer number of pixels in the width of this column

This example creates a spreadsheet with 10 columns and 20 rows. A Column object is then created and assigned to the second column of the spreadsheet. The BackColor, ForeColor, Font and Width properties are set to various values and the text inserted into the column reflect the changes.

C#

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.BackColor=Color.Yellow;
mycol.ForeColor=Color.Red;
mycol.Font.Bold=true;
mycol.Font.Name="ComicSansMS";
mycol.Width=140;
for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest");
}

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
Dim col,i As Integer
col=1
mycol=FpSpread1.ActiveSheetView.Columns(col)
mycol.BackColor=Color.Yellow
mycol.ForeColor=Color.Red
mycol.Font.Bold=True
mycol.Font.Name="ComicSansMS"
mycol.Width=140
For i = 0 To FpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest")
Next i

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

Reference

Column Class
Column Members