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

  • 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?

    Friday, August 26, 2016 3:09 AM

All replies

  • User269602965 posted

    Try IMEX=1

    Saturday, August 27, 2016 2:43 AM
  • 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.



    Tuesday, September 6, 2016 8:46 AM