How to Drag and Drop Element in Selenium

Sometime in testing, we need to do some operations with mouse and keyboard. 
Selenium web driver directly can not handle mouse and keyboard event like double click, right click, pressing key combination in keyboard.

We can handle such type of event with Actions class in selenium webdriver. We have to create object of that class and perform action which we want.

In this article, we will understand how to do drag and drop any element using selenium.

We have to use Actions class for drag and drop any element form one place to another place.There are two methods for drag and drop element in Actions class.

Method 1:

action.dragAndDrop(source, target);

Method 2:

action.dragAndDropBy(source, xOffset, yOffset);

Here, action is object of Actions class.

In first method, you have to pass two web elements. One is source element and second is target element at where you want to drop your source element.

In Second method, You have to pass only source web element. For target element you have to pass value of X coordinate and Y coordinate of target element. Value of  X coordinate and Y coordinate are Integer value.

Please add comment if you have any question.

Chrome browser maximize issue in Selenium C#

If you are using C# in selenium and chrome browser then you will face issue for maximize browser.

If you are using maximize() function then it will throw exception. If you use capability for chrome browser for maximize it then it will also not work.

You have to use AutoIT for maximize browser. It is very easy to use.

Configuration:

First of all you have to add Nuget Package 'AutoItX' into your project. Please see below screen shot.

Once you are installed AutoItX into your project then you have to add 'AutoItX3Lib.dll' into references.

You can find that .dll file from where AutoItX is installed.

One more thing and very important is you have to register that .dll first because without register that .dll you can not use.

You can register  .dll file using 'regsvr32' command from command prompt.

regsvr32 path of .dll file

Now you all set for used of AutoIt functions.You have to use AutoItX3 class for access all functionality.

I have created below function for maximize chrome browser.

public void MaximizeBrowserWindow(IWebDriver driver, String vWindowName)
        {
            try
            {
                AutoItX3 autoIT = new AutoItX3();  // Create object of AutoItX3 class

                autoIT.WinSetState(vWindowName, "", autoIT.SW_MAXIMIZE); // For Maximize browser
                
                Console.WriteLine("Browser is maximized");
            }
            catch (NoSuchWindowException E)
            {
                Console.WriteLine(E.Message);
                Console.WriteLine("Browser is not maximized");                
            }
            catch (Exception E)
            {
                Console.WriteLine(E.Message);
                Console.WriteLine("Browser is not maximized");                
            }
        }

Code Explanation:

autoIT.WinSetState(vWindowName, "", autoIT.SW_MAXIMIZE);

vWindowName : It is Browser window name.

autoIT.SW_MAXIMIZE : It is for maximize browser.

Please add comment if you have any question.

How to Read Data from Excel in Selenium C#

Read test data from any external source in selenium is very important when we are working with framework. Test data can be store in any format like excel, csv, text etc.

We have to use approach as per which language we are using in selenium. If you are using C# then you have to use below reference in your code.

using Excel = Microsoft.Office.Interop.Excel;

I have created below function for read data from Excel file. You have to provide Excel file path and sheet number of sheet from which you want to read data.

public String[,] GetDataFromExcelFile(String vXlpath, int vSheetNum)
        {

            Excel.Application vXlApp;
            Excel.Workbook vXlWorkBook;
            Excel.Worksheet vXlWorkSheet;
            Excel.Range vXlrange;

            vXlApp = new Excel.Application();            
            vXlWorkBook = vXlApp.Workbooks.Open(@vXlpath);                       
            vXlWorkSheet = vXlWorkBook.Sheets[vSheetNum];

            vXlrange = vXlWorkSheet.UsedRange;

            int vRowCnt = vXlrange.Rows.Count;
            int vColCnt = vXlrange.Columns.Count;

            String[,] vXlData = new String[vRowCnt, vColCnt];

            for (int i = 1; i <= vRowCnt; i++)
            {
                for (int j = 1; j <= vColCnt; j++)
                {
                    vXlData[i - 1, j - 1] = Convert.ToString(vXlrange.Cells[i, j].Value2);
                }
            }

            vXlWorkBook.Close(true, null, null);
            vXlApp.Quit();

            Marshal.ReleaseComObject(vXlWorkSheet);
            Marshal.ReleaseComObject(vXlWorkBook);
            Marshal.ReleaseComObject(vXlApp);

            return vXlData;
        }

Above function will give you excel sheet data in form of two dimensional string array.

Please add comment if you have any question.

How to Do Database Connection in Selenium C#

Selenium is compatible with many languages like Java, C#, Python, Perl etc. Connect with database and execute query on database is very common thing in testing. 

Basic steps for connect with database and execute query is common for all languages.

• Connect with database
• execute query
• return query result

Syntax is only difference in different languages. If you are using C# in selenium then please go for below code for database connection and execute query.

I have created one function for database connection and execute query on database. It will return query result into DataTable object.

        public DataTable GetQueryResult(String vConnectionString, String vQuery)
        {
            SqlConnection Connection;  // It is for SQL connection
            DataSet ds = new DataSet();  // it is for store query result
   
            try
            {
                Connection = new SqlConnection(vConnectionString);  // Declare SQL connection with connection string 
                Connection.Open();  // Connect to Database
                Console.WriteLine("Connection with database is done.");
    
                SqlDataAdapter adp = new SqlDataAdapter(vQuery, Connection);  // Execute query on database 

                adp.Fill(ds);  // Store query result into DataSet object   

                Connection.Close();  // Close connection 
                Connection.Dispose();   // Dispose connection             
            }
            catch (Exception E)
            {
                Console.WriteLine("Error in getting result of query.");
                Console.WriteLine(E.Message);                                
                return new DataTable();
            }
            return ds.Tables[0];
        }

Code Explanation:

Connection = new SqlConnection(vConnectionString);
Connection.Open();

It is for connect to database as per you connection string.

Connection string format:

ConnectionString = @"Data Source="Data Source"; Initial Catalog="Database name"; User ID="Username"; Password="Password";

SqlDataAdapter adp = new SqlDataAdapter(vQuery, Connection);
adp.Fill(ds);

SqlDataAdapter is used for execute query.
Fill command is used for fill query result into DataSet object.

Connection.Close();
Connection.Dispose();

It is for Close and dispose database connection.

In above code, you can see I have return below value.

return ds.Tables[0];

It is because, query will give only one table. if your query will return more than

one table then your return type should be DataSet instead of DataTable.

return ds;

Please add comment if you have any question.

How to Read data from CSV file in Selenium

Read test data from any external source in selenium is very important when we are working with framework. Test data can be store in any format like excel, CSV, text etc.

In this article, we will discuss how we can read data from CSV file.

CSV file is comma separated Value file. It means all the value in file is comma separated from each other. If we want to read data from CSV file then we need to first get all comma separated values individually.

I have created one function for read data from CSV first and store it to two dimensional string array.

Lets take an example. Suppose we have below CSV file.

You can see here in every line all values are comma separated. 

I have created below function for read data from CSV file.

 public String[][] GetDataFromCSV(File fCSVFile)
 {  
        List<String[]> resultsList = new ArrayList<String[]>();
  try
  {
   BufferedReader reader = new BufferedReader(new FileReader(fCSVFile.getAbsolutePath()));
         String line;
         while((line = reader.readLine()) != null)
         {
          String[] temp = line.split(",");          
          resultsList.add(temp);
         }         
         reader.close();
  }
  catch (Exception e) 
  {
   e.printStackTrace();
  }
    
  String[][] resultsArray = new String[resultsList.size()][resultsList.get(0).length];
  
  for(int i=0; i<resultsList.size(); i++)
        {
         for(int j=0; j<resultsList.get(0).length; j++)
         {
          resultsArray[i][j] = resultsList.get(i)[j];
         }
        }
  
  return resultsArray;
 }

Code Explanation : 

In above code, you can see first I am reading every line and spit line by ','. So I will get all values from every line.

String[] temp = line.split(",");

Once I get values from single line then I am storing that all values into List of one dimensional String array.

List<String[]> resultsList = new ArrayList<String[]>();
resultsList.add(temp);

After getting values from all the line, I am storing that values from List to two dimensional String array because we want  data from CSV into two dimensional String array.

String[][] resultsArray = new String[resultsList.size()][resultsList.get(0).length];

for(int i=0; i<resultsList.size(); i++)
        {
        for(int j=0; j<resultsList.get(0).length; j++)
        {
        resultsArray[i][j] = resultsList.get(i)[j];
        }

        }

Please add comment if you have any question.

Extent Report with Selenium Wrapper Automation

Extent report is very interesting feature in selenium web driver. When we want to create any extent report then we need to create object of 'ExtentReports' and 'ExtentTest' class. We also need to set all the basic information related to test case like test case name, author name, Configuration file etc.

This all actions are basic and common actions for all extent report. So, we can out all this action in one separate class and create separate methods for all the action. It will be very helpful when we required more that one test report in single test case.

Just we need use object of that class and use different methods as per needed. If we declare all the method static then we don't need to create object of that class. we can access all the methods with class name.

If you don't know how to configure Extent Report then go to below URL.
Configuration

I have created one class 'ExtentReportUtility' for selenium wrapper automation.

Inside this class, I have created different methods for create report, set test case, write log for test step etc.

import java.io.File;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import com.relevantcodes.extentreports.ExtentReports;
import com.relevantcodes.extentreports.ExtentTest;
import com.relevantcodes.extentreports.LogStatus;
import com.relevantcodes.extentreports.NetworkMode;


public class ExtentReportUtility 
{
 
 public ExtentReports extentReport;
 public ExtentTest extentTest;
 
 public ExtentReports mSetupExtentReport(String vReportName)
 {
  String vReportPath  = "\\ path of where you want to store report";
  String vConfigPath = "\\ path of extent config file";   
  
  extentReport = new ExtentReports(vReportPath + vReportName + ".html", true, NetworkMode.OFFLINE);
  extentReport.loadConfig(new File(vConfigPath));
  
  return extentReport;
 }
 
 public ExtentTest mSetupTestCase(ExtentReports Report, String vTestcaseName, String vDescription, String vAuthor)
 {
  extentTest = Report.startTest(vTestcaseName, vDescription);
  extentTest.assignAuthor(vAuthor);
    
  return extentTest;
 }
 
 public ExtentTest mWriteLog(ExtentTest Test, String vStatus, String vDescription)
 {
  switch(vStatus.toLowerCase())
  {  
  case "pass":
   
   Test.log(LogStatus.PASS, vDescription);   
   break;
   
  case "fail":
   
   Test.log(LogStatus.FAIL, vDescription);   
   break;
   
  case "error":
   
   Test.log(LogStatus.ERROR, vDescription);   
   break;
   
  case "fatal":
   
   Test.log(LogStatus.FATAL, vDescription);   
   break;
   
  case "info":
   
   Test.log(LogStatus.INFO, vDescription);   
   break;
   
  case "warning":
   
   Test.log(LogStatus.WARNING, vDescription);   
   break;
   
  case "skip":
   
   Test.log(LogStatus.SKIP, vDescription);   
   break;
   
  case "unknown":
   
   Test.log(LogStatus.UNKNOWN, vDescription);   
   break;
  
  }
  
  return Test; 
 }
 
 public ExtentTest mAppendChild(ExtentTest ParentTest, ExtentTest ChildTest)
 {  
  ParentTest.appendChild(ChildTest);
  
  return ParentTest;
 }

}

If you want to see that how to use all methods of these class then I have also created one small class for demo purpose.

Please see below is code. You can see I have used object of 'ExtentReportUtility' class to create report, set up test case and other stuff.

public class ExtentReport 
{
 WebDriver driver = null;
 
 public ExtentReports extentReport;
 public ExtentTest extentTest;
 
 @Test
 public  void mExtentReportDemo() throws Exception
 {
  ExtentReportUtility objExtentReportUtility = new ExtentReportUtility();
  
  extentReport = objExtentReportUtility.mSetupExtentReport("Test Automation Report");
  
  extentTest = objExtentReportUtility.mSetupTestCase(extentReport, "First Test Case", "First Test Case", "Sameer");
    
  GetDriver objGetDriver = new GetDriver();  
  driver = objGetDriver.mGetDriver("chrome", false);
    
  objExtentReportUtility.mWriteLog(extentTest, "pass", "Browser launched successfully.");
  
  
  // Go to Google in Browser
  driver.get("https://www.google.co.in");
  Thread.sleep(2000);
          
  objExtentReportUtility.mWriteLog(extentTest, "pass", "Google is open successfully.");
  
  // Search for Selenium in Google
  driver.findElement(By.id("lst-ib")).sendKeys("test");
  
  // Click on Search button
  driver.findElement(By.xpath("//input[@value = 'Google Search']")).click();
  Thread.sleep(3000);  // you can use implicit or explicit wait here. It is good practice.
  
  // Verify First link should be 'Selenium - Web Browser Automation'  
  WebElement link = driver.findElement(By.xpath("//a[text() = 'Selenium - Web Browser Automation']"));  
  try
  {
   if(link.isDisplayed())
   {    
    objExtentReportUtility.mWriteLog(extentTest, "pass", "First link is correct.");
   }  
  }
  catch (Exception E)
  {   
   objExtentReportUtility.mWriteLog(extentTest, "fail", "First link is not correct.");
  }
    
 }
 
 @After
    public void setupAfterSuite() 
 {
  driver.close();
  driver.quit();
  extentTest.log(LogStatus.PASS, "Browser closed successfully.");  
  extentReport.endTest(extentTest);
  extentReport.flush();
  extentReport.close();  
    }

}

Please add comment if you have any question.

Other article on selenium Wrapper Automation.

Driver Setup with selenium wrapper automation

How to handle drop down using selenium wrapper automation

Test Result with Extent Report in Selenium Webdriver

Test result report is very important part in selenium automation. Based on test result report we can verify that script is successfully run or we can verify status of verification point.

Below are selenium webdriver reporting tools.

• TestNG Report
• JUnit Report
• Extent Report

In this article, we will see how to generate extent report in selenium webdriver.

Extent report is third party tool which is used for generate user friendly HTML report in selenium web driver. There is two edition for extent report. Community edition is free ware and Pro is not free ware.  

Configuration:

Extent report is depend on testng library. So first of all you have to add testng jar files into your project.

If you are using maven structure then add below dependency into 'pom.xml' file.

<dependency>
    <groupId>com.aventstack</groupId>
    <artifactId>extentreports</artifactId>
    <version>3.1.3</version>
</dependency>

You can use latest version from URL Extent Report Maven Dependency.

If you are not using maven structure the you have to add .jar file into build path of your project.

You can download extent report jar file from below URL.
Extent Report

Now you can use Extent Report features into your project for report generations.

There is main two classes for report generation. 'ExtentReports' and 'ExtentTest'.

ExtentReports class is used for create new report and load configuration file. Configuration file is used for set basic configuration of report like theme, headline, data format, time format etc.

ExtentTest class is used for set author name, test type, test step description etc.

Please see below is sample code for how to generate extent report.

import java.io.File;

import org.junit.After;
import org.junit.Test;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.testng.annotations.BeforeSuite;

import com.relevantcodes.extentreports.ExtentReports;
import com.relevantcodes.extentreports.ExtentTest;
import com.relevantcodes.extentreports.LogStatus;
import com.relevantcodes.extentreports.NetworkMode;

import CommonUtilities.GetDriver;


public class ExtentReport 
{
 WebDriver driver = null;
 
 public ExtentReports extentReport;
 public ExtentTest extentTest;
 
 @Test
 public  void mExtentReportDemo() throws Exception
 {
  String vReportPath  = "D:\\Study\\Selenium\\Testing\\GitRepository\\SeleniumAutomation\\lib\\TestResult\\TestResult.html";
  String vConfigPath = "D:\\Study\\Selenium\\Testing\\GitRepository\\SeleniumAutomation\\Configs\\extent-config.xml";
  
  extentReport = new ExtentReports(vReportPath, true, NetworkMode.OFFLINE);
  extentReport.loadConfig(new File(vConfigPath));   
  
  extentTest = extentReport.startTest("First Test", "This is First Test");
  extentTest.assignAuthor("Sameer");
  
  GetDriver objGetDriver = new GetDriver();  
  driver = objGetDriver.mGetDriver("chrome", false);
  
  extentTest.log(LogStatus.PASS, "Browser launched successfully.");
  
  // Go to Google in Browser
  driver.get("https://www.google.co.in");
  Thread.sleep(2000);
        
  extentTest.log(LogStatus.PASS, "Google is open successfully.");
  
  // Search for Selenium in Google
  driver.findElement(By.id("lst-ib")).sendKeys("Selenium");
  
  // Click on Search button
  driver.findElement(By.xpath("//input[@value = 'Google Search']")).click();
  Thread.sleep(3000);  // you can use implicit or explicit wait here. It is good practice.
  
  // Verify First link should be 'Selenium - Web Browser Automation'  
  WebElement link = driver.findElement(By.xpath("//a[text() = 'Selenium - Web Browser Automation']"));  
  try
  {
   if(link.isDisplayed())
   {
    extentTest.log(LogStatus.PASS, "First link is correct.");
   }  
  }
  catch (Exception E)
  {
   extentTest.log(LogStatus.FAIL, "First link is not correct.");
  }
    
 }
 
 @After
    public void setupAfterSuite() 
 {
  driver.close();
  driver.quit();
  extentTest.log(LogStatus.PASS, "Browser closed successfully.");
  extentReport.endTest(extentTest);
  extentReport.flush();
  extentReport.close();  
    }

}

Code Explanation : 

public ExtentReports extentReport;

public ExtentTest extentTest;

It is for create object of ExtentReports and ExtentTest class.

extentReport = new ExtentReports(vReportPath, true, NetworkMode.OFFLINE);

vReportPath : It is for set report path at which place you want to generate report.

true : It will replace report if same report is already existing

NetworkMode.OFFLINE : all report artifacts will be stored locally in %reportFolder%/extentreports with the following structure:

- extentreports/css 

- extentreports/js

extentReport.loadConfig(new File(vConfigPath));

It is for loading configuration file. You can download configuration file from below URL.
Extent Report Configuration File

extentTest = extentReport.startTest("First Test", "This is First Test");

It is for create test case.

extentTest.assignAuthor("Sameer");

Set author of test case.

extentTest.log(LogStatus.PASS, "Browser launched successfully.");

It is for add test step into test case with description.

extentReport.endTest(extentTest);

It is for end test and add all log into Report.

extentReport.flush();

extentReport.close();

It is used for close report.

Please see below screen shot for Extent report.

You can see UI of report is very attractive and user friendly. We do not need to record time stamp of any test step. Extent report automatically handle internally and display in the report.

Please add comment if you have any question.

Extent report with Selenium Wrapper Automation.
Extent Report with Selenium Wrapper Automation