String title="公共通讯录";
// 第一步,创建一个webbook,对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步,在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = wb.createSheet("sheet1");
sheet.setColumnWidth((short) 0,4500);
sheet.setColumnWidth((short) 1,4500);
sheet.setColumnWidth((short) 4,9000);
sheet.setColumnWidth((short) 5,4500);
sheet.setColumnWidth((short) 6,4500);
sheet.setColumnWidth((short) 7,4500);
// 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
HSSFRow row = sheet.createRow((int) 0);
// 第四步,创建单元格,并设置值表头 设置表头居中
HSSFCellStyle style = wb.createCellStyle();
//style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
HSSFCell cell = row.createCell((short) 0);
cell.setCellValue("工号");
cell.setCellStyle(style);
cell = row.createCell((short) 1);
cell.setCellValue("姓名");
cell.setCellStyle(style);
cell = row.createCell((short) 2);
cell.setCellValue("电子邮件地址");
cell.setCellStyle(style);
cell = row.createCell((short) 3);
cell.setCellValue("手机");
cell.setCellStyle(style);
cell = row.createCell((short) 4);
cell.setCellValue("QQ");
cell.setCellStyle(style);
cell = row.createCell((short) 5);
cell.setCellValue("性别");
cell.setCellStyle(style);
cell = row.createCell((short) 6);
cell.setCellValue("公司");
cell.setCellStyle(style);
// 第五步,写入实体数据 实际应用中这些数据从数据库得到,
List<Map<String,Object>> _result = (List<Map<String,Object>>)result;;
int i=0;
for(Map<String,Object> _doc:_result){
row = sheet.createRow(i + 1);
row.createCell((short) 0).setCellValue(String.valueOf(_doc.get("pkid")));
row.createCell((short) 1).setCellValue(String.valueOf(_doc.get("username")));
row.createCell((short) 2).setCellValue(String.valueOf(_doc.get("email")));
row.createCell((short) 3).setCellValue(String.valueOf(_doc.get("mobilePhone")));
row.createCell((short) 4).setCellValue(String.valueOf(_doc.get("qq")));
row.createCell((short) 5).setCellValue(String.valueOf(_doc.get("gender")));
row.createCell((short) 6).setCellValue(String.valueOf(_doc.get("company")));
row.createCell((short) 16).setCellValue(String.valueOf(_doc.get("remark")));
i++;
}
OutputStream os = null;
getContext().getResponse().reset(); // 清空输出流
os = getContext().getResponse().getOutputStream(); // 取得输出流
getContext().getResponse().setHeader("Content-disposition", "attachment; filename=" + new String((title+".xls").getBytes("gb2312"), "ISO-8859-1")); // 设定输出文件头
getContext().getResponse().setContentType("application/msexcel"); // 定义输出类型
os.flush();
wb.write(os);
os.close();
} catch (Exception e) {
e.printStackTrace();
}
java poi导出excel
最新推荐文章于 2022-10-12 00:54:53 发布