Read Range (Inside Re Framework): Object reference not set to an instance of an object

[Vaishnav_Tej]

Hi Community,

I’m trying to read Excel File to fetch the config file details. I’m using this activity inside RE Framework Initialization. But I’m facing issue as shown below:

Please help me.

Thanks in Advance:-)

[Gokul001 (Gokul Balaji)]

Hi @Vaishnav_Tej

Check out the File path and sheet name is passing correctly?

Have you Read the Config file and pass the Dt Value correctly?

Regards
Gokul

[Vaishnav_Tej]

Hello,

In config File I have given correct Path to the Excel File and Also Sheet name.

And Yes I have Passed the correct DT value as shown below which is a default DT created when using RE Framework.

[kumar.varun2 (Varun Kumar)]

Hi @Vaishnav_Tej

Where exactly are you using this Read Range Activity in Initialization?

It should be used after invocation of InitAllSettings xaml and not before it.

[Vaishnav_Tej]

I couldn’t find InitAllSettings. But I’m using Read Range Activity after KillAllProcess

[kumar.varun2 (Varun Kumar)]

@Vaishnav_Tej

In the InitAllSettings.xaml framework, the config variable is initialized and populated with values. If it is not present, the config is not initialized and where ever the config variable will be used, the same error will be thrown.

[ahmed.moqbali]

Check the config file keys, if there are extra spaces it will give you this error