Apache POI - Reading excel data row by row
Program to read Excel data & store it in Array List - Each row as an object containing column data in the form of Strings //Function to read Excel Data - Row by Row public void getTest() throws CustomException { // array list to read each row's data as one record - i.e each test steps is stored as one record ArrayList<Object> excelData = new ArrayList<>(); //store each row data as an object XSSFSheet sheet = getExcelReader().getSheet("Functions"); for (Row row : sheet) { // each column data in the row[Test step] is read to list List<String> data = null; data = new ArrayList<>(); for (Cell cell : row) { data.add(cell.getStringCellValue()); //each column value in the row is read one after the other & copied to array list } //once complete row data - all the columns are copied to an array list // Now this list is treated as a list object & added to one more arr...