I am facing a problem , where I am using a For each row loop under Excel Application Scope . Now I filter a DataTable (in Sheet2) based on some condition from Sheet 1.
Now the I want to write/paste Filtered Data in Sheet3.
For this I am Write Range activity under the For Each row of Sheet 1.
When I use Write Range, it throws an error showing the “Value does not fall within the expected range”.
@Palaniyappan, @balupad14 @lakshman
Please help on the same.
Use a KILL PROCESS activity before WRITE RANGE activity and mention as “EXCEL” in ProcessName property
and make sure that we use WRITE RANGE ACTIVITY from workbook activities
So the sequence be like this
—Excel application scope
—within that read range activity
—For each row loop
—write range from workbook with sheetname and filepath
Will the bot open the excel sheet again from which it was taking the data earlier .
Yah of course
Kindly try this and let know for any queries or clarification
Do I need to get out of the For Each row loop ??
Yah if we keep the write range within
For each row loop it will write that range for each iteration
So keep the write range outside the for each row loop
Let me check and get i’ll get back to you.
Kindly share your xaml if possible
Guys Please find the Workflow and the Excel Sheet attached.