python - 更改Excel工作表中现有选项卡的列宽

Question

我有作为新选项卡（'打印'）添加到现有 excel 文件中的数据框（df）。我在调整列宽时遇到困难有什么想法吗？

代码

book = load_workbook('file.xlsx')
writer = pd.ExcelWriter('file.xlsx', engine = 'openpyxl')
writer.book = book
df.to_excel(writer,sheet_name = 'Print')
worksheet = writer.sheets['Print']
worksheet.set_column('B:B', 40) #This does not work

标签： pythonexcelopenpyxl

Answer 1

writer = pd.ExcelWriter('file.xlsx', engine='openpyxl')
writer.book = book
df.to_excel(writer, sheet_name='Print')
sheet = book.get_sheet_by_name('Print')
sheet.column_dimensions['B'].width = 40
writer.save()