Free Support Forum - aspose.com

How to get DateTime in text format

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

Hi,

Thanks for considering Aspose.

Are you using English version of MS Excel or other and what are the regioanl local settings related datetime on your system.

Could you post your template excel file here. We will check it soon.

Thank you.