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.