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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

>>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?
newtosvgAuthor Commented:
I don't. Where can I get the .jar files?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

newtosvgAuthor Commented:
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.


Any success with this?

newtosvgAuthor Commented:
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.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Languages-Other

From novice to tech pro — start learning today.