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

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.

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.

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

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

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.