title: Missing data trying to read an excel file In c# using OleDb
body: <p>I have a problem when I try to read a Excel file in C#</p>
  
  <pre><code>filePath = txtExcelFile.Text;
                  string[] fileSpit = filePath.Split('.');
                  if (filePath.Length &gt; 1 &amp;&amp; fileSpit[1] == "xls")
                  {
                      connString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=No'";
                  }
                  else
                  {
                      connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0;HDR=No'";
                  }
  OleDbCommand cmd = new OleDbCommand(@"Select * from [" +comboBox1.SelectedValue.ToString() + "]", ole);
  OleDbDataAdapter oledata = new OleDbDataAdapter();
  oledata.SelectCommand = cmd;
  DataSet ds = new DataSet();
  oledata.Fill(ds);
  dataGridView1.DataSource = ds.Tables[0].DefaultView;
  </code></pre>
  
  <p>But it only shows only partial data. I have attached images.</p>