File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Reading data from Excel Sheets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Reading data from Excel Sheets" Watch "Reading data from Excel Sheets" New topic
Author

Reading data from Excel Sheets

P Jain
Ranch Hand

Joined: Jul 31, 2004
Posts: 52
Hi!
I have an Excel Sheet that contains different Columns such as

SCRIPT and RESULT

I have to read data from SCRIPT column and write some data in RESULT column.
This Excel Sheet contains 10 rows.

How do I can read data (from specific column) from Excel Sheet and then write in the (specific column) Excel Sheet.


Regards<br />P Jain
Dave Mace
Greenhorn

Joined: Jan 04, 2005
Posts: 11
The poi library from http://jakarta.apache.org/poi/ has the functions you are looking for.

Hope this helps.


Dad always thought laughter was the best medicine, which I guess is why several of us died of tuberculosis. -Jack Handy
P Jain
Ranch Hand

Joined: Jul 31, 2004
Posts: 52
Hi!
Thanks for your reply.
But Can I do it with simple java.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

"Simple" is a relative term: if you don't want to use Jakarta POI, or a commercial Java-COM bridge (like JIntegra for example) then you are left with JNI. Since both POI and JIntegra are built with JNI, it would make sense to use one of them. Writing this from the ground up feels like a big job.

(BTW: Cross posting is not a good thing to do. Pick which thread you want to follow this in, as I'm sure the moderators will close one as soon as they notice)
[ January 13, 2005: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading data from Excel Sheets
 
Similar Threads
HTML Tags through JAVA into Excel Sheet
accessing excel file from java
Reading Data from Excel Sheets
Reading and Writing chinese characters
Generate Excel file