Selenium with Excelsheet

Hi,

I want to learn and work on excelsheet (A-POI), and I do not have experience or knowledge in working with excelsheet.

So could you please let me know which all are the good site to learn from basic.

Which excel you prefer for automation – JXL or POI and want to prefer for me also?.

Thanks..

Doctor Asked on September 13, 2014 in Selenium WebDriver.
Add Comment
  • 2 Answer(s)

    Hi Rocky

    I Would Suggest you to go With Apache Poi
    Generally We have a Hierachy in Poi

    WorkBook—>Sheet—>Row—>Cell

    http://www.toolsqa.com/selenium-webdriver/data-driven-testing-excel-poi/
    Here is The Implementation of Poi
    Still if You Feel any Problem , Post your Query Here

    thanks
    ankit

    Vice Professor Answered on September 14, 2014.

    Hi Ankit,

    Above link is good when you know something or knowledge on excelsheet. But I don’t have knowledge also. So I want to go with basics first then I want to work on above link.

    So please suggest which site is the best for this (Basic knowledge).

    on September 14, 2014.
    Add Comment

    Hi rocky,

    Apache POI is suggestible then JXL because JXL supports only office 2007 excel sheet (.xls) where as POI supports both office 2007 and 2010 Excel formats (.xls and .xlsx)

    use XSSF class’s in POI to use workbook, sheet, row and column

    i suggest you to look at the following websites all are very good –

    Train Answered on September 15, 2014.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.