This is a migrated thread and some comments may be shown as answers.

Binding multiple sheets from the Excel to the Test

4 Answers 45 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Veera
Top achievements
Rank 1
Veera asked on 13 Dec 2010, 09:19 PM
Binding multiple sheets from the Excel to the Test

Right now, using the built-in data binding option, only one data sheet from an excel file can be binded to the test. This will prevent the reusability of data from other sheets. Is there a option to bind multiple sheets to test or change the sheet when even required

4 Answers, 1 is accepted

Sort by
0
Cody
Telerik team
answered on 14 Dec 2010, 04:52 AM
Hello Veeraraghavan,

One approach you could take is to take advantage of the Inherit Parent Data Source feature. To use this feature you have multiple parent tests bound to different data sources, but they can all call the same subtest using the test-as-step feature and have this subtest inherit the data that the parent test is bound to. I have attached a screenshot showing this setting. You get to this setting from Test View in Visual Studio. Select the subtest and view its properties while in Test View.

Will this approach work for you?

All the best,
Cody
the Telerik team
Interested in Agile Testing? Check out Telerik TV for a recording of Automated Testing in the Agile Environment
0
Nithya
Top achievements
Rank 1
Veteran
answered on 19 Jul 2017, 10:00 AM

Hi , 

I have a  question here. I am trying to use the multiple sheets from the excel to different test. But it is taking the data from the parent excel.

Details :

1. I have a test name (eg: Test1) with excel (Test1.xls) 

2. I am using the sheet1 from excel in this Test1

3. I have another Test (Test2) with the excel (Test1.xls) - But Sheet 2

4. If I try to run test2 , - Then it is taking the data from Sheet1 and not from sheet2

5. As you mentioned,  Inherit from Parent data source  setting is unchecked in Test2.

 

Could you please help me to solve this problem.

 

 

Regards,

Nithya A.

0
Nithya
Top achievements
Rank 1
Veteran
answered on 21 Jul 2017, 11:20 AM

Hi All, 

I understood now. It works fine now. 

Use the options (Inherit from Parent data source)

 

Regards,

Nithya A

0
Elena
Telerik team
answered on 24 Jul 2017, 07:54 AM
Hello Nithya,

I am glad to know you have resolved the issue on your end! 

Regards,
Elena Tsvetkova
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Veera
Top achievements
Rank 1
Answers by
Cody
Telerik team
Nithya
Top achievements
Rank 1
Veteran
Elena
Telerik team
Share this question
or