将Python列表导出到Excel

pip install openpyxl

import openpyxl

data = [
    ['姓名', '年龄', '性别'],
    ['张三', 25, '男'],
    ['李四', 30, '女'],
    ['王五', 28, '男']
]

workbook = openpyxl.Workbook()
sheet = workbook.active

for row in data:
    sheet.append(row)

workbook.save('data.xlsx')

pip install pandas

import pandas as pd

data = [
    ['姓名', '年龄', '性别'],
    ['张三', 25, '男'],
    ['李四', 30, '女'],
    ['王五', 28, '男']
]

df = pd.DataFrame(data)
df.to_excel('data.xlsx', index=False)