使用openpyxl写入数据到excel表

将二维数组按行写入 excel表

import openpyxl
lst = [[2000, 1, 1], [2000, 1, 2]]
workbook = openpyxl.Workbook()
sheet = workbook.create_sheet("sheetName", index=0)
header = ["year", "month", "day"]
sheet.append(header)
for row in lst:
    sheet.append(row)
workbook.save("./test.xlsx")

指定行列数写入数据到工作簿单元格

import openpyxl

lst = [[2000, 1, 1], [2000, 1, 2]]
workbook = openpyxl.Workbook()
sheet = workbook.create_sheet("sheetName", index=0)
header = ["year", "month", "day"]
sheet.append(header)
for i in range(len(lst)):  # 行
    for j in range(len(lst[i])):  # 列
        data = lst[i][j]
        sheet.cell(row=i + 2, column=j + 1).value = data
        workbook.save("./test.xlsx")

注意：工作簿行列号最低索引为1