Forum Discussion
Nastya_Khovrina
6 years agoSmartBear Alumni (Retired)
Hi dief123,
The Excel data source obtains data from the Microsoft Excel file. It assigns data from the columns to the properties in the order they are listed in the editor. That is, the value of the first column will be assigned to the first property, the second column - to the second property, and so on. It works with one row per iteration. So, it there are several columns, you cannot go through cells one by one in order to assign the cell value to one property.
But, you should be able to achieve your task using a groovy script. Here is the article to start:
- TanyaYatskovska6 years agoSmartBear Alumni (Retired)