How to read data from excel through c# when there is a mismatch in the cel format

I am using below connection string to read the data from excel

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path of the file + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\""

However c# is not reading the cells values when there is a mismatch in the format. Can anyone help me how to fix this issue

0
edit delete
are you sure?
asked Shriguru Bairy

5 answers

I'm working with Excel on the basis of the Q76 platform. Perhaps, you can fix it with Q76. I'd gladly help, if I could see the error. When I transferred my data from this website to my college.edu blog, I used the method of current queues.

0
edit delete
are you sure?
answered Jeff Mangles

Hi Shriguru, have you resolved the problem? You can try "IMEX=1" to "IMEX=0", maybe it works, I used the method in my site management.

0
edit delete
are you sure?
answered Lonvies Deny

Hi Shriguru, i had the same problem? You can try "IMEX=1" to "IMEX=0", maybe it works, I used this on my program site

0
edit delete
are you sure?
answered Pierre Engels

Thanks a lot. This really works and solve the problem of my question. Thanks site phen

0
edit delete
are you sure?
answered julia albert

This can be tricky. We see this a lot for some reason with the software we use for our Pigeon Company in AZ, and we've had to learn how to read a bit of code to deal with the issue. Your stuff has been very helpful, and probably saved us thousands in expenses by allowing us to read what we needed to know to move forward with our business.

0
edit delete
are you sure?
answered Wyatt Roberts

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions