Import Data From Excel File to VB.Net

[@jamesfrancia2376]

oh my gosh! it really surprised me to find a tutorial on this in tagalog. thank you po!!!

[@gordonwolfe2536]

Thank you Sir Paya, that was so good and exactly what I was looking for, I didn't skip the ads! thank you.

[@SirPaya]

Glad it was helpful!

[@rexwilliams2896]

Took me a while but finely got there. But how do you do some non adjacent columns. Like columns 1-3, 5,8,10

[@KlausKeplinger]

Thank you that was a great explanation

[@ivandaevesarsadillas6340]

Nice sir nag dub na gajud hahaha

[@АлександрИванович-б6м]

And what if I want to read data from Sheet2 or another? Will it works?

[@SirPaya]

yes

[@АлександрИванович-б6м]

​@@SirPaya Sorry, I'm not a professional. I change "Sheet1" to "Sheet2" and it didn't work. It load data from the saved sheet. If I save excel file on Sheet1 - loads from Sheet1. If I save excel file on Sheet2 - loads from Sheet2. Line 22 don't work in my repetition of your code.

[@АлександрИванович-б6м]

@@SirPaya ?

[@jordyramirez9697]

A good video ¡¡ You've helped me a lot

[@Matthew.1994]

how can i search for a name that i input to a textbox and then give me only that row or let the birthdate be shown in a massgebox for example?

[@SirPaya]

use where clause in your sql statement

[@Matthew.1994]

@@SirPaya i dont use sql, i just want to use a excel file

[@dsudhir005]

Hello, this is sudhir your code was great after that please saher gridview auto sr NO column and one text box data insert in gridview with excel using textbox. Can you show me how to, also save to SQL DATA base code Please

[@tganton21]

Anong visual studio version gamit mopo?

[@SirPaya]

Ito 2010 pa peru ngayon 2022 na gamit ko

[@yu7521]

Sir pwede ba ma filter for example yung address using only textbox as search?

[@anonymouscyp4308]

How I can import specific Excel file automatically?!

[@mr.RAND5584]

Salamat mas ok to kesa mobile legend adik n ko.

[@lailay3800]

Great, I want code to read excel file with filter some data

[@chardcoretv8784]

Sir may error ako nkukuha kpag mag import na. Rows cannot be programmatically added to the datagridview rows collection when the control is data-bound

[@ralpryandelacruz2512]

pano po gawing inputted yung count or ispecific yung range

[@SirPaya]

Inputted ex 5 tapos 5 record lng din ang llbas? Pagganum use limit pag mysql, top for mssql

[@mr.RAND5584]

Sir bk meron k vb.net web request, sending json string, sending header string, response json string. Hirap maghanap puro csharp.

[@jefesanes]

di ko po magamit yung .Text nao pong problema nun?

[@evbwe8891]

sir pano mag-add pop up progress bar when loading excel to datagridview? medyo madami po kaseng laman excel ko.

[@SirPaya]

Threading lang yan boss. Gawan kita ng example pagkakavant ako bukas

[@evbwe8891]

@@SirPaya sige sir maraming salamat

[@TheSarmurai]

Sir okay na okay po ito ginawa mo, pero after importing the excel file, pwede ba mapili yung ibang laman at mai-transfer o ma-save uli sa excel format. Kung baga may pick lang ako details tapos i-save ko siya uli sa excel.

[@SirPaya]

Pwede lagyan lng ng checkbox sa datagridview, kung sinong lng ang nkacheck xa lng ang maexport

[@Myst876]

sir how to update on foreign key sir upon import ng excel

[@SirPaya]

Gagawa ako ng discord para maexplain ko

[@elpidiopantoja738]

sir yung sakin walang microsoft.interop. paano po ba mag kakaroon ng ganun? salamat po

[@SirPaya]

Install ka ms office

[@elpidiopantoja738]

@@SirPaya meron naman po ako naka install sir

[@charlesbenjo]

Am i Late? Paano naman po i save eto sa Mysql database sa XAMPP?

[@SirPaya]

gawa ako ng tutorial

[@carlaaoun3978]

System.MissingMemberException: 'Public member 'Text' on type 'Range' not found.'

[@clemmmy4757]

Error ako sir sa OpenFileDialog :c

[@SirPaya]

What kindnof error?

[@pedromedeiros9053]

"cannot convert COM object of type 'Microsoft.Office.Excel.ApplicationClass' in interface type' Microsoft.interop.excel.Application.

[@pedromedeiros9053]

The same error appeared to me