VB里能连接EXCEL吗?
解决方案 »
- 请问各位,哪有免费的spread3.0下载啊.谢谢
- 过几天需要发布软件,需要ftp空间,大该学要60mb,用一个星期就可以拉!!请帮帮忙!
- midi发声的程序怎么写??
- 怎样把A表里的100条记录都放到B表里去?
- TextBox控件如何换行?
- 请问ActiveBar2.1控件不支持XP操作系统吗?如果不支持,哪里有支持XP操作系统ActiveBar控件提供?
- 在vb中怎么在一个窗体中某一个地方引入另一个窗体?
- 打包问题(答对了立即 结)
- 如何在treeview的节点名称及combo的item名称上显示两种不同字体及两种不同颜色(同一行)
- 有无可能做一个用于考察AUTHORWARE操作的机考系统
- ADO连接EXCEL出现“run time error”是怎么回事 谢谢
- 在一个窗体中要显示很多内容,放不开,用什么技术好呀?
是金山的API开发文档,同样适用于微软的OFFICE!
我第一次连接 Excel,就是搜索到的。
如果当作数据源,则用ADO。相关的代码,网上都可以找到。
'引用 Microsoft Excel 11.0 Object Library
Dim xlsApp As Excel.Application
Dim eworkbook As Workbook
Dim eworksheet As Worksheet
Set xlsApp = New Excel.Application
Set eworkbook = xlsApp.Workbooks.Open("G:\2005.xls")
Set eworksheet = eworkbook.Sheets("Sheet1")
With eworksheet
'1
.Cells(1, 1) = "1"
.Cells(1, 2) = "2"
.Cells(1, 3) = "3"
'2
.Cells(2, 1) = "11"
.Cells(2, 2) = "22"
.Cells(2, 3) = "33"
'3
.Cells(3, 1) = "111"
.Cells(3, 2) = "222"
.Cells(3, 3) = "333"
End With
eworkbook.Save
eworkbook.Close
xlsApp.Quit
End Sub
If ERR.Number = 429 Then 'not exist Excel instance
Set Xl = CreateObject("Excel.Application")
End If'Open Excel Sheet
Xl.Workbooks.Open (App.Path & "\Report\GC020R.xls")
Set Ws = Xl.Worksheets("Sheet1") Rows = vaSpread1.MaxRows
ReDim Ary_Char(0 To Rows, 1 To vaSpread1.MaxCols)
For IDr = 0 To Rows
j = 0
vaSpread1.Row = IDr
For i = 1 To vaSpread1.MaxCols
vaSpread1.COL = i
If vaSpread1.ColHidden = False Then
j = j + 1
Ary_Char(IDr, j) = vaSpread1.Text & ""
End If
Next i
Next IDr
DestRange = Rows + 4
Ws.Range("A4:" & Chr(vaSpread1.MaxCols + 64) & DestRange).Value = Ary_Char 'FILL DATA Ws.Range("B3").Value = Format(Date, "YYYY-MM-DD")
Ws.Range("P3").Value = oLbl_RecordCount.Caption
Ws.Range("R3").Value = oLbl_Count.Caption Screen.MousePointer = vbDefault frmPrint.Show 1 Exit Sub
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\f\study\book1.xls;Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""",其他跟连接其他数据库一样
就是要select时不清楚怎么select,除非select *