Visual Basic .Net | Export DataGridView to Excel and Import Excel to DataGridView with VB .NET

Visual Basic .Net | Export DataGridView to Excel and Import Excel to DataGridView with VB .NET . In this project video I use Visual Studio 2015 and Microsoft Office 2007.

***********************************************
Thanks for watching & don't forget to like, comment and Subscribe...
***********************************************

***********************************************

***********************************************

For other video tutorials on this channel, please see this playlist:

***********************************************
Reference :

***********************************************

***********************************************

Music Background :

Song: Envici - November (Original Instrument)
Artists: Envici

Creative Commons — Attribution 3.0 Unported — CC BY 3.0

Song: Ikson - Do It (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
***********************************************

[govindaraji]

Thank you lot brother you are saved my college life ❤❤❤

[tommcmeekin]

Thanks, worked great and faster than anything else I've tried with around 50, 000 rows :)

[edsonmauricioplatayugra]

I am using vb-2015 with excel 2016 ... when exporting and importing I get a message box Failed to save !!! help me please .. thanks

[VictorSouza-cnnr]

Thanks bro, worked fine! For the ones having problem saving the file, replace in the code the lines with document format and sheet name to your PC's language respective, my PC uses Portuguese language so I replaced "Excel Document (*.xlsx)|*.xlsx" to "Pasta de Trabalho do Excel (*.xlsx)|*.xlsx" and "sheet1" to "Planilha1". Thank you Uteh Str.

[ivango]

Hey why when i click export, sometimes it says failed to save and sometime it saved but inside the excel file does not have any data pls help

[isaackennethjoseph]

Can you please help me? I use the source code that you provide, but when I run the program, error msg says
" Unable to cast COM object of type
to interface type This operation failed because of the QueryInterface call on the COM component for the interface with IID Failed due to the following error: Error loading type library/DLL.(Exemption From HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

[masyanto]

thanks sir, is good tutorial, i want request backup restore database mysql with vbnet

[ashercrush]

hi sir can help if i want export an image ex: qrcode from vb net picturebox to excel how did i do that

[kimmergal]

I got an error saying "object reference not set to instance of an object. "

[GAMINGWITHINTELHD]

When i Tun The Program It is saying Microsoft.Ace.oledb 12.0 is not registered in you local machine How to fix Microsoft.Ace.oledb 12.0 is not registered in you local machine

[GAMINGWITHINTELHD]

​ @Uteh Str The File IS Working Fine Thank U

[meftehferes]

Please helpppp. program is succesfully buged but i got an error message when i try to export to excell "failed to save !!!"where is the problem please

[RyankuNS]

Bro klo misal gue punya texboxt gtu yg di isi field2 data, kemudian gw export ke excel gtu bs ga? Bikin tutorial nya dong :3

[vinray]

Pls help why only first row is exported to excel

[Jalan_Bareng_Bocil]

Bang request dong untuk membantu pembuatan TA bang .
untuk gridview nampilin on off dari digital input di arduino misal menggunakan push button terus di simpan di excel.
saya cari di video abang kebanyakan analog bang
Kalo berkenan buatin tutorialnya bang

[annisasrianggraini]

Maaf sebelum nya, ini data yang di import gak bisa ya di update ke database?? Terimakasih sebelum nya kak

[jericotelan]

'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

[ckznmsj]

knp di aku ga ada referensi ms excell nya ya

[baynabaykabayka]

When I click export and save the file with my datagridview it get stucked in please wait It didn't save at all

[ragamotomotif]

bisa kah anda membantu saya bagaiman acara agar proses penyimpanan nya bisa lebih cepat atau responsif