If: Object reference not set to an instance of an object for importing data from excel

madhavraichur25 · November 21, 2023, 3:34pm

If: Object reference not set to an instance of an object.

AJ_Ask · November 21, 2023, 3:37pm

Put a log above the if statment & check the file path that you are using in if statment via config is correct or not.

Shiva_Nikhil · November 21, 2023, 3:38pm

can you check in the immediate panel whether the values is present or not

Config("credpath").tostring

and also check this

file.exists(Config(“credpath”).tostring)

check whether the arguments are correctly mapped for config argument or not

postwick · November 21, 2023, 3:38pm

You’re trying to use Config in the If before you’ve read the Excel file into Config, so Config has no value yet.

rikulsilva · November 21, 2023, 3:48pm

Can you check in Locals Panel the current values to your variables to see if you initiate the Config properly.

and, you trying to read another sheet from your config file or this is the first time you trying to read de Config file?