Set excelObj = CreateObject("Excel.Applicaiton") '创建一个对象
xlsUrl = "C:\测试结果.xls" '指定一个已经存在的XSL文件路径
excelObj.workbooks.open(xlsUrl) '打开EXCEL
Set sheetNew = excelObj.sheets.item(2) '设置将数据放在EXCEL中的那一页上(索引从1开始)
'相关的数据库操作
Set conn = CreateObject("adodb.connection")
set rs = createobject("adodb.recordset")
conn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=callbackdb;Data Source=192.168.1.53"
sql="select * from callrecord"
rs.open sql,conn
Dim i
i = 26
While not rs.eof
user_id = rs("CALLID").value
user_name = rs("SESSIONID").value
sheetNew.cells(i+1,1).value = user_id '列赋值
sheetNew.cells(i+1,2).value = user_name '列赋值
i = i + 1
rs.movenext
wend
excelObj.activeworkbook.saveas "C:\QTP\0110\sql-excel-qtp\data.xls" '保存数据
excelObj.quit '关闭对象
set excelObj = nothing '清空对象
rs.close '关闭数据库连接操作
set rs=nothing
conn.close