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...
***********************************************
***********************************************
Download source code here : drive.google.com/open?id=15pM...
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
***********************************************
Reference :
www.codeproject.com/Questions...
• How to export data fro...
stackoverflow.com/questions/2...
***********************************************
Download Visual Studio : www.visualstudio.com/
***********************************************
Music Background :
Song: Envici - November (Original Instrument)
Music provided by Twin Pillars Records: • Video
Artists: Envici
Download: goo.gl/aDiQhU
Lights by Sappheiros / sappheirosmusic
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
creativecommons.org/licenses/...
Music promoted by Audio Library • Lights - Sappheiros (N...
Song: Ikson - Do It (Vlog No Copyright Music)
Music promoted by Vlog No Copyright Music.
Video Link: • Video
***********************************************

[@tommcmeekin1]

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

[@utehstr]

You're welcome :-)

[@VictorSouza-cn5nr]

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.

[@utehstr]

You're welcome 🙂

[@goodrive4757]

NICE gan sungguh bermanfaat

[@utehstr]

Terima kasih :-)

[@user-mu9pv4fo4o]

thanks very useful

[@omahgedek4448]

Thanks bro..

[@govindaraji2348]

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

[@utehstr]

You're welcome🙂

[@jheizandalis952]

can you make an example for importing single excel file with multiple sheets inside. with searchbar. thanks

[@edsonmauricioplatayugra3424]

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

[@masyanto3658]

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

[@isaackennethjoseph8924]

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
'Microsoft.Office.Interop.Excel.Application'. to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because of the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' Failed due to the following error: Error loading type library/DLL.(Exemption From HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

[@borithy559]

very good thank u

[@utehstr]

You're welcome :-)

[@ivango1182]

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

[@winsilopes456]

thank's very good tuto

[@utehstr]

You are welcome :-)

[@ashercrush8953]

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

[@bayuichigo9847]

Trimakasih Banng

[@utehstr]

Sama-sama :-)

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

[@vinray8781]

Pls help why only first row is exported to excel

[@meftehferes4994]

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

[@annisasrianggraini116]

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

[@AsupanInternet]

Awesome :)

[@utehstr]

Thank you :-)

[@kimmergal8330]

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

[@GAMINGWITHINTELHD2000]

​ @Uteh Str The File IS Working Fine Thank U

[@utehstr]

You are welcome :-)

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

[@utehstr]

Kalau ada waktu luang akan saya buat, tapi mungkin tidak dalam waktu dekat ini :-)
Terima Kasih

[@Jalan_Bareng_Bocil]

Siap bang di tunggu ya bang makasih 🙏

[@jericotelan6020]

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

[@utehstr]

Look here : www.vbforums.com/showthread.php?857031-The-Microsoft-ACE-OLEDB-12-0-provider-is-not-registered-on-the-local-machine

[@GAMINGWITHINTELHD2000]

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

[@utehstr]

I've never experienced anything like that, this link might help:
www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine
www.layer2solutions.com/support/business-data-list-connector-faqs/how-to-access-office-2010-data-from-sharepoint

[@baynabaykabayka2481]

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

[@utehstr]

The process of saving long or not stored at all ?

[@user-ck3zn2ms3j]

knp di aku ga ada referensi ms excell nya ya

[@muhammadfattah775]

bang, kalau import excel dengan cara begini, gimana cara filter data dgv-nya menggunakan textboxt bang?

[@utehstr]

Maksudnya ? Maaf saya tidak mengerti maksud kamu.

[@ragamotomotif1770]

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

[@utehstr]

coba kode pada link ini : www.codeproject.com/Questions/841359/Faster-way-to-export-data-from-datagridview-to-exc , lihat kode pada "Solution 2", saya sudah coba dan menurut saya lebih cepat dari pada yang ada pada video.

[@zaqiarmanovandi2919]

bang saya pakai vb 2010 dan Ms Excel 2016. Dan error bang karena tidak ada library. dan saat mencari refference di vb untuk MS excel object library, gak ada bang. mohon pencerahannya

[@utehstr]

Lihat disini : www.vbforums.com/showthread.php?777615-Work-with-excel-objects-Missing-Microsoft-Excel-12-0-Object-Library

[@MuhammadAmin-el3vr]

Numpang tanya, kalau data di datagridview itu di tampilkan ke textbox, kemudian menggunakan button next dan previous untuk melanjutkan ke data selanjutnya gimana mas

[@thewalkers1116]

kasih tau fungsi dari setiap item nya dong bang

[@sergoa.8849]

6:01

[@vanphinuce]

Excuse me, What is the background music in the video ?

[@utehstr]

Look at the video description

[@vanphinuce]

@@utehstr Thank you

[@laszlototh4417]

Hi!
Can you help?
I get this error message when importing:
System.InvalidOperationException: 'The provider 'Microsoft.ACE.OLEDB.12.0' is not registered on the local machine.'
Anyway, nice job!

[@rezhapramudiaadhiti1579]

kalo export 2 datagridview sekaligus bisa ga?

[@utehstr]

Saya belum pernah coba kalau pakai 2 dgv, jadi saya belum tau bisa atau tidak. Mungkin kamu boleh mencobanya :-)

[@randaelguenouni7509]

Please did you find the solution ?

[@VinodbhaiPatel-uo1rl]

Move jaisa music nahi chalega

[@itpusatasoka2432]

Bang Kalau Export Ribuan Kok lama banget ya Hampir 10 menit, Ada cara yg lebih cepat bang ?, Terimakasih

[@utehstr]

coba kode pada link ini : www.codeproject.com/Questions/841359/Faster-way-to-export-data-from-datagridview-to-exc , lihat kode pada "Solution 2", saya sudah coba dan menurut saya lebih cepat dari pada yang ada pada video.

[@itpusatasoka2432]

@@utehstr Okee Thanks

[@HS-gb4wx]

Hi Sir, thanks before for the tutorial, but the source code can not be downloaded, can you help, thanks

[@utehstr]

I've checked it and the file can be downloaded.

[@sergoa.8849]

12:20 текст проги

[@shinepdf2713]

Download file is damage, please check and upload again

[@utehstr]

I checked it, the file is fine and can be downloaded.
For information, I save this file in the file format ".rar", Google Drive does not provide a preview of the file format ".rar", so you must download it first to see the file. Make sure you have the software to open the file format ".rar", for example software like winRAR.

[@Gadzooks-fx9ng]

@@utehstr same issue here, unsolved

[@utehstr]

@@Gadzooks-fx9ng I have checked it many times and the file can be downloaded. I do not know whether this is blocked in some regions or countries. I have tried searching for it on Google, try reading this : support.google.com/a/answer/2992016?hl=en

[@user-ut9vi7fu8v]

new meta to?\

[@CuongBui-hf8kj]

very very slowly