We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Jasper Report

zolf
zolf asked
on
Medium Priority
1,780 Views
Last Modified: 2012-05-06

Hello there,

i am trying to save a jasperviewer as excel file.but i get this error.i have no problem printing.
i also added the poi-3.5-beta4-20081128 jar file to my application

Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region;)I
      at net.sf.jasperreports.engine.export.JRXlsExporter.createMergeRegion(JRXlsExporter.java:558)
      at net.sf.jasperreports.engine.export.JRXlsExporter.initCreateCell(JRXlsExporter.java:530)
      at net.sf.jasperreports.engine.export.JRXlsExporter.createTextCell(JRXlsExporter.java:520)
      at net.sf.jasperreports.engine.export.JRXlsExporter.exportText(JRXlsExporter.java:391)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:561)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:434)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:218)
      at net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor.save(JRSingleSheetXlsSaveContributor.java:112)
      at net.sf.jasperreports.view.JRViewer.btnSaveActionPerformed(JRViewer.java:1128)
      at net.sf.jasperreports.view.JRViewer$3.actionPerformed(JRViewer.java:668)
      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
Comment
Watch Question

Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
you're using an incompatible version of poi

Author

Commented:

do i use an older version poi
this one poi-3.2-FINAL-20081019 or can you give me the link to theversion i need to download
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
yes u need an older version
what version of jasper?

Author

Commented:

what version of jasper?
jasperreports-3.0.0
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
try 2.0 while I ask around


Author

Commented:

cheers mate
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:

Author

Commented:

what is the way out
Mick BarryJava Developer
CERTIFIED EXPERT
Top Expert 2010

Commented:
how did 2.0 go?  It should still work

Author

Commented:

is that jasper 2.0 or poi

Author

Commented:

i downlaaded this poi-3.0.1-FINAL.jar adn when i try to save i dont get that exception.but i dont see the values in the cells
1.jpg
Java Developer
CERTIFIED EXPERT
Top Expert 2010
Commented:
others having problems as well

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=50185

perhaps file a report with jasper

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.