//POI导出的方法;实体类MemberContact
public void exportAll(){
// 创建一个webbook,对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = wb.createSheet("联系人");
// 在sheet中添加表头第0行
HSSFRow row = sheet.createRow(0);
// 创建单元格,并设置表头 设置表头居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
HSSFCell cell = row.createCell(0);
cell.setCellValue(new HSSFRichTextString("姓名"));
cell.setCellStyle(style);
cell = row.createCell( 1);
cell.setCellValue(new HSSFRichTextString("性别"));
cell.setCellStyle(style);
cell = row.createCell( 2);
cell.setCellValue(new HSSFRichTextString("工作单位"));
cell.setCellStyle(style);
cell = row.createCell(3);
cell.setCellValue(new HSSFRichTextString("部门"));
cell.setCellStyle(style);
List<MemberContact> list = (List<MemberContact>) this.getQueryService().list();
MemberContact memberContact=null;
if(list.size()>0){
for (int i = 0; i < list.size(); i++) {
row = sheet.createRow(i + 1);
memberContact=list.get(i);
row.createCell(0).setCellValue(new HSSFRichTextString(memberContact.getName()));
row.createCell(1).setCellValue(new HSSFRichTextString(memberContact.getSexCode()=="1"?"男":"女"));
row.createCell(2).setCellValue(new HSSFRichTextString(memberContact.getName()));
row.createCell(3).setCellValue(new HSSFRichTextString(memberContact.getName()));
}
}
SimpleDateFormat df=new SimpleDateFormat("yyyyMMddHHmmss");
//命名
String fileName=df.format(new Date())+".xls";
try
{
response.setContentType("application/x-msdownload");
response.setHeader("Content-Disposition", "attachment;"+ " filename=" + new String(fileName.getBytes(), "UTF-8"));
OutputStream out = response.getOutputStream();
wb.write(out);
out.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
POI导出EXCEL
最新推荐文章于 2022-06-22 13:53:30 发布