Hi Team,
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?
Hi,
You can add that excel as an excel application
And using Set Text interaction you can paste the extracted value in desired cell
Regards.
Amit
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.