InsertSpreadsheetrowvalues - EcoSys - Help

Insert data into a new spreadsheet row. The new row(s) need to already exist in the spreadsheet and must be created by previous test steps.

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

Data- A data provider reference to the data that will be entered into the cells of the spreadsheet.

To create the 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 specify all column headers that exist in the EcoSys Spreadsheet. You can only specify the column header you want to enter data for.

3. In the next row, enter the data that must be entered the cells. If the cell is a lookup, provide the data as it appears in the lookup for selection. You can list as many rows as you want and the framework will find the next available new row to insert the data into.

To create the string 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.

   DataProvider_ProjectData= data provider name

2. For example- To insert data into this spreadsheet row which was added in the previous step,

   

3. The data provider would be:

   

   The values in the number/text filed are user-defined. You can enter the value that you want in these fields.

   For Lookup Fields, the automation suggests using Type-Ahead string, so the value must be the Type-Ahead string completely:

   • In few instances, the framework will use the lookup field, as it will open and select the value itself. However, the string must be a full value displayed in the lookup that you want to select. If it is a hierarchy, use > symbol as the delimiter for each level.

   • In few instances, during the automation run time, when you enter the value, it does not get saved correctly. In such cases, you must override the automation tool to use the lookup selection and add FORCE_LOOKUP’ text at the end of the column.

     For example, if the column is ‘Parent Task’, the data the sheet must be named “Parent Task FORCE_LOOKUP’

4. The entered data in the data cell of the test step would be:

   DataProvider_ProjectData=WorkflowAdminSetup