Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading data from Excel Sheets

 
P Jain
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Dave Mace
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The poi library from http://jakarta.apache.org/poi/ has the functions you are looking for.

Hope this helps.
 
P Jain
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
Thanks for your reply.
But Can I do it with simple java.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic