python 操作Excel

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

原文：https://www.cnblogs.com/thaimj1314520/p/14588558.html