workbook = writer.bookworksheet = writer.sheets[sheet_name]cell_format = workbook.add_format({'border':1})worksheet.conditional_format('A1:XFD1048576', {'type': 'no_blanks', 'format': cell_format})
添加上面的代码,会自动将表格中有数据的部分设置边框
设置列宽
# 设置列宽-->将B列跟C列的列宽设置为17个字符,单位是字符worksheet.set_column('B:C', 17)
参考:
xlsxwriter去掉网格线_用XlsxWriter设置Excel的表格边框_把夏天绑在鞋带上的博客-CSDN博客
官网:
Creating Excel files with Python and XlsxWriter — XlsxWriter Documentation