Binding multiple sheets from the Excel to the Test

5 posts, 0 answers
  1. Veera
    Veera avatar
    25 posts
    Member since:
    Jul 2010

    Posted 13 Dec 2010 Link to this post

    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

  2. Cody
    Admin
    Cody avatar
    3360 posts

    Posted 13 Dec 2010 Link to this post

    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
  3. Nithya
    Nithya avatar
    14 posts
    Member since:
    Aug 2016

    Posted 19 Jul in reply to Cody Link to this post

    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.

  4. Nithya
    Nithya avatar
    14 posts
    Member since:
    Aug 2016

    Posted 21 Jul in reply to Nithya Link to this post

    Hi All, 

    I understood now. It works fine now. 

    Use the options (Inherit from Parent data source)

     

    Regards,

    Nithya A

  5. Elena Tsvetkova
    Admin
    Elena Tsvetkova avatar
    581 posts

    Posted 24 Jul Link to this post

    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
Back to Top