Write Range in/out of excel app scope not working

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?

Can u Share the screenshot of Workflow

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.


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


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