动态列报表导出Excel

动态列报表导出Excel/***********publicclassCommonOutleadExcel{导出excel前对数据进行处理@authorwwy@date2017-3-1@paramcolumnList:列索引跟dataList中map的key值保持一致@paramDatalist:数据列表@paramcolumnNameMap:列名，其中key/************/publicvoidoutleadExcelPro(List<String>columnList,List<Map<String,Object>>Datalist,Map<String,Object>columnNameMap,HttpServletResponseresponse,StringstringName)throwsIOException{Map<String,Object>resultMap=newHashMap<String,Object>();finalServletOutputStreamos=response.getOutputStream();//获得ServletOutputStream对象response.setContentType("application/x-msdownload");response.setHeader("Content-Disposition”,"attachment;filename="+URLEncoder.encode(stringName+".xlsx”,"UTF-8")+';');〃导出excelcopyrightContractCount(stringName,resultMap,columnList,columnNameMap,Datalist,os);}privatevoidcopyrightContractCount(Stringname,Map<String,Object>resultMap,List<String>columnList,Map<String,Object>columnNameMap,List<Map<String,Object>>dataList,OutputStreamos){Stringtitle=name;Workbookworkbook=newXSSFWorkbook();//产生通用单元格样式CellStylestyle=generateCommonCellStyle(workbook);〃创建sheet表单，同时写入标题Sheetsheet=generateSheet(workbook,title,columnList,style);

〃写入标题行writeColumnName(sheet,columnList,columnNameMap,style);//写入数据行//writeDataRow(sheet,columnList,resultMap,dataList,style);writeDataRow_new(sheet,columnList,dataList,style);//输入excel文件try{workbook.write(os);os.close();}catch(lOExceptione){e.printStackTrace();}/**

********}写入数据@authorwwy@date2017-3-1@paramsheet@param/**

*********/privatevoidwriteDataRow_new(Sheetsheet,List<String>columnList,List<Map<String,Object>>dataList,CellStylestyle)(introwIndex=2;for(inti=0;i<dataList.size();i++)(〃创建一行RowdataRow=sheet.createRow(rowIndex++);〃获取改行数据Map<String,Object>rowDataMap=dataList.get(i);if(columnList!=null&&columnList.size()>0)(for(intj=0;j<columnList.size();j++)(〃创建单元格CelldataCell=dataRow.createCell(j);〃设置单元格样式dataCell.setCellStyle(style);//从数据map中获取对应列的数据Stringvalue=String.valueOf(rowDataMap.get(columnList.get(j)));〃将数据写入单元格

/***

*/***

********往sheet表单中写入列头数据columnList:列头数据liststyle：单元格样式@authorwwy@date2017-3-1@paramsheet@paramcolumnList@paramstyle*/privatevoidwriteColumnName(Sheetsheet,List<String>columnList,Map<String,Object>columnNameMap,CellStylestyle)(RowtitleRow=sheet.createRow(1);intindex=0;for(inti=0;i<columnList.size();i++)(CelltitleCell=titleRow.createCell(index);titleCell.setCellStyle(style);titleCell.setCellValue(String.valueOf(columnNameMap.get(columnList.get(i))));index++;}/**********}

〃创建sheet表单Sheetsheet=workbook,createSheet(title);〃在表单中创建一行RowtableRow=sheet.createRow(O);〃在行中创建单元格for(inti=0;i<columnList.size();i++)(Cellcell=tableRow.createCell(i);cell.setCellStyle(style);}/**********sheet.addMergedRegion(newCellRangeAddress(0,0,0,columnList.size()-1));returnsheet;/***/********创建sheet表单，同时生成表头title：标题名columnList:列名list@authorwwy@date2017-3-1@paramworkbook@paramtitle@paramcolumnList*/privateSheetgenerateSheet(Workbookworkbook,Stringtitle,List<String>columnList,CellStylestyle)(创建通用cell样式@authorwwy@date2017-3-1@paramworkbook@return*/privateCellStylegenerateCommonCellStyle(Workbookworkbook)(CellStylestyle=workbook.createCellStyle();style.setAlignment(CellStyle.ALIGN_CENTER);style.setBorderLeft(