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

Подписаться 18 тыс.

Просмотров 71 тыс.

50% 1

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: • [No Copyright Music] E...
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
***********************************************

Наука

Опубликовано:

22 фев 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 71

@tommcmeekin1 4 года назад

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

@utehstr 4 года назад

You're welcome :-)

@goodrive4757 4 года назад

NICE gan sungguh bermanfaat

@utehstr 4 года назад

Terima kasih :-)

@omahgedek4448 4 года назад

Thanks bro..

@user-mu9pv4fo4o 3 года назад

thanks very useful

@edsonmauricioplatayugra3424 3 года назад

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

@borithy559 3 года назад

very good thank u

@utehstr 3 года назад

You're welcome :-)

@govindaraji2348 8 месяцев назад

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

@utehstr 7 месяцев назад

You're welcome🙂

@jheizandalis952 5 месяцев назад

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

@winsilopes456 5 лет назад

thank's very good tuto

@utehstr 5 лет назад

You are welcome :-)

@VictorSouza-cn5nr 4 года назад

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 4 года назад

You're welcome 🙂

@bayuichigo9847 3 года назад

Trimakasih Banng

@utehstr 3 года назад

Sama-sama :-)

@masyanto3658 4 года назад

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

@ashercrush8953 2 года назад

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

@ivango1182 4 года назад

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

@TwinPillarsSounds 4 года назад

Awesome :)

@utehstr 4 года назад

Thank you :-)

@isaackennethjoseph8924 4 года назад

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)).

@vinray8781 4 года назад

Pls help why only first row is exported to excel

@RyankuNS 4 года назад

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

@meftehferes4994 4 года назад

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

@GAMINGWITHINTELHD2000 5 лет назад

@Uteh Str The File IS Working Fine Thank U

@utehstr 5 лет назад

You are welcome :-)

@kimmergal8330 5 лет назад

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

@annisasrianggraini116 Год назад

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

@Jalan_Bareng_Bocil 5 лет назад

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 5 лет назад

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

@Jalan_Bareng_Bocil 5 лет назад

Siap bang di tunggu ya bang makasih 🙏

@GAMINGWITHINTELHD2000 5 лет назад

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 5 лет назад

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

@jericotelan6020 4 года назад

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

@utehstr 4 года назад

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

@baynabaykabayka2481 5 лет назад

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

@utehstr 5 лет назад

The process of saving long or not stored at all ?

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

@user-ck3zn2ms3j 6 месяцев назад

knp di aku ga ada referensi ms excell nya ya

@zaqiarmanovandi2919 4 года назад

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 4 года назад

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

@MuhammadAmin-el3vr 4 года назад

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 3 года назад

kasih tau fungsi dari setiap item nya dong bang

@vanphinuce 5 лет назад

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

@utehstr 5 лет назад

Look at the video description

@vanphinuce 4 года назад

@@utehstr Thank you

@rezhapramudiaadhiti1579 4 года назад

kalo export 2 datagridview sekaligus bisa ga?

@utehstr 4 года назад

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

@randaelguenouni7509 2 года назад

Please did you find the solution ?

@itpusatasoka2432 2 года назад

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

@utehstr 2 года назад

@itpusatasoka2432 2 года назад

@@utehstr Okee Thanks

@sergoa.8849 Год назад

6:01

@VinodbhaiPatel-uo1rl 2 месяца назад

Move jaisa music nahi chalega

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

@sergoa.8849 Год назад

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

@HS-gb4wx 3 года назад

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

@utehstr 3 года назад

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

@user-ut9vi7fu8v 3 года назад

new meta to?\

@shinepdf2713 5 лет назад

Download file is damage, please check and upload again

@utehstr 5 лет назад

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 5 лет назад

@@utehstr same issue here, unsolved

@utehstr 5 лет назад

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