11 Answers, 1 is accepted
I added an excel sheet with the location I wanted the file to be saved as a data source.
After binding the data source to the test, when I click on the area to drop down, the column
name does not appear. I have done data driven testing before and every other time, the
column name appears. Any idea as to why it is not now?
The problem you mentioned does not show any sheets to select. That is not my problem as I am able to select the sheet. Once selecting the sheet and going into properties to do the bindings, in the drop down when usually there are the column names to bind the test with, nothing appears. Additionally, yes I am using an XLSX file.
Since you are able to select a sheet I agree you are not running into the same problem of data not showing as documented in that KB article.
I'd like to reproduce this problem on my machine so I can study it and figure out why it's happening. Can you send me a complete test project that reproduces this problem (including detailed instructions how to reproduce it)?
To send me your project put the entire project folder into a .zip file and attach that file to this support ticket. You can leave out the Backup folder and Results folder to save space. If it's larger than 20MB let me know and I'll provide and alternate method for sending me the .zip file.
I have attached the test along with screenshots of when I bind the test and the path where it should be saving (although you will have to change it to match yours). I hope this helps. Is the path format that I have included correct? To reproduce the problem you just have to execute the test and see where the file is saved to.
The webpage is blocked on my PC. Did it save the document to the specified drive in the excel doc?
What do you mean by its running exactly as expected?
The test saved the file in the folder pointed to by the Excel file. I attached the video for you to download. You'll need 7zip to extract it. In case you cannot download and install 7zip, here's a direct link to download the video:
It works when I add the myfile.exe like you did.