TXlsFile.GetCellValue Method
Overloads
- TXlsFile.GetCellValue(Integer, Integer, Integer)
- TXlsFile.GetCellValue(Integer, Integer, Integer, Integer)
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.