GrapeCity.Xaml.Excel
SetPane Method


GrapeCity.Excel Namespace > IExcelReader Interface : SetPane Method
The zero based sheet index used to locate the IExcelWorksheet instance
Set the value for the horizontal position of the split, 0 if none
Set the value for the vertical position of the split, 0 if none
Set the count of top visible rows in the bottom pane
Set the count of leftmost visible columns in the right pane
The active pane number
A flag indicate whether the pane is frozen
Set the number and position of unfrozen panes in a window
Syntax
'Declaration
 
Sub SetPane( _
   ByVal sheet As Short, _
   ByVal horizontalPosition As Integer, _
   ByVal verticalPosition As Integer, _
   ByVal topVisibleRow As Integer, _
   ByVal leftmostVisibleColumn As Integer, _
   ByVal paneIndex As Integer, _
   ByVal isPanesFrozen As Boolean _
) 
'Usage
 
Dim instance As IExcelReader
Dim sheet As Short
Dim horizontalPosition As Integer
Dim verticalPosition As Integer
Dim topVisibleRow As Integer
Dim leftmostVisibleColumn As Integer
Dim paneIndex As Integer
Dim isPanesFrozen As Boolean
 
instance.SetPane(sheet, horizontalPosition, verticalPosition, topVisibleRow, leftmostVisibleColumn, paneIndex, isPanesFrozen)

Parameters

sheet
The zero based sheet index used to locate the IExcelWorksheet instance
horizontalPosition
Set the value for the horizontal position of the split, 0 if none
verticalPosition
Set the value for the vertical position of the split, 0 if none
topVisibleRow
Set the count of top visible rows in the bottom pane
leftmostVisibleColumn
Set the count of leftmost visible columns in the right pane
paneIndex
The active pane number
isPanesFrozen
A flag indicate whether the pane is frozen
See Also

Reference

IExcelReader Interface
IExcelReader Members