У нас вы можете посмотреть бесплатно Selenium Framework for Beginners 19 | Selenium TestNG How to get data from Excel using DataProvider или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
more about Raghav - https://automationstepbystep.com/ Today we will learn How to get data from Excel using DataProvider of TestNG REFERENCES How to use excel for getting data • Selenium Framework for Beginners 18 | How ... Today we will learn 1. How to get test data from excel 2. How to create excel data provider function 3. How to use testNG @DataProvider 4. How to refer test data from DataProvider 5. Run a sample data driven Selenium Test helpful tips Prerequisite Add excel reading libraries (Apache POI) Create functions to read data from excel Watch the video - • Selenium Framework for Beginners 18 | How ... How to get test data from excel Step 1 -Create a function to get Row Count Step 2 - Create a function to get Column Count Step 3 - Create a function to get String cell data Step 4 - Create a function to get Numerical cell data How to create Excel Data Provider function Step 1 - Create a new class ExcelDataProvider Step 2 - Create a function and create object for ExcelUtils ExcelUtils excel = new ExcelUtils(“excelpath”, “sheetname”); Step 3 - Get row and column count int rowCount = excel.getRowCount(); int colCount = excel.getColCount(); Step 4 - Run a loop to get all data in an Object Array How to use testNG @DataProvider Step 1 Create a function and provide testNG annotation @DataProvider(name = “testData”) Step 2 Call the excel data provider function with excel and sheet name Step 3 Return the data object How to get test data from excel Step 1 Create a function and provide testNG annotation @Test(dataProvider = “testData”) Step 2 In the function arguments, get input parameters equal to the parameters in the excel file Step 3 Use the values in your test #SeleniumDataDrivenFramework #SeleniumTestNGFramework #SeleniumTraining #SeleniumBeginnerTutorials PLAYLISTS SELENIUM JAVA FRAMEWORK BEGINNERS • Selenium Java Framework for Beginners KATALON STUDIO • Katalon Studio SELENIUM BEGINNERS • Selenium Beginner Tutorial SELENIUM TIPS • Selenium Tips SELENIUM PYTHON • Selenium Python SELENIUM BUILDER • Selenium Builder JAVA • Java JAVA TIPS & TRICKS • Java Tips and Tricks JENKINS • Jenkins JENKINS TIPS & TRICKS • Jenkins Tips n Tricks JMETER BEGINNER • JMeter Beginner JMETER INTERMEDIATE • Jmeter Intermediate JMETER ADVANCED • JMeter Advanced JMETER TIPS & TRICKS • JMeter Tips n Tricks SOAPUI • SoapUI POSTMAN • Postman Beginner Tutorial GIT & GITHUB • Git and GitHub DOCKER • Docker ROBOT FRAMEWORK • Robot Framework Beginner Tutorial WEB SERVICES (API) • API Web Services REDIS BEGINNER TUTORIALS • Redis Beginner Tutorials MAVEN • Maven MISC • Misc Tutorials TOOLS & TIPS • Tools and Tips QnA FRIDAY • QnA Friday SUNDAY SPECIAL • Sunday Special ALL PLAYLISTS / @raghavpal Like on FACEBOOK : / automationstepbystep Follow on TWITTER: / automationsbs Subscribe on YOUTUBE : / automationstepbystep ---------- Connect with Raghav ----------- Website - https://automationstepbystep.com/ LifeCharger - Udemy Courses - https://www.udemy.com/user/raghav-pal-3/ Facebook - / automationstepbystep Twitter - / automationsbs Youtube - / automationstepbystep Like, Subscribe & Share You can support my mission for education by sharing this knowledge and helping as many people as you can _______ ONLINE COURSES TO LEARN _______ https://automationstepbystep.com/ Never Stop Learning Raghav