XlsFile.GetCellValue Method
Overloads
XlsFile.GetCellValue(Int32, Int32, Int32)
Reads a Cell Value and Format.
Syntax
Namespace: FlexCel.XlsAdapter
public override Object GetCellValue(Int32 row, Int32 col, ref Int32 XF)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| row | Int32 | Row, 1 based. | |
| col | Int32 | Column, 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
XlsFile.GetCellValue(Int32, Int32, Int32, Int32)
Reads a Cell Value and Format from a sheet that is not the active sheet.
Syntax
Namespace: FlexCel.XlsAdapter
public override Object GetCellValue(Int32 sheet, Int32 row, Int32 col, ref Int32 XF)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| sheet | Int32 | Sheet where is the cell you want to get the value. | |
| row | Int32 | Row, 1 based. | |
| col | Int32 | Column, 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.