Answered
Hi all,
In the “Write Value To Excel File Step,” I need to update multiple cells in different sheets of the same Excel workbook. Can I specify multiple sheet names and cell ranges within a single “Write Value To Excel File Step,” or do I need to create separate steps for each sheet and cell range update?
Thank you for your reply!
- tihanaM asked 11 months ago
- You must login to post comments
Best Answer
Hi Tihana,
Unfortunately you can’t write to multiple sheet at once. Write Value To Excel File Step writes value to only one cell in one sheet.
You can try and use for each and loop trough needed sheets if you need to write values to the same cell. In case you need to write to different cells, you can put if step to determine ranges for sheets.
Hope this helps!
- Klara answered 11 months ago
- You must login to post comments
Your Answer
Please login first to submit.