excel导出后台代码

@RequestMapping("/excelOut")
@ResponseBody
public String exportXxx1(HttpServletRequest request,StatementInfo statementInfo,String orgname,String orgcode)throws IOException{
 
 try {
  Map<String,String> map = new HashMap<String,String>();
    Page page = packingPage(request); 
     //设置数据量
 page.setPageSize(100000);
PageList pageList = new PageList(page);
      List<StatementInfo> statementList = statementInfoMapper.getStatementList(statementInfo);
     
//创建workbook对象
HSSFWorkbook workbook = new HSSFWorkbook();
//在workbook中创建sheet页 并拿到sheet对象
HSSFSheet sheet = workbook.createSheet();
sheet.setColumnWidth(0, (short)25*256);
sheet.setColumnWidth(1, (short)11*256);
sheet.setColumnWidth(2, (short)11*256);
sheet.setColumnWidth(3, (short)11*256);
sheet.setColumnWidth(4, (short)11*256);
sheet.setColumnWidth(5, (short)11*256);
sheet.setColumnWidth(6, (short)11*256);
sheet.setColumnWidth(7, (short)11*256); 
sheet.setColumnWidth(8, (short)11*256);
sheet.setColumnWidth(9, (short)11*256);
sheet.setColumnWidth(10,(short)11*256);
sheet.setColumnWidth(11,(short)11*256);
sheet.setColumnWidth(12,(short)11*256);
sheet.setColumnWidth(13,(short)11*256);
sheet.setColumnWidth(14,(short)11*256);
sheet.setColumnWidth(15,(short)11*256);

//表头的样式
HSSFCellStyle titleStyle = workbook.createCellStyle();
       titleStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
       titleStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
       titleStyle.setFillForegroundColor(HSSFColor.GREY_80_PERCENT.GREY_25_PERCENT.index);
       titleStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
       titleStyle.setBorderBottom((short)1);
       titleStyle.setBorderLeft((short)1);
       titleStyle.setBorderRight((short)1);
       HSSFFont font = workbook.createFont();
       font.setCharSet(HSSFFont.DEFAULT_CHARSET);
       font.setFontHeightInPoints((short)11);
       font.setFontName("微软雅黑");
       titleStyle.setFont(font);
       //内容样式
       HSSFCellStyle contentStyle = workbook.createCellStyle();
       contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
       contentStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
       contentStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
         contentStyle.setBorderBottom((short)1);
       contentStyle.setBorderLeft((short)1);
       contentStyle.setBorderRight((short)1);
       HSSFFont contentfont = workbook.createFont();
       contentfont.setCharSet(HSSFFont.DEFAULT_CHARSET);
       contentfont.setFontHeightInPoints((short)11);
       contentfont.setFontName("华文细黑");
       contentStyle.setFont(contentfont);

//输出表头  表头都可以写在配置文件中 防止以后发生变动要修改
       HSSFRow rowTh = sheet.createRow(0);
HSSFCell cell0 = rowTh.createCell(0);
cell0.setCellValue(new HSSFRichTextString(" "));
cell0.setCellStyle(titleStyle);
HSSFCell cell1 = rowTh.createCell(1);     
cell1.setCellValue(new HSSFRichTextString("宝塔中队"));
cell1.setCellStyle(titleStyle);
HSSFCell cell2 = rowTh.createCell(2);
cell2.setCellValue(new HSSFRichTextString("甘泉中队"));
cell2.setCellStyle(titleStyle);
HSSFCell cell3 = rowTh.createCell(3);
cell3.setCellValue(new HSSFRichTextString("姚店中队"));
cell3.setCellStyle(titleStyle);
HSSFCell cell4 = rowTh.createCell(4);
cell4.setCellValue(new HSSFRichTextString("洛川中队"));
cell4.setCellStyle(titleStyle);
HSSFCell cell5 = rowTh.createCell(5);
cell5.setCellValue(new HSSFRichTextString("富县中队"));
cell5.setCellStyle(titleStyle);
HSSFCell cell6 = rowTh.createCell(6);
cell6.setCellValue(new HSSFRichTextString("延长中队"));
cell6.setCellStyle(titleStyle);
HSSFCell cell7 = rowTh.createCell(7);
cell7.setCellValue(new HSSFRichTextString("延川中队"));
cell7.setCellStyle(titleStyle);
HSSFCell cell8 = rowTh.createCell(8);
cell8.setCellValue(new HSSFRichTextString("子长中队"));
cell8.setCellStyle(titleStyle);
HSSFCell cell9 = rowTh.createCell(9);
cell9.setCellValue(new HSSFRichTextString("志丹中队"));
cell9.setCellStyle(titleStyle);
HSSFCell cell10 = rowTh.createCell(10);
cell10.setCellValue(new HSSFRichTextString("黄陵中队"));
cell10.setCellStyle(titleStyle);
HSSFCell cell11 = rowTh.createCell(11);
cell11.setCellValue(new HSSFRichTextString("黄龙中队"));
cell11.setCellStyle(titleStyle);
HSSFCell cell12 = rowTh.createCell(12);
cell12.setCellValue(new HSSFRichTextString("吴起中队"));
cell12.setCellStyle(titleStyle);
HSSFCell cell13 = rowTh.createCell(13);
cell13.setCellValue(new HSSFRichTextString("安塞中队"));
cell13.setCellStyle(titleStyle);
HSSFCell cell14 = rowTh.createCell(14);
cell14.setCellValue(new HSSFRichTextString("宜川中队"));
cell14.setCellStyle(titleStyle);
HSSFCell cell15 = rowTh.createCell(15);
cell15.setCellValue(new HSSFRichTextString("特勤中队"));
cell15.setCellStyle(titleStyle);


         
         for (int i = 0; i < statementList.size(); i++) {
String itemname=statementList.get(i).getMaterialname();

map.put("itemname", itemname);
if(!"".equals(orgname)&&orgname != null){
map.put("orgname", orgname);
}
 
  List<OrgItemNumber> itemNuber = statementService.getItemNuber(map);
  for (int j = 0; j < itemNuber.size(); j++) {
if (itemNuber!=null) {

orgcode=itemNuber.get(j).getOrgcode();
 
if (orgcode=="ORG-05BA426E-37FF-4DE4-B8AA-C7B9B9F7826F"
||"ORG-05BA426E-37FF-4DE4-B8AA-C7B9B9F7826F".equals(orgcode)) {
statementList.get(i).setLuochuan(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-0F3912B2-A7AB-4991-8323-46FD7F90B753"
||"ORG-0F3912B2-A7AB-4991-8323-46FD7F90B753".equals(orgcode)) {
statementList.get(i).setZichang(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-303C8629-FEBF-43CF-92F8-D569FB444F29"
||"ORG-303C8629-FEBF-43CF-92F8-D569FB444F29".equals(orgcode)) {
statementList.get(i).setYaodian(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-841E59AE-7CDE-416B-99B9-5EC55D5DE8AE"
||"ORG-841E59AE-7CDE-416B-99B9-5EC55D5DE8AE".equals(orgcode)) {
statementList.get(i).setWuqi(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-8CF8E262-4E5A-44B1-9FD8-CFB2B698491B"
||"ORG-8CF8E262-4E5A-44B1-9FD8-CFB2B698491B".equals(orgcode)) {
statementList.get(i).setYanchang(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-8FF50BB4-8FD4-4917-8487-A13ECBB503AD"
||"ORG-8FF50BB4-8FD4-4917-8487-A13ECBB503AD".equals(orgcode)) {
statementList.get(i).setBaota(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-92223A1B-7ADE-4C8A-87D7-AF0BAF78686B"
||"ORG-92223A1B-7ADE-4C8A-87D7-AF0BAF78686B".equals(orgcode)) {
statementList.get(i).setZhidan(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-4C6ADBE3-6E31-4353-B762-0530FC14A19D"
||"ORG-4C6ADBE3-6E31-4353-B762-0530FC14A19D".equals(orgcode)) {
statementList.get(i).setGanquan(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-9D22796C-0731-48DB-9144-91347131DA60"
||"ORG-9D22796C-0731-48DB-9144-91347131DA60".equals(orgcode)) {
statementList.get(i).setYichuan(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-A17CA070-276C-4897-9BA9-F29C455FD052"
||"ORG-A17CA070-276C-4897-9BA9-F29C455FD052".equals(orgcode)) {
statementList.get(i).setFuxian(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-A8DE0D31-3E12-4D84-8DDE-8110EA9978F6"
||"ORG-A8DE0D31-3E12-4D84-8DDE-8110EA9978F6".equals(orgcode)) {
statementList.get(i).setTeqin(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-B2E3DEBF-8F84-492A-8C68-73DE2FD59F77"
||"ORG-B2E3DEBF-8F84-492A-8C68-73DE2FD59F77".equals(orgcode)) {
statementList.get(i).setHuanglong(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-BB9DD56E-DE83-4935-9CB4-0126C27BF394"
||"ORG-BB9DD56E-DE83-4935-9CB4-0126C27BF394".equals(orgcode)) {
statementList.get(i).setHuangling(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-E104485D-B1C2-45E1-B316-E70369CA8941"
||"ORG-E104485D-B1C2-45E1-B316-E70369CA8941".equals(orgcode)) {
statementList.get(i).setYanchuan(itemNuber.get(j).getAmount());
}
if (orgcode=="ORG-FDFC9D0D-6789-40F9-ADD3-8C87EAAA1502"
||"ORG-FDFC9D0D-6789-40F9-ADD3-8C87EAAA1502".equals(orgcode)) {
statementList.get(i).setAnsai(itemNuber.get(j).getAmount());
}
 
          }
   }
   pageList.setObjectList(statementList);
   List<StatementInfo> s =pageList.getObjectList();

   for (int x = 0; x < s.size(); x++) {
String baota=s.get(x).getBaota();
String ganquan=s.get(x).getGanquan();
String yandian=s.get(x).getYaodian();
String luochuan=s.get(x).getLuochuan();
String fuxian=s.get(x).getFuxian();
String yanchang=s.get(x).getYanchang();
String yanchuan=s.get(x).getYanchuan();
String zichuang=s.get(x).getZichang();
String zhidan=s.get(x).getZhidan();
String huangling=s.get(x).getHuangling();
String huanglong=s.get(x).getHuanglong();
String wuqi = s.get(x).getWuqi();
String ansai = s.get(x).getAnsai();
String yichuan = s.get(x).getYichuan();
String teqin = s.get(x).getTeqin();
 
//第二行内容 
rowTh = sheet.createRow(x+1);
HSSFCell contentcell0 = rowTh.createCell(0);
contentcell0.setCellValue(s.get(x).getMaterialname());
contentcell0.setCellStyle(contentStyle);
HSSFCell contentcell1 = rowTh.createCell(1);
contentcell1.setCellValue(baota);
contentcell1.setCellStyle(contentStyle);
HSSFCell contentcell2 = rowTh.createCell(2);
contentcell2.setCellValue(ganquan);
contentcell2.setCellStyle(contentStyle);
HSSFCell contentcell3 = rowTh.createCell(3);
contentcell3.setCellValue(yandian);
contentcell3.setCellStyle(contentStyle);
HSSFCell contentcell4 = rowTh.createCell(4);
contentcell4.setCellValue(luochuan);
contentcell4.setCellStyle(contentStyle);
HSSFCell contentcell5 = rowTh.createCell(5);
contentcell5.setCellValue(fuxian);
contentcell5.setCellStyle(contentStyle);
HSSFCell contentcell6 = rowTh.createCell(6);
contentcell6.setCellValue(yanchang);
contentcell6.setCellStyle(contentStyle);
HSSFCell contentcell7 = rowTh.createCell(7);
contentcell7.setCellValue(yanchuan);
contentcell7.setCellStyle(contentStyle);
HSSFCell contentcell8 = rowTh.createCell(8);
contentcell8.setCellValue(zichuang);
contentcell8.setCellStyle(contentStyle);
HSSFCell contentcell9 = rowTh.createCell(9);
contentcell9.setCellValue(zhidan);
contentcell9.setCellStyle(contentStyle);
HSSFCell contentcell10 = rowTh.createCell(10);
contentcell10.setCellValue(huangling);
contentcell10.setCellStyle(contentStyle);
HSSFCell contentcell11 = rowTh.createCell(11);
contentcell11.setCellValue(huanglong);
contentcell11.setCellStyle(contentStyle);
HSSFCell contentcell12 = rowTh.createCell(12);
contentcell12.setCellValue(wuqi);
contentcell12.setCellStyle(contentStyle);
HSSFCell contentcell13 = rowTh.createCell(13);
contentcell13.setCellValue(ansai);
contentcell13.setCellStyle(contentStyle);
HSSFCell contentcell14 = rowTh.createCell(14);
contentcell14.setCellValue(yichuan);
contentcell14.setCellStyle(contentStyle);
HSSFCell contentcell15 = rowTh.createCell(15);
contentcell15.setCellValue(teqin);
contentcell15.setCellStyle(contentStyle);
              
     //输出Excel文件  
      FileOutputStream output=new FileOutputStream("d:\\Material.xls");        
             workbook.write(output);  
             output.close();            
   } 
System.out.println("ok");
          } 
   return this.returnGridData(true, null, pageList);


} catch (Exception e) {
e.printStackTrace();
return this.returnResult(false, "数据查询异常");
}
}