[ igrgic13 @ 23.05.2011. 13:37 ] @

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!!
[ drazenp86 @ 24.05.2011. 06:31 ] @
Imas ovde dosta dobro objasnjeno:

http://itsrashid.wordpress.com.../export-dataset-to-excel-in-c/
http://csharp.net-informations.../csharp-excel-datagridview.htm
[ igrgic13 @ 24.05.2011. 08:07 ] @
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]()
[ drazenp86 @ 24.05.2011. 12:49 ] @
Probaj sa ovim:

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


EnableEventValidation="false";
[ jmarko2002 @ 25.05.2011. 21:35 ] @
Ovde imas dosta dobrih primera.

http://vb.net-informations.com/
[ igrgic13 @ 27.05.2011. 08:22 ] @
Odlično, ima dobrih primjera...

Trenutno sam napravio ovaj export u xls, cak i ok izgleda. Nije čisi xls naravno al uspio sam formatirati tablicu, fontove i sl tako da solidno izgleda!!