Excel Reading

Hi,

I am having one issue regarding excel sheet reading. The columns which is of the format of "Number" are unreadable by OleDB Extended properties 8.0 . I used IMEX =1 as well but no success . I dont want user to change excle sheet format and just directly upload the file to the system.

Can anyone help me in this regard as soon as possible

Thanks

syed

re: Excel Reading

What do you mean "unreadable"? I don't think I've ever seen an unreadable column before?

re: Excel Reading

I mean i cannot read mix data type columns from excel sheet using c#

re: Excel Reading

That STILL does not tell me anything.
Does your program throw exceptions?
Does it return a null data type?
Does it return an empty string?
Just saying "It doesn't work" is a pretty big waste of everyone's time

re: Excel Reading

hi plater,

my program is returning NULL data when excel sheet has mix type of data.
I used IMEX =1 as well but didn't work for me ,same NULL data is returning when i read the excel sheet.
I hope you understrand

re: Excel Reading

Not sure what to tell you.
The only thing close to your issue that I have seen is that in mixed column types, if the "numbers" are at the top, the string columns show up as an empty string. The easiest way around that is to ensure there is a text string at the top. (If you have column headers, consider setting HDR=0 to force the headers as data and thus all columns of string type)