//创建Excel工作簿 HSSFWorkbook workbook = new HSSFWorkbook(); //创建一个工作表sheet HSSFSheet sheet = workbook.createSheet(); //创建第一行 HSSFRow row = sheet.createRow(0); String[] title = ObjectTransferUtils.generateObjAttr(o); //插入第一行数据 for (int i = 0; i < title.length; i++) { HSSFCell 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; } HSSFRow nextrow = sheet.createRow(i + 1); for (int j = 0; j < value.length; j++) { HSSFCell cell2 = nextrow.createCell(j); if (value[j] != null) { cell2.setCellValue(value[j].toString()); } } }
poi 创建 xls 通用接口
最新推荐文章于 2021-11-12 11:13:06 发布