Spread WPF Documentation
Cells Property (Worksheet)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : Cells Property
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

Reference

Worksheet Class
Worksheet Members