VB.NET Tutorial - Open and Read Excel files/ Import Excel file to DataGridView | FoxLearn

Programming in Visual Basic .Net: Open and Read Excel files/ Import Excel file to DataGridView using ExcelDataReader, ExcelDataReader.DataSet in VB.NET Windows Forms Application.

Lightweight and fast library written in C# for reading Microsoft Excel files (2.0-2007).

ExcelDataReader extension for reading Microsoft Excel files into System.Data.DataSet.

[lhrintl]

Was waiting for this. Thanks for uploading!!!

[pauldenton]

Hello. Could you please tell how you switched to the Events tab in the Properties window at 8:34? I can't find such shortcut in my VS 2013.

[jordyramirez]

A good code ¡¡¡ Thank you so much ¡¡ You help me a lot. I'll subscribe

[xghimhg]

iv a two pbs
1. that when i click or select the sheet again so it reads the excel again and that wht idn want have
2. when the sheet is empty so ive to show a messagebx that the Sheet empty si how i can check if the Sheet empty or not thank you so much :)

[logiclaunchpvt.ltd.officia]

can you work on open any file such as txt, word file in richtextbox when selected from listbox ??

[ahmadzulhamizanahmadrudain]

hello could i ask how do take the imported
total value of column and row to find the average value to put in textbox

[ITLAB]

Can you add progess count of row like progress bar or animation gif file loading when import file?

[abarnaabi]

How to export specific column values from the sheet to datagrid. Excel does not have header how can we do it with column(A, B...)

[Matthew.]

how can i search for a secific name and then get the adress for example out of it automaticly to a string variable or just a messagebox?

[DavidKurniawan]

Its Simple than uuses Microsoft Office INterop. Tks

[emilionavarrete]

Hi! Great video, very clear instructions. One question, is there a way to extract information from specific cells without directly selecting them from the DataGridView?

[riyadh]

I have wandered, about how to use this method to import the excel data to MS Access as an additional step

[Fdcmbv]

Great Video Thank you! How do i save information that I, eventually, want to put in there?

[josemariabaja]

hi fox learn I have an error " no datais available fort encoding 1252. for information on defining a custom encoding, see the documentation for the encoding. registerprovider method" how can i fix it? thanks

i get this error System.NotSupportedException: 'No data is available for encoding 1252. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method.'

[HariKrishna-tchu]

'Object variable or With block variable not set.'
excel sheet is not opening i data gridviwe pls help to solve this problem

[kaleshkarun]

Nice explanation....Thank you Madam.
How to call/select only specific column of this data Gridview to another form of the same project for mathematical calculations such as mean, SD etc ??

[carloscarrillo]

Hello, How Can I install ExcelDataReader from VS 2008 web.NET? I can't reach de Nuget Package, or maybe there´s a way to install it? good video btw

[segalgbenou]

hello, i created a QR code generating application in C # thanks to you (grandiose your courses) ... i have 2 problems now: 1- i have a database in SQL and i would like to store, with a button "Download", the image of the QR code generated in Visual Studio 2019 in my database ... 2- I would like, with a button "Find", to bring back the image / all the images linked to an identifier, ID that I will enter in the textbox just next to the "Find" button .... still in c # ... can you help me please?

[logiclaunchpvt.ltd.officia]

Can you work on open and read word files (.docx & .Doc) in richtextbox and save files as word files (.docx & .Doc) and .txt ?