Export date from Excel to visual C# 2008

Question

Greetings dear members I'm attempting to export a data with the type 'Date' from excel to a cell in datagridview in visual c# 2008 express edition (i.e. exporting '1/11/2010'). When I did that using the function: xlWorkSheet.get_Range(  ) It did work but the date was transffered as an integer: '40189' !!! How can I prevent that from happening? How can I transfer data as it is formatted in excel??? Or How can I convert the integers '40189' into date formate within visual c# environment??? Thanks in advance Ali

John Penn · Answer

The value you're getting from Excel is really a double -- if there's a time with the date you'd get something like 40189.321. .Net can handle this for you: DateTime convertedExcelDate = DateTime.FromOADate(40189);

Ali Alfaraj · Answer

Thanks It worked fine.

Suthish Nair · Answer

yep.. that's more easier way...

Suthish Nair · Answer

You need to use Convert.ToDateTime(1/11/2010).ToString(dd/mm/yyyy) before binding..