使用Python连接DB2数据库分发EXCEL数据 import ibm_db import ibm_db_dbi import pandas as pd # 连接字符串 connStr = "DATABASE=RGRL;HOSTNAME=192.168.1.5;PORT=50000;PROTOCOL=TCPIP;UID=DB2ADMIN;PWD=123456;" #连接对象 conn = ibm_db.connect(connStr, "", "") #查询语句 sql = "SELECT * FROM BJSOFT.ACCESSRIGHTSET " \ "WHERE NAME IS NOT NULL" #dbi连接对象 conn = ibm_db_dbi.Connection(conn) #执行SQL df = pd.read_sql(sql, conn) for index,row in df.iterrows(): print(row['NAME']) sql2="select * from BJSOFT.ACCESSRIGHTSET WHERE NAME='"+row['NAME']+"'" print(sql2) df2=pd.read_sql(sql2,conn) print(df2.size) if df2.shape[0]>0: df2.to_excel('d:/'+row['NAME']+'.xlsx')