XSSFWorkbook workbook = new XSSFWorkbook(); //创建一个工作表sheet Sheet sheet = workbook.createSheet(); //创建第一行 Row row = sheet.createRow(0); Cell cell = null; //插入第一行数据 Object o = datas.get(0); String[] title = ObjectTransferUtils.generateObjAttr(o); for (int i = 0; i < title.length; i++) { cell = row.createCell(i); cell.setCellValue(title[i]); } for (int i = 0; i < datas.size(); i++) { Object obj = datas.get(i); String[] titl = ObjectTransferUtils.generateObjAttr(obj); Object[] value = new Object[titl.length]; for (int t = 0; t < titl.length; t++) { value[t] = ObjectTransferUtils.generateAttrValue(titl[t], obj); } if (value == null) { continue; } Row nextrow = sheet.createRow(i); for (int j = 0; j < value.length; j++) { Cell cell2 = nextrow.createCell(j); if (value[j] != null) { cell2.setCellValue(value[j].toString()); } } } //创建一个文件 File file = new File("c:/report.xlsx"); try { file.createNewFile(); //将Excel内容存盘 FileOutputStream stream = FileUtils.openOutputStream(file); workbook.write(stream); stream.close(); } catch (IOException e) { e.printStackTrace(); }
poi 创建xls
最新推荐文章于 2024-04-24 13:17:14 发布