Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / Cells Property
Example


In This Topic
    Cells Property (Worksheet)
    In This Topic
    Gets the two-dimensional collection of Cell objects.
    Syntax
    'Declaration
     
    Public ReadOnly Property Cells As Cells
    'Usage
     
    Dim instance As Worksheet
    Dim value As Cells
     
    value = instance.Cells
    public Cells Cells {get;}

    Property Value

    The two-dimensional collection of Cell objects.
    Example
    This example uses the Cells property.
    gcSpreadSheet1.Sheets[0].DefaultColumnWidth = 30;
    gcSpreadSheet1.Sheets[0].DefaultRowHeight = 20;
    gcSpreadSheet1.Sheets[0].Cells(0, 0).Text = "test";
    gcSpreadSheet1.Sheets[0].ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1;
    listBox1.Items.Add(gcSpreadSheet1.Sheets[0].LastNonEmptyRowIndex.ToString());
    gcSpreadSheet1.Invalidate();
    GcSpreadSheet1.Sheets(0).DefaultColumnWidth = 30
    GcSpreadSheet1.Sheets(0).DefaultRowHeight = 20
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "test"
    GcSpreadSheet1.Sheets(0).ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1
    ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).LastNonEmptyRowIndex.ToString())
    GcSpreadSheet1.Invalidate()
    See Also