title: How to read Excel cells and write to database
body: <p>I am writing an C# application that reads from an an excel sheet. It reads the whole sheet, however I am interested in just reading particular cells in a row and move to the next row and read particular cells in that row again. Cells not read or  omitted are the same for all rows in excel. Below is my sample code for reading excel:</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
          {
              Excel.Application xlApp = new Excel.Application();
              Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"C:/test.xlsx");
              Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
              Excel.Range xlRange = xlWorksheet.UsedRange;
  
              int rowCount = xlRange.Rows.Count;
              int colCount = xlRange.Columns.Count;
              for(int i=1; i &lt;= rowCount; i++)
                  {
                      for(int j=1; j&lt;=colCount; j++)
                          {
                               MessageBox.Show(xlRange.Cells[i,j].Value2.ToString());
                          }
                  }
          }
  </code></pre>