TXlsFile.GetCellValue Method

Overloads

TXlsFile.GetCellValue(Integer, Integer, Integer)

Reads a Cell Value and Format.

Syntax

Unit: FlexCel.XlsAdapter

function TXlsFile.GetCellValue(const row: Integer; const col: Integer; var XF: Integer): TCellValue; overload; override;

Parameters

<-> Parameter Type Description
const row Integer Row, 1 based.
const col Integer Column, 1 based.
var XF Integer 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

TXlsFile.GetCellValue(Integer, Integer, Integer, Integer)

Reads a Cell Value and Format from a sheet that is not the active sheet.

Syntax

Unit: FlexCel.XlsAdapter

function TXlsFile.GetCellValue(const sheet: Integer; const row: Integer; const col: Integer; var XF: Integer): TCellValue; overload; override;

Parameters

<-> Parameter Type Description
const sheet Integer Sheet where is the cell you want to get the value.
const row Integer Row, 1 based.
const col Integer Column, 1 based.
var XF Integer 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