I’m writing Excel file reader. It should extract currency information from sheet.
How to detect that cell is cell with currency value?
I’ve tried to use Cell.Type but Enum CellValueType (result of Cell.Type) does not contain currency type.
Cell.Style doesn’t return useful information also. I suspected that cell with Currency category in Excel would have style.Number = 5, but instead it is 0 and cell has setup Custom format “[$$-409]# ##0,00” that is not useful for me because source excel file can be with any culture and custom format can vary greatly.
Also, it would be nice to receive valid currency symbol from cell’s value.