- 建议使用hutool工具类来实现,maven依赖。
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.2.4</version>
</dependency>
- 使用方式demo,这里面使用了hutool工具类的自动换行和设置列值的方法可以让你少写很多很多代码
import cn.hutool.core.util.StrUtil;
import cn.hutool.poi.excel.RowUtil;
import cn.hutool.poi.excel.StyleSet;
import cn.hutool.poi.excel.cell.CellUtil;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
public static void main(String[] args) throws IOException {
collapseRow();
}
private static void collapseRow() throws IOException {
try (SXSSFWorkbook workbook = new SXSSFWorkbook(100)) {
SXSSFSheet sheet = workbook.createSheet("new sheet");
StyleSet styleSet = new StyleSet(workbook);
styleSet.setBorder(BorderStyle.THIN, IndexedColors.PINK);
styleSet.setWrapText();
List<String> titleList = Arrays.asList("编号", "创建时间", "数量", "是否正确", "详细内容", "名称");
int lastRowNum = 0;
Row row = RowUtil.getOrCreateRow(sheet, lastRowNum++);
int cellNum = 0;
for (String titleName : titleList) {
Cell cell = CellUtil.getOrCreateCell(row, cellNum++);
CellUtil.setCellValue(cell, titleName, styleSet, true);
}
List<Map<String, Object>> excelDataMap = getExcelDataMap();
for (Map<String, Object> map : excelDataMap) {
row = RowUtil.getOrCreateRow(sheet, lastRowNum++);
cellNum = 0;
for (String key : map.keySet()) {
Object value = map.get(key);
Cell cell = CellUtil.getOrCreateCell(row, cellNum++);
CellUtil.setCellValue(cell, value, styleSet, false);
}
}
try (FileOutputStream fileOut = new FileOutputStream("gideonYeung.xlsx")) {
workbook.write(fileOut);
System.out.println("导出成功。");
} finally {
workbook.dispose();
}
}
}
private static List<Map<String, Object>> getExcelDataMap() {
List<Map<String, Object>> dataList = new ArrayList<>();
Map<String, Object> resultMap = new LinkedHashMap<>();
resultMap.put("code", "C01");
resultMap.put("createTime", LocalDate.now());
resultMap.put("qty", 2000);
resultMap.put("isStop", true);
resultMap.put("id", "窗前明月光,疑似地上霜。举头望明月,低头思故乡。");
resultMap.put("name", "哒哒");
dataList.add(resultMap);
resultMap = new LinkedHashMap<>();
resultMap.put("code", "C02");
resultMap.put("createTime", LocalDate.now());
resultMap.put("qty", 20000);
resultMap.put("isStop", false);
resultMap.put("id", "日照香炉生紫烟,遥看瀑布挂前川。飞流直下三千尺,疑是银河落九天。");
resultMap.put("name", "滴滴");
dataList.add(resultMap);
return dataList;
}
- 导出的结果。