You’re offline. This is a read only version of the page.
I have a loop and i want it to write back to a excel file. Right now the loop is working but instead of writing back the data in the same excel file, it replaces the first url, with the latest one, instead of appending it to the excel spreadsheet. How can i accomplish writing back to excel buy appending the data to spreadsheet each time the loop runs, instead of overwriting the previous saved url.
If you take a look above i am storing the url in a variable and then trying to write that variable value into a spreadsheet. This process runs multiple times and i am suppose to store a list of urls in the test.xlsx spreadsheet. But right now when the loop runs, it overwrites the older url instead of appending to it.
Thank you in advance
@Anonymous
You'll need to change the active cell to the next available row to avoid having your URLs overwritten. Use the "Get first free column/row from Excel worksheet" directly after your set variable step. Produce the variable FirstFreeRow. Then use that variable in your next step "Write To Excel"" in the Row field and make the Column field 1 (assuming you are writing all of your URLs in column A).
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Share
Report
All responses (
Answers (
29,991
