<a href="###" class="eui-btn eui-btn-small" onclick="Export()"><i class="eui-icon" ></i>模板下载</a>

   //导出数据

    function  Export() {

        window.open("/Summary/excelExport");

    }

 //导出

    @RequestMapping("/excelExport")

    @ResponseBody

    public void excelExport(String params, HttpServletRequest

            request , HttpServletResponse response,String projectCode

            ,String projectName,String engineeringName,Integer status,String creatorName,String creatororgname,String createTime,String providername) throws Exception{

        BufferedInputStream in = null;

        BufferedOutputStream out = null;

        SimpleDateFormat sdf1=new SimpleDateFormat("yyyy-MM-dd");//小写的mm表示的是分钟

        // path是指欲下载的文件的路径。

        /*File file = new File(path);*/

        //创建excel

        HSSFWorkbook wb = new HSSFWorkbook();

        String fileName = "科目信息表.xls";//导出时下载的EXCEL文件名

        //创建sheet

        HSSFSheet sheet = wb.createSheet("科目信息");

        sheet.setDefaultColumnWidth();

        sheet.setDefaultRowHeightInPoints();

        //创建一行

        HSSFRow rowTitle = sheet.createRow();

        rowTitle.setHeightInPoints();

        HSSFCellStyle styleTitle = wb.createCellStyle();

        styleTitle.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 居中

        HSSFCellStyle styleCenter = wb.createCellStyle();

        styleCenter.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 居中

        styleCenter.setWrapText(true); // 设置为自动换行

        // 在行上创建1列

        HSSFCell cellTitle = rowTitle.createCell();

        // 列标题及样式

        cellTitle.setCellValue("科目ID");

        cellTitle.setCellStyle(styleTitle);

        // 在行上创建2列

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("科目名称");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("上年实际");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("本年预算");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("1月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("2月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("3月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("4月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("5月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("6月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("7月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("8月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("9月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("10月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("11月");

        cellTitle.setCellStyle(styleTitle);

        cellTitle = rowTitle.createCell();

        cellTitle.setCellValue("12月");

        cellTitle.setCellStyle(styleTitle);

        List<BudgetDetail> budgetDetails=budgetDetailService.ExcelInfo();

        for(int i=;i<budgetDetails.size();i++){

            BudgetDetail budgetDetail = budgetDetails.get(i);

            HSSFRow row = sheet.createRow(i + );

            row.setHeightInPoints();

            HSSFCell cell = row.createCell();

            cell.setCellValue(budgetDetail.getSubid());//科目ID

            cell.setCellStyle(styleCenter);

            cell = row.createCell();

            cell.setCellValue(budgetDetail.getSubname());//科目名称

            cell.setCellStyle(styleCenter);

        }

        String path="c:/aaaa.xls";

        String path2="D:/aaaa.xls";

        FileOutputStream fout = null;

        try{

            fout = new FileOutputStream(path);

        }catch (Exception e){

            fout = new FileOutputStream(path2);

        }

        wb.write(fout);

        fout.close();

        wb.close();

        try {

            try {

                InputStream inputStream = new FileInputStream(ResourceUtils.getFile(path));

                fileName = URLEncoder.encode(fileName, "UTF-8");

                response.setContentType("applicationnd/octet-stream");

                response.setCharacterEncoding("UTF-8");

                response.setHeader("Content-Disposition", "attachment; filename="+fileName);

                in = new BufferedInputStream(inputStream);

                out = new BufferedOutputStream(response.getOutputStream());

            }catch (Exception e){

                InputStream inputStream = new FileInputStream(ResourceUtils.getFile(path2));

                fileName = URLEncoder.encode(fileName, "UTF-8");

                response.setContentType("applicationnd/octet-stream");

                response.setCharacterEncoding("UTF-8");

                response.setHeader("Content-Disposition", "attachment; filename="+fileName);

                in = new BufferedInputStream(inputStream);

                out = new BufferedOutputStream(response.getOutputStream());

            }

            byte[] data = new byte[];

            int len = ;

            while (- != (len=in.read(data, , data.length))) {

                out.write(data, , len);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            if (in != null) {

                in.close();

            }

            if (out != null) {

                out.close();

            }

            File f = new File(path);

            if (f.exists()){

                f.delete();//删除

            }

            File f1=new File(path2);

            if (f1.exists()){

                f1.delete();

            }

        }

    }