Session 41 - Selenium with Java | Data Driven Testing with MS-Excel | 2024 New Series

[@stevenclark1973]

This is brilliant. I'm amazed that you don't try run the script in each section as you have the confidence that it will work when you have finished coding. Really good. 👍 I tried this and it's asking me to create an account for the given website. That was the only issue I had.

[@abhishekshahi1209]

Thank you so much sir. The way of explaining is absolutely amazing. Thanks a lot sir.

[@chandrasekhar2969]

Thank you sir, I want be a full Automation test engineer in selenium with Java. This all video's ,whic you are provided is this videos enough for that.

[@francistabora1580]

You did a great video sir, thank you a lot. I have a question : Is it possible to automate Microsoft Excel Online with Selenium ? or How can I automate Microsoft Excel Online version ??

[@KiranKumar-pm2ui]

Thank you very much for clarity explanation and kindly upload remaining videos

[@sdetpavan]

Welcome

[@nareshan5178]

Yes, it’s very clear. Thank you

[@sdetpavan]

Welcome

[@akeemolalere7915]

Finished the assignment....Thank you sir

[@priyankakanumuri7459]

can you share me utility file

[@srprohit1349]

Can you share the assignment bro

[@akeemolalere7915]

@@srprohit1349 finished the assignment I could share it to you if you dont mind

[@shubhamlavekar6886]

bro please share code pleaee?

[@anjalianjali646]

Hello sir Thank you once again sir😊Today i will attend interview on softsuave technology Only iam able to answer what did u teach in last 41session iam not selected but I will done better with compared to my previous interview i hope one day i will become tester on this field with your wishing 👍thank you sir👍

[@Hariharasudhan0303]

softsuave in porur?

[@anjalianjali646]

@@Hariharasudhan0303 Bangalore Gayatri tech park!

[@fariahasan3965]

How was Your interview?

[@anjalianjali646]

@@fariahasan3965 core java + Selenium + TestNG+ Cucumber

[@anjalianjali646]

@@fariahasan3965 core java + Selenium + TestNG + Cucumber

[@MS-dg9li]

Very very helpful sir..

[@sdetpavan]

Thanks

[@suriyapraba-vw2cn]

Thanks sir God bless you 🎉

[@sdetpavan]

Welcome

[@matinshaikh6102]

The excel code you have written in Utility, How we can access?

[@Shinelikeastar-is7yy]

Hello sir… how to handle that push notification coming after launching browser (url) Thanks

[@Aayaan-y2s]

Hello Pavan Sir, Please share the utilities code. Without that we can not practice.

[@vanajaseshadri5529]

Thank you so much sir..

[@sdetpavan]

Most welcome

[@ranjithv133]

Thank you sir and team.

[@sdetpavan]

Welcome

[@sayedraheman8529]

Sr..which video number is about frame work..like cocumber😊😊

[@proudmodi]

Good evening sir

[@MS-dg9li]

Sir.. test case likhne k liye best way for beginners... Facing lot of issues.. Please help me

[@yuvrajbhamare9021]

Hello sir,I realy love your style of teaching,lot of respect But always 1 question disturbs that,will AI or codeless automation tools replace selenium?please answer this sir.

[@cuddletheshihtzu]

Sir will BDD and maven, cucumber, jenkins also be covered in next videos ?

[@akshaykathole6802]

Good Evening Sir.

[@parthasarathipradhan3420]

sir, where i find utility class

[@harikrishna-km2cp]

Hi Pavan sir, please provide the link of sbi url too

[@crazyviralteam5796]

is it completed or some part is pending?

[@manjulacn3289]

Good evening sir😊😊

[@SanjeetKumar-xq5lm]

from where i got the excel utils file

[@PratikNaidu]

Hello Sir, Session 41 Data Driven Testing with MS-Excel, In that I am getting an error of "java.lang.NoSuchMethodError: 'java.io.File org.openqa.selenium.internal.Require$FileStateChecker.isExecutable()" while executing program. I have written every single step as per video its throwing an error. Please Reply as soon as possible.

[@akeemolalere7915]

I can help you out

[@PratikNaidu]

@@akeemolalere7915 please do help me.please give me the solution

[@srprohit1349]

​@@akeemolalere7915can you help me now....

[@srprohit1349]

​@@akeemolalere7915 bro can you help me

[@purnimasadanala9344]

hi sir can we get live classes

[@chandrasekhar2969]

Give me your valuable feedback.

[@dileepkumar-zr8co]

Hello I didn't found 1 to 40 session for selenium which is recently uploaded

[@dilipkumarp7396]

check the play list bro

[@watchit9964]

Please upload the remaining videos

[@rishavraj1142]

Please provide the excel utility file sir ,I already explored your github but unable to find there.

[@harshalchaudhari7065]

Hi can you please provide the link for sir's github?

[@Aruna123QA]

Anyone know's where to find solutions for assignments?

[@mohdafzal8208]

Sir please tell me where to find assignment solutions and utility files...

[@mitrabhanuprusty1948]

package excel; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.DataFormatter; import org.apache.poi.ss.usermodel.FillPatternType; import org.apache.poi.ss.usermodel.IndexedColors; 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 ExcelUtils { public static FileInputStream fis; public static FileOutputStream fos; public static XSSFWorkbook wb; public static XSSFSheet ws; public static XSSFRow row; public static XSSFCell cell; public static CellStyle style; public static int getRowCount(String xlfile, String xlsheet) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); int rowCount = ws.getLastRowNum(); wb.close(); fis.close(); return rowCount; } public static int getCellCount(String xlfile, String xlsheet, int rowNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); int cellCount = row.getLastCellNum(); wb.close(); fis.close(); return cellCount; } public static String getCellData(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); String data; try { // data=cell.toString(); DataFormatter formatter = new DataFormatter(); data = formatter.formatCellValue(cell);// Returns the formatted value of cell as a string } catch (Exception e) { data = ""; } wb.close(); fis.close(); return data; } public static void setCellData(String xlfile, String xlsheet, int rowNum, int colNum, String Data) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); cell = row.getCell(colNum); cell.setCellValue(Data); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillGreenColor(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.GREEN.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillRedColor(String xlfile, String xlsheet, int rownum, int column) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rownum); cell = row.getCell(column); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.RED.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } }

[@sridharj3285]

👍

[@KiranKumar-pm2ui]

Kindly upload remaining videos

[@rishavraj1142]

how can i get these excel utility file

[@chikudi1170]

Sir when to start Python automation batch..... Pls reply

[@ram-b2z]

Sir, How to get utility files?

[@mitrabhanuprusty1948]

package excel; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.DataFormatter; import org.apache.poi.ss.usermodel.FillPatternType; import org.apache.poi.ss.usermodel.IndexedColors; 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 ExcelUtils { public static FileInputStream fis; public static FileOutputStream fos; public static XSSFWorkbook wb; public static XSSFSheet ws; public static XSSFRow row; public static XSSFCell cell; public static CellStyle style; public static int getRowCount(String xlfile, String xlsheet) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); int rowCount = ws.getLastRowNum(); wb.close(); fis.close(); return rowCount; } public static int getCellCount(String xlfile, String xlsheet, int rowNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); int cellCount = row.getLastCellNum(); wb.close(); fis.close(); return cellCount; } public static String getCellData(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); String data; try { // data=cell.toString(); DataFormatter formatter = new DataFormatter(); data = formatter.formatCellValue(cell);// Returns the formatted value of cell as a string } catch (Exception e) { data = ""; } wb.close(); fis.close(); return data; } public static void setCellData(String xlfile, String xlsheet, int rowNum, int colNum, String Data) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); cell = row.getCell(colNum); cell.setCellValue(Data); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillGreenColor(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.GREEN.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillRedColor(String xlfile, String xlsheet, int rownum, int column) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rownum); cell = row.getCell(column); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.RED.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } }

[@raghu9997]

Sir still how many sessions left to complete full course

[@ECE-KAVYAV]

Same doubt

[@Sandeepsunny-z7y]

please be patience bro. sir is giving full and clear information. it will take time but no other you tuber giving this much of knowledge

[@raghu9997]

@@Sandeepsunny-z7y yeah

[@ram-b2z]

Anyone? knows where will i get those utility files?

[@kamephile]

No where bro You have make at your own😂

[@ram-b2z]

Sir, How to get those utility files...anyone?

[@mitrabhanuprusty1948]

package excel; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.DataFormatter; import org.apache.poi.ss.usermodel.FillPatternType; import org.apache.poi.ss.usermodel.IndexedColors; 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 ExcelUtils { public static FileInputStream fis; public static FileOutputStream fos; public static XSSFWorkbook wb; public static XSSFSheet ws; public static XSSFRow row; public static XSSFCell cell; public static CellStyle style; public static int getRowCount(String xlfile, String xlsheet) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); int rowCount = ws.getLastRowNum(); wb.close(); fis.close(); return rowCount; } public static int getCellCount(String xlfile, String xlsheet, int rowNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); int cellCount = row.getLastCellNum(); wb.close(); fis.close(); return cellCount; } public static String getCellData(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); String data; try { // data=cell.toString(); DataFormatter formatter = new DataFormatter(); data = formatter.formatCellValue(cell);// Returns the formatted value of cell as a string } catch (Exception e) { data = ""; } wb.close(); fis.close(); return data; } public static void setCellData(String xlfile, String xlsheet, int rowNum, int colNum, String Data) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); cell = row.getCell(colNum); cell.setCellValue(Data); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillGreenColor(String xlfile, String xlsheet, int rowNum, int colNum) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rowNum); cell = row.getCell(colNum); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.GREEN.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } public static void fillRedColor(String xlfile, String xlsheet, int rownum, int column) throws IOException { fis = new FileInputStream(xlfile); wb = new XSSFWorkbook(fis); ws = wb.getSheet(xlsheet); row = ws.getRow(rownum); cell = row.getCell(column); style = wb.createCellStyle(); style.setFillForegroundColor(IndexedColors.RED.getIndex()); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); cell.setCellStyle(style); fos = new FileOutputStream(xlfile); wb.write(fos); wb.close(); fis.close(); fos.close(); } }

[@kamephile]

At 1:20:01 Black has filled in Result column Anyone can help

[@fariahasan3965]

Next video please

[@ABHI-bi8fe]

Sir inka enni topics migili unai

[@praveenraj-sk6sq]

Hi sir,

[@zelalemgetachew2374]

Code in git

[@Bashashaik-gb5lq]

Sir aa selenium apesi.. framework ki randi sir