How to read an Excel file using VB.Net
The following program illustrates how to open an existing Excel spreadsheet in VB.Net using .NET Framework COM interop capability. Also this program explains how to Find the last used row in Excel and how to find Named Ranges in Excel
Excel Data Reader using Excel Interop
The following VB.Net source code using Microsoft Excel 12.0 Object Library for reading an Excel file. In the previous section we saw how to import Microsoft Excel 12.0 Object Library in the VB.Net project .How to add Excel Library
Reading Cells in Excel Using VB.NET
If you want to select a specific cell in Excel sheet, you can code like this.
Using EXCEL Named Ranges in VB.NET
If you want to select multiple cell value from Excel sheet, you can code like this.
How to get the range of occupied cells in excel sheet
For reading all used rows of an Excel file in VB.Net, we have to know how many cells used in the Excel file. In order to find the used range we use "UsedRange" property of xlWorkSheet . A used range includes any cell that has ever been used. It will return the last cell of used area.
When you execute this source code the program read all content from Excel file.