Issue with "Object reference is not set" Error in Read Range Activity

[Melroy_Dsa]

I was recently using the read range activity to read from an excel file. Despite providing the correct file location and sheet name, I kept receiving the error message: “Object reference is not set to an instance of an object". When I added a new Read Range activity with the same properties, it resolved the issue and worked as expected.

Has anyone experienced a similar issue? Any insights on why the original Read Range activity failed while the new one worked would be greatly appreciated.

[Binit_Sarkar]

Same bro, Even i have faced similar issue

[katta_nikhil]

what ever you are giving path right… in that path excel is placed ??
if yes … then give some delay between two excel and try

[lucas.stern]

Theres any advanced property on the property window that could causing that difference?

Anyway, some activities like to give us some headache from time to time.
Did you convert you project from Windows-Legacy recently?

[Kismet_Tosun (Kısmet Tosun)]

Don’t use the Workbook. Try excel application scope and read range.

[Melroy_Dsa]

I was testing a few things and since Workbook activities are generally faster than Excel activities, I thought it would be more efficient for validation purposes. In the actual process, I’m using Excel Application Scope with Read Range, and it works well. Thanks for the suggestion!

[Melroy_Dsa]

The issue actually occurred after a recent update, so it’s likely related to that. Before the update, everything was functioning, and I haven’t made any significant changes to the project.

[Anil_G (Anil Gorthi)]

@Melroy_Dsa

Welcome to the community

If the package is updated may be that might be breaking it

Try to just open advanced editor and then add the values and check if the error persists

Cheers

[Kismet_Tosun (Kısmet Tosun)]

Please mark as solution