How to export data from DataGridView to Excel in VB.NET

Export your Data from DataGridView to Excel using VB.NET.
For codes and more details please visit
techchoco.com/h...

[@sahar-srairi]

Thank you so much for the code ^^

[@filipinasmabatid2813]

An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in .exe How to fix the error. Thanks

[@JoseDarioCorrea]

Excellent! This was what I was looking for but do not want to create a new book, I want to export the data to a book that already exists, as I do?

[@dusktaker02]

Not a clear tutorial Broken Link may i please have the complete sets of code?

[@lavishrich]

worked fine for me!

[@rustypalelr]

How about if I'm going to add 2 or more sheet? What would be the code

[@gemlucenio]

hi, i would like to ask some favor, when i export, i want the data to transfer to a specific rows and columns with the same functions as this.. can you help me sir? it would be great if you can help me...

[@zachkrizan7818]

Error here: "xlWorkSheet.Cells(i + 2, j + 1) = Fitch_AllDataGridView1(j, i).Value.ToString()" Null REference not set to an instance of an object Object reference not set to an instance of an object

[@geoffe1987]

i have problems with these code's can you help me with a different code?

[@edsonmaleiane2618]

Hello... Please i want to print all datagridview values but without a database in VB.Net...

[@Liviualexutavlad]

I had the same error... All you need to do is delete the ".ToString" command. Besides that the work should work

[@divyakattamuri8269]

Thank you soo much

[@prasadshete2639]

Thanks .... But it can works if I search data and export

[@johney1985]

Superb.. Code please...

[@joseolivo3475]

Hola buenas Necesito exportar de un Datagriview a Word cuando yo escribe. Me. Explico no lo que biene de la Base de Datos si no cuando escriba del datagriwiEW En visual Basic.net

[@SOLDACCOUNT001]

deLeting on excel via datagrids?? how??

[@michelecostantino2961]

I have not "microsoft.office.interop.excel" in the list, how can I add it?

[@HassanAlamiMchichi]

i think you should install excel

[@SuperGamezDownloader]

guys who have error please add Microsoft.Office.Interop.Excel to your project reference

[@alihusseinalissa25]

How?? I am beginner :)

[@alanondo1067]

released object??

[@TheGuursade]

Hello sir i'm using lisview instead of gridview can you please help code thanks

[@garyoptica]

I would avoid using point and click containers and learn to do this using code. You simply don't get the flexibility you need as a coder when you set complex tasks up using drag and drop as you inherit a loss of programming control.

[@HarshadPatelshrikalikaminerals]

get full code file. drive.google.com/open?id=0ByscXiijGlAuSXExZmJaTUdhc1E

[@rizalullutfi7175]

can send to my email sir ? because the link is doesn't work thanks

[@Darkyinkia]

Please invest in a microphone :3

[@andyajhisramadhan6453]

How to fix error "xlWorkSheet.Cells(i + 2, j + 1) = DataGridView1(j, i).Value.ToString()" it's doesn't work.

[@SamirRezai]

This will fix it. xlWorkSheet.Cells(i + 2, j + 1) = DataGridView1(j, i).Value

[@sahar-srairi]

Samir Rezai Thank you :)

[@invicibyul599]

+Samir Rezai hi i use that code but still having error? what should i do?

[@parthlogistic374]

its not working For k As Integer = 1 To dgv_gstn.Columns.Count xlworksheet.Cells(1, k) = dgv_gstn.Columns(k - 1).HeaderText xlworksheet.Cells(i + 1, j + 1) = dgv_gstn(j, i).Value.ToString() next he through error object not set what can i do plz help me

[@vipulgehlot9304]

data can not enter in excel file

[@JosueLopezXIX]

Can you please provide the script code?

[@MetinTuncer]

problem Missing.Value dosent work.. I useing Excel 2013 ..

[@poptrt]

Does not work

[@markalix1060]

Great work...but many errors

[@fzorig]

source>?

[@lebronimad9941]

Sir please please please ..........i need your code

[@amzch3d]

this is a broken Link

[@martinsantos4348]

pls renew the site.

[@SongbyKOK]

Code OK but process Long time

[@arijit786]

Not clear

[@user-gc6sd3gw2v]

i have code

[@dusktaker02]

+จิรศักดิ์ ราวพิมาย may i please have the complete code?

[@Thebluewilli]

syntax error.... thx for nothing....