Selenium Framework Tutorial #11 - Read Excel File in Selenium with Apache POI - Part 2

[@snehaingalkar491]

I was waiting for videos. Thanks a lot for such informative videos.

[@phanikiran9826]

best apache poi tutorial.

[@KrisuParikh]

thank you

[@stylishmanurana]

Very helpful video.... Great work!!

[@bhagyasrikothamasu8572]

Nice explanation sir. thank you

[@krishnavamankrishna3047]

if in Excel we used a formula for calculation then formateCellValue can display in the console that formula instead of value any alternative solution is there

[@rmahideep]

Thanks Sir !!

[@softwaretestingmentor]

Most welcome. Keep watching for more videos!

[@ashish_dewal4245]

Can you please help me i am getting the error "Cannot invoke "org.apache.poi.ss.usermodel.Sheet.getLastRowNum()" because "sheetName" is null"

[@deepakchopra2145]

check your sheet name spelling and you have entered data in correct sheet , you will see sheet name in bottom left side.

[@deepakchopra2145]

it will be sheet1 you can rename as you want

[@monil.joshi4]

How to read excel file present on one drive in selenium java

[@AjaySingh-oe6zb]

It is giving error - "You need to specify at least one testng.xml, one class or one method"

[@AjaySingh-oe6zb]

now when i run it as java application, it is resolved but now the error coming is - Exception in thread "main" java.lang.NullPointerException: Cannot invoke "org.apache.poi.ss.usermodel.Sheet.getLastRowNum()" because "sheetName" is null

[@mvtvvlogs5405]

getting this error: have tried everything not able to resolve: Please help: java: cannot access org.apache.poi.poifs.filesystem.NPOIFSFileSystem class file for org.apache.poi.poifs.filesystem.NPOIFSFileSystem not found

[@TheCoolparas]

package utilities; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import org.apache.poi.EncryptedDocumentException; import org.apache.poi.ss.usermodel.DataFormatter; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class ReadXLSdata { public static void main(String[] args) throws EncryptedDocumentException, IOException { ReadXLSdata red = new ReadXLSdata(); red.getdata("login"); } public String[][] getdata(String excelSheetName) throws EncryptedDocumentException, IOException { File f = new File(System.getProperty("user.dir") + "\\src\\test\ esources\\testdata\\testdata.xlsx"); FileInputStream fis = new FileInputStream(f); Workbook wb = WorkbookFactory.create(fis); Sheet sheetName = wb.getSheet(excelSheetName); int totalRows = sheetName.getLastRowNum(); // FOR ROW COUNT System.out.println(totalRows); Row rowCells = sheetName.getRow(0); // FOR COULMNS COUNT int totalCols = rowCells.getLastCellNum(); System.out.println(totalCols); DataFormatter format = new DataFormatter(); String testData[][] = new String[totalRows][totalCols]; for (int i = 1; i