Import EXCEL data into Visual Studio 2019

Question

Can any one suggest me where to look for VB code for importing data from EXCEL into Visual Studio 2019

Answer 1

The usual way is with Office Interop
Many samples on Google, like :
Read data from an Excel workbook in Visual Basic .NET
How to Read an Excel file in Windows Forms Application using C# and Vb.Net
etc...

Answer 2

• To open Excel with automation see the following code sample.
• With OleDb see the following code sample.

Either way, there is not one ideal method that will work for every file, you will need to tinker with the code in many cases dependent on how things are structured and if there are mixed types in columns which is shown in this code sample for OleDb.

I have a bunch of code samples here.

Answer 3

Try this solution. More details can be found through this link - https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html

Dim workbook As Workbook = New Workbook
workbook.LoadFromFile(..\ FandH.xlsx)
Dim sheet As Worksheet = workbook.Worksheets(0)
Me.dataGridView1.DataSource = sheet.ExportDataTable