Reading data from Excel Sheets

[P Jain]

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]

The poi library from http://jakarta.apache.org/poi/ has the functions you are looking for.

Hope this helps.

[P Jain]

Hi!
Thanks for your reply.
But Can I do it with simple java.

[Paul Sturrock]

"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 ]