How to assign variable value to the excel sheet column
there is issue regarding assign the variable value to the excel column.
error: # Object reference not set to an instance of an object.
Allan Zimmermann last edited by
What activity ? what property did you use a variable for ? What is the content of the variable ? ( set a breakpoint with F9 and take a screenshot of the value of the variable content )
I also encountered this error using ReadExcel activity.
After using breakpoint, I discovered that my DataSet variable is null after the ReadExcel activity. But when I run the RPA with the 'Visual Tracking' option ticked, and stopped at the breakpoint, my variable is not null.
My problem is fixed.
I discovered that my excel is not being read because it is open in Excel and the RPA is not stopping due to the error because I enclosed the Read Excel Activity inside a try-catch.