How to set column width in EasyExcel for Java?

In EasyExcel, you can use the setColumnWidth method of the Sheet object to set the width of a column. This method takes two parameters: the first parameter is the index of the column to be set (starting from 0), and the second parameter is the value of the column width in characters.

Here’s an example code showing how to set column width.

// 创建一个工作簿对象
Workbook workbook = new Workbook();
// 创建一个工作表对象
Sheet sheet = workbook.createSheet("Sheet1");
// 设置列宽，参数分别为列索引和列宽的值
sheet.setColumnWidth(0, 10);
sheet.setColumnWidth(1, 15);
sheet.setColumnWidth(2, 20);

// ... 其他操作

// 保存工作簿
workbook.save("output.xlsx");

In the example above, we created a worksheet object and set the width of columns 0, 1, and 2 to 10, 15, and 20 characters wide, respectively. Finally, we used the save method of the workbook to save the workbook as an xlsx file.

When setting column widths, it is important to consider the relationship between character width and the actual displayed width. Different fonts and font sizes may result in slight discrepancies between the displayed width and the set column width.