Excel Reading Problem with Column having multiple types
<p>I am Reading Excel File in .Net Framework 1.1 , using C# . I am getting problem in reading Excel file when i have column which contains number as well text something like this</p>

<p>1003 1004 1005 Test_1 Test_2</p>

<p>Its not giving me any error, but i am getting null values in first three row.
This is the code that i am using to read excel file.</p>

<pre><code>string strcon   = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
                                                     path +
                                                     ";Extended Properties=Excel 8.0;";

            System.Data.OleDb.OleDbConnection objConn  = new System.Data.OleDb.OleDbConnection(strcon);

            try
            {
                    objConn.Open ();                                
                    System.Data.OleDb.OleDbDataAdapter objadp = new System.Data.OleDb.OleDbDataAdapter("Select * from [" + sheetName + "$" + "]",objConn);  
                    DataSet ds = new DataSet ();                            
                    objadp.Fill (ds);
                    return ds;                              
            }
            catch(Exception ex)
            {
                    throw ex;
            }
            finally
            {
                    objConn.Close();
                    objConn.Dispose();                              
            }
</code></pre>

<p>can anybody tell me what can be a problem? Thanks.</p>
