Session 51: Selenium with Java | Hybrid Framework | Data Driven Tests | Apache POI | 2024 Series

[@shafaquebushra1787]

Thank you so much sir.
I started watching your videos a couple of months ago. I watched manual testing, Api testing and selenium and learned all the concepts.
I have given an interview, and it went very well.
You are putting great effort.
God bless you sir.
Thanks for your amazing videos.
You are delivering knowledge from basic to advanced.
Seriously, you are the best teacher. 😊
Thank you so much sir. 🙏

[@stevenclark1973]

Another brilliant video. Well tutored again. The problem I'm having is remembering all the concepts/syntax over the last 50 sessions.

[@malikbilalawan89]

practice practice

[@numeshialmapiyasiri]

Sir, thank you very much for uploading this video. We've been eagerly waiting for it! Your sessions are truly amazing, and we're already looking forward to the next ones. We're absolutely addicted to these sessions-can't wait for more

[@rameshrongala922]

Thank you sir.

[@sdetpavan]

Welcome

[@rajeshbe2234]

Sir please upload the next video a bit earlier.
I'm going to join as a automation Tester at one reputed company so by learning this framework series i planned to implement this framework in my project that's why I'm requesting.

[@TheNivrutti]

Pavan sir plz tell from where to get all the project related files

[@kushi_datta]

thank you sir,please upload next videos also it's very useful and need to us now🙂🥺🙏👏

[@manichowdry547]

🔥🔥🔥🔥🔥

[@TheNivrutti]

Pavan sir how to get framework resources. In videos you told that i will share.
Where to find all stuff of this project

[@rajeshbe2234]

Hi Pawan Sir thank you very much sir for uploading this video we most awaited for this 🙏🙏🙏🙏

[@sushmitar3105]

Where I can find the Utility file contents? Iam executing in my system so

[@keerthirao8241]

pavan sir your teaching awesome....can u please share the excel utility file sir 🙏🙏🙏

[@AVUPATINARENDRA-lc6zg]

have you got the excel file?

[@SamuelSalvi-y4r]

You can buy his course on udemy and there in resources section you will get all files required

[@keerthirao8241]

@@AVUPATINARENDRA-lc6zg pavan sir shared github link in Session 56 as a pinned comment

[@sreekanthdamisetty-d4o]

Sir...can you please provide link for excel utility class

[@AVUPATINARENDRA-lc6zg]

have you got excel file?

[@sujithkumarakambaram7047]

Have you got excel file?

[@rajeshbe2234]

Sir, In this data-driven testing how we add pass fail text at run time in the same test data Excel sheet? And also override the results for multiple time executions.
If we do like that we won't get confused at the results verification. So please consider my request.

[@thirdviews]

Can you please provide any git link for ExcelUtility class. Specially for those people who is paying monthly.

[@AVUPATINARENDRA-lc6zg]

have you got excel file?

[@BaduguSaiNirmala]

Sir, Can you please share Excel utility file

[@bhaskargve855]

Sir, can I get the project zip file and the documentation please?

[@QAteam-w1e]

How many Sessions remaining in this entire Course??

[@pawanbokolia4013]

Hi sir i have an issue that negative test are getting failed select them in invalid data it should pass but i don't know why they are failing

[@AmitKumar-yy3lq]

Thanks sir

[@School_Of_Thought-pe6hm]

Where can we get the utilities file to copy sir

[@Butterfly_World12345]

package com.excel.utility;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Excelutility
{
public FileInputStream fi;
public FileOutputStream fo;
public XSSFWorkbook workbook;
public XSSFSheet sheet;
public XSSFRow row;
public XSSFCell cell;
public CellStyle style;
String path;
public Excelutility (String path)
{
this.path=path;
}
public int getRowCount(String sheetName) throws IOException
{
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
int rowcount=sheet.getLastRowNum();
workbook.close();
fi.close();
return rowcount;
}
public int getCellCount(String sheetName, int rownum) throws IOException {
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
row=sheet.getRow(rownum);
int cellcount=row.getLastCellNum();
workbook.close();
fi.close();
return cellcount;
}
public String getCellData(String sheetName, int rownum, int colnum) throws IOException
{
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
row=sheet.getRow(rownum);
cell=row.getCell(colnum);
DataFormatter formatter = new DataFormatter();
String data;
try
{
data = formatter.formatCellValue(cell);
}
catch(Exception e)
{
data="";
}
workbook.close();
fi.close();
return data;
}
public void setCellData(String sheetName, int rownum, int colnum, String data) throws IOException
{
File xlfile=new File(path);
if(!xlfile.exists()) // If file not exists then create new file
{
workbook=new XSSFWorkbook();
}
fo=new FileOutputStream(path);
workbook.write(fo);
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
if(workbook.getSheetIndex(sheetName)==-1) // If sheet not exists then create new Sheet workbook.createSheet(sheetName);
sheet=workbook.getSheet(sheetName);
if(sheet.getRow(rownum)==null) // If row not exists then create new Row sheet.createRow(rownum);
row=sheet.getRow(rownum);
cell=row.createCell(colnum);
cell.setCellValue(data);
fo=new FileOutputStream(path);
workbook.write(fo);
workbook.close();
fi.close();
fo.close();
}
}

[@AvishekPaulOnline]

@@Butterfly_World12345 Thanks! Where did you get this from? Are the codes in this series uploaded somewhere?

[@TheNivrutti]

Sir plz give me framework related all file's, application test cases, frs srs,

[@niteshojha3702]

Sir doing all the steps same as you did but getting "Data provider mismatch" error

[@AVUPATINARENDRA-lc6zg]

Hi Sir, Please provide ExcelUtility File .. i just want to import into my project

[@sreekanthdamisetty-d4o]

please provide any git link for Excel Utility class or someone please drop the Excel-utility file code here🙏

[@AVUPATINARENDRA-lc6zg]

have you got excel file?

[@Fatma-ho5ol]

Thank you for valuable information, bless you but any chance to add your notes documents and excel utilities somewhere

[@AVUPATINARENDRA-lc6zg]

have you got excel file?

[@bhaveshkarnewar719]

someone please drop the Excel-utility file code here.

[@Butterfly_World12345]

package com.excel.utility;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Excelutility
{
public FileInputStream fi;
public FileOutputStream fo;
public XSSFWorkbook workbook;
public XSSFSheet sheet;
public XSSFRow row;
public XSSFCell cell;
public CellStyle style;
String path;
public Excelutility (String path)
{
this.path=path;
}
public int getRowCount(String sheetName) throws IOException
{
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
int rowcount=sheet.getLastRowNum();
workbook.close();
fi.close();
return rowcount;
}
public int getCellCount(String sheetName, int rownum) throws IOException {
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
row=sheet.getRow(rownum);
int cellcount=row.getLastCellNum();
workbook.close();
fi.close();
return cellcount;
}
public String getCellData(String sheetName, int rownum, int colnum) throws IOException
{
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
sheet=workbook.getSheet(sheetName);
row=sheet.getRow(rownum);
cell=row.getCell(colnum);
DataFormatter formatter = new DataFormatter();
String data;
try
{
data = formatter.formatCellValue(cell);
}
catch(Exception e)
{
data="";
}
workbook.close();
fi.close();
return data;
}
public void setCellData(String sheetName, int rownum, int colnum, String data) throws IOException
{
File xlfile=new File(path);
if(!xlfile.exists()) // If file not exists then create new file
{
workbook=new XSSFWorkbook();
}
fo=new FileOutputStream(path);
workbook.write(fo);
fi=new FileInputStream(path);
workbook=new XSSFWorkbook(fi);
if(workbook.getSheetIndex(sheetName)==-1) // If sheet not exists then create new Sheet workbook.createSheet(sheetName);
sheet=workbook.getSheet(sheetName);
if(sheet.getRow(rownum)==null) // If row not exists then create new Row sheet.createRow(rownum);
row=sheet.getRow(rownum);
cell=row.createCell(colnum);
cell.setCellValue(data);
fo=new FileOutputStream(path);
workbook.write(fo);
workbook.close();
fi.close();
fo.close();
}
}

[@bhaveshkarnewar719]

@@Butterfly_World12345 Thank you... Do you have Extent report utility file? If yes please drop here.

[@praneshrr7]

@@Butterfly_World12345 thanks

[@fariahasan3965]

Sir please provide session 50 for free..

[@rajeshbe2234]

Pay 159 per month to become a member of Pawan sir SDET QA channel.
Don't hesitate to pay because he is providing these great things at a minimum cost. If you join any institute or watch other youtube mentors for selenium automation framework you won't be able to gain depth knowledge on that that's why I am suggesting you.

[@fariahasan3965]

@@rajeshbe2234 I am from Bangladesh bro. channel membership is not available here. Otherwise I won't hesitate to pay even 1000 per month.

[@rajeshbe2234]

@@fariahasan3965 Oh I see then Pawan sir only can say any other option to help you bro.

[@fariahasan3965]

@@rajeshbe2234 he has already made these videos public.He is very kind I must say.

[@rajeshbe2234]

@@fariahasan3965 then cool bro. Yesterday I tried to open it but it didn't open so I paid.

[@pradeeppatel-yo5ce]

Can someone drop ExtentReportManager file?

[@dillikumar7074]

Hi Sir , I tried to practice this, by copying same utility files and when i try to run the DDT test , my browser is opening for first time and getting close ,without entering any username or password , and getting below error in console , could you please help on this ,what could be the possible reason ?
[Utils] [ERROR] [Error] java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFRow.getCell(int)" because "this.row" is null
at utilities.ExcelUtility.getCellData(ExcelUtility.java:64)
at utilities.DataProviders.getData(DataProviders.java:27)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)

[@BaduguSaiNirmala]

can you please share excelUtility file.