Read Range : Object reference not set to an instance of an object


#1

Scenario: Read range from excel returns object reference not set error

Steps to reproduce: read range with sepecified cell

Current Behavior: Not reading after upgrading excel activites

Expected Behavior: Need to read whole excel from specified cell

Studio/Robot/Orchestrator Version: latest version

Last stable behavior:
Last stable version:
OS Version:Windows server 2012
Others if Relevant: (workflow, logs, .net version, service pack, etc):


#2

#3

Hey, did you find any solution to this problem cuz i just bumped into it :-?


#4

Could you please check if the excel package in updated in Manage Package window. It should be 2.0.6382.14545


#5

Hey, yes the package is up to date but it’s not only in excel but workbook too… i have the same robot on 5 machines and only one get’s this error, another get something else and on the rest of 3 machines it works flawlessly


#6

Any update on this?


#7

I have solved this issue just initializing the object that the activity ExcelReadRange is pointing to. That is, I set the output variable (array of strings, defined in my activity) to a default value {"","",""}. It works now.


Error: Object reference not set to an instance of an object. This error usually occurs when using a variable with no set value (not initialized)
#8

I have resolved this issue by entering the VB expression in the variable. I never faced any problem after that. Try and let me know.