title: Display columns and rows after exporting data from gridview to excel
body: <p>Hi all i am having a task to export gridview data to excel which i have done using the forums and articles available.</p>
  
  <p>But i would like to display complete <code>excel columns</code> after the data was imported to excel, means expect the place occupied by the grid content i would like to display the remaining columns of the excel as it is.</p>
  
  <p>Sample the normal way of exporting the we do in common is as follows</p>
  
  <p><img src="https://i.stack.imgur.com/rR7dI.jpg" alt="enter image description here"></p>
  
  <p>My requirement is to show as follows</p>
  
  <p><img src="https://i.stack.imgur.com/cIROq.jpg" alt="enter image description here"></p>
  
  <p>I followed as per here</p>
  
  <p><a href="http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx" rel="nofollow noreferrer">http://www.aspsnippets.com/Articles/Export-GridView-To-Word-Excel-PDF-CSV-Formats-in-ASP.Net.aspx</a></p>