Results 1 to 7 of 7
  1. #1
    chetan-24 is offline Member
    Join Date
    Mar 2009
    Posts
    1
    Rep Power
    0

    Thumbs down How to read Excel file with java

    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!

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    20

    Default

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

  3. #3
    Threddy is offline Member
    Join Date
    Apr 2009
    Posts
    1
    Rep Power
    0

    Default

    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.

  4. #4
    darked17 is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default

    This seams really hard

  5. #5
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    20

  6. #6
    darked17 is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default

    Making Java Read Excel files??? Any Tutorial

  7. #7
    nabhanya is offline Banned
    Join Date
    Sep 2014
    Posts
    2
    Rep Power
    0

    Default Re: How to read Excel file with java

    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]
    Last edited by DarrylBurke; 09-13-2014 at 01:53 PM.

Similar Threads

  1. writing to a excel file from java program
    By priyankabhar in forum New To Java
    Replies: 15
    Last Post: 01-17-2014, 12:39 PM
  2. JXL read excel documents
    By ironicending in forum Java Applets
    Replies: 1
    Last Post: 09-08-2010, 12:42 AM
  3. Replies: 1
    Last Post: 10-10-2008, 08:47 AM
  4. How to read data from excel and store it in db
    By saran123 in forum New To Java
    Replies: 5
    Last Post: 10-03-2008, 10:19 AM
  5. How to read a text file from a Java Archive File
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-08-2008, 09:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •