Question

用poi包的hssf，怎样让excel中的单元格cell里面的文字"自动换行

Answer 1

参考：

public static void main(String[] args) {

try {
FileInputStream is = new FileInputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx"));
XSSFWorkbook wb = new XSSFWorkbook(is);
String header = "123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789";
Sheet sheet = wb.getSheet("Sheet1");
sheet.setColumnWidth(0, 18000);
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);

if(header.length() > 50){ //Length of String for my test
sheet.setColumnWidth(0, 18000);
CellStyle style = wb.createCellStyle(); //Create new style
style.setWrapText(true); //设置换行
cell.setCellStyle(style); //Apply style to cell
cell.setCellValue(header); //Write header
}

wb.write(new FileOutputStream(new File("D:\\Users\\user2777005\\Desktop\\bob.xlsx")));
} catch (IOException e) {
e.printStackTrace();
}
}