Examples of ExportExcel

com.thinkgem.jeesite.common.utils.excel.ExportExcel
导出Excel文件（导出“XLSX”格式，支持大数据量导出 @see org.apache.poi.ss.SpreadsheetVersion） @author ThinkGem @version 2013-04-21
org.pentaho.cdf.export.ExportExcel

Examples of com.thinkgem.jeesite.common.utils.excel.ExportExcel

    public String importFileTemplate(HttpServletResponse response, RedirectAttributes redirectAttributes) {
    try {
      String fileName = "用户数据导入模板.xlsx";
      List<User> list = Lists.newArrayList();
      list.add(UserUtils.getUser());
      new ExportExcel("用户数据", User.class, 2).setDataList(list).write(response, fileName).dispose();
      return null;
    } catch (Exception e) {
      addMessage(redirectAttributes, "导入模板下载失败！失败信息：" + e.getMessage());
    }
    return "redirect:" + Global.getAdminPath() + "/sys/user/?repage";

View Full Code Here

Examples of com.thinkgem.jeesite.common.utils.excel.ExportExcel

    @RequestMapping(value = "export", method=RequestMethod.POST)
    public String exportFile(User user, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
    try {
      String fileName = "用户数据" + DateUtils.getDate("yyyyMMddHHmmss") + ".xlsx"; 
        Page<User> page = systemService.findUser(new Page<User>(request, response, -1), user); 
        new ExportExcel("用户数据", User.class).setDataList(page.getList()).write(response, fileName).dispose();
        return null;
    } catch (Exception e) {
      addMessage(redirectAttributes, "导出用户失败！失败信息："+e.getMessage());
    }
    return "redirect:" + Global.getAdminPath() + "/sys/user/?repage";

View Full Code Here

Examples of org.pentaho.cdf.export.ExportExcel


        if ( exportType.equals( IExport.EXPORT_TYPE_CSV ) ) {
          export = new ExportCSV( output );
          setResponseHeaders( MimeTypes.CSV, 0, "export" + export.getExtension() );
        } else {
          export = new ExportExcel( output );
          setResponseHeaders( MIME_XLS, 0, "export" + export.getExtension() );
        }


        export.exportFile( new JSONObject( out.toString() ) );
      }

View Full Code Here

Examples of org.pentaho.cdf.export.ExportExcel

      if ( IExport.EXPORT_TYPE_CSV.equalsIgnoreCase( exportType ) ) {
        export = new ExportCSV( response.getOutputStream() );
        response.setHeader( "Content-Type", MimeTypes.CSV );


      } else {
        export = new ExportExcel( response.getOutputStream() );
        response.setHeader( "Content-Type", MimeTypes.XLS );
      }


      response.setHeader( "Cache-Control", "max-age=0, no-store" );
      response.setHeader( "content-disposition", "attachment; filename=" + "export" + export.getExtension() );

View Full Code Here

Examples of org.pentaho.cdf.export.ExportExcel


                if (exportType.equals("csv")) {
                    export = new ExportCSV(output);
                    setResponseHeaders(MIME_CSV, 0, "export" + export.getExtension());
                } else {
                    export = new ExportExcel(output);
                    setResponseHeaders(MIME_XLS, 0, "export" + export.getExtension());
                }


                export.exportFile(new JSONObject(out.toString()));
            }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.