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 in Selenium by Raj

edited May 8 15 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by Abha
• 5,440 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 in Selenium by Anvi
• 5,680 points
16 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
48 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 8 in Selenium by Pratibha
• 2,520 points
22 views
+1 vote
1 answer

What is locators used for in selenium?

Locator are used to find and match ...READ MORE

answered Dec 18, 2018 in Selenium by Nabarupa
21 views
0 votes
1 answer

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,030 points
51 views
0 votes
1 answer
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,130 points
411 views
0 votes
1 answer

How to use such xpath to find web elements

It's much simpler to use: #MyDiv123 > div.super or ...READ MORE

answered Jun 14, 2018 in Selenium by Samarpit
• 5,130 points
40 views
0 votes
1 answer
0 votes
1 answer

What are locators in Selenium and what are the different types of it?

Hi Divya, in Selenium Locators define an ...READ MORE

answered May 7 in Selenium by Abha
• 5,440 points
17 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.