Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ColumnCount Property
Example


In This Topic
    ColumnCount Property (SheetView)
    In This Topic
    Gets or sets the number of columns in the sheet.
    Syntax
    'Declaration
     
    Public Property ColumnCount As Integer
    'Usage
     
    Dim instance As SheetView
    Dim value As Integer
     
    instance.ColumnCount = value
     
    value = instance.ColumnCount
    public int ColumnCount {get; set;}

    Property Value

    Integer number of columns in the data area of the sheet
    Remarks
    The maximum number of columns allowed in a sheet is 2,147,483,647 (or over 2 billion). This is the number of columns in the data area of the sheet. For the number of columns in the row header, refer to the RowHeader ColumnCount.
    Example
    This example illustrates the use of this member by returning the number of columns and rows in the spreadsheet.
    int c, r;
    c = fpSpread1.ActiveSheet.ColumnCount;
    r = fpSpread1.ActiveSheet.RowCount;
    listBox1.Items.Add(c.ToString() + " - " + r.ToString());
    Dim c, r As Integer
    c = FpSpread1.ActiveSheet.ColumnCount
    r = FpSpread1.ActiveSheet.RowCount
    ListBox1.Items.Add(c.ToString() & " - " & r.ToString())
    See Also