POI导出Excel强制换行
HSSFWorkbook wb = new HSSFWorkbook();
HSSFRow headRow = sheet.createRow(1);
HSSFCellStyle cellStyle =wb.createCellStyle();
//设置自动换行
cellStyle.setWrapText(true);
//具体使用:
cell.setCellValue(new HSSFRichTextString("呵呵哒\r\n 我是下一行内容了"));
网上好多答案都是 “/r/n” 你TM是怎么换的我就纳闷了!!!
// 导出
ByteArrayOutputStream output = new ByteArrayOutputStream();
try {
wb.write(output);
} catch (IOException e) {
e.printStackTrace();
}
InputStream in = new ByteArrayInputStream(output.toByteArray());
try {
return super.downFile(IOUtils.toByteArray(in), "文件名-" + DateUtil.format(new Date(), "yyyyMMdd") + ".xls");
} catch (IOException e) {
e.printStackTrace();
return new ResponseEntity<String>(super.sendMessage(Message.ERROR, e.getLocalizedMessage()),
getHttpHeaders(), HttpStatus.OK);
}