Forum Discussion

Vijay_Joshi's avatar
Vijay_Joshi
Occasional Visitor
6 years ago

Fetch column value from the Excel - DataSource

I want to search a column value from the excel sheet imported in the DataSource with respect to some other column value.  How could I achieve a above requirement in Soap UI.   Thanks , Vijay
jhanzeb1's avatar
jhanzeb1
Frequent Contributor
6 years ago

Hi,

 

As you are using SoapUI Pro, right click on your test case and then click on DataSource. This will open a new UI, click on + and give that data source a name i.e excelSheetOne. This will result in you seeing a dropdown, by default "Excel" is selected, then choose your excel file by clicking on browse. Select the values you want and store them in custom property. 

 

Now, to use those values in your test step, you call those values by ${#excelSheetOne#customValue}

 

Cheers

 

  • Olga_T's avatar
    Olga_T
    SmartBear Alumni (Retired)
    6 years ago

    Hi all,

     

    Thank you, jhanzeb1, your help is greatly appreciated!

     

    Vijay_Joshi, have you had a chance to try the above instructions? Is this what you were looking for?