How to read the displayed text in a cell?

FLX TMS FlexCel for VCL & FMX
1

I would like to read texts from cells. It doesn't matter what value type is in the cell. If it is a formula, I would like to read the calculation result as a string; If it is number, I would like to read a string for that number; if it is empty cell, I read a empty string; If it is boolean, read true/false.
Basically, I would like to read whatever I see in that cell as text. Is that possible?
Thanks in advance!
Gene.

2

Hi,
Yes, try with xls.GetStringFromCell: https://doc.tmssoftware.com/flexcel/vcl/api/FlexCel.Core/TExcelFile/GetStringFromCell.html#texcelfilegetstringfromcell-method

3

Thanks! That works!