Solved

Read / Write Excel File ....

Posted on 2004-03-23
9
194 Views
Last Modified: 2010-03-31
Hi,

How to read / write Excel file using JBuilder tool.
0
Comment
Question by:smartvanl5
  • 3
  • 2
  • 2
9 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 50 total points
ID: 10656469
Use this library:

http://jakarta.apache.org/poi/
0
 

Author Comment

by:smartvanl5
ID: 10656492
Is there any other way to access, like how we are accessing Text file in the java.
0
 
LVL 16

Expert Comment

by:krakatoa
ID: 10656498
Yes, just use a text file.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 16

Expert Comment

by:krakatoa
ID: 10656506
Get Excel to output in delimited text format, and use, probably a RandomAccessFile in java to open and import the contents.

Then write a macro in Excel, and get the output from Java re-imported in updated fashion if that is what you need.
0
 

Author Comment

by:smartvanl5
ID: 10656521
Can you show me some example using JBuilder to read / write the Excel file. Pleaseeeee ...

I am not the core java programmer.

Thanks & Regards,
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10656523
Depends what kind of Excel file it is. If it's just a csv file that simply happens to be showing an Excel icon on the desktop then you're laughing. Otherwise you're looking at a binary file.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 10656529
>>Can you show me some example

That library contains examples
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This video teaches viewers about errors in exception handling.

830 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