openpyxl：使用 python 编写大型 excel 文件

使用Python编写大型Excel文件是一项非常有用的技能。而openpyxl是一个强大的Python库，可以帮助我们实现这个目标。本文将介绍如何使用openpyxl来生成大型Excel文件，并提供一些实际案例代码。

pip install openpyxl

python
import openpyxl

python
workbook = openpyxl.Workbook()

python
worksheet = workbook.active

python
worksheet.title = "Sales"

python
worksheet['A1'] = "产品名称"
worksheet['B1'] = "销售额"
worksheet['A2'] = "苹果"
worksheet['B2'] = 1000
worksheet['A3'] = "香蕉"
worksheet['B3'] = 2000

python
data = [
    ["产品名称", "销售额"],
    ["苹果", 1000],
    ["香蕉", 2000],
    ["橙子", 1500],
    ["葡萄", 3000]
]
for row in data:
    worksheet.append(row)

python
workbook.save("sales.xlsx")
workbook.close()

python
import openpyxl
workbook = openpyxl.Workbook()
worksheet = workbook.active
worksheet.title = "Sales"
data = [
    ["产品名称", "销售额"],
    ["苹果", 1000],
    ["香蕉", 2000],
    ["橙子", 1500],
    ["葡萄", 3000]
]
for row in data:
    worksheet.append(row)
workbook.save("sales.xlsx")
workbook.close()