title: How to add empty rows in excel sheet data table using c#
body: <p><a href="https://i.stack.imgur.com/Vjsta.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Vjsta.jpg" alt="enter image description here"></a>How to add empty rows in my data table and then loop through the column heading and split by- Then year insert to the empty row and
  After that merge the year row</p>
  
  <p>Here is my data table code:</p>
  
  <pre><code>       private void button1_Click(object sender, EventArgs e)
         {
              Excel.Application xlApp;
              Excel.Workbook xlWorkBook;
              Excel.Worksheet xlWorkSheet;
              object misValue = System.Reflection.Missing.Value;
              Excel.Range chartRange;
  
              xlApp = new Excel.Application();
              xlWorkBook = xlApp.Workbooks.Add(misValue);
              xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
  
          xlWorkSheet.Cells[2, 1] = "Retailer";
  
          xlWorkSheet.Cells[2, 2] = "Brand";
          xlWorkSheet.Cells[2, 3] = "2019_WK1";
  
          xlWorkSheet.Cells[2, 4] = "2019_WK2";
  
              xlWorkSheet.Cells[2, 5] = "2019_WK3";
  
  
              xlWorkSheet.Cells[3, 1] = "LuLu";
              xlWorkSheet.Cells[3, 2] = "Perisil";
              xlWorkSheet.Cells[3, 3] = "25";
              xlWorkSheet.Cells[3, 4] = "26";
              xlWorkSheet.Cells[3, 5] = "23";
  
              xlWorkSheet.Cells[4, 1] = "Lulu";
              xlWorkSheet.Cells[4, 2] = "Ariel";
              xlWorkSheet.Cells[4, 3] = "26";
              xlWorkSheet.Cells[4, 4] = "28";
              xlWorkSheet.Cells[4, 5] = "29";
  
              xlWorkSheet.Cells[5, 1] = "Danube";
              xlWorkSheet.Cells[5, 2] = "Omo";
              xlWorkSheet.Cells[5, 3] = "27";
              xlWorkSheet.Cells[5, 4] = "28";
              xlWorkSheet.Cells[5, 5] = "30";
  
  
              xlWorkSheet.Cells[6, 1] = "Danube";
              xlWorkSheet.Cells[6, 2] = "Tide";
              xlWorkSheet.Cells[6, 3] = "24";
              xlWorkSheet.Cells[6, 4] = "23";
              xlWorkSheet.Cells[6, 5] = "29";
  
  
              xlWorkSheet.Cells[7, 1] = "Bin Dawood";
              xlWorkSheet.Cells[7, 2] = "Persil";
              xlWorkSheet.Cells[7, 3] = "26";
              xlWorkSheet.Cells[7, 4] = "27";
              xlWorkSheet.Cells[7, 5] = "28";
  
  
          xlWorkBook.SaveAs("F:\\CTR_Data", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
              xlWorkBook.Close(true, misValue, misValue);
              xlApp.Quit();
  
              releaseObject(xlApp);
              releaseObject(xlWorkBook);
              releaseObject(xlWorkSheet);
  
              MessageBox.Show("File created !");
          }    
  </code></pre>
  
  <p>I want to add five empty rows in ("A1" to "E1" cells) and loop through the column heading and split by-</p>
  
  <p>I want a excel output like above picture</p>