Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IOptimizedExcel Interface / ExcelGetCellInfo Method
Sheet index
List of cell coordinates
List of cell values
List of cell formulas
List of format indexes


In This Topic
    ExcelGetCellInfo Method (IOptimizedExcel)
    In This Topic
    Gets the cell information for exporting to Excel BIFF file.
    Syntax
    'Declaration
     
    
    Function ExcelGetCellInfo( _
       ByVal sheet As Short, _
       ByVal cellCoord As ArrayList, _
       ByVal cellValue As ArrayList, _
       ByVal cellFormula As ArrayList, _
       ByVal formatIndex As ArrayList _
    ) As Boolean
    'Usage
     
    
    Dim instance As IOptimizedExcel
    Dim sheet As Short
    Dim cellCoord As ArrayList
    Dim cellValue As ArrayList
    Dim cellFormula As ArrayList
    Dim formatIndex As ArrayList
    Dim value As Boolean
     
    value = instance.ExcelGetCellInfo(sheet, cellCoord, cellValue, cellFormula, formatIndex)

    Parameters

    sheet
    Sheet index
    cellCoord
    List of cell coordinates
    cellValue
    List of cell values
    cellFormula
    List of cell formulas
    formatIndex
    List of format indexes
    See Also