Data binding using Excel sheet.

4 posts, 0 answers
  1. Shashikant
    Shashikant avatar
    4 posts
    Member since:
    Jul 2016

    Posted 04 Nov Link to this post

    I have a test Case which is binded to a excel sheet to fill in the data from excel.

    Now, some columns in excel have some formula's to calculate amounts, dates and some other thing (which is being updated each time excel is opened and some data changed). But in telerik, the data is kept which was initially bounded, and have to manually update the binding in order to get the latest data from excel sheet.

     

    Is there any way in telerik that it picks the latest updated data all the time, when data binding is used( Please suggest).

  2. Elena Tsvetkova
    Admin
    Elena Tsvetkova avatar
    251 posts

    Posted 07 Nov Link to this post

    Hi Shashikant,

    Please note that once a file is bound to a project a local copy is created for the project under project root folder/Data. Therefore this is the file that needs to be updated to reflect your latest changes. You could easily manage it through the Test Studio UI as well. 

    Let me know in case you need further assistance. Thanks! 

    Regards,
    Elena Tsvetkova
    Telerik by Progress
     
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
     
  3. Shashikant
    Shashikant avatar
    4 posts
    Member since:
    Jul 2016

    Posted 07 Nov in reply to Elena Tsvetkova Link to this post

    Hi Elena,

    Thanks for your response, but I still have a doubt that I am using some date and sum formulas in my excel file which is placed in project root folder/Data and the test which is binded with this file is still picking the old(initial) values, for workaround I manually have to click the Update button on the Bind Test UI only then new values are picked.

    Is there any solution in telerik so that it can pick the latest values from excel file all the time?

  4. Elena Tsvetkova
    Admin
    Elena Tsvetkova avatar
    251 posts

    Posted 10 Nov Link to this post

    Hello Shashikant,

    Thank you for getting back to me. I reviewed your feedback and tested it on my side. I managed to reproduce the same and therefore I submitted a bug report to our public feedback portal for further investigation. Here you could follow its progress, comment and vote for the issue. 

    Until a resolution is published you could use the workaround you have found by yourself. Thanks in advance for your understanding! 

    Regards,
    Elena Tsvetkova
    Telerik by Progress
     
    Quickly become an expert in Test Studio, check out our new training sessions!
    Test Studio Trainings
     
Back to Top
  Cast Your Vote at DevPro Connections! Cast Your Vote at  Win IT Pro Connections!