Solved

Write XML ResultSet data from JAVA or JSP page to Excel

Posted on 2003-11-13
9
2,953 Views
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.
0
Comment
Question by:newtosvg
  • 4
  • 3
9 Comments
 
LVL 20

Expert Comment

by:Venabili
Comment Utility
>>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?
0
 

Author Comment

by:newtosvg
Comment Utility
I don't. Where can I get the .jar files?
0
 
LVL 20

Accepted Solution

by:
Venabili earned 250 total points
Comment Utility
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:newtosvg
Comment Utility
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.*;
0
 
LVL 20

Expert Comment

by:Venabili
Comment Utility
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

0
 
LVL 20

Expert Comment

by:Venabili
Comment Utility
newtosvg,

Any success with this?

Venabili
0
 

Author Comment

by:newtosvg
Comment Utility
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.

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
format the code in java 6 72
EvenOdd challenge 10 81
countHi challenge 25 84
wordlen challenge 3 46
Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
The goal of this video is to provide viewers with basic examples to understand and use switch statements in the C programming language.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now