VB.NET读取excel行和列

在VB.NET中，可以使用Microsoft.Office.Interop.Excel库来读取Excel文件的数据。以下是一个简单的步骤来读取Excel的工作表中的行和列：

1. 引入所需命名空间：

Imports Microsoft.Office.Interop.Excel

2. 创建Excel应用程序实例：

Dim excelApp As New Application()
Dim workbook As Workbook = excelApp.Workbooks.Open("路径\to\your\file.xlsx")
Dim worksheet As Worksheet = workbook.Sheets(1) '假设工作表索引从1开始

3. 选择特定范围，例如A1到C5，代表第一行到第五行的A、B、C三列：

Dim range As Range = worksheet.Range["A1:C5"]

4. 遍历行和列获取数据：

For Each row As Range In range.Rows
    For Each cell As Range In row.Cells
        Console.WriteLine("行：" & row.Row + ", 列：" & cell.Column & ", 值：" & cell.Value)
    Next
Next

5. 关闭并释放资源：

workbook.Close()
excelApp.Quit()
Marshal.ReleaseComObject(worksheet)
Marshal.ReleaseComObject(workbook)
Marshal.ReleaseComObject(excelApp)