Hello I am trying to retrieve data from excel sheet and save it in web app.
lets say I have set of data in excel sheet which I need to transfer or save into the web app where the data will be kept.
in other words we can migrate
so any help will be much appreciated thanks.
7 Answers, 1 is accepted
Based on my understanding for the required scenario on your side, I assume that data driving the test will guide you in the right direction. Also, you can have a look how an excel sheet can be used as data source for a data driven test. Still, if this is not the case you are after, or you have questions about the content in those articles, please let me know with further details and I will assist you further.
I hope this helps.
Regards,
Elena Tsvetkova
Progress Telerik
Rank 1
Rank 1
By using the methods which you shared I wil be able to save the data in the web app or not?
The out come which I want is that the test studio gets the data from excel sheet which has a lot of rows and columns than saves the data into web app and keep running till the data is finished and it’s been entered in respective rows and columns.
Thanks
Based on the description of the requirements you have, the data driven test seems to be the approach which should cover the scenario. Since I am not familiar in details with the application you are automating, I will share an example when a test can be data driven and what the result will be.
Let's have an online shop web page for example and a web form to create an item in that shop. That form contains multiple fields to fulfill in order to describe the item to sell. To avoid preparing a test for each item to be uploaded, you can record the necessary actions once and then data drive the test with an Excel file, for example. The necessary steps are listed below:
1. Add a data source in the project.
2. Bind the test to the data source.
3. Attach the data source columns to Input or Verification steps.
4. Execute the test - it will be run multiple iterations which amount corresponds to the rows in the Excel file.
How to build a thorough example for data driven test is described for the case when using the built-in data source. Though, if switching the data source to any external, the main idea remains the same.
I hope the above information provides sufficient information for your query. Of course, in case you have additional questions, please let me know.
Regards,
Elena Tsvetkova
Progress Telerik
Rank 1
I am also trying to upload an excel sheet into my web app. However I don't want to have the data in the sheet be iterative. I want it to be able to save the entire sheet 1 into the web app. Is there a way to do this?
For Example:
Web application adds multiple lines per Item at 1 time. In order to satisfy the requirements, I must make sure that I can upload an excel sheet with multiple lines for 1 item. I don't want it to run 1x1 through the lines and add them 1 per test. I need them to all upload at 1 time.
Is this possible?
Thanks
Thank you for the additional notes.
Test Studio provides built-in dialog handlers to handle any dialogs triggered from the web page. Among these is the Upload dialog which I believe should work for you in this scenario. There is no limitation what the uploaded file will contain as long as the application under test accepts it.
If still this is not covering the desired scenario, please prepare a sample test which demonstrates what the requirements are. It will be helpful if this can be executed against a public accessible page. However, even if the script cannot be executed on my end, it will still show the steps it goes through and thus, I will have more context about the case that is to be covered.
Thanks in advance.
Regards,
Elena Tsvetkova
Progress Telerik
Rank 1