Spread for ASP.NET 8.0 Product Documentation
GetSheetView Method
Example 


Name of the sheet
Gets the sheet with the specified name from the collection.
Syntax
'Declaration
 
Public Function GetSheetView( _
   ByVal name As String _
) As SheetView
'Usage
 
Dim instance As SheetViewCollection
Dim name As String
Dim value As SheetView
 
value = instance.GetSheetView(name)
public SheetView GetSheetView( 
   string name
)

Parameters

name
Name of the sheet

Return Value

SheetView object containing the sheet
Example
This example returns the sheet with the specified name.
System.Collections.ArrayList coll = New System.Collections.ArrayList(2);
FarPoint.Web.Spread.SheetView sv2 = New FarPoint.Web.Spread.SheetView();
FarPoint.Web.Spread.SheetView sv3 = New FarPoint.Web.Spread.SheetView();
sv2.GridLineColor = Color.Red;
sv2.GridLines = GridLines.Vertical;
sv3.GridLineColor = Color.Yellow;
sv3.GridLines = GridLines.Horizontal;
coll.Add(sv2);
coll.Add(sv3);
FpSpread1.Sheets.Clear();
FpSpread1.Sheets.AddRange(coll);
FpSpread1.Sheets.GetSheetView("Sheet2").BackColor = Color.Tan;
Dim coll As New System.Collections.ArrayList(2)
Dim sv2 As New FarPoint.Web.Spread.SheetView
Dim sv3 As New FarPoint.Web.Spread.SheetView
sv2.GridLineColor = Color.Red
sv2.GridLines = GridLines.Vertical
sv3.GridLineColor = Color.Yellow
sv3.GridLines = GridLines.Horizontal
coll.Add(sv2)
coll.Add(sv3)
FpSpread1.Sheets.Clear()
FpSpread1.Sheets.AddRange(coll)
FpSpread1.Sheets.GetSheetView("Sheet2").BackColor = Color.Tan
Requirements

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

See Also

Reference

SheetViewCollection Class
SheetViewCollection Members

 

 


Copyright © GrapeCity, inc. All rights reserved.