This is infragistics 10.3. Is there a way to get the formatted value of a cell from a workbook that's been read in from a file? The issue is that the second column contains dates. But to excel, a date is a number with a format string applied. So when I try to read the value I get a number like 40653 instead of "4/20/11". Neither .value or .tostring() return the formatted value. Did I miss something?
Getting the value based on the format string is currently not supported. You can submit a feature request for this. If you detect the format string is a date string, you can pass the cell value into the static ExcelCalcValue.ExcelDateToDateTime method and then format that DateTime value approapriately based on the format.