在VB.NET怎样动态读取EXCEL单元格的值?
szyyx 2007-05-13 06:42:29 各位高手帮忙看一下
我想用VB.NET动态读取每个单元格的值,在LISTBOX显示出来,不知怎样用变量,请各位帮帮忙?
Dim objExcelFile As Excel.Application
Dim objWorkBook As Excel.Workbook
Dim objImportSheet As Excel.Worksheet
objExcelFile = New Excel.Application
objWorkBook = objExcelFile.Workbooks.Open(strFileName)
objImportSheet = objWorkBook.Sheets.items(1)
listbox.items.add()
如下EXCEL表.
dept itemcede
10 000001
10 123458
10 124478
12 346798
12 789425