Question

VB.NET获取Excel单元格内容

想获取某个Excel中的某个单元格的内容，让它显示在文本框里，应该用哪个命令？
网上找了半天，都是给单元格赋值的

Answer 1

Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim xlRange As Excel.Range
Dim strTmp As String = ""
xlApp = CreateObject("Excel.Application")
xlBook = xlApp.Workbooks.Open(txtfileName.Text)
xlSheet = xlBook.Worksheets(1)
xlApp.Visible = False
xlRange = xlSheet.Cells(1, 1)
strTmp = xlRange.Value'读取第一行第一列值,其它的你自己可以写
xlApp.Application.Visible = False
xlBook.Close()
xlApp = Nothing'"交还控制给Excel
xlBook = Nothing
xlSheet = Nothing

Answer 2

在程序中引用spire.xls.dll

1. Imports Spire.Xls

2.  

3. Namespace GetCellValue

4.     Class Program

5.         Shared  Sub Main(ByVal args() As String)

6.             '创建Workbook对象

7.             Dim wb As Workbook =  New Workbook() 

8.  

9.             '加载Excel文档

10.             wb.LoadFromFile("C:\Users\Administrator\Desktop\test.xlsx")

11.  

12.             '获取第一个工作表

13.             Dim sheet As Worksheet =  wb.Worksheets(0) 

14.  

15.             '获取指定单元格的值

16.             Dim value As String =  sheet.Range("C4").Value2.ToString() 

17.         End Sub

18.     End Class

19. End Namespace