Shea Martin wrote:
> I am reading data in from an XLS file use Excel interop. I currently
> get cell data like this:
>
> lRange = lSheet.get_Range( lTopLeftCellName, lBotRightCellName );
> Object[,] lValues = (Object[,])lRange.Value2;
>
> The problem is that columns which contain dates (formatted as m/d/y)
> come across as floats. i.e., 5/15/2004 comes across as 38122.0.
>
> Is there a way to programmatically know that a cell is formatted as a
> date? Is there a way to bring it accross as a DateTime or atleast a
> String so I can parse it on my own?
>
> Thanks,
>
> ~S

> I am reading data in from an XLS file use Excel interop. I currently
> get cell data like this:
>
> lRange = lSheet.get_Range( lTopLeftCellName, lBotRightCellName );
> Object[,] lValues = (Object[,])lRange.Value2;
>
> The problem is that columns which contain dates (formatted as m/d/y)
> come across as floats. i.e., 5/15/2004 comes across as 38122.0.
>
> Is there a way to programmatically know that a cell is formatted as a
> date? Is there a way to bring it accross as a DateTime or atleast a
> String so I can parse it on my own?
>