Validate if sheet exist

Help
1

hi im trying to validate if a string exist, i use get workbook sheets activities to get the sheets name, and the condition is if sheets.Contains(“Sheets1”)
it looks like this
image
the Sheet1 does exist in the excel file, but the output is alwasy false ! Any solution ?

1 Like
2

Hi @RobertoEwaldo

In the condition, the name of the sheet you provided “Sheets1”, is that correct? Should it be “Sheet1” instead of “Sheets1”?

5 Likes
3

Hi @RobertoEwaldo @Lahiru.Fernando is right should be Sheet1 as default name for excel workbook.

image

5 Likes
4

@RobertoEwaldo

That’s right the default value of excel sheets is Sheet1 ,Thanks for the keen observation of @Gemlan, By the way did you rename the default name in excel ?

cheers :smiley:

Happy learning :smiley:

6 Likes
5

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