Python向Excel写入数据

from openpyxl import Workbook

# 创建一个Workbook对象
wb = Workbook()

# 激活默认的工作表
ws = wb.active

# 假设我们要写入的数据列表
data_list = ["Hello", "World", "Python", "Excel", "Data"]

# 初始行号
row_num = 1

# 循环写入数据
for data in data_list:
    ws.cell(row=row_num, column=1, value=data)
    row_num += 1  # 更新行号以写入下一行

# 保存文件
wb.save("sample_auto_next_row.xlsx")