Data-Driven Loop through files
Hello,
I'm trying to automate my testing using data-driven loops. In my tests I have to load several different files into my application so I created an exel file which contains the necessary paths to the files. I load a file and then I have to do another loop through some coordinates to calculate some values which I want to check. For each file I need to load into my application I have got a exel file which contains the coordinates and the values which should be the result of my calculation. So I would like to do the coordinates loop inside of the loading loop and I would need to give the coordinates loop a new exel file each time the loading loop runs. Is there any possibility to do that? Or is there another better way? I could put all the coordinates into one exel file as well but than I would have to choose a different subset of rows every time I load a new file. Is there a way to do that? Maybe there is a simple solution to my problem that I haven't found jet. I don't realy want to create a new test for every file because if something in the application changes I would have to go through all the tests and apply the changes besides that it would be a lot of work creating all the test.
Any help would be appreciated. I couldn't really find anything that helps me in the forum.
Thank you.
Sascha Meuser (Cervus Consult GmbH, Germany)
I'm trying to automate my testing using data-driven loops. In my tests I have to load several different files into my application so I created an exel file which contains the necessary paths to the files. I load a file and then I have to do another loop through some coordinates to calculate some values which I want to check. For each file I need to load into my application I have got a exel file which contains the coordinates and the values which should be the result of my calculation. So I would like to do the coordinates loop inside of the loading loop and I would need to give the coordinates loop a new exel file each time the loading loop runs. Is there any possibility to do that? Or is there another better way? I could put all the coordinates into one exel file as well but than I would have to choose a different subset of rows every time I load a new file. Is there a way to do that? Maybe there is a simple solution to my problem that I haven't found jet. I don't realy want to create a new test for every file because if something in the application changes I would have to go through all the tests and apply the changes besides that it would be a lot of work creating all the test.
Any help would be appreciated. I couldn't really find anything that helps me in the forum.
Thank you.
Sascha Meuser (Cervus Consult GmbH, Germany)