Last post Sep 06, 2016 08:46 AM by Deepak Panchal
Aug 26, 2016 03:09 AM|vijayy_myl|LINK
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?
Aug 27, 2016 02:43 AM|Lannie|LINK
Sep 06, 2016 08:46 AM|Deepak Panchal|LINK
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.