I have a use case where I want to insert the data fetched from a web application in an excel sheet.
I already have the excel sheet with me. I don’t want to create a new excel sheet.
I want that the data fetched from my web application should be added on the topmost row of my excel sheet.
How do I automate this use case using Automation Studio?
You can add that excel as an excel application
And using Set Text interaction you can paste the extracted value in desired cell
I was able to meet this requirement by using Excel Recorder
I inserted the new row on top of all my rows.
And then set the value of the cell to the arguments storing the value extracted from my Web Application.