While reading excel sheet in data table some row order no comes empty

Question

User1750643896 posted

am reading excel sheet with the below connetion,but in one order no some rows comes empty row, but excel sheet the row has present..

*connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended *Properties='Excel 8.0;HDR=Yes;IMEX=0';"**

How can I read all the order in from the excel sheet?

Answer 1

User269602965 posted

Try IMEX=1

Answer 2

User347430248 posted

Hi Vijay,

When we are using an excel file as a data source using any provider. The used provider is define datatype of any column based on first some rows data. so in you data it is considering numeric data type and your alphanumeric data is being null. 

you can try to set any column to text you need to set an order on column.

Regards

Deepak