Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffWrite Interface / ExcelGetMergeCells Method
Sheet index
Number
Array list of first row indexes
Array list of last row indexes
Array list of first column indexes
Array list of last column indexes


In This Topic
    ExcelGetMergeCells Method
    In This Topic
    Gets the merge cells for exporting to Excel BIFF file.
    Syntax
    'Declaration
     
    
    Function ExcelGetMergeCells( _
       ByVal sheet As Short, _
       ByRef count As Integer, _
       ByVal rowFirsts As ArrayList, _
       ByVal rowLasts As ArrayList, _
       ByVal colFirsts As ArrayList, _
       ByVal colLasts As ArrayList _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelBiffWrite
    Dim sheet As Short
    Dim count As Integer
    Dim rowFirsts As ArrayList
    Dim rowLasts As ArrayList
    Dim colFirsts As ArrayList
    Dim colLasts As ArrayList
    Dim value As Boolean
     
    value = instance.ExcelGetMergeCells(sheet, count, rowFirsts, rowLasts, colFirsts, colLasts)

    Parameters

    sheet
    Sheet index
    count
    Number
    rowFirsts
    Array list of first row indexes
    rowLasts
    Array list of last row indexes
    colFirsts
    Array list of first column indexes
    colLasts
    Array list of last column indexes
    See Also