Read xls cell values as text only

Nov 4, 2014 at 12:00 PM
Hi,

I am new to ExcelDataReader class. Can we read xls file data in text format like one we have in OLEDB (Setting IMEX = 1).

In my xls there is column containing date and other column containing time. While reading the data it convert both column to double format. I have changed the value into datetime using OFromDate function, it returns me date as 14-02-14 12:00:00 and time as 31-12-99 07:08:59.

I wanna it should show same as it in xls file ie. date as 14-02-2014 and time as 07:08:59.