[#4408] - Can't export to Xlsx format

Category:
Bug report
Priority:
Urgent
Status:
Assigned
Project: Severity:
Block
Resolution:
Open
Component: Reproducibility:
Unable to Reproduce
Assigned to:

Hi, I updated from version 3.5.3 to 3.6.1 aiming to test the XlsxExporter (using Rational Application Developer for JAVA) BUT when I did, I got a 'NoSuchMethodError' that looks like this:

Exception in thread "Thread-188" java.lang.NoSuchMethodError: net/sf/jasperreports/engine/export/ooxml/XlsxWorkbookHelper.write(Ljava/lang/String;)V
at net.sf.jasperreports.engine.export.ooxml.XlsxWorkbookHelper.exportHeader(XlsxWorkbookHelper.java:48)
at net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter.openWorkbook(JRXlsxExporter.java:1218)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:381)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:207)
at co.com.easy.uc.businesslogic.reports.fidelizacion.ReporteFidelizacionHelper.run(ReporteFidelizacionHelper.java:176)
at java.lang.Thread.run(Thread.java:810)

JUST IN CASE, the instructions I use are:

JasperPrint jasperPrint = JasperFillManager.fillReport( reportSourcePath, parameters, con );

JRXlsxExporter exporter = new JRXlsxExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, reportPath + fileReportName);

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE);
exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

exporter.exportReport();

Can you please help me with this?

----------

Carlos

k_maldini3_k's picture
Joined: Nov 6 2009 - 1:57pm
Last seen: 13 years 10 months ago

2 Comments:

#1

Carlos, I'm not able to reproduce the problem (which is actually really strange). Do you experience this problem in iReport?

#2

No, I'm using the new JRXlsxExporter which is included in the libraries of iReport (version 3.6.1). This problem happens in JAVA and I reported it because previously I was using the JRXlsExporter (XLS) and it exported the report, but I updated the libraries of my JAVA project to use the JRXlsxExporter (XLSX) and the Exception 'NoSuchMethodError' appeared. I don't know if this is the right place to ask this kind of stuff, but I suppose it is because I'm using the new jars included in the new version of iReport.

Thanks,

Carlos

Feedback
randomness