ExcelWriter writer = ExcelUtil.getWriter(url);
List<String> list = new ArrayList<>(); // 设置默认行高 writer.setDefaultRowHeight(18);
//输出 writer.write(list,true);
//设置自动宽度,不考虑合并单元格 SXSSFSheet sheet =(SXSSFSheet)writer.getSheet(); sheet.trackAllColumnsForAutoSizing(); writer.autoSizeColumnAll();