Exporting to Excel

  • Thread starter Thread starter Andrew Cooper
  • Start date Start date
A

Andrew Cooper

I've got an ASP.NET page with a GridView connected to an Object Data
Source. The GridView is working fine but my users would like the
information to also be available in an Excel spreadsheet format. Is
there any way to export the data from either the Data Source or from the
Grid View into an Excel document programmatically and then link to it?

Andrew Cooper
 
I've got an ASP.NET page with a GridView connected to an Object Data
Source.  The GridView is working fine but my users would like the
information to also be available in an Excel spreadsheet format.  Is
there any way to export the data from either the Data Source or from the
Grid View into an Excel document programmatically and then link to it?

Andrew Cooper
Click to expand...

Simplest thing, which occasionally works, is to set the page's
ContentType to the MIME type for Excel ("application/excel" or
something like that). This will force the page to be opened by Excel
and might do the job (or you might just get a scrambled mess!)

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
 
Back
Top