关注我们

POI Excel - 换行单元格

要将多行数据写入单元格，Apache POI提供了处理它的方法。让无涯教程看一个示例，其中已将多行数据存储到一个单元格中。

Apache POI 单元格换行示例

package poiexample;
import java.io.FileOutputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class NewlineExample {
	public static void main(String[] args) {
		try (OutputStream fileOut = new FileOutputStream("Learnfk.xls")) {
			Workbook wb = new HSSFWorkbook();
			Sheet sheet = wb.createSheet("Sheet");
			Row row     = sheet.createRow(1);
			Cell cell   = row.createCell(1);
			cell.setCellValue("This is first line and \n this is second line");
			CellStyle cs = wb.createCellStyle();
			cs.setWrapText(true);
			cell.setCellStyle(cs);
			row.setHeightInPoints((2*sheet.getDefaultRowHeightInPoints()));
			sheet.autoSizeColumn(2);
	        wb.write(fileOut);
	    }catch(Exception e) {
	    	System.out.println(e.getMessage());
	    }
	}
}