Code import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.util.ArrayList; import java.util.Iterator; import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.util.NumberToTextConverter; import org.apache.poi.xssf.usermodel.XSSFWo

Now lets create a class file, for assessing the data in the excel using the Apache poi classes and methods. Code import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.usermodel.X

Now we will access the cell in a rows and column to control our Data driven tests Code import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.util.Iterator; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.ss.usermodel.

Apache POI is an open source API while allows us to work with MS office document via Java programs. It contains classes and methods to decode the user input data or a file into MS Office documents.This is one of the best way to use data driven testcases for legacy testing. Commonly used components