Java build Excel forced wrap code

Java build Excel forced wrap code

First use the POI style in the cell where you want to force a newline, and set the style to wrap.
Java code

1. Hssfcellstyle Cellstyle=workbook.createcellstyle ();
2. Cellstyle.setwraptext (TRUE);
3. Cell.setcellstyle (CellStyle);

Hssfcellstyle Cellstyle=workbook.createcellstyle ();    Cellstyle.setwraptext (TRUE); Cell.setcellstyle (CellStyle);

2. Second, in the need to force a newline of cells, you can actually force the line wrap
Java code

1. Hssfcell cell = Row.createcell ((short) 0);
2. Cell.setcellstyle (CellStyle); Cell.setcellvalue (New Hssfrichtextstring ("Hellorn world!"));

Hssfcell cell = Row.createcell ((short) 0);       Cell.setcellstyle (CellStyle); Cell.setcellvalue (New Hssfrichtextstring ("Hellorn world!"));

This enables you to enforce line wrapping,
After the line break, the effect is to force a newline in a cell.
Hello
world!