I am using version 18.104.22.168 of your Excel component. When I upload the attached file, the dates in column B don’t come in correctly. For example cell B2 has 3/21/2005 as the date. When it is read with the following call…
private DateTime GetDateTimeFromExcelCell(Cell cell)
DateTime dateTime = Constant.DBNULL_DATE;
if ((cell.Type == CellValueType.IsNumeric) || (cell.Type == CellValueType.IsDateTime))
dateTime = cell.DateTimeValue;
Can you help me determine what the problem is here?