Write XML ResultSet data from JAVA or JSP page to Excel

Posted on 2003-11-13
Last Modified: 2007-12-19
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.
Question by:newtosvg
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 20

Expert Comment

ID: 9746813
>>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?

Author Comment

ID: 9748402
I don't. Where can I get the .jar files?
LVL 20

Accepted Solution

Venabili earned 250 total points
ID: 9748714
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 9751655
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.*;
LVL 20

Expert Comment

ID: 9751669
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.

LVL 20

Expert Comment

ID: 9763519

Any success with this?


Author Comment

ID: 9771504
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.


Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question