# __*__encoding:utf8__*__
import openpyxl
import openpyxl.worksheet
wb = openpyxl.load_workbook("files/whsf.xlsx")
st = wb.active
row_max = st.max_row
print
row_max
cell1 = []
cell2 = []
cell3 = []
for i in range(1, row_max):
btxt1 = st.cell(row=i, column=2).value
btxt2 = st.cell(row=i, column=2).value
btxt3 = st.cell(row=i, column=2).value
if (btxt1 == u"断路器*"):
cell1.append(i)
if (btxt2 == u"辅材"):
cell2.append(i)
if (btxt3 == u"合计"):
cell3.append(i)
print
cell1, cell2, cell3
print(len(cell1))
for i in range(0, len(cell1)-1):
st['G' + str(cell3[i])].value = "=SUM(G" + str(cell1[i]) + ":G" + str(cell2[i]) + ")"
wb.save("whsfc.xlsx")
用openpyxl插入格公式2
最新推荐文章于 2024-07-24 19:58:49 发布