在类中使用 openpyxl 写入单元格范围

小吉弗

我正在尝试使用 openpyxl 作为类中的函数写入单元格范围（不确定我是否正在编写）

我想将 total_cull、total_all、total_all、total_good、total_hold 和 total_joblot 的计算值写入 days_of_the_month_cells 中的单元格

在此示例中，每个单元格范围的值都相同

excel_writer.py

from datetime import date
from openpyxl import Workbook, load_workbook

days_of_the_month_cells = {
    "Week 1": {
        "Sun": "D6:D22",
        "Mon": "E6:E22",
        "Tue": "F6:F22",
        "Wed": "G6:G22",
        "Wed": "H6:H22",
        "Thu": "I6:I22",
        "Fri": "J6:J22",
        "Sat": "K6:K22",
    }, "Week 2": {
        "Sun": "D23:D39",
        "Mon": "E23:E39",
        "Tue": "F23:F39",
        "Wed": "G23:G39",
        "Wed": "H23:H39",
        "Thu": "I23:I39",
        "Fri": "J23:J39",
        "Sat": "K23:K39",
    }, "Week 3": {
        "Sun": "D40:D56",
        "Mon": "E40:E56",
        "Tue": "F40:F56",
        "Wed": "G40:G56",
        "Wed": "H40:H56",
        "Thu": "I40:I56",
        "Fri": "J40:J56",
        "Sat": "K40:K56",
    }, "Week 4": {
        "Sun": "D57:D73",
        "Mon": "E57:E73",
        "Tue": "F57:F73",
        "Wed": "G57:G73",
        "Wed": "H57:H73",
        "Thu": "I57:I73",
        "Fri": "J57:J73",
        "Sat": "K57:K73",
    }

}


class Write_To_Excel:
    def __init__(self, cull, all, broke, good, hold, joblot):
        self.cull = cull
        self.all = all
        self.broke = broke
        self.good = good
        self.hold = hold
        self.joblot = joblot

    def write(calculated_cull):
        wb = load_workbook('XLSXs/input/Finished Goods Daily Report 2022.xlsx')

        ws = wb.active
       
        # ???

        wb.save('XLSXs/output/Finished Goods Daily Report 2022.xlsx')

main.py

from excel_writer import Write_To_Excel

total_cull = ending_inventory.sum()
total_all = Total_Riper("all.pdf").calculate()
total_broke = Total_Riper("broke.pdf").calculate()
total_good = Total_Riper("good.pdf").calculate()
total_hold = Total_Riper("hold.pdf").calculate()
total_joblot = Total_Riper("joblot.pdf").calculate()

Write_To_Excel(total_cull, total_all, total_good, total_good, total_hold, total_joblot).write()

您可以提供的任何帮助将不胜感激

阿尔伯特汉娜

您可以通过这种方式读取单元格范围并写入它们

from datetime import date
from openpyxl import Workbook, load_workbook

wb = Workbook()

ws = wb.active

# for every week
for vs in days_of_the_month_cells.values():
    # for every day, range
    for k, rng in vs.items():
        # for row in range
        for cs in ws[rng]:
            # for col in row
            for c in cs:
                # assign the value k for all that range
                c.value = k

wb.save('foo.xlsx')

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。