Forum Discussion

LennSar's avatar
LennSar
Contributor
3 years ago

delete or clear excel xlsx file

Hi there, I use a xlsx file to basically buffer some reference data. In the first step I generate that data, write it to a xlsx file and later get that data back from the xlsx file to compare it aga...
Data-Driven Testing
Function Tests
REST
Scripting
  • LennSar's avatar
    LennSar
    3 years ago

    I took the opportunity to ask Nicolas Chara during a different service request about this issue and he pointed me towards setup and teardown scripts. This seems to do the trick which I assume is because it runs before the initialization procedure of the Test Case. 

    For later reference as I had some trouble finding it: The TestCase specific setup and tear down scripts can be found when clicking on the TestCase than shows TestSteps and than on the bottom Setup Script

LennSar's avatar
LennSar
Contributor

Hi richie,

 

thanks for the suggestion. Sounded promising but unfortunately disabling the auto recovery doesn't change the behaviour. 

 

Just to clarify I'll describe the test case procedure again:

1) Delete files (I can see this happening in the command line and / or windows explorer)

2) generate data

3) write data using data sink

4) loop back to 2 for x times

5) done (I can now see the xlsx file appearing in the command line and / or windows explorer. NOT BEFORE THIS STEP)


any further suggestions would be highly appreciated! Thanks!

LennSar's avatar
LennSar
Contributor
3 years ago

I took the opportunity to ask Nicolas Chara during a different service request about this issue and he pointed me towards setup and teardown scripts. This seems to do the trick which I assume is because it runs before the initialization procedure of the Test Case. 

For later reference as I had some trouble finding it: The TestCase specific setup and tear down scripts can be found when clicking on the TestCase than shows TestSteps and than on the bottom Setup Script