Write Range in/out of excel app scope not working

Help Forum
1

I am reading an excel, grabbing data from one of the sheets into a data table, modifying that data, and attempting to write it back into the same sheet. I am receiving the Object reference not set to an instance of an object" error. I have tried both write ranges inside and outside of the excel application scope - both do not work. Suggestions?

2

Can u Share the screenshot of Workflow
@itvic

3

Hi @itvic ,
“Object reference not set to an instance of an object” Means
Data is empty. First you will check if the data is empty or not.

4

@itvic

Check the scope of your datatable, also check if there are any duplicates available

Object reference not set to an Instance error will happen when you try to write a invalid / empty value

Hope this helps you

Thanks

5

@
If the data is empty can also check the variables.
You created two variables with same name it shows the data is empty.