[es] - Multiple gridview vb.net export u EXCEL

igrgic13

Član broj: 141138
Poruke: 23

+1 Profil

Multiple gridview vb.net export u EXCEL

^{23.05.2011. u 13:37 - pre 157 meseci}

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!!

Odgovor na temu

drazenp86
Drazen Pupovac
Novi Sad

Član broj: 234628
Poruke: 5
*.adsl-2.sezampro.rs.

Profil

Re: Multiple gridview vb.net export u EXCEL

^{24.05.2011. u 06:31 - pre 157 meseci}

Imas ovde dosta dobro objasnjeno:

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

Odgovor na temu

igrgic13

Član broj: 141138
Poruke: 23

+1 Profil

Re: Multiple gridview vb.net export u EXCEL

^{24.05.2011. u 08:07 - pre 157 meseci}

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]()

Odgovor na temu

drazenp86
Drazen Pupovac
Novi Sad

Član broj: 234628
Poruke: 5
*.adsl-2.sezampro.rs.

Profil

Re: Multiple gridview vb.net export u EXCEL

^{24.05.2011. u 12:49 - pre 157 meseci}

Probaj sa ovim:

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

EnableEventValidation="false";

Odgovor na temu

jmarko2002
Jovanovic Marko
Uzice

Član broj: 10271
Poruke: 29
*.dynamic.isp.telekom.rs.

Profil

Re: Multiple gridview vb.net export u EXCEL

^{25.05.2011. u 21:35 - pre 157 meseci}

Ovde imas dosta dobrih primera.

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

Odgovor na temu

igrgic13

Član broj: 141138
Poruke: 23

+1 Profil

Re: Multiple gridview vb.net export u EXCEL

^{27.05.2011. u 08:22 - pre 157 meseci}

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!!

Odgovor na temu