从XLWT以横向模式设置Excel工作表

pip install xlwt

import xlwt

# 创建一个工作簿
workbook = xlwt.Workbook()

# 创建一个工作表
worksheet = workbook.add_sheet('Sheet1')

# 写入表头
header = ['姓名', '年龄', '性别']
for i in range(len(header)):
    worksheet.write(0, i, header[i])

# 写入数据
data = [['张三', 25, '男'], ['李四', 30, '女'], ['王五', 28, '男']]
for i in range(len(data)):
    for j in range(len(data[i])):
        worksheet.write(i+1, j, data[i][j])

# 保存工作簿
workbook.save('example.xls')

import xlwt

# 创建一个工作簿
workbook = xlwt.Workbook()

# 创建一个工作表
worksheet = workbook.add_sheet('Sheet1')

# 写入表头
header = ['姓名', '年龄', '性别']
for i in range(len(header)):
    worksheet.write(0, i, header[i])

# 写入数据
data = [['张三', 25, '男'], ['李四', 30, '女'], ['王五', 28, '男']]
for i in range(len(data)):
    for j in range(len(data[i])):
        worksheet.write(i+1, j, data[i][j])

# 保存工作簿
workbook.save('example.xls')