Forum Discussion

rhsou123's avatar
rhsou123
Contributor
8 years ago

Keyword Driven framework & Excel

Hi all,   this is a general question and I'm sorry if this is not the correct place to ask it.   I'm using Excel for my keyword driven framework and I'm actually using one sheet for the Test case...
Ravik's avatar
Ravik
Super Contributor
8 years ago

Hi,

 As per my understanding your TestCases have the reference of available keywords, but the problem is - If you have modified Keyword or TestCases, You have to update in both.

 

You can try in excel -

select column where you want to display your keyword

1- Go to DATA tab

2- Select DATA VALIDATION

3- In data validation pop-up  - Setting Tab

4- Select LIST from drop down

5- Click on Source (pop-up will minimize) - Select sheet2 (where your keywords present)

6- Select Column where your keywords Stored and click on icon.

 

This will add you all keywords in your TestCase sheet, so whenever you made changes in keywords it will be automatically reflect in TestCases sheet.

 

Or

 

You can create Macros in a way -

 

Which is shows all available Keywords, Header for that Keywords (required parameter for that keyword)