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”.
before write range activity use a KILL PROCESS ACTIVITY and mention the processname property as “EXCEL” and then use WRITE RANGE activity from WORKBOOK activity and not from excel
also enable the add headers property