Solved

Write XML ResultSet data from JAVA or JSP page to Excel

Posted on 2003-11-13
9
2,965 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
[X]
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
9 Comments
 
LVL 20

Expert Comment

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

Author Comment

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

Accepted Solution

by:
Venabili earned 250 total points
ID: 9748714
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Expert Comment

by:Venabili
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.
http://www.andykhan.com/jexcelapi/download.html

0
 
LVL 20

Expert Comment

by:Venabili
ID: 9763519
newtosvg,

Any success with this?

Venabili
0
 

Author Comment

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

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
no14 challenge 14 73
fizzArray3  challenge 1 107
java constructor error 8 133
Python Encoding Problem \u2013 4 134
If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
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 video teaches viewers about errors in exception handling.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

740 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