title: Retrieving excel sheet cell value
body: <p>I am using c# to read the value of particular cell of excel sheet. But as per my code I am not getting any value..</p>
  
  <p>My code for getting the cell value is:</p>
  
  <pre><code>foreach (DataRow dr in sourceds.Tables[0].Rows) {
      while (clmn &lt; dr.ItemArray.Count()) {
          value = ((Microsoft.Office.Interop.Excel.Range)ws.Cells[row,clmn]).Text.ToString();
          ws.Cells[row, clmn] = value;
          ws.Cells[row, clmn] = value;
          clmn++;
      }
      row++;
  }
  wb.Save();
  </code></pre>
  
  <p>Here I am reading the cell from other sheet and want to insert that value in other sheet.<br>
  but I am not getting any value of "value"..</p>