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

2 Replies

  • jhanzeb1's avatar
    jhanzeb1
    Frequent Contributor

    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)

      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?