问题:在导出类设置了width,也设置了自动换行,但是导出的excel文字显示不全,要调整行高才能够显示完全
解决方案:我把导出类的width属性去掉了,在导出时设置列宽,然后设置行高为-1,导出的excel就显示完全了
// 设置默认列宽
private void setAutoHeight(Workbook workbook) {
Sheet sheet = workbook.getSheetAt(0);
sheet.setColumnWidth(0, 8 * 256);
sheet.setColumnWidth(1, 5 * 256);
sheet.setColumnWidth(2, 5 * 256);
sheet.setColumnWidth(3, 23 * 256);
sheet.setColumnWidth(4, 39 * 256);
sheet.setColumnWidth(5, 6 * 256);
sheet.setColumnWidth(6, 10 * 256);
for (int i = 2; i <= sheet.getLastRowNum(); i++) {
//前两行标题跳过
Row row = sheet.getRow(i);
row.setHeight((short) -1);
}
}