 |
|
Web Wiz Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Need to export Gridview results to Excel |
Post Reply 
|
| Author | |
luwandui 
Groupie 
Joined: 10 August 2011 Status: Offline Points: 64 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Need to export Gridview results to ExcelPosted: 07 September 2011 at 7:42am |
|
I have a very simple asp page that shows the results of an SQL query in gridview. I would like to place button on the page that will allow the user to extract the data to excel. I need to do this in either asp or vb. Any suggestions would be appreciated.
Thanks |
|
 |
|
|
s93ncer
Newbie 
Joined: 08 February 2006 Status: Offline Points: 4 |
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2012 at 8:23am |
|
You could add a button to the page to postback to itself with a parameter
You could then check to that parameter and add something like if request("parameter") = "excel" then response.ContentType="application/vnd.ms-excel" Then just write out your gridview - as long as the columns line up correctly it should work I seem to remember if the user has excel installed then it will just open, otherwise it will ask the user to save the file ...Spence
|
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
