跳转至

Symphra Excel

模板示例

getaix/symphra-excel

模板示例¶

基本模板使用¶

from symphra_excel.templates import TemplateWorkbook

with TemplateWorkbook("invoice_template.xlsx") as template:
    data = {
        "invoice_no": "INV-2024-001",
        "customer": "张三",
        "amount": 5000.00,
        "date": "2024-01-15",
    }

    template.render(data)
    template.save("invoice_001.xlsx")

循环数据¶

with TemplateWorkbook("list_template.xlsx") as template:
    data = {
        "items": [
            {"name": "产品A", "price": 100},
            {"name": "产品B", "price": 200},
            {"name": "产品C", "price": 300},
        ]
    }

    template.render(data)
    template.save("product_list.xlsx")

批量生成¶

customers = [
    {"name": "张三", "amount": 5000},
    {"name": "李四", "amount": 8000},
]

for idx, customer in enumerate(customers, start=1):
    with TemplateWorkbook("template.xlsx") as template:
        template.render(customer)
        template.save(f"output_{idx}.xlsx")

相关文档¶