Hi
I have query regarding accessing DateTime value from Excel. i have excel in which one column contain dates. I access that value using
Cell objBirthDate = objExcel.Worksheets[0].Cells[intRowIndex, 3];
string strTempDate = objBirthDate.StringValue.Trim(); and when i parse it using
DateTime.Parse(strTempDate, objCurrentCultureInfo.DateTimeFormat);
i get an exception. the Date in excel are in dd.MM.yyyy format. but when i open the excel and select the cell. the value it show in Formula Bar is mm/dd/yyyy format.
How can get directly the text from excel so that now exception is throw
if any better suggest please provide its
thanks in advance
This message was posted using Aspose.Live 2 Forum