Read excel sheet cell in C#
<p>I try to read the .xls flie using c#. </p>

<p>This is my code</p>

<pre><code>OleDbCommand command = new OleDbCommand("Select [Id], [Name], [Email] from [sheet$]", connection);

OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter .SelectCommand = command;

DataSet objDataset = new DataSet();

objAdapter .Fill(objDataset1);
DataView dv = objDataset .Tables[0].DefaultView;

for (int i = 0; i &lt; dv.Count; i++)
{
    if (dv[i][0] != DBNull.Value ) 
    {
    }
}
</code></pre>

<p>but in the excel sheet cell has a green color mark  it does not read.</p>

<p><img src="http://i.stack.imgur.com/FMNvC.png" alt="enter image description here"></p>

<p>It say it is null.
So how can i read Like this cells?</p>

<p>thank you.</p>
