Problem on reading xlsx file using c#.net.

See more:

C#3.5

Dear All,
I am using VS2010 Wpf application with c#. I am read the xlsx file using oledb connection its working fine but after reading my xlsx some data missing in the reading data set.

Here i attached my Coding and i have the screen shot of the problem but here no option is there for attaching screen shot.

private DataTable ReadExcel(string tabName)
       {
           DataTable retTbl = new DataTable();
           DataTable dtRead = new DataTable();
           try
           {


               System.Data.OleDb.OleDbConnection MyConnection;
               System.Data.DataSet DtSet;
               System.Data.OleDb.OleDbDataAdapter MyCommand;
               MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\\csharp.net-informations.xls';Extended Properties=Excel 8.0;");
               MyConnection = conn;
               MyConnection.Open();
               MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [" + tabName + "$]", MyConnection);
               MyCommand.TableMappings.Add("Table", "TestTable");
               DtSet = new System.Data.DataSet();
               MyCommand.Fill(DtSet);
               dtRead = DtSet.Tables[0];
               MyConnection.Close();
           }

           catch (Exception ex)
           {
              MessageBox.Show(ex.ToString());
           }

           return dtRead;
       }

Ex:
Consider as Excel Columns

' c1' c2 ' c3'
---------------
' 1 ' Test ' 0 '
---------------
' 3 ' 1 ' 4 '
----------------

After Read the Excel:

' c1' c2 ' c3'
---------------
' 1 ' ' 0 '
---------------
' 3 ' 1 ' 4 '
----------------

see the Above example "Test" is missing after Read excel.

sorry for my English..

Thanks all,
Regards,
karthik M

What I have tried:

i am tried to read the XLSX file.