XlsFile.GetCellValueIndexed Method
Reads a Cell Value and Format, using a column index for faster access. Normal GetCellValue(row, col) has to search for the column on a sorted list. If you are looping from 1 to ExcelFile.ColCountInRow(Int32) this method is faster.
Syntax
Namespace: FlexCel.XlsAdapter
public override Object GetCellValueIndexed(Int32 sheet, Int32 row, Int32 colIndex, ref Int32 XF)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| sheet | Int32 | Sheet where the cell is, 1 based. | |
| row | Int32 | Row, 1 based. | |
| colIndex | Int32 | Column index, 1 based. | |
| ref | XF | Int32 | XF format. |
Returns
Object with the value. It can be null, a double, a string, a boolean, a TFormula, a TFlxFormulaErrorValue or a TRichString. Dates are returned as doubles. See the Reading Files demo to know how to use each type of the objects returned.