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

Help
1

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

image

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

image

but the workbook has a value

image

i wonder what’s wrong with the first one ?

2

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.

2 Likes
3

Hey @RobertoEwaldo

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

–
Mukesh

4

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