h,JEyl;Qg0 昨天遇到这个问题.自己也有点迷茫,在51上发帖后得到高人指点,在这里我将代码写出来,留个足迹,呵呵,谢谢风过无痕.
-KEMkU0$S6Ohz_0------------------
v+JVbK:\07y(L7h K7uX0Set excelObj = CreateObject("Excel.Applicaiton") '创建一个对象
Y5L(sR4g_0xCOu3f.uG/C0xlsUrl = "C:\QTP\0110\sql-excel-qtp\data.xls" '指定一个已经存在的XSL文件路径51Testing软件测试网pBc)t$J-q
51Testing软件测试网GppA#n
VexcelObj.workbooks.open(xlsUrl) '打开EXCEL51Testing软件测试网$\~xoN&@)i
"PYD+v"U%o)J/N2WU0Set sheetNew = excelObj.sheets.item(2) '设置将数据放在EXCEL中的那一页上(索引从1开始)51Testing软件测试网2Z;Ftg_I1Mq
xz&bE+n@db'YN%l0'相关的数据库操作
iOf9{`H0LPq!z(G `)~1GY0Set conn = CreateObject("adodb.connection") set rs = createobject("adodb.recordset") conn.open "Provider=SQLOLEDB.1;Password=qaqc;Persist Security Info=True;User ID=test;Initial Catalog=test;Data Source=192.168.0.53" sql="select * from test" rs.open sql,conn51Testing软件测试网K;R5cN:],X
51Testing软件测试网;~ GX1Mu
}\1l.dDim i while not rs.eof
/?Q.pIrU"i7P'e^|051Testing软件测试网?gNVQM
Rt!~0d4@ s user_id = rs("user_id").value51Testing软件测试网%v&p;j!JenS
1Y*i0X-_)D
h!J7?5a4M0 user_name = rs("user_name").value51Testing软件测试网#Ue8c1O]Yu.~0f
51Testing软件测试网'sj*H}+}cI5LRtf sheetNew.cells(i+1,1).value = user_id '列付值
&_
K+A;Kv-s}051Testing软件测试网9~CY*x'wH$d7Cc sheetNew.cells(i+1,2).value = user_name '列付值51Testing软件测试网+O\)WC ^
l~)B$a/C8p(G/g0i = i + 1
3QiLA;o$gW0&wJ-k/P!Ia_2X)fQ~.Q0 rs.movenext
7t:Ns`p9KH0v7x'D5D)mtF8G0wend
5gNq6k.@y0#G$gH)HC$y:AT0excelObj.activeworkbook.saveas "C:\QTP\0110\sql-excel-qtp\data.xls" '保存数据
9s*c}&LG'}eM051Testing软件测试网 e!p8]S5Mh M4u[
e9pRexcelObj.quit '关闭对象51Testing软件测试网Vb\P(Da,u
Hq*zr(k,j0set excelObj = nothing '清空对象51Testing软件测试网 r"@ x|`#VaPl
51Testing软件测试网9~:@0J+~ drs.close '关闭数据库连接操作51Testing软件测试网!m+y
es k:Qpc]8i
51Testing软件测试网p,`8G'y2TiQ_\set rs=nothing
`f/_7M$d$~v-d
x5V0(^D+he},R B0h:?0conn.close51Testing软件测试网F3`I0g;B0i"Qh
/_3V{makw ~0set conn = nothing
d1@zv2M8I5\[kp0]0#|P#d'hS.ss#X0 51Testing软件测试网E#E;o!I%_oh#G"Q0o
51Testing软件测试网[4AGZY6O------------这就是导出到EXCEL的全部过程:),后面如果要用到这些数据的话,直接导入进来就可以了51Testing软件测试网o)I d
edq