Getting error when export to xls

Request for help on DynamicReports

Moderator: ricardo

Getting error when export to xls

Postby ALeopold » Mon Jul 20, 2015 6:18 am

hi all, im new in programming, especially in dynamic report... i got error when export to xls with image...
Code: Select all
cmp.image(getClass().getResource("/tss02/rnd/alvin/pictures/tsslogo.png")).setFixedDimension(212, 49)

im add an image at title but im getting this error... when i remove the code, i can save to xls normally...

Code: Select all
Jul 20, 2015 1:08:37 PM net.sf.jasperreports.view.JRViewer btnSaveActionPerformed
SEVERE: Save error.
net.sf.jasperreports.engine.JRException: The cell cannot be added
   at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1641)
   at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:1020)
   at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:815)
   at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:665)
   at net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor.save(JRSingleSheetXlsSaveContributor.java:124)
   at net.sf.jasperreports.view.JRViewer.btnSaveActionPerformed(JRViewer.java:1233)
   at net.sf.jasperreports.view.JRViewer$3.actionPerformed(JRViewer.java:763)
   at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
   at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
   at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
   at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
   at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
   at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
   at java.awt.Component.processMouseEvent(Component.java:6525)
   at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
   at java.awt.Component.processEvent(Component.java:6290)
   at java.awt.Container.processEvent(Container.java:2234)
   at java.awt.Component.dispatchEventImpl(Component.java:4881)
   at java.awt.Container.dispatchEventImpl(Container.java:2292)
   at java.awt.Component.dispatchEvent(Component.java:4703)
   at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)
   at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)
   at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)
   at java.awt.Container.dispatchEventImpl(Container.java:2278)
   at java.awt.Window.dispatchEventImpl(Window.java:2739)
   at java.awt.Component.dispatchEvent(Component.java:4703)
   at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:746)
   at java.awt.EventQueue.access$400(EventQueue.java:97)
   at java.awt.EventQueue$3.run(EventQueue.java:697)
   at java.awt.EventQueue$3.run(EventQueue.java:691)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
   at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
   at java.awt.EventQueue$4.run(EventQueue.java:719)
   at java.awt.EventQueue$4.run(EventQueue.java:717)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:716)
   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/codec/digest/DigestUtils
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.addPicture(HSSFWorkbook.java:1610)
   at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1629)
   ... 43 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.codec.digest.DigestUtils
   at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
   at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
   ... 45 more


please help me... ^.^
ALeopold
 
Posts: 13
Joined: Mon Jul 20, 2015 4:32 am

Re: Getting error when export to xls

Postby ricardo » Tue Jul 21, 2015 11:06 am

Hi,
just add lib commons-codec-1.5.jar to your classpath
ricardo
Site Admin
 
Posts: 1362
Joined: Sat Sep 18, 2010 4:47 pm
Name: Ricardo Mariaca

Re: Getting error when export to xls

Postby ALeopold » Wed Jul 22, 2015 4:12 am

thanks Richardo... its work... ^.^
ALeopold
 
Posts: 13
Joined: Mon Jul 20, 2015 4:32 am

Re: Getting error when export to xls

Postby sthasabin » Thu Jan 05, 2017 7:46 am

Hello Rechard,
i add commons-codec:commons-codec:1.5 lib but still error exits.
Caused by: net.sf.jasperreports.engine.JRException: The cell cannot be added
at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1641)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:1020)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:815)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:665)
at net.sf.dynamicreports.jasper.builder.JasperConcatenatedReportBuilder.export(JasperConcatenatedReportBuilder.java:316)

Thanks.
sthasabin
 
Posts: 1
Joined: Thu Jan 05, 2017 7:41 am

Re: Getting error when export to xls

Postby Zuckas » Sat Jan 14, 2017 6:44 am

sthasabin wrote:Hello Rechard,
i add commons-codec:commons-codec:1.5 lib but still error exits.
Caused by: net.sf.jasperreports.engine.JRException: The cell cannot be added
at net.sf.jasperreports.engine.export.JRXlsExporter.exportImage(JRXlsExporter.java:1641)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:1020)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:815)
at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:665)
at net.sf.dynamicreports.jasper.builder.JasperConcatenatedReportBuilder.export(JasperConcatenatedReportBuilder.java:316)

Thanks.


Hi sthasabin did you fix the error?
Zuckas
 
Posts: 1
Joined: Fri Jan 13, 2017 8:11 am


Return to Help

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 4 guests