openpyxl autoSUM

最新推荐文章于 2024-08-18 22:00:18 发布

mengtianwxs

最新推荐文章于 2024-08-18 22:00:18 发布

阅读量529

点赞数

分类专栏： Qt/Python/C++

本文链接：https://blog.csdn.net/mengtianwxs/article/details/78232372

版权

Qt/Python/C++ 专栏收录该内容

167 篇文章 4 订阅

订阅专栏

# __*__encoding:utf8__*__

import openpyxl
import openpyxl.worksheet

wb = openpyxl.load_workbook("xt_t3.xlsx")
st = wb.active

row_max = st.max_row

cell1 = []
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")