public InputStream dataExcel(List<String[]> data, String[] head) throws IOException {
//创建核心对象
SXSSFWorkbook sw = new SXSSFWorkbook();
//创建sheet表
Sheet sheet = sw.createSheet();
//创建行
Row row = sheet.createRow(0);
for (int i = 0; i < head.length; i++) {
//在第一行中循环创建单元格
Cell cell = row.createCell(i);
//给单元格设置值
cell.setCellValue(head[i]);
}
//创建第二行以上
for (int i = 0; i < data.size(); i++) {
//创建行
row = sheet.createRow(i+1);
//拿到具体的某一个对象
String[] strs = data.get(i);
for (int j = 0; j < strs.length; j++) {
//循环创建单元格
Cell cell = row.createCell(j);
cell.setCellValue(strs[j]);
}
}
ByteArrayOutputStream out = new ByteArrayOutputStream() ;
sw.write(out);
ByteArrayInputStream inputStream = new ByteArrayInputStream(out.toByteArray());
return inputStream;
}
如何输出一个excel
最新推荐文章于 2022-06-20 16:52:24 发布