Read mulitple excel sheets "Object reference not set to an instance of an object"

hi guys im trying to read multiple excel files, this is my workflow


i get an error saying “Object reference not set to an instance” of an object and the workbook value is null. the message box doesn’t even show up
i have another workflow that i think it’s the same with the 1st one


but the workbook has a value


i wonder what’s wrong with the first one ?

Hi @RobertoEwaldo

Try using the Get Workbook sheets activity to get the sheets available in the file you have opened under excel application scope. Set the output of the get excel sheets header to an output variable. Then use a For Each activity to loop through the sheets that are held by that variable…

Let know whether that works.


Hey @RobertoEwaldo

can you Try with
sheet.ToString.Equals(“Details”) in your if condition.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.