Spread WinForms 15
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffWrite Interface / ExcelGetFrozen Method
Sheet index
Number of fixed or frozen leading rows
Number of fixed or frozen leading columns
Number of fixed or frozen trailing rows
Number of fixed or frozen trailing columns


In This Topic
ExcelGetFrozen Method
In This Topic
Gets the fixed or frozen rows and columns for exporting to Excel BIFF file.
Syntax
'Declaration
 
Function ExcelGetFrozen( _
   ByVal sheet As Short, _
   ByRef frozenRowCount As Integer, _
   ByRef frozenColumnCount As Integer, _
   ByRef frozenTrailingRowCount As Integer, _
   ByRef frozenTrailingColumnCount As Integer _
) As Boolean
 
'Usage
 
Dim instance As IExcelBiffWrite
Dim sheet As Short
Dim frozenRowCount As Integer
Dim frozenColumnCount As Integer
Dim frozenTrailingRowCount As Integer
Dim frozenTrailingColumnCount As Integer
Dim value As Boolean
 
value = instance.ExcelGetFrozen(sheet, frozenRowCount, frozenColumnCount, frozenTrailingRowCount, frozenTrailingColumnCount)

Parameters

sheet
Sheet index
frozenRowCount
Number of fixed or frozen leading rows
frozenColumnCount
Number of fixed or frozen leading columns
frozenTrailingRowCount
Number of fixed or frozen trailing rows
frozenTrailingColumnCount
Number of fixed or frozen trailing columns
See Also