awking00
asked on
Getting error when attempting to create a workbook using Java POI API
I am getting an error when trying to create a workbook. I have attached the error stack from the debug screen. This is the first time I have run into this issue and I think it may have something to do with the recent upgrade to Microsoft Office 2010 and I'm now trying to read .xlsx files where before I was reading .xls files. As such, it might mean I need some different jars. If so, how do I go about adding them to the application. As always, any help is greatly appreciated.
error-stack.txt
error-stack.txt
ASKER
Added information - The environment is Windows and the application is being launched via Eclipse.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please bear with me as I am awaiting the installation of a new version of Java that I belileve contains the jar file(s) that I need. I work in a place that makes one go through hoops to install any new software. I will close the question when I find that the upgrade solves my problem.
ASKER
The jar files I needed were just recently made available and adding them to my class path took care of the issue.
I think you looking for the POI-HSSF and or POI-XSSF related jar files. You may need to verify that they are somewhere in your system.
Once you have loaded/located the jar files there are generally two ways to specify where to find the .JAR files to the JVM.
The CLASSPATH environment variable.
The -cp/-classpath command line parameter of the java jvm. Try java -h for parameters.
To make adjustments you may need to track down a launch script. Or the parameters of a desktop launch widget. The CLASSPATH could also be set by login scripts.
This article talks a bit about the CLASSPATH environment variable: http://docs.oracle.com/jav