What is Apache POI in Selenium and what it is used for

0 votes
I want to know what is Apache POI and what it is used for in Selenium?
May 8, 2019 in Selenium by Raj

edited May 8, 2019 2,822 views

1 answer to this question.

0 votes

Hi Raj, Apache POI is the most commonly used API for Selenium data driven tests. POI is a set of library files that gives an API to manipulate Microsoft documents like .xls and .xlsx. It is used to create, modify, read and write data into Excel. In POI, Workbook is a common interface for HSSF, XSSF and SXSSF; where HSSF (Horrible Spread Sheet Format) implements Excel ’97 (.xls) file format and XSSF (XML Spread Sheet Format) implements Excel 2007 (.xlsx) file format. SXSSF is the streaming extension for XSSF which was introduced later in Apache POI 3.8. Syntax for using POI in selenium webdriver is:

Workbook wb = new HSSFWorkbook();

Apache POI Jar files can be downloaded from here: https://poi.apache.org/download.html

answered May 8, 2019 by Abha
• 28,140 points

Related Questions In Selenium

0 votes
1 answer

What is POM in Selenium and what it is used for?

Hello Rubina, POM is Page Object Model which ...READ MORE

answered May 12, 2019 in Selenium by Anvi
• 14,150 points
1,529 views
0 votes
1 answer

What is TestNG and why it is used in selenium?

Hello @User, Talking about TestNG, it is an ...READ MORE

answered Dec 24, 2018 in Selenium by Shuvodip
1,102 views
0 votes
1 answer

What is Robot Class in selenium webdriver and why it is used?

Hello Akanksha, Robot Class is used for those ...READ MORE

answered May 9, 2019 in Selenium by Pratibha
• 3,690 points
1,817 views
0 votes
1 answer

What is IWebElement and how it is used in Selenium C#?

Hello Paul, IWebElement is an Interface in ...READ MORE

answered Jun 11, 2019 in Selenium by Esha
11,059 views
0 votes
2 answers

Finding WebDriver element with Class Name in java

The better way to handle this element ...READ MORE

answered Apr 10, 2018 in Selenium by nsv999
• 5,500 points
12,617 views
0 votes
2 answers

Problem while using InternetExplorerDriver in Selenium WebDriver

enable trusted connection  in internet explorer by ...READ MORE

answered Aug 31, 2020 in Selenium by Sri
• 3,190 points
8,572 views
0 votes
1 answer

Geo-location microphone camera pop up

To Allow or Block the notification, access using Selenium and you have to ...READ MORE

answered May 11, 2018 in Selenium by Samarpit
• 5,910 points
6,629 views
0 votes
2 answers

How to use such xpath to find web elements

xpath are two types. 1) Absolute XPath:    /html/b ...READ MORE

answered Sep 3, 2020 in Selenium by Sri
• 3,190 points
7,519 views
0 votes
1 answer

What is a Modular Framework and why it is useful in Selenium webdriver?

Hi Junaid, as the name suggests, Modular ...READ MORE

answered May 13, 2019 in Selenium by Abha
• 28,140 points
12,457 views
0 votes
1 answer

What is error collector in JUnit and why it is used?

Hey Ekanshi, Error collector collects all error objects ...READ MORE

answered Jun 19, 2019 in Selenium by anonymous
• 28,140 points
1,414 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP