Export data from Gridview to Excel

Hi All,

I'm using asp.net 2.0 to develop a web site to export data from Gridview to Excel.
I can successfully export a excel for using the code below:

   Response.Clear()
   Response.AddHeader("content-disposition", "attachment;filename=filename.xls")
   Response.Charset = ""
   Response.ContentType = "application/vnd.xls"

  Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
  Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)

  Dim gv As GridView = GetGridView() '// a function to generate Gridview

  gv.RenderControl(htmlWrite)
  Response.Write(stringWrite.ToString)
  Response.End()


This will export an excel with ONE (1) worksheet. Is it possible to Export an excel with TWO (2) or THREE (3) worksheet?
Is there other method to do it beside the about one?
Many thanks!

Ashley
ywingyanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
prajapati84Commented:
Just refer this link... a complete code...

http://geekswithblogs.net/azamsharp/archive/2005/12/21/63843.aspx

Regards,
Mukesh
0
 
ywingyanAuthor Commented:
thanks Mukesh,

But I can't find any different compare with mine. What I'm looking for is a method to export an Excel with more than one worksheet.

E.g. I have 2 GridView. gridView1 and gridView2. how to put the gridView1 on worksheet1 and gridView2 on worksheet2?

Regards,
Ashley
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ywingyanAuthor Commented:
Thanks for vivekthangaswamy  provided another way to export the data without using gridview. but this link still can't fix my problem..

finally I design to paste all the reason in one WorkSheet instead of Three.

THanks
0
 
Vivek ThangaswamyCommented:
Hi ywingyan

Is my solution helped you???
0
All Courses

From novice to tech pro — start learning today.