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.
what ever you are giving path right… in that path excel is placed ??
if yes … then give some delay between two excel and try
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?
Don’t use the Workbook. Try excel application scope and read range.
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!
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.
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
Please mark as solution 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
Yoichi
Akash_Javalekar1
jast1631
k.sakaguchi0804
singh_sumit
Nisha_K21
shaik.muktharvalli1
postwick
naoko0623