Write Range activity showing, range not found
Check the sheet name and the range value you are passing. the Excel worksbook should have the sheet as you are passing.
Share your activity details with screenshot
The range does not exist. —> RemoteException wrapping System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
sheet name exist, range vakue “”
Could you please show me screenshot of Write Range activity properties and so that we can check and get back to you.
You need to change the workbook name, give full path name with .xlsx.
I think it’s Excel scope
Excel scope is given, xcel file is project folder. This write range is working in other activities of same file name
Kindly ensure that the file is closed before accessing it
For that use KILL PROCESS ACTIVITY with ProcessName mentioned as “EXCEL”
Also if we have excel application installed kindly use the EXCEL APPLICATION SCOPE and mention the file path as input
I had the same. Turns out that while creating the dt with an Add Row it would accept certain characters like = when the variable was a GenericValue. Changed it into a String and works like a charm.