Spread Windows Forms 15.0
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