整个代码是:
#coding:utf-8
import xlrd
import xlwt
import cx_oracle
db=cx_oracle.connect('用户名','密码','ip:1521/服务名')
workbook = xlwt.workbook(encoding = 'ascii')
worksheet = workbook.add_sheet('my worksheet')
data = xlrd.open_workbook('1.xls')
table = data.sheets()[0]
nrows = table.nrows
for i in range(nrows):
rowi=unicode(table.row_values(i)[0])
sql="select * from tskuplu where plucode = '"+rowi+"' and isactive = '1' and ywstatus in ('1','2')"
cr=db.cursor()
cr.execute(sql)
rs=cr.fetchall()
if rs:
print rs[0][1],type(rs[0][1])
worksheet.write(i, 0, label = rs[0][1])
workbook.save('111.xls')
cr.close()
db.close()
如对本文有疑问, 点击进行留言回复!!
oracle数据库imp导入失败提示:“不是有效的导出文件, 标头验证失败”解决方法,修改dmp文件里oracle数据库版本号方法
Oracle DataGuard故障转移(failover)后使用RMAN还原失败的主库
Oracle Dataguard故障转移(failover)操作
网友评论