Excel data
Hi All Hope you can help me, I have data loops in my keyword test that reads data from excel spreadsheets. The problem is that it only reads the same data from each excel sheet. There are 1...
Forum Discussion
Just to clear something up from my side.
I use 3 excel spreadsheet files that are named differently and that have different data inside.My test does read data from all the files , but only the first lines from all files. All data in the files are on sheet 1 in the file. My files does have column headings.
I do not have one data driven loop, I have a couple, some reading from one excel file but from different columns. But almost all of the data driven loop read from the same file to populate fields.
My test starts by populating a field with a ID number( simulat to passport number). This data tipe only comes from 1 excel file (File 1). The system checks if account with this ID number exists.
If not, it alows you to proceed with account registration. Here I use data loops to populate the bank card detail fields with the bank card data from one excel file (file 2).
This completes succesfully. I then reissue the card (client lost his card). The system needs to search for client. Using the account number from file that was just used previously to do registration of account to search for client on system DB. System finds client and I the use data loop to populate Reissue bank card details from another excel file (File 3). This completes succesfully.
When I run test again, TC uses the very same data just used in first run??? I noticed that it starts with the very last row in all 3 excel files. Each time??
Now you know what happens in my keyword test (sort of) :)
Im not sure if I should still follow your first advice? If so please confirm. I should have given this info earlier to give you a better understanding. :)
I use 3 excel spreadsheet files that are named differently and that have different data inside.My test does read data from all the files , but only the first lines from all files. All data in the files are on sheet 1 in the file. My files does have column headings.
I do not have one data driven loop, I have a couple, some reading from one excel file but from different columns. But almost all of the data driven loop read from the same file to populate fields.
My test starts by populating a field with a ID number( simulat to passport number). This data tipe only comes from 1 excel file (File 1). The system checks if account with this ID number exists.
If not, it alows you to proceed with account registration. Here I use data loops to populate the bank card detail fields with the bank card data from one excel file (file 2).
This completes succesfully. I then reissue the card (client lost his card). The system needs to search for client. Using the account number from file that was just used previously to do registration of account to search for client on system DB. System finds client and I the use data loop to populate Reissue bank card details from another excel file (File 3). This completes succesfully.
When I run test again, TC uses the very same data just used in first run??? I noticed that it starts with the very last row in all 3 excel files. Each time??
Now you know what happens in my keyword test (sort of) :)
Im not sure if I should still follow your first advice? If so please confirm. I should have given this info earlier to give you a better understanding. :)