Unable to get format data cell

Topics: Developer Forum
Nov 5, 2014 at 10:04 AM
good morning, i have a problem to get excel format cell .
my cell is formatted in short date but when i check datatype give me string instead of date (or datetime)
i have tryied to get format type in this way:
var type =item.Cell(y).Value.GetType() and this gives me string
if i look item.Cell(y).DataType gives string and not datetime.
why my cell is not DateTime type?
how to get true fomat (short date)?
thanks a lot