关于Java中多个数据excel表格的导出

最新推荐文章于 2024-07-03 14:13:18 发布

SuperWeiWei1

最新推荐文章于 2024-07-03 14:13:18 发布

阅读量1.1k

点赞数

本文链接：https://blog.csdn.net/SuperWeiWei1/article/details/48718707

版权

本文介绍了如何在Java中利用Apache POI库导出多个数据Excel表格，详细讲解了所需的依赖和实现步骤。

摘要由CSDN通过智能技术生成

public HSSFWorkbook exportType20(List<Map<String, Object>> list, String mentName) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("历史记录");

HSSFRow row0 = sheet.createRow((int) 0);
HSSFCellStyle style0 = wb.createCellStyle();
style0.setAlignment(HSSFCellStyle.ALIGN_CENTER);
HSSFCell cell0 = row0.createCell(0);
cell0.setCellValue(new HSSFRichTextString("设备名称"));
cell0.setCellStyle(style0);
row0.createCell(1).setCellValue(mentName);

HSSFRow row1 = sheet.createRow((int) 1);
HSSFCellStyle style1 = wb.createCellStyle();
style1.setAlignment(HSSFCellStyle.ALIGN_CENTER);
HSSFCell cell1 = row1.createCell(0);
cell1.setCellValue(new HSSFRichTextString("采集时间"));
cell1.setCellStyle(style1);
String st_time = null;
String en_time = null;
for (int j = 0; j < list.size(); j++) {
if (j == 0 || j == list.size() - 1) {
Map<String, Object> map = list.get(j);
if (null != map.get("gather_time")) {
if (j == list.size() - 1) {
String start_time = sdf.format(map.get("gather_time"));
st_time = start_time;
} else {
String end_time = sdf.format(map.get("gather_time"));
en_time = end_time;
}

}
}
}
row1.createCell(1).setCellValue(st_time + "~" + en_time);

HSSFRow row2 = sheet.createRow((int) 2);
HSSFCellStyle style2 = wb.createCellStyle();