python设置单元格宽度_python – 在Excel中调整单元格宽度

我正在使用xlsxwriter写入Excel工作表.我面临的问题是：当文本超过单元格大小时,它会被隐藏.

import xlsxwriter

workbook = xlsxwriter.Workbook("file.xlsx")

worksheet1 = workbook.add_worksheet()

worksheet1.write(1, 1,"long text hidden test-1" )

worksheet1.write(2, 1,"long text hidden test-2")

worksheet1.write(3, 1,"short-1")

worksheet1.write(4, 1,"short-2")

worksheet1.write(1, 2,"Hello world" )

worksheet1.write(2, 2,"Hello world")

worksheet1.write(3, 2,"Hello world")

worksheet1.write(4, 2,"Hello world")

workbook.close()

我得到了什么

调整宽度我期待什么