How can I read the data from Excel in selenium?

In the context of Selenium, you can read the data from an Excel file in Selenium by using a library like Apache POI( for Java programming language) or even openpyxl (for Python programming language). Here is how you can do so:-

Java with Apache POI

Import org.apache.poi.ss.usermodel.*;
Import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Import java.io.FileInputStream;
Import java.io.IOException;

Public class ExcelReader {
    Public static void main(String[] args) throws IOException {
        // Specify the path to your Excel file
        String excelFilePath = “path/to/your/excel/file.xlsx”;
        // Create a FileInputStream to read the Excel file
        FileInputStream inputStream = new FileInputStream(excelFilePath);
        // Create a Workbook object for the Excel file
        Workbook workbook = new XSSFWorkbook(inputStream);
        // Get the desired sheet from the workbook
        Sheet sheet = workbook.getSheet(“Sheet1”); // Replace “Sheet1” with your sheet name
        // Iterate over rows in the sheet and read data
        For (Row row : sheet) {
            // Assuming the data you want is in the first column (index 0)
            Cell cell = row.getCell(0);
            If (cell != null) {
                String testData = cell.getStringCellValue();
                System.out.println(“Test Data: “ + testData);
            }
        }
        // Close the workbook and input stream
        Workbook.close();
        inputStream.close();
    }
}

Python with openpyxl

  From openpyxl import load_workbook

# Specify the path to your Excel file

  Excel_file_path = ‘path/to/your/excel/file.xlsx’

# Load the Excel workbook

  Workbook = load_workbook(filename=excel_file_path)

# Get the desired sheet from the workbook

  Sheet = workbook[‘Sheet1’]  # Replace “Sheet1” with your sheet name

# Iterate over rows in the sheet and read data

  For row in sheet.iter_rows(values_only=True):

    # Assuming the data you want is in the first column (index 0)

    Test_data = row[0]
    Print(“Test Data:”, test_data)
# Close the workbook
Workbook.close()

Here is also the example given in HTML which would Demonstrate a simple login form:-

    <meta</span> charset=”UTF-8”>

    <meta</span> name=”viewport” content=”width=device-width, initial-scale=1.0”>

   

        Registration Form