openpyxl autoSUM

# __*__encoding:utf8__*__import openpyxlimport openpyxl.worksheetwb = openpyxl.load_workbook("xt_t3.xlsx")st = wb.activerow_max = st.max_rowcell1 = []cell2 = []cell3 = []for i in range(1, row_max):    btxt1 = st.cell(row=i, column=11).value    btxt2 = st.cell(row=i, column=3).value    btxt3 = st.cell(row=i, column=3).value    if (btxt1 == "*"):        cell1.append(i)    if (btxt2 == u"运费"):        cell2.append(i)    if (btxt3 == u"合计"):        cell3.append(i)print(len(cell1))for i in range(0, len(cell1) - 1):    st['H' + str(cell3[i])].value = "=SUM(H" + str(cell1[i]) + ":H" + str(cell2[i]) + ")"wb.save("zhongyiyuan.xlsx")