Read numeric data from Excel using apache poi for Selenium Webdriver - Automation

How to read numeric data from Excel using apache poi for Selenium Webdriver

In the last post, we have already discussed how to read excel data using POI but we have missed one important point which can become the blocker for you. We can read numeric data from Excel using apache poi  for Selenium webdriver.

Our test data contains numeric data, string data, and sometimes combination as well which is totally dynamic in nature. so we need to create such library which will take care of dynamic data.

Read numeric data from Excel using apache poi

read numeric data from Excel using apache poi

Program to read numeric data from Excel using apache poi

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

import java.io.File; import java.io.FileInputStream; import java.io.IOException; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.testng.annotations.Test; public class ReadExcel { @Test public void test1() throws Throwable, IOException { // return the path of local path of project          String path=System.getProperty("user.dir");          // load workbook XSSFWorkbook wb=new XSSFWorkbook(new FileInputStream(new File(path+"/TestData/AppTestData.xlsx")));         // read numeric data int data= (int)wb.getSheetAt(0).getRow(0).getCell(1).getNumericCellValue();         // print on console System.out.println("Data from Excel is >>> "+data); } }

Few observations while reading the different set of Data

1. You need to make sure which kind of data you want to read.
2. To read String value you can call getStringCellValue() method
3.  To read Numeric value you can call getNumericCellValue() which will return double value which we can typecast into int and then we can use in our test data.

You can check below screenshot which will explain what are the different type of methods which can help us to read data.

read numeric data from Excel using apache poi

While implementing Data-driven framework you have to make sure that data which is coming from excel should be used in script effectively.

The Same concept will be applied while writing to excel as well. While passing the data to excel you can call respective methods.

Let’s see the below screenshot for more details.

In above screenshot,you can see it will ask you to pass the specific data to write in excel.

Hope above post will help you to read the numeric data from excel.

If you have any doubt then let me know in comment section.

SHARE SHARE SHARE

yash

• 
• 
• 
• 
•