tprice1960 Posted March 1, 2010 Share Posted March 1, 2010 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/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(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 ? Link to comment Share on other sites More sharing options...
mamo Posted March 4, 2010 Share Posted March 4, 2010 I have the sampe problem.It seems a new bug introduced with 3.7.1 Link to comment Share on other sites More sharing options...
nashbr Posted March 8, 2010 Share Posted March 8, 2010 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 Link to comment Share on other sites More sharing options...
nashbr Posted March 9, 2010 Share Posted March 9, 2010 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 Link to comment Share on other sites More sharing options...
rw-network Posted April 9, 2010 Share Posted April 9, 2010 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? ThanksPost Edited by scottj314 at 04/09/2010 11:45 Link to comment Share on other sites More sharing options...
nashbr Posted April 9, 2010 Share Posted April 9, 2010 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 herehttp://jasperforge.org/projects/jasperreportsthat's all, you don't need to change anymore Link to comment Share on other sites More sharing options...
tprice1960 Posted April 11, 2010 Author Share Posted April 11, 2010 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? Link to comment Share on other sites More sharing options...
rw-network Posted April 12, 2010 Share Posted April 12, 2010 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. Link to comment Share on other sites More sharing options...
tprice1960 Posted April 14, 2010 Author Share Posted April 14, 2010 FYI, problem solved in iReport 3.7.2. Thanks. Link to comment Share on other sites More sharing options...
shekharv Posted May 24, 2010 Share Posted May 24, 2010 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now