导出excel

List list = departReportService.excelDepartReport(params, currPage, pageSize);
       
        String downpath = "temp_xml/user";
        String filepath = getServlet().getServletContext().getRealPath(File.separator + downpath);
        SimpleDateFormat fts = new SimpleDateFormat("yyyyMMddHHmmss");
        String sdate = fts.format(new Date());
        String filename = "用户报表" + "_" + sdate + ".xls";
        String downnamepath = downpath + "/" + filename;
        String linuxdownnamepath = downnamepath.replace("\\", "/");
       
        // 判断目录是否存在,不存在创建
        FileUtil.DirIsExiste(filepath);
        String filenamepath = filepath + "\\" + filename;
        String linuxfilenamepath = filenamepath.replace("\\", "/");
        ExcelCreator creator = new ExcelCreator(linuxfilenamepath, filename,null, list);
        creator.createXLS();
       
        DownLoadFileTools.downloadFile(request,response, filename, linuxdownnamepath);

 

 

/**
  * 下载excel到自定目录 <功能详细描述>
  *
  * @param title
  *            文件标题
  * @param fileContext
  *            文件内容
  * @param fileName
  *            文件名
  * @param format
  *            Excel格式
  * @return void [返回类型说明]
  * @exception throws
  *                [违例类型] [违例说明]
  */
 public void createExcelFile(String title, List fileContext,
   String fileName, SheetFormat format, String templet) {

  // 导出文件路径
  String filePath = PlatformConfig.getUseDataPath()
    + Constants.EXPORT_PATH;
  // 判断目录是否存在,不存在创建
  FileUtil.DirIsExiste(filePath);
  filePath = filePath + fileName;
  String linuxfilenamepath = filePath.replace("\\", "/");
  ExcelCreator creator = new ExcelCreator(linuxfilenamepath, title, null,
    fileContext, templet);
  if (null != format) {
   creator.setFormat(format);
  } else {
   creator.setFormat(new SheetFormat());
  }
  creator.createXLS();

 }