public void exportExcel(HttpServletRequest request,HttpServletResponse response){
OutputStream ouputStream = null;
try{
response.setContentType("application/vnd.ms-excel");
String bankCardId = request.getParameter("bankCardId");
String month = request.getParameter("month");
String sy = request.getParameter("sy");
String fileName = sy+month;
if(StringUtil.isEmpty(fileName)){
fileName="allData";
}
// 根据浏览器进行转码
if (BrowserUtils.isIE(request))
{
response.setHeader("content-disposition",
"attachment;filename="+ java.net.URLEncoder.encode(fileName,"UTF-8") + ".xls");
} else {
String newtitle = new String(fileName.getBytes("ISO8859-1"),
"UTF-8");
response.setHeader("content-disposition","attachment;filename=" + newtitle + ".xls");
}
// 第一步，创建一个webbook，对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = wb.createSheet(fileName);
//设置列宽
this.setSheetColumnWidth(sheet, 100);
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("内容");
cell.setCellStyle(style);
List<Map<String,Object>> lists=dailyTotalAccountService.getFundList(bankCardId, month, sy);
if(lists.size()>0&&lists!=null){
BigDecimal money = null;
for(int i = 0; i < lists.size(); i++){
row = sheet.createRow((int) i + 1);
// 第四步，创建单元格，并设置值
row.createCell((short) 0).setCellValue((String)lists.get(i).get("number"));
row.createCell((short) 1).setCellValue((String)lists.get(i).get("submitTime"));
row.createCell((short) 2).setCellValue((String)lists.get(i).get("projectName"));
row.createCell((short) 3).setCellValue(lists.get(i).get("money").toString());
row.createCell((short) 4).setCellValue((String)lists.get(i).get("description"));
}
}
//写到输出流
ouputStream = response.getOutputStream();
wb.write(ouputStream);
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(ouputStream !=null){
ouputStream.flush();
ouputStream.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
/**
* 设置列宽
*
* @param sheet
*/
private void setSheetColumnWidth(HSSFSheet sheet, int count) {
for (int i = 0; i < count; i++) {
sheet.setColumnWidth(i, 25*256);
}
}