java jasper 生成xlsx_Jasper模板导出为Excel、PDF

/*** @Description： 将模板导出为Excel

*@author:

* @date: 2018年3月22日 下午8:57:24

*@parampagename 模板文件名称

*@paramparams 导出参数

*@paramjavaBean 报表数据源实体类

*@paramrequest 请求对象

*@paramresponse 响应对象

*@throwsJRException Jasper异常

*@throwsIOException IO异常*/@Overridepublic void exportTemplateToExcel(String pagename, Mapparams, Object javaBean,

HttpServletRequest request, HttpServletResponse response)throwsJRException, IOException {

List list = new ArrayList();

list.add(javaBean);//获取模板

JasperReport jasperReport =getJasperReport(pagename);//创建数据源

JRBeanCollectionDataSource dataSource = newJRBeanCollectionDataSource(list);//设置jasper文件夹的路径

params =setJasperPath(params);//填充模版

JasperPrint jasperPrint =JasperFillManager.fillReport(jasperReport, params, dataSource);//生成文件名

String fileName = UUID.randomUUID().toString().toUpperCase() + ".xlsx";//资源文件完整路径

String completePath =getPdfUrl(request, fileName);//服务器文件临时路径

String templatePath = getTempFoleder() + "/" +fileName;//设置response参数，用于打开下载页面

response.reset();

response.setContentType("application/x-msdownload;");

response.setHeader("Content-Disposition","attachment;filename=" + new String(fileName.getBytes("utf-8"), "ISO-8859-1"));//创建Jasper Excel导出类

JRXlsxExporter exporter = newJRXlsxExporter();//设置导出配置项

SimpleXlsxReportConfiguration conf = newSimpleXlsxReportConfiguration();

conf.setWhitePageBackground(false);

conf.setDetectCellType(true);

exporter.setConfiguration(conf);//设置输入项

ExporterInput exporterInput = newSimpleExporterInput(jasperPrint);

exporter.setExporterInput(exporterInput);//设置输出项

OutputStreamExporterOutput exporterOutput = newSimpleOutputStreamExporterOutput(templatePath);

exporter.setExporterOutput(exporterOutput);//导出报表

exporter.exportReport();//重定向到资源文件url

response.sendRedirect(completePath);

exporterOutput.close();

}/*** 导出模板为PDF文件

*@parampagename

*@paramparams

*@paramjavaBean

*@paramrequest

*@paramresponse

*@throwsJRException

*@throwsIOException*/@Overridepublic void exportTemplateToPdf(String pagename, Mapparams, Object javaBean,

HttpServletRequest request, HttpServletResponse response)throwsJRException, IOException {

List list = new ArrayList();

list.add(javaBean);//获取模板

JasperReport jasperReport =getJasperReport(pagename);//创建数据源

JRBeanCollectionDataSource dataSource = newJRBeanCollectionDataSource(list);//设置jasper文件夹的路径

params =setJasperPath(params);//填充模版

JasperPrint jasperPrint =JasperFillManager.fillReport(jasperReport, params, dataSource);//生成文件名

String fileName = UUID.randomUUID().toString().toUpperCase() + ".pdf";//资源文件完整路径

String completePath =getPdfUrl(request, fileName);//服务器文件临时路径

String templatePath = getTempFoleder() + "/" +fileName;//设置response参数，用于打开下载页面

response.reset();

response.setContentType("application/pdf;");

response.setHeader("Content-Disposition","attachment;filename=" + new String(fileName.getBytes("utf-8"), "ISO-8859-1"));//定义报表输出源

JRPdfExporter exporter = newJRPdfExporter();//设置输入项

ExporterInput exporterInput = newSimpleExporterInput(jasperPrint);

exporter.setExporterInput(exporterInput);//设置输出项

OutputStreamExporterOutput exporterOutput = newSimpleOutputStreamExporterOutput(templatePath);

exporter.setExporterOutput(exporterOutput);//导出报表

exporter.exportReport();//重定向到资源文件url

response.sendRedirect(completePath);

exporterOutput.close();

}