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

[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?

[filipinasmabatid]

An unhandled exception of type occurred in .exe

How to fix the error. Thanks

[rustypalelr]

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

[dusktaker]

Not a clear tutorial
Broken Link
may i please have the complete sets of 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... 

[geoffe]

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

[edsonmaleiane]

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

[prasadshete]

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

[TheGuursade]

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

[joseolivo]

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

[michelecostantino]

I have not in the list, how can I add it?

[zachkrizan]

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

[Liviualexutavlad]

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

[SOLDACCOUNT]

deLeting on excel via datagrids??
how??

[parthlogistic]

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

[GboleKepo]

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

[JosueLopezXIX]

Can you please provide the script code?

[SuperGamezDownloader]

guys who have error please add to your project reference

[lebronimad]

Sir please please please need your code

[MetinTuncer]

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