python *** 作Excel

概述importxlrdimportpymysqlfname="LAX0412.xls"bk=xlrd.open_workbook(fname)print(bk)try:sh=bk.sheet_by_index(0)except:print("////")nrows=sh.nrows#获取列数ncols=sh.ncols forbinrange(1,nrows):data1=sh.cell(b,0)dingd

import xlrd
import pyMysqL
fname = "LAX0412.xls"
bk = xlrd.open_workbook(fname)
print(bk)

try:
sh = bk.sheet_by_index(0)
except:
print("////")

nrows = sh.nrows
#获取列数
ncols = sh.ncols

 

for b in range(1,nrows):
data1 = sh.cell(b,0)
dingdanbianha=str(data1)[6:-1]
dingdanbianhao=dingdanbianha[7:]
## print(dingdanbianhao)

data2 = sh.cell(b,1)
chanPingmingcheng=str(data2)[6:-1]
## print(chanPingmingcheng)
data3 = sh.cell(b,2)
huohao=str(data3)[6:-1]
## print(huohao)
data4 = sh.cell(b,3)
jine=str(data4)[6:-1]
## print(jine)
data5 = sh.cell(b,4)
kuaIDIDanhao=str(data5)[6:-1]
## print(kuaIDIDanhao)

data6 = sh.cell(b,5)
name=str(data6)[6:-1]
## print(name)

data7 = sh.cell(b,6)
dianhua=str(data7)[6:-1]
## print(dianhua)

data8 = sh.cell(b,7)
dian=str(data8)[-6:-4]
print(dian)
if "x" in dian:
d=dian[1:]
print("asd",d,d)
##
db = pyMysqL.connect(host='localhost', user='root', password='123456', port=3306, db='kuaIDi')
cursor = db.cursor()
sql = 'INSERT INTO nihao(c) values("%s")'%(d)
print(sql)
cursor.execute(sql)
db.commit()
else:

db = pyMysqL.connect(host='localhost', user='root', password='123456', port=3306, db='kuaIDi')
cursor = db.cursor()
sql = 'INSERT INTO nihao(c) values("%s")'%(dian)
print(sql)
cursor.execute(sql)
db.commit()

#### print(guige)
## print("----",tracking)
## reference=sh.cell(b,1)
## referenc=str(reference)[6:-1]
## print(";''''''''''''''",referenc)
## refe=sh.cell(b,2)
## referen=str(refe)[7:-2]
## print(referen)
## db = pyMysqL.connect(host='localhost', user='root', password='123456', port=3306, db='test')
## cursor = db.cursor()
## sql = 'INSERT INTO numm1(tracking,referenc,oderitm,referen) values("%s","%s","%s","%s")'%(tracking,referenc,y1,referen)
## print(sql)
##
##
## #----------
## cursor.execute(sql)
## db.commit()
##
## ''' table.write(b,1,[tracking])
## table.write(b,2,[referenc])
## table.write(b,3,[y1])
## table.write(b,4,[referen])
## print(tracking)
## print(referenc)
## print(y1)
## print(referen)
## table.write("infoPList")
##
## table.write(cell_overwrite_ok=True)
##
##
## file.save('zongshujv.xls')
##'''
##
## for a in range(1, nrows):
## row_data1 = sh.cell(i,1)
## print(row_data1)

## print(a)
#______________
## table.write(i,1,[tracking])
## table.write(i,2,[referenc])
## print(tracking)
## print(referenc)
## file.save('qwe.xls')
#____________________

## db = pyMysqL.connect(host='localhost', user='root', password='123456', port=3306, db='test')
## cursor = db.cursor()
## sql = "INSERT INTO dadan(tracking,reference) values(%s,%s)"%(tracking,referenc)
## print(sql)
## cursor.execute(sql)
## db.commit()

 

总结

以上是内存溢出为你收集整理的python *** 作Excel全部内容，希望文章能够帮你解决python *** 作Excel所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。