#2
zhuxujie2021-07-18 15:12
|
程序代码:
import openpyxl
import statistics as stats
book = openpyxl.load_workbook('志愿.xlsx')
zy = book["小学"]
jh = book["计划信息"]
hangshu = 1
break_1= 0
for hang1 in range(2,730):
for lie in range(3,8):
x = zy.cell(hang1,lie).value
for hang2 in range(2,7):
y = jh.cell(hang2,2).value
jhs = jh.cell(hang2,4).value #计划数
sjs = jh.cell(hang2,6).value #实际数
if y == x:
if int(jhs) > int(sjs):
jh.cell(hang2,6).value = sjs+1
zy.cell(hang1,9).value = x
break_1= 1
print(lie,x,y)
if break_1 == 1:
break
print(hang1)
book.save('志愿.xlsx')
import statistics as stats
book = openpyxl.load_workbook('志愿.xlsx')
zy = book["小学"]
jh = book["计划信息"]
hangshu = 1
break_1= 0
for hang1 in range(2,730):
for lie in range(3,8):
x = zy.cell(hang1,lie).value
for hang2 in range(2,7):
y = jh.cell(hang2,2).value
jhs = jh.cell(hang2,4).value #计划数
sjs = jh.cell(hang2,6).value #实际数
if y == x:
if int(jhs) > int(sjs):
jh.cell(hang2,6).value = sjs+1
zy.cell(hang1,9).value = x
break_1= 1
print(lie,x,y)
if break_1 == 1:
break
print(hang1)
book.save('志愿.xlsx')