Write Range Activity throwing error

Hi
Write Range activity showing, range not found

@KarthikBallary,

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 “”

@KarthikBallary

Could you please show me screenshot of Write Range activity properties and so that we can check and get back to you.

writeRange writeRange2

@KarthikBallary,
You need to change the workbook name, give full path name with .xlsx.

ex: “C:\Users\admin\Desktop\BookNewNew.xlsx”

Hi @sarathi125,
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

1 Like

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

Cheers @KarthikBallary

1 Like

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.