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

  Рет қаралды 27,519

SDET- QA

SDET- QA

Күн бұрын

Пікірлер: 77
@stevenclark1973
@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
@abhishekshahi1209 3 ай бұрын
Thank you so much sir. The way of explaining is absolutely amazing. Thanks a lot sir.
@chandrasekhar2969
@chandrasekhar2969 4 ай бұрын
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
@francistabora1580 6 күн бұрын
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
@KiranKumar-pm2ui 4 ай бұрын
Thank you very much for clarity explanation and kindly upload remaining videos
@sdetpavan
@sdetpavan 4 ай бұрын
Welcome
@nareshan5178
@nareshan5178 4 ай бұрын
Yes, it’s very clear. Thank you
@sdetpavan
@sdetpavan 4 ай бұрын
Welcome
@akeemolalere7915
@akeemolalere7915 3 ай бұрын
Finished the assignment....Thank you sir
@priyankakanumuri7459
@priyankakanumuri7459 3 ай бұрын
can you share me utility file
@srprohit1349
@srprohit1349 3 ай бұрын
Can you share the assignment bro
@akeemolalere7915
@akeemolalere7915 3 ай бұрын
@@srprohit1349 finished the assignment I could share it to you if you dont mind
@shubhamlavekar6886
@shubhamlavekar6886 2 ай бұрын
bro please share code pleaee?
@anjalianjali646
@anjalianjali646 4 ай бұрын
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
@Hariharasudhan0303 4 ай бұрын
softsuave in porur?
@anjalianjali646
@anjalianjali646 4 ай бұрын
@@Hariharasudhan0303 Bangalore Gayatri tech park!
@fariahasan3965
@fariahasan3965 4 ай бұрын
How was Your interview?
@anjalianjali646
@anjalianjali646 4 ай бұрын
@@fariahasan3965 core java + Selenium + TestNG+ Cucumber
@anjalianjali646
@anjalianjali646 4 ай бұрын
@@fariahasan3965 core java + Selenium + TestNG + Cucumber
@MS-dg9li
@MS-dg9li 4 ай бұрын
Very very helpful sir..
@sdetpavan
@sdetpavan 4 ай бұрын
Thanks
@suriyapraba-vw2cn
@suriyapraba-vw2cn 4 ай бұрын
Thanks sir God bless you 🎉
@sdetpavan
@sdetpavan 4 ай бұрын
Welcome
@matinshaikh6102
@matinshaikh6102 2 ай бұрын
The excel code you have written in Utility, How we can access?
@Shinelikeastar-is7yy
@Shinelikeastar-is7yy 2 ай бұрын
Hello sir… how to handle that push notification coming after launching browser (url) Thanks
@Aayaan-y2s
@Aayaan-y2s 20 күн бұрын
Hello Pavan Sir, Please share the utilities code. Without that we can not practice.
@vanajaseshadri5529
@vanajaseshadri5529 4 ай бұрын
Thank you so much sir..
@sdetpavan
@sdetpavan 4 ай бұрын
Most welcome
@ranjithv133
@ranjithv133 4 ай бұрын
Thank you sir and team.
@sdetpavan
@sdetpavan 4 ай бұрын
Welcome
@sayedraheman8529
@sayedraheman8529 23 күн бұрын
Sr..which video number is about frame work..like cocumber😊😊
@proudmodi
@proudmodi 4 ай бұрын
Good evening sir
@MS-dg9li
@MS-dg9li 4 ай бұрын
Sir.. test case likhne k liye best way for beginners... Facing lot of issues.. Please help me
@yuvrajbhamare9021
@yuvrajbhamare9021 4 ай бұрын
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
@cuddletheshihtzu 4 ай бұрын
Sir will BDD and maven, cucumber, jenkins also be covered in next videos ?
@akshaykathole6802
@akshaykathole6802 4 ай бұрын
Good Evening Sir.
@parthasarathipradhan3420
@parthasarathipradhan3420 3 ай бұрын
sir, where i find utility class
@harikrishna-km2cp
@harikrishna-km2cp 2 ай бұрын
Hi Pavan sir, please provide the link of sbi url too
@crazyviralteam5796
@crazyviralteam5796 4 ай бұрын
is it completed or some part is pending?
@manjulacn3289
@manjulacn3289 4 ай бұрын
Good evening sir😊😊
@SanjeetKumar-xq5lm
@SanjeetKumar-xq5lm Ай бұрын
from where i got the excel utils file
@PratikNaidu
@PratikNaidu 4 ай бұрын
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
@akeemolalere7915 3 ай бұрын
I can help you out
@PratikNaidu
@PratikNaidu 3 ай бұрын
@@akeemolalere7915 please do help me.please give me the solution
@srprohit1349
@srprohit1349 3 ай бұрын
​@@akeemolalere7915can you help me now....
@srprohit1349
@srprohit1349 3 ай бұрын
​@@akeemolalere7915 bro can you help me
@purnimasadanala9344
@purnimasadanala9344 4 ай бұрын
hi sir can we get live classes
@chandrasekhar2969
@chandrasekhar2969 4 ай бұрын
Give me your valuable feedback.
@dileepkumar-zr8co
@dileepkumar-zr8co 4 ай бұрын
Hello I didn't found 1 to 40 session for selenium which is recently uploaded
@dilipkumarp7396
@dilipkumarp7396 4 ай бұрын
check the play list bro
@watchit9964
@watchit9964 4 ай бұрын
Please upload the remaining videos
@rishavraj1142
@rishavraj1142 2 ай бұрын
Please provide the excel utility file sir ,I already explored your github but unable to find there.
@harshalchaudhari7065
@harshalchaudhari7065 2 ай бұрын
Hi can you please provide the link for sir's github?
@Aruna123QA
@Aruna123QA 2 ай бұрын
Anyone know's where to find solutions for assignments?
@mohdafzal8208
@mohdafzal8208 2 ай бұрын
Sir please tell me where to find assignment solutions and utility files...
@mitrabhanuprusty1948
@mitrabhanuprusty1948 29 күн бұрын
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
@sridharj3285 4 ай бұрын
👍
@KiranKumar-pm2ui
@KiranKumar-pm2ui 4 ай бұрын
Kindly upload remaining videos
@rishavraj1142
@rishavraj1142 2 ай бұрын
how can i get these excel utility file
@chikudi1170
@chikudi1170 4 ай бұрын
Sir when to start Python automation batch..... Pls reply
@ram-b2z
@ram-b2z 3 ай бұрын
Sir, How to get utility files?
@mitrabhanuprusty1948
@mitrabhanuprusty1948 29 күн бұрын
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
@raghu9997 4 ай бұрын
Sir still how many sessions left to complete full course
@ECE-KAVYAV
@ECE-KAVYAV 4 ай бұрын
Same doubt
@Sandeepsunny-z7y
@Sandeepsunny-z7y 4 ай бұрын
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
@raghu9997 4 ай бұрын
@@Sandeepsunny-z7y yeah
@ram-b2z
@ram-b2z 3 ай бұрын
Anyone? knows where will i get those utility files?
@kamephile
@kamephile Ай бұрын
No where bro You have make at your own😂
@ram-b2z
@ram-b2z 3 ай бұрын
Sir, How to get those utility files...anyone?
@mitrabhanuprusty1948
@mitrabhanuprusty1948 29 күн бұрын
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
@kamephile Ай бұрын
At 1:20:01 Black has filled in Result column Anyone can help
@fariahasan3965
@fariahasan3965 4 ай бұрын
Next video please
@ABHI-bi8fe
@ABHI-bi8fe 4 ай бұрын
Sir inka enni topics migili unai
@praveenraj-sk6sq
@praveenraj-sk6sq 4 ай бұрын
Hi sir,
@zelalemgetachew2374
@zelalemgetachew2374 Ай бұрын
Code in git
@Bashashaik-gb5lq
@Bashashaik-gb5lq 4 ай бұрын
Sir aa selenium apesi.. framework ki randi sir
兔子姐姐最终逃走了吗?#小丑#兔子警官#家庭
00:58
小蚂蚁和小宇宙
Рет қаралды 14 МЛН
😜 #aminkavitaminka #aminokka #аминкавитаминка
00:14
Аминка Витаминка
Рет қаралды 2,3 МЛН
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18
How to Read Excel File in Java using Apache POI | Data Driven Testing in Selenium
28:47
SDET Adda For QA Automation
Рет қаралды 1,4 М.
Data Driven Testing in Selenium | Framework For Automation
16:13
SoftwaretestingbyMKT
Рет қаралды 3,2 М.
SDET | QA Automation Mock Interview - 5+ Years of Experience
1:55:33
Naveen AutomationLabs
Рет қаралды 225 М.
Top 5 Software Testing Trends of 2024 ⚡️
10:15
Execute Automation
Рет қаралды 25 М.
兔子姐姐最终逃走了吗?#小丑#兔子警官#家庭
00:58
小蚂蚁和小宇宙
Рет қаралды 14 МЛН