ClickSpreadsheetrowvalues - EcoSys - Help

EcoSys Functional Automation Framework

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
8.7

Click on a cell in a spreadsheet. This is used for row or cell events.

Object- xPath to the spreadsheet (See Spreadsheet section of working with xPath)

Data- A data provider for finding the row and cell to click on. The data provider and data field provide the framework with information on how to find the correct row, column and value to click on.

To create a data provider:

  1. Go to the Project Data worksheet and scroll to the first free line in the sheet. Leaving a blank row between the last row with data, enter a unique name to identify the data provider for the test step to find on the project data worksheet.

  2. In the row below the Data Provider Name, enter the column headers of the spreadsheet as they appear in the UI.

    You do not need to add all columns, but you must add enough columns so that the columns defined are enough for the framework to find a unique row and contains the cell you want to click on the EcoSys spreadsheet.

  3. In the next row, enter the row values data as it appears in the EcoSys spreadsheet.

To create the data for the data cell of the test step:

  1. In the Data cell, enter the following text, where data provider name is the name from step 2, column name is the name of the column you want to click on and value to click on is the value of that cell.

    DataProvider_ProjectData=data provider name>ColName=column name>ClickRowVal=value to click on

    For example, click the Active link of PRJ-00008 in this Spreadsheet

    The data provider would be:

    And the enter in the data cell of the test step would be:

    DataProvider_ProjectData=ProjectSetupStatus>ColName=Status>ClickRowVal=Active