ExcelFile.GetCellValueIndexed Method
Overloads
- ExcelFile.GetCellValueIndexed(Int32, Int32, Int32)
- ExcelFile.GetCellValueIndexed(Int32, Int32, Int32, Int32)
ExcelFile.GetCellValueIndexed(Int32, Int32, Int32)
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 ColCountInRow(Int32) this method is faster.
Syntax
Namespace: FlexCel.Core
public Object GetCellValueIndexed(Int32 row, Int32 colIndex, ref Int32 XF)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
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.
See also
ExcelFile.GetCellValueIndexed(Int32, Int32, Int32, Int32)
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 ColCountInRow(Int32) this method is faster.
Syntax
Namespace: FlexCel.Core
public abstract 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.