Sheets Property (GcSpreadSheet)

Gets or sets the GrapeCity.Windows.SpreadSheet.Data.Worksheet collection for the GcSpreadSheet control.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.BrowsableAttribute(False)>
Public ReadOnly Property Sheets As WorksheetCollection

'Usage
 
Dim instance As GcSpreadSheet
Dim value As WorksheetCollection
 
value = instance.Sheets

[System.ComponentModel.Browsable(false)]
public WorksheetCollection Sheets {get;}

Example

This example uses the Sheets property.

gcSpreadSheet1.ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1;
gcSpreadSheet1.SheetCount = 1;
\\Or
\\gcSpreadSheet1.Sheets.Count = 1;
gcSpreadSheet1.Sheets[0].RowRangeGroup.Group(0, 2);
gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Group(3, 2);
gcSpreadSheet1.ShowColumnRangeGroup = true;
gcSpreadSheet1.ShowRowRangeGroup = true;
gcSpreadSheet1.ShowGridLine = true;

VB.NET

GcSpreadSheet1.ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1
GcSpreadSheet1.SheetCount = 1
'Or
'GcSpreadSheet1.Sheets.Count = 1
GcSpreadSheet1.Sheets(0).RowRangeGroup.Group(0, 2)
GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Group(3, 2)
GcSpreadSheet1.ShowColumnRangeGroup = True
GcSpreadSheet1.ShowRowRangeGroup = True
GcSpreadSheet1.ShowGridLine = True

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GcSpreadSheet Class
GcSpreadSheet Members