Table of Contents

ExcelFile.GetCellValueIndexed Method

Overloads

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.

See also