title: How to insert a row and format a row of Excel in c#
body: <p>I created an excel file using <code>Microsoft.Office.interop</code>. Now i want to add headings for all columns in that excel file. Also want to bold, color the heading row.</p>
  
  <p>I have something like this:</p>
  
  <pre><code>using Excel = Microsoft.Office.Interop.Excel; //initialize&amp;create,open app,wb,... 
  for (rCnt = 1; rCnt &lt;= range.Rows.Count; rCnt++) {
      WorkSheet2.Cells[rCnt2, 1] = xlWorkSheet.Cells[rCnt, 1]; 
      xlWorkSheet2.Cells[rCnt2, 2] = xlWorkSheet.Cells[rCnt, 2]; rCnt2++; 
  }
  </code></pre>
  
  <p>For formatting, i often use </p>
  
  <pre><code>range1=xlworksheet.get_Range("A1","A4"); 
  range1.Font.Bold;
  </code></pre>
  
  <p>Could u provide c# code for this using interop?</p>