How to read and write data in excel using selenium web driver with java

Read Data from excel in Java. public static XSSFSheet readExcel(String Path, String SheetName) { try { System.out.println(Path); // Open the Excel file FileInputStream ExcelFile = new FileInputStream(Path); // Access the required test data sheet ExcelWBook = new XSSFWorkbook(ExcelFile); ExcelWSheet = ExcelWBook.getSheet(SheetName); } catch (Exception e) { System.out.println(e); } return ExcelWSheet; } How to read data from excel in selenium web driver with java. To call the above method: XSSFSheet excelSheet = TestListener.readExcel("DataFiles\\testData.xlsx",

How to disable notification in chrome browser using selenium web driver with java

To perform automation with chrome browser’s tools selenium provide the ChromeOptions class in selenium lib. A class which contains the method to perform the operation like Proxy setting in the browser, enable popup, disable notification etc. How to disable notification in selenium web driver with java. The key point of the task. Create a object of

How to perform right click operation in selenium web driver using java

KeyPoints for the task  Create an object of Actions class. Actions action = new Actions(driver); Call the method to perform an action. action.contextClick(“Name of the element”).perform(); Task Scenario:  Open browser. Load the URL “http://www.seleniumeasy.com/test/”. Right click on the logo of the home page. Automate mouse events (Right click) in selenium web driver with an example.   import org.openqa.selenium.By;

How to automate drag and drop event in selenium web driver using java

To perform drag and drop operation in selenium. We need to user Actions class and its method. Key Points for the task Create an object of Actions class. action.dragAndDrop(dragElement, dropElement).build().perform(); Call the method to perform an action. action.dragAndDrop(dragElement, dropElement).build().perform(); Automate drag and drop event in selenium web driver with an example. Task scenario:  Open browser.

How to perform mouseover events in selenium web driver using java

Testcase scenario to Automate mouseover event in selenium web driver Open URL “codebun.com”. Perform mouseover operation on “Automation” in the menu. Click on selenium web driver submenu under the menu tab. Action class in selenium web driver with an example. package testCases; import org.openqa.selenium.By; import org.openqa.selenium.WebDriver; import org.openqa.selenium.WebElement; import org.openqa.selenium.chrome.ChromeDriver; import org.openqa.selenium.interactions.Actions; import org.openqa.selenium.support.ui.ExpectedConditions; import org.openqa.selenium.support.ui.WebDriverWait; public class ActionClassExamples { public static WebDriver driver; /* * ................Task description............... URL=

Operating system multiple question and answer

In mainframe system,the block of data is called as __________. None of the mentioned options (answer) Record Note Both the mentioned options _________ command in UNIX can be used to display or create a new file. mv cat (answer) cp vi A ___________ is a collection of  logically related data, stored in DASD. Filesets Recordsets

How to automate login form using multiple users in selenium web driver in java.

Automate login form using multiple users in selenium web driver Task. Data-driven automation using selenium web driver. Here is the automation example using selenium web driver where we are going to automate login form using 100 users in selenium web driver in java. Task description is given below. Selenium web driver Task Description: Need to