Multiple gridview vb.net export u EXCEL

Imam na stranici vise gridview-ova i za primjer
- prvi prikazuje podatke o kupcu
- drugi prikazu podatke o dobavljacu
- treci prikazuje proizvode

to bih htio eksportirat u XLS fajl...pa ako netko ima neku sugestiju ili primjer vrlo rado bih prihvatio.

tnx!!

Imas ovde dosta dobro objasnjeno:

http://itsrashid.wordpress.com.../export-dataset-to-excel-in-c/
http://csharp.net-informations.../csharp-excel-datagridview.htm

nasao sam na netu par primjera, recimo ovaj...radi ili ne dobro :)
ispise mi samo jedan gridview i to onaj gdje imam ime i prezime, a recimo drugi gridview ne zeli, niti zeli ispisat kad su oba ukljucena..izbaci mi gresku
RegisterForEventValidation can only be called during Render();



Dim fileName As String = "excel_export_test.xls"

Response.ContentType = "application/vnd.ms-excel"
Response.ContentEncoding = System.Text.Encoding.[Default]
Response.Charset = "Windows-1250"
Response.AddHeader("content-disposition", "attachment;filename=" & fileName)

Dim sWriter As New System.IO.StringWriter()
Dim hWriter As New System.Web.UI.HtmlTextWriter(sWriter)

Dim sBuilder As New StringBuilder()
sBuilder.Append("<html xmlns:o=urn:schemas-microsoft-com:office:office xmlns:x=urn:schemas-microsoft-com:office:excel xmlns=http://www.w3.org/TR/REC-html40>" & vbCr & vbLf)
sBuilder.Append("<head>" & vbCr & vbLf & "<meta http-equiv=Content-Type content=text/html; charset=windows-1250>" & vbCr & vbLf & "<meta name=ProgId content=Excel.Sheet>" & vbCr & vbLf)
sBuilder.Append("<meta name=Generator content=Microsoft Excel 11>" & vbCr & vbLf & "<style>col" & vbTab & "{mso-width-source:auto;}</style>" & vbCr & vbLf)

hWriter.Write(sBuilder)
GridView2.RenderControl(hWriter)
GridView1.RenderControl(hWriter)


Dim content As String = sWriter.ToString()

Response.Write(sWriter)
Response.Flush()
Response.[End]()

Probaj sa ovim:

EnableViewState = False;
Response.Charset = String.Empty;


EnableEventValidation="false";

Ovde imas dosta dobrih primera.

http://vb.net-informations.com/