Spread WinForms 15
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

Reference

IOptimizedExcel Interface
IOptimizedExcel Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page