Forum Discussion

VeenaDevi's avatar
VeenaDevi
Contributor
4 years ago

Using Same Excel file for dataDriven as well as to update Using Excel Write

In Data Driven loop , as the last statement , i am trying to update the last column as Status (looping via Rowindex maintained in Variable and incrementing ) , however when call excel.save , TestComp...
  • sonya_m's avatar
    sonya_m
    4 years ago

    Let me quote what support replied to Veena as this might be of help to others, as well:

     

    >> The reason for this issue is that when you use data from the Excel file (read data) in the Data-Driven testing, it is not possible to write in this file. In this case, I would recommend creating a copy of this Excel file and write all changes there - thus it will help avoid this error.

     

sonya_m's avatar
sonya_m
SmartBear Alumni (Retired)

Thank you, Marsha!

 

Hi VeenaDevi ! Unfortunately, I wasn't able to locate your support ticket, could you let the Community know if you were able to solve the issue and provide details on that? Thank you!

VeenaDevi's avatar
VeenaDevi
Contributor
4 years ago

Created ST for the same :

00486425

  • LSMURUGAN1981's avatar
    LSMURUGAN1981
    New Contributor
    4 years ago

    I am also getting the same error. I am writing the excel report at step level for each click, enter, select, etc. Before Excel.Save or Excel.Open step is completed, it is proceeding to the next line of code and eventually fails the test.

     

    No proper integration of Excel.Save or Excel.Open is not concluded before it moves to the next line of code.

    • LSMURUGAN1981's avatar
      LSMURUGAN1981
      New Contributor
      4 years ago

      Support Ticket - 00489631

      • sonya_m's avatar
        sonya_m
        SmartBear Alumni (Retired)
        4 years ago

        Let me quote what support replied to Veena as this might be of help to others, as well:

         

        >> The reason for this issue is that when you use data from the Excel file (read data) in the Data-Driven testing, it is not possible to write in this file. In this case, I would recommend creating a copy of this Excel file and write all changes there - thus it will help avoid this error.