private byte[] generaXls(List lista) throws JRException {
Map<String, Object> params = new HashMap<>();
JRXlsExporter exporter = new JRXlsExporter();
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
JasperDesign jd =
JRXmlLoader.load(
this.getClass()
.getResourceAsStream("/mx/edu/um/mateo/inventario/reportes/almacenes.jrxml"));
JasperReport jasperReport = JasperCompileManager.compileReport(jd);
JasperPrint jasperPrint =
JasperFillManager.fillReport(jasperReport, params, new JRBeanCollectionDataSource(lista));
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, byteArrayOutputStream);
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporter.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporter.exportReport();
byte[] archivo = byteArrayOutputStream.toByteArray();
return archivo;
}
private static JRExporter getJREXporter(final String extension) {
if ("pdf".equalsIgnoreCase(extension)) {
JRPdfExporter exporter = new JRPdfExporter();
// exporter.setParameter(JRPdfExporterParameter.PDF_JAVASCRIPT, "this.print();");
return exporter;
} else if ("html".equalsIgnoreCase(extension)) {
return new JRHtmlExporter();
} else if ("xls".equalsIgnoreCase(extension)) {
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporterXLS.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
return exporterXLS;
} else if ("txt".equalsIgnoreCase(extension)) {
return new JRTextExporter();
} else if ("csv".equalsIgnoreCase(extension)) {
return new JRCsvExporter();
} else if ("docx".equalsIgnoreCase(extension)) {
return new JRDocxExporter();
}
return null;
}
protected void generateXLSOutput(
String reportName,
JasperPrint jasperPrint,
HttpServletResponse resp,
HashMap<String, Object> params)
throws IOException, JRException {
String reportfilename = (reportName) + ".xls";
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
// exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporterXLS.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE);
exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, resp.getOutputStream());
for (Iterator<?> iterator = params.keySet().iterator(); iterator.hasNext(); ) {
String key = (String) iterator.next();
try {
PdfReportParam.class.getDeclaredField(key);
Field field = JRXlsExporterParameter.class.getDeclaredField(key);
field.setAccessible(true);
exporterXLS.setParameter(
(JRExporterParameter) field.get(JRPdfExporterParameter.class), params.get(key));
} catch (Exception e) {
// Xls Param will only valid in report param
}
}
resp.setHeader("Content-Disposition", "inline;filename=" + reportfilename);
resp.setContentType("application/vnd.ms-excel");
exporterXLS.exportReport();
resp.getOutputStream().close();
// clear();
}
public static void exportToExcel(String jrprintFileName, String excelFileName) throws Exception {
long start = System.currentTimeMillis();
File sourceFile = new File(URL + jrprintFileName);
JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
File destFile = new File(URL + excelFileName);
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporter.exportReport();
System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
System.out.println("成功创建了一个Excel文档");
}
/** 导出excel */
public static void exportExcel(
JasperPrint jasperPrint,
String defaultFilename,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, JRException {
logger.debug("执行导出excel The method======= exportExcel() start.......................");
/*
* 设置头信息
*/
response.setContentType("application/vnd.ms-excel");
String defaultname = null;
if (defaultFilename.trim() != null && defaultFilename != null) {
defaultname = defaultFilename + ".xls";
} else {
defaultname = "export.xls";
}
String fileName = new String(defaultname.getBytes("gbk"), "utf-8");
response.setHeader("Content-disposition", "attachment; filename=" + fileName);
ServletOutputStream ouputStream = response.getOutputStream();
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);
exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.exportReport();
ouputStream.flush();
ouputStream.close();
}
public void xls() throws JRException {
long start = System.currentTimeMillis();
File sourceFile = new File("build/reports/DataSourceReport.jrprint");
JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporter.exportReport();
System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
}
private void cargarPropiedadesReporte(JRXlsExporter exporter) {
SimpleXlsReportConfiguration configuracionExcel = new SimpleXlsReportConfiguration();
configuracionExcel.setDetectCellType(Boolean.TRUE);
configuracionExcel.setOnePagePerSheet(Boolean.FALSE);
configuracionExcel.setWhitePageBackground(Boolean.FALSE);
configuracionExcel.setRemoveEmptySpaceBetweenColumns(Boolean.TRUE);
configuracionExcel.setRemoveEmptySpaceBetweenRows(Boolean.TRUE);
configuracionExcel.setIgnoreCellBorder(Boolean.FALSE);
exporter.setConfiguration(configuracionExcel);
}
public static void generateXLSReport(JasperPrint jp, String path) throws Exception {
// JasperExportManager.exp exportReportToPdfFile(jp, path);
if (jp != null) {
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT, jp);
OutputStream output = new FileOutputStream(new File(path));
exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);
System.out.print(exporter.getParameters().toString());
exporter.exportReport();
output.close();
} else {
System.out.print("problme XLS");
}
}
public void xls() throws JRException {
long start = System.currentTimeMillis();
File sourceFile = new File("build/reports/JRMDbReport.jrprint");
JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
JRXlsExporter exporter = new JRXlsExporter();
exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile));
SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
configuration.setOnePagePerSheet(false);
exporter.setConfiguration(configuration);
exporter.exportReport();
System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
}
public void generarReporteEvaluador() {
HttpServletRequest request =
(HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();
ByteArrayOutputStream outReporte = new ByteArrayOutputStream();
String pathJasperReporte =
request.getSession().getServletContext().getRealPath("")
+ "/reportesJasper/variables/cuantitativasPorInformacionIes.jasper";
Map<String, Object> parametrosReporte = new HashMap<>();
String pathLogo =
request.getSession().getServletContext().getRealPath("") + "/images/logo_ceaaces.png";
parametrosReporte.put("par_logo", pathLogo);
parametrosReporte.put("ies", informacionIesDTO.getIes().getNombre());
// parametrosReporte.put("SUBREPORT_DIR", request.getSession()
// .getServletContext().getRealPath("")
// + "/reportesJasper/mallasGrafico/");
try {
JRDataSource dataSourceMallas =
new JRBeanCollectionDataSource(listaValoresVariablesEvaluador);
if (dataSourceMallas != null) {
JRXlsExporter exporter = new JRXlsExporter();
cargarPropiedadesReporte(exporter);
JasperPrint jasperPrint =
JasperFillManager.fillReport(pathJasperReporte, parametrosReporte, dataSourceMallas);
exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outReporte));
exporter.exportReport();
reporteBytes = outReporte.toByteArray();
}
} catch (Exception e) {
e.printStackTrace();
JsfUtil.msgError("Error al generar el reporte, comuníquese con el administrador del sistema");
}
}
public void xls() throws JRException {
long start = System.currentTimeMillis();
File sourceFile = new File(TMP_DIR + ALL_CHARTS_REPORT_JRPRINT);
Map<String, String> dateFormats = new HashMap<String, String>();
dateFormats.put("EEE, MMM d, yyyy", "ddd, mmm d, yyyy");
JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
JRXlsExporter exporter = new JRXlsExporter();
exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile));
SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
configuration.setOnePagePerSheet(true);
configuration.setDetectCellType(true);
configuration.setFormatPatternsMap(dateFormats);
exporter.setConfiguration(configuration);
exporter.exportReport();
System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
}
public void serveResource(ResourceRequest resourceRequest, ResourceResponse resourceResponse) {
try {
String portletId = ParamUtil.getString(resourceRequest, "portletId");
LOGGER.debug("portlet id--" + portletId);
SimpleDateFormat timeStampFormat = new SimpleDateFormat(TIMESTAMP_FORMAT_FOR_EXCEL);
PortletSession session = resourceRequest.getPortletSession();
String timeStamp = timeStampFormat.format(Calendar.getInstance().getTime());
String fileName = "Location_Tracker" + timeStamp + ".xls";
List<LocationDetailsVO> locationDetailList =
LocationTrackerReportsUtil.getLocationDetailsVoList(resourceRequest);
JRBeanCollectionDataSource reportList = new JRBeanCollectionDataSource(locationDetailList);
JasperReport report =
JasperCompileManager.compileReport(
session.getPortletContext().getRealPath("/reports/location_tracker_report.jrxml"));
JasperPrint print =
JasperFillManager.fillReport(report, new HashMap<String, Object>(), reportList);
OutputStream os = resourceResponse.getPortletOutputStream();
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);
exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, os);
exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporterXLS.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporterXLS.exportReport();
resourceResponse.setContentType("application/x-excel");
resourceResponse.setProperty("Content-Disposition", "attachment; filename=" + fileName);
} catch (JRException jre) {
LOGGER.error("Error in exporting the resluts:" + jre.getMessage(), jre);
} catch (Exception e) {
LOGGER.error("Error in exporting the resluts:" + e.getMessage(), e);
}
}
public static void exportReportXls(JasperPrint jp, String path)
throws JRException, FileNotFoundException {
JRXlsExporter exporter = new JRXlsExporter();
File outputFile = new File(path);
File parentFile = outputFile.getParentFile();
if (parentFile != null) {
parentFile.mkdirs();
}
FileOutputStream fos = new FileOutputStream(outputFile);
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, fos);
exporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporter.setParameter(JRXlsAbstractExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.setParameter(JRXlsAbstractExporterParameter.IS_IGNORE_GRAPHICS, Boolean.FALSE);
exporter.exportReport();
logger.debug("XLS Report exported: " + path);
}
public void xls() throws JRException {
long start = System.currentTimeMillis();
File sourceFile = new File("build/reports/FirstJasper.jrprint");
JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
Map dateFormats = new HashMap();
dateFormats.put("EEE, MMM d, yyyy", "ddd, mmm d, yyyy");
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.FORMAT_PATTERNS_MAP, dateFormats);
exporter.exportReport();
System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
try {
System.out.println("Genetate Report");
// Get requested student id from user request
// String studentId = request.getParameter("sid");
// Get requested report type from user request
String reportType = request.getParameter("reportType");
// Setting Default report Type
if (reportType == null || reportType.trim().length() == 0) {
reportType = "pdf";
}
// Get servlet Out put stream to displat report at client side
ServletOutputStream sos = response.getOutputStream();
// Construct path for your .jrxml file
ServletContext application = getServletContext();
String prefix = application.getRealPath("\\");
// String file = getInitParameter("reportTemplet");
String file = "AveTechEventReport.jrxml";
String path = prefix + file;
System.out.println("Path : " + path);
// Load that .jrxml file in Jasper Design
JasperDesign jasperDesign = JRXmlLoader.load(path);
// Compile that .jrxml file into .jasper file
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
/* Populate data from your database It must contain all the fields used in designing a .jrxml file
Here we have used Java Bean Data Source in generating report.
So populate ArrayList which contains your collection of your beans.
*/
JRBeanCollectionDataSource ds =
new JRBeanCollectionDataSource(AdminDAO.getAllEventData(), false);
// Filling the reports using your .jasper file and generated Java Bean Datasource
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, ds);
// Response for generating PDF report
if (reportType != null && reportType.equals("pdf")) {
System.out.println("PDF");
response.setContentType("application/pdf");
JRPdfExporter expoterPDF = new JRPdfExporter();
expoterPDF.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
expoterPDF.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);
expoterPDF.exportReport();
}
// Response for generating EXCEL report
if (reportType != null && reportType.equals("excel")) {
response.setContentType("application/vnd.ms-excel");
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, sos);
exporterXLS.exportReport();
}
// Response for generating WORD report
if (reportType != null && reportType.equals("word")) {
response.setContentType("application/msword");
JRRtfExporter exporterRTF = new JRRtfExporter();
exporterRTF.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporterRTF.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);
exporterRTF.exportReport();
}
// Closing all opened streams
sos.flush();
sos.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void generarReporteInformeEvaluacion() {
HttpServletRequest request =
(HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();
ListaIesController controller =
(ListaIesController) JsfUtil.obtenerObjetoSesion("listaIesController");
IesDTO ies = controller.getIes();
ByteArrayOutputStream outReporte = new ByteArrayOutputStream();
String pathJasperReporteCuantitativas =
request.getSession().getServletContext().getRealPath("")
+ "/reportesJasper/variables/informeEvaluacionCuantitativas.jasper";
String pathJasperReporteCualitativas =
request.getSession().getServletContext().getRealPath("")
+ "/reportesJasper/variables/informeEvaluacionCualitativas.jasper";
Map<String, Object> parametrosReporte = new HashMap<>();
String pathLogo =
request.getSession().getServletContext().getRealPath("") + "/images/logo_ceaaces.png";
parametrosReporte.put("par_logo", pathLogo);
parametrosReporte.put("IES", ies.getNombre());
parametrosReporte.put("CODIGO_IES", ies.getCodigo());
parametrosReporte.put("ID_INFORMACION_IES", informacionIesDTO.getId());
parametrosReporte.put("ID_PROCESO", controller.getFaseIesDTO().getProcesoDTO().getId());
DataSource dataSource = null;
Connection connection = null;
try {
InitialContext ic = new InitialContext();
Context xmlContext = (Context) ic.lookup("java:comp/env");
dataSource = (DataSource) xmlContext.lookup("jdbc/casDbConnection");
connection = dataSource.getConnection();
JRXlsExporter exporter = new JRXlsExporter();
cargarPropiedadesReporte(exporter);
JasperPrint jasperCuantitativas =
JasperFillManager.fillReport(
pathJasperReporteCuantitativas, parametrosReporte, connection);
JasperPrint jasperPrintCualitativas =
JasperFillManager.fillReport(
pathJasperReporteCualitativas, parametrosReporte, connection);
ArrayList<JasperPrint> hojasReporte = new ArrayList<JasperPrint>();
hojasReporte.add(jasperCuantitativas);
hojasReporte.add(jasperPrintCualitativas);
exporter.setExporterInput(SimpleExporterInput.getInstance(hojasReporte));
exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outReporte));
exporter.exportReport();
reporteBytes = outReporte.toByteArray();
outReporte.flush();
outReporte.close();
} catch (Exception e) {
e.printStackTrace();
JsfUtil.msgError(
"Error al generar el reporte, comunÃquese con el administrador del sistema");
} finally {
try {
if (connection != null) {
connection.close();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
public static File generate(HrReport report, String outputFormat, String jrxmlUrl)
throws IOException {
String url = Context.getRuntimeProperties().getProperty("connection.url", null);
Connection conn;
try {
conn = connect(url);
} catch (SQLException e) {
log.error("Error connecting to DB.", e);
return null;
}
Map<String, Object> map = new HashMap<String, Object>();
for (HrReportParameter reportParameter : report.getParameters()) {
if (reportParameter != null)
if (reportParameter.getName() != null)
map.put(reportParameter.getName(), reportParameter.getValue());
}
log.debug("Report parameter map: " + map);
String exportPath = OpenmrsUtil.getApplicationDataDirectory();
URL resourceUrl = new URL(jrxmlUrl);
InputStream is = resourceUrl.openStream();
BufferedReader br = new BufferedReader(new InputStreamReader(is));
FileWriter appDirJrxml = new FileWriter(new File(exportPath + report.getFileName()));
BufferedWriter bw = new BufferedWriter(appDirJrxml);
String line;
while ((line = br.readLine()) != null) {
bw.write(line);
bw.write("\n");
}
bw.flush();
bw.close();
JasperPrint jasperPrint = null;
try {
JasperDesign jasperDesign = JRXmlLoader.load(exportPath + report.getFileName());
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
jasperPrint = JasperFillManager.fillReport(jasperReport, map, conn);
if (outputFormat.equals("PDF")) {
File pdfFile =
new File(
exportPath
+ report.getName()
+ new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss").format(new Date())
+ ".pdf");
JasperExportManager.exportReportToPdfFile(jasperPrint, pdfFile.getAbsolutePath());
return pdfFile;
} else if (outputFormat.equals("Excel")) {
ByteArrayOutputStream output = new ByteArrayOutputStream();
File outputfile =
new File(
exportPath
+ report.getName()
+ new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss").format(new Date())
+ ".xls");
OutputStream outputfileStream = new FileOutputStream(outputfile);
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);
exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporterXLS.setParameter(
JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporterXLS.exportReport();
outputfileStream.write(output.toByteArray());
outputfileStream.flush();
outputfileStream.close();
return outputfile;
}
} catch (JRException e) {
log.error("Error generating report", e);
} finally {
try {
if (!conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
log.error("Exception closing report connection.", e);
}
}
return null;
}