37,719
社区成员
发帖
与我相关
我的任务
分享
for i in range(table.nrows):
if (len(table.cell(i,0).value)>30)&(i>1):
for w in range(table.nrows):
h=i+w
if (h>i)&(len( table.cell(h,0).value)<11)&(len(table.cell(h,0).value)>3)&(len(table.cell(h,0).value)!=6):
table.cell(h,0).value
if table.cell(h,1).value is '':
table.cell(h,1).value=table.cell(h-1,2).value
print table.cell(h,0).value+" "+table.cell(h-1,2).value
ws.write(h,0,table.cell(h,0).value)
ws.write(h,1,table.cell(h-1,2).value)
wb.save('a.xls')
else:
print table.cell(h,0).value+" "+table.cell(h,1).value
ws.write(h,0,table.cell(h,0).value)
ws.write(h,1,table.cell(h,1).value)
wb.save('a.xls')