使用pandas和xlsxwriter在excel中增加不同工作表上列的宽度

import pandas as pd
import xlsxwriter

# 创建一个Excel文件
workbook = xlsxwriter.Workbook('output.xlsx')

# 添加工作表
worksheet1 = workbook.add_worksheet('Sheet1')
worksheet2 = workbook.add_worksheet('Sheet2')

# 设置Sheet1中第一列的宽度为10
worksheet1.set_column(0, 0, 10)

# 设置Sheet2中第二列的宽度为15
worksheet2.set_column(1, 1, 15)

# 在Sheet1中写入数据
data1 = {'Column1': [1, 2, 3, 4, 5]}
df1 = pd.DataFrame(data1)
worksheet1.write('A1', 'Column1')
worksheet1.write_column('A2', df1['Column1'])

# 在Sheet2中写入数据
data2 = {'Column2': ['A', 'B', 'C', 'D', 'E']}
df2 = pd.DataFrame(data2)
worksheet2.write('B1', 'Column2')
worksheet2.write_column('B2', df2['Column2'])

workbook.close()