java poi 换行,apache poi单元格中的换行

本文概述

要将多行数据写入单元格，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("srcmini.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());

}

}

}

输出：