Set the number and position of unfrozen panes in a window
Syntax
'Declaration
Sub SetPane( _
ByVal As Short, _
ByVal As Integer, _
ByVal As Integer, _
ByVal As Integer, _
ByVal leftmostVisibleColumn As Integer, _
ByVal As Integer, _
ByVal 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