How to read Excel file with java

[chetan-24]

Hello,

I am a new user in java and i don't have good grip in java, basically i am a software Tester and rightnow i am automating my application with Selenium (Testing Tool) so i need to write a script in java, so far i Worked with QTP for the same but in that its really easy to Data Driven test with Excel but here i am facing lots of problem.

Could you please help me and define how to read/Write data from excel with java.

also how can i create input dialog box (like prompt in jscript) ?

Please Guide me

Thanks
chetan!

[Eranga]

Please search the forum. We are discuss about working on with Excel in Java here in our community several times.

[Threddy]

Hi Chetan,

I may have a ready made solution for you. I have created a Selenium/Java test framework, with a Excel interface, called Hrmes. It works with a Java API called POI.

Unsure whether the rules on this forum would call this advertising but google for "Hrmes Selenium W3QA". The framework is entirely free. W3QA is my company that promotes it.

I hope this helps.

[darked17]

This seams really hard

[Eranga]

This seams really hard

Seems what?

[darked17]

Making Java Read Excel files??? Any Tutorial

[nabhanya]

Normally, to read a data in excel, first we should have access to workbook, sheet which we want to read as workbook contains multiple sheets and if you want to read a particular cell we need location of a Cell.

You can view more details and a sample program.

[removed spammy link]