Spread Windows Forms 17
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffWrite Interface / ExcelGetAxisInfo Method / ExcelGetAxisInfo(Int16,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,Boolean,Int32) Method
Sheet index
Index
Size
Whether hidden
Style index
List of whether style formatted
List of outline levels
List of zero heights
List of whether collapsed
Row axis
Maximum column set


In This Topic
    ExcelGetAxisInfo(Int16,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,ArrayList,Boolean,Int32) Method
    In This Topic
    Gets the axis information for exporting to Excel BIFF file.
    Syntax
    'Declaration
     
    
    Overloads Function ExcelGetAxisInfo( _
       ByVal sheet As Short, _
       ByVal index As ArrayList, _
       ByVal size As ArrayList, _
       ByVal hidden As ArrayList, _
       ByVal styleIndex As ArrayList, _
       ByVal isStyleFormattedList As ArrayList, _
       ByVal outLevel As ArrayList, _
       ByVal zeroHeight As ArrayList, _
       ByVal IsCollapsed As ArrayList, _
       ByVal rowAxis As Boolean, _
       ByRef maxColumnSet As Integer _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelBiffWrite
    Dim sheet As Short
    Dim index As ArrayList
    Dim size As ArrayList
    Dim hidden As ArrayList
    Dim styleIndex As ArrayList
    Dim isStyleFormattedList As ArrayList
    Dim outLevel As ArrayList
    Dim zeroHeight As ArrayList
    Dim IsCollapsed As ArrayList
    Dim rowAxis As Boolean
    Dim maxColumnSet As Integer
    Dim value As Boolean
     
    value = instance.ExcelGetAxisInfo(sheet, index, size, hidden, styleIndex, isStyleFormattedList, outLevel, zeroHeight, IsCollapsed, rowAxis, maxColumnSet)

    Parameters

    sheet
    Sheet index
    index
    Index
    size
    Size
    hidden
    Whether hidden
    styleIndex
    Style index
    isStyleFormattedList
    List of whether style formatted
    outLevel
    List of outline levels
    zeroHeight
    List of zero heights
    IsCollapsed
    List of whether collapsed
    rowAxis
    Row axis
    maxColumnSet
    Maximum column set
    See Also