Error using XLS preview in 3.7.1

[tprice1960]

When trying to use the XLS Preview in iReport 3.7.1 I get the error shown below.   I can run the exact same report in iReport 3.7.0 and the XLS Preview works fine.    Found other topics regarding POI version, but both 3.7.0 and 3.7.1 include poi-3.2.

--------------------------------------------------

Error exporting print... org/apache/poi/ss/util/CellRangeAddress

java.lang.NoClassDefFoundError: org/apache/poi/ss/util/CellRangeAddress      at com.jaspersoft.ireport.designer.export.DefaultExporterFactory.createExporter(DefaultExporterFactory.java:89)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:1046)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.util.CellRangeAddress      at java.net.URLClassLoader$1.run(Unknown Source)      at java.security.AccessController.doPrivileged(Native Method)      at java.net.URLClassLoader.findClass(Unknown Source)      at java.lang.ClassLoader.loadClass(Unknown Source)      at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)      at java.lang.ClassLoader.loadClass(Unknown Source)      at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252)      at java.lang.ClassLoader.loadClass(Unknown Source)      at java.lang.ClassLoader.loadClassInternal(Unknown Source)      ... 4 more

---------------------------------------------------

I also get a prompt trying to open a dot-jasper file rather than the dot-xls file.

(Executing: rundll32 SHELL32.DLL,ShellExec_RunDLL "C:\CVSroot\Reports\IR37\boxplant_rolls.jasper")

 

Any suggestions ?

[mamo]

I have the sampe problem.

It seems a new bug introduced with 3.7.1

[nashbr]

Anything about this??, y cannot generate excel files.

 

Code:

Error exporting print... org/apache/poi/ss/util/CellRangeAddressjava.lang.NoClassDefFoundError: org/apache/poi/ss/util/CellRangeAddress     at com.jaspersoft.ireport.designer.export.DefaultExporterFactory.createExporter(DefaultExporterFactory.java:89)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:1046)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.util.CellRangeAddress     at java.net.URLClassLoader$1.run(URLClassLoader.java:200)     at java.security.AccessController.doPrivileged(Native Method)     at java.net.URLClassLoader.findClass(URLClassLoader.java:188)     at java.lang.ClassLoader.loadClass(ClassLoader.java:307)     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)     at java.lang.ClassLoader.loadClass(ClassLoader.java:252)     at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252)     at java.lang.ClassLoader.loadClass(ClassLoader.java:252)     at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)     ... 4 more 

[nashbr]

well, ok, was simple, the distribution of ireport3.7.1 still comming with poi.3.2.

I've just import poi3.5 of the jasperreports distribution and problem solved.

Thanks

[rw-network]

I am getting this same error.

If you have Excel export working under iReport 3.7.1, can you please better explain what you did to get it working?

 Thanks

Post Edited by scottj314 at 04/09/2010 11:45

[nashbr]

Ok, originally I have this library in my IReport folder:

...\Jaspersoft\iReport-3.7.1\ireport\modules\ext\poi-3.2-FINAL-20081019.jar

 

You can replace it with poi-3.5-FINAL-20090928.jar that came with the JasperReports-3.7.1, wich you can download from here

http://jasperforge.org/projects/jasperreports

that's all, you don't need to change anymore

[tprice1960]

Using the updated poi files did not resolve the problem for me.  I still get the exact same error.

I can use the JExcelApi viewer or the Excel 2007 xlsx preview, but not the normal xls preview.

Are there any steps beyond replacing the poi-3.2 files you performed?

[rw-network]

 Copying in the updated poi did not work for me either. That is why I asked for clarification on what was done to 'fix' this bug.

[tprice1960]

FYI,  problem solved in iReport 3.7.2.      Thanks.

[shekharv]

hi,

 

Even iam getting the same problem after giving the poi-3.5-FINAL-20090928.jar even error is same.

please can u tell me how you have solved this problem?

 

Thank & regards,

Shekarv

 

 

Code:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/ss/util/CellRangeAddressat at.go_mobile.zuckerreports.JasperBatchMain.getJRExporter(JasperBatchMain.java:227)at at.go_mobile.zuckerreports.JasperBatchMain.main(JasperBatchMain.java:80)Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.util.CellRangeAddressat java.net.URLClassLoader$1.run(Unknown Source)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(Unknown Source)at java.lang.ClassLoader.loadClass(Unknown Source)at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)at java.lang.ClassLoader.loadClass(Unknown Source)at java.lang.ClassLoader.loadClassInternal(Unknown Source)... 2 more