# __*__encoding:utf8__*__
import openpyxl
import openpyxl.worksheet
wb = openpyxl.load_workbook("source_file/aabb.xlsx")
st = wb.active
row_max = st.max_row
cell1 = []
cell2 = []
cell3 = []
for i in range(1, row_max+1):
btxt1 = st.cell(row=i, column=9).value
btxt2 = st.cell(row=i, column=2).value
btxt3 = st.cell(row=i, column=2).value
if (btxt1 == "*"):
cell1.append(i)
if (btxt2 == u"运费"):
cell2.append(i)
if (btxt3 == u"合计"):
cell3.append(i)
print(len(cell1))
print(len(cell2))
print(len(cell3))
for i in range(0, len(cell1)):
st['G' + str(cell3[i])].value = "=SUM(G" + str(cell1[i]) + ":G" + str(cell2[i]) + ")"
wb.save("resault_file/hjylhj.xlsx")