我要讀寫EXCEL 文件
我已經在VB裡引用了Microsoft office 9.0 object library,它的位置在
C:\Program Files\Microsoft Office\Office\EXCEL9.OLBOption ExplicitPrivate Sub cmdStart_Click()
Dim SourceXLS As New Excel.Application
'Dim SourceXLS As Excel.Application
'Set SourceXLS = New Excel.Application '???????
Dim Col1() As String
Dim Col2() As String
Dim Col3() As String
Dim Col4() As String
Dim nRows As Long
Dim n As Long
Dim i As Long
Dim j As Long
Dim sFileName As String
If txtRows.Text = "" Then
MsgBox "請輸入源EXCEL文件的行數!", vbExclamation
Exit Sub
Else
nRows = txtRows.Text
End If
CommonDialog1.DialogTitle = "打開EXCEL文件"
CommonDialog1.Filter = "EXCEL文件(*.xls)|*.xls"
CommonDialog1.ShowOpen
sFileName = CommonDialog1.FileName
'SourceXLS.Workbooks.Open App.Path + "\Source.xls" SourceXLS.Workbooks.Open sFileName '提示載入DLL時發生錯誤。
'read data from Excel
For i = 1 To nRows
Col1(i) = SourceXLS.Worksheets(1).Cells(i, 1)
Col2(i) = SourceXLS.Worksheets(1).Cells(i, 2)
Col3(i) = SourceXLS.Worksheets(1).Cells(i, 3)
Col4(i) = SourceXLS.Worksheets(1).Cells(i, 4)
Next i
End Sub
我已經在VB裡引用了Microsoft office 9.0 object library,它的位置在
C:\Program Files\Microsoft Office\Office\EXCEL9.OLBOption ExplicitPrivate Sub cmdStart_Click()
Dim SourceXLS As New Excel.Application
'Dim SourceXLS As Excel.Application
'Set SourceXLS = New Excel.Application '???????
Dim Col1() As String
Dim Col2() As String
Dim Col3() As String
Dim Col4() As String
Dim nRows As Long
Dim n As Long
Dim i As Long
Dim j As Long
Dim sFileName As String
If txtRows.Text = "" Then
MsgBox "請輸入源EXCEL文件的行數!", vbExclamation
Exit Sub
Else
nRows = txtRows.Text
End If
CommonDialog1.DialogTitle = "打開EXCEL文件"
CommonDialog1.Filter = "EXCEL文件(*.xls)|*.xls"
CommonDialog1.ShowOpen
sFileName = CommonDialog1.FileName
'SourceXLS.Workbooks.Open App.Path + "\Source.xls" SourceXLS.Workbooks.Open sFileName '提示載入DLL時發生錯誤。
'read data from Excel
For i = 1 To nRows
Col1(i) = SourceXLS.Worksheets(1).Cells(i, 1)
Col2(i) = SourceXLS.Worksheets(1).Cells(i, 2)
Col3(i) = SourceXLS.Worksheets(1).Cells(i, 3)
Col4(i) = SourceXLS.Worksheets(1).Cells(i, 4)
Next i
End Sub
解决方案 »
- 自动计算两textbox里数值相除,得小数点后两位的百分数?
- 我想连接到SQL,再运行一段sql,哪位给个源码吧,找了好多都太复杂
- run time error '20534',error detected by database dll
- 注册.dll 问题?
- 是用msde还是用sql server?
- 我照别人的例子做了个收发邮件的程序,重装系统和VB后,编绎不了了。
- 怎么解决ActiveReport2.0中中文显示异常的问题?
- 想将自己的控件编译成ocx文件时,提示“检测到非公共的 UserControl”,是怎么回事?怎么解决??
- 有是高分问题:Bitblt,还有点问题。
- 在安装过程中自动安装MDAC2.7,用InstalShield如何作?
- VB6自带的日志功能如何使用?
- 共享文件夹度取得 问题
我以前也作過這方面的程序,是可以的。
我已經在VB裡引用了Microsoft office 9.0 object library,它的位置在
C:\Program Files\Microsoft Office\Office\EXCEL9.OLB
是不是引用錯了-----EXCEL9.OLB????????
office2000.excel的动态连接库就是这个东西
/////提示載入DLL時發生錯誤
可能是系统或者office2000的问题了