WR 从数据库读数据到Excel中

 

WR脚本

#
# Original SQL: select * from dbo.t_common_stock
#
db_check("list1.cdl", "dbvf1");

table="D://work//11.xls";

state=ddt_open(table,DDT_MODE_READWRITE);

if (state!=E_OK) pause("error");

sql_query="D://work//SQLQuery1.sql";

ddt_update_from_db(table,sql_query,out_row_count,NO_LIMIT,30);

ddt_save(table);

ddt_close(table);

 

sql文件 服务器sql2005

Descrīption=51;DRIVER=SQL Native Client;SERVER=IP地址;UID=tx007;PWD=***;APP=WinRunner;WSID=MAJX;DATABASE=stock_china;
select * from dbo.t_common_stock;