title: Excel Export button using EPPlus
body: <p>I developed Excel export button for my .Net application using EPPlus ( its an amazing library it helped me design my template really nice!). my gridview data is exporting to Excel file, the columns are in same order as the Gridview. the only issue is that I have added in the template design three columns so I want to have the flexibility and say e.g. column "First name" in gridview should export into Column "D" in Excel. how can you achieve this???</p>
  
  <p>this is my code so far:</p>
  
  <pre><code> For i As Integer = 0 To GridView1.Columns.Count - 1
  
                      dr("column" &amp; i.ToString()) = row.Cells(i).Text
  
                      dr("column" &amp; i.ToString()) = row.Cells(i).Text.Replace("&amp;nbsp;", " ")
  </code></pre>