Link to home
Start Free TrialLog in
Avatar of newtosvg
newtosvg

asked on

Write XML ResultSet data from JAVA or JSP page to Excel

I need to put my xml data result from java class to excel. Please help.
I put this in my java class and got the error message. "The import jxl cannot be resolved". What do I need?

import jxl.*;
import jxl.write.*;

I need the code to get this done. I am running out of time with the project.
Avatar of Venabili
Venabili
Flag of Bulgaria image

>>I put this in my java class and got the error message. "The import jxl cannot be resolved".

Do you have the jxl classes in your classpath?
Avatar of newtosvg
newtosvg

ASKER

I don't. Where can I get the .jar files?
ASKER CERTIFIED SOLUTION
Avatar of Venabili
Venabili
Flag of Bulgaria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I already tried the site you mentioned, doesn't tell me how to get the .jar files that I need in order to use
import jxl.*;
import jxl.write.*;
From the site:

"JExcelApi comes packaged as a zipped tar file, called something like jexcelapi_2_0.tar.gz. To unpack on UNIX systems, at the command line type
gunzip jexcelapi_2_0.tar.gz      followed by
tar xf jexcelapi_2_0.tar
On Linux systems this can be accomplished within the single command
tar zxf jexcelapi_2_0.tar.gz
On Windows/NT systems, the archive may be unpacked visually using a utility such as Winzip.
Whatever the unpacking process, the application will be placed in a subdirectory called jexcelapi. The top level directory contains this html page and the pre-built jar file, jxl.jar. The docs directory contains the javadoc documentation for the public classes, the build directory contains the buildfile (requires ant ) and the src directory contains the source code for the java classes. "

Here is the link for the direct download. Download the tar.gz file and unpack it.
http://www.andykhan.com/jexcelapi/download.html

newtosvg,

Any success with this?

Venabili
I did the download and put the jxl.jar in the class path. I was able to include the imports "import jxl.*;
import jxl.write.*;". I actually need the code to do this. Thanks.