Problem creating excel form.

[burferd]

I am trying to generate a PDF and Excel version of the same report.

I am able to generate the PDF version, but get the error shown in the code section when I try to do the Excel version.

It appears that it can't find something i the poi library:    org.apache.poi.hssf.usermodel.HSSFWorkbook.getCreationHelper()

I thought I had all the proper libraries loaded, but maybe I am missing something.  Here are the libraries I have loaded:

commons-beanutils-1.8.0.jar

commons-collections-2.1.1.jar

commons-digester-1.7.jar

commons-logging-1.0.4.jar

jasperreports-4.0.1.jar

groovy-all-1.7.5.jar

iText-2.1.7.jar

poi-3.6.jar

Could anyone tell me what I am missing that caused the error?

Thanks.

 PS. I found a post on this problem using JR4.0.0.   They said that using POI-3.6 solved the problem. however, I have POI-3.6 in my library list and still get the error.  Here is the post:  http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=84285

 

Code:

Post Edited by burferd at 06/23/2011 17:44