Label Property (Column)

Visual Basic
C#

'Declaration
 
Public Property Label As String

'Usage
 
Dim instance As Column
Dim value As String
 
instance.Label = value
 
value = instance.Label

public string Label {get; set;}

Property Value

String containing the label for this column

Column objects returned by the Columns object's Default property and Column objects in the column or row headers do not have a label.

This is not the same as the automatic text. For information on the automatic text that appears in a column row, refer to ColumnHeader class AutoText and AutoTextIndex.

This example creates a spreadsheet with 10 columns and 20 rows. A Column object is created and assigned to the second column of the spreadsheet. The column header is given custom text via the Label property, which is also returned to a text box.

C#

FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.PageSize=20;
FpSpread1.ActiveSheetView.RowCount=20;
FarPoint.Web.Spread.Column mycol;
mycol=FpSpread1.ActiveSheetView.Columns[1];
mycol.Label="FarPoint";
TextBox1.Text=mycol.Label;

Visual Basic

FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
Dim mycol As FarPoint.Web.Spread.Column
mycol=FpSpread1.ActiveSheetView.Columns(1)
mycol.Label="FarPoint"
TextBox1.Text=mycol.Label

Reference

Column Class
Column Members
Default Property