i have 200 rows in my excel file. im using OleDbConnection to read the excel file.
The problem is that it will read all the blank rows from row 200 onwards. Is there a configuration im missing ? or is there a way to import all rows that has data? Here's some of my code.
string excelConnectionString =
"Data Source=" + filePath + ";" +
"Extended Properties=Excel 8.0";
OleDbConnection excelConnection =
new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=NO'");
OleDbCommand cmd = new OleDbCommand("Select * from [list$]",excelConnection);
View Complete Post