I have multiple files in one folder. The excel file has two sheets(names). I want to check each excel file has two sheets or not . How to check the two sheet name with one condition. Pleas

Help Community
, ,
1

Please help me with solution.

2

Hi @rdrameshraj53d,
Welcome to the UiPath Community

image
image931Ă—677 18.9 KB

image
image737Ă—671 15.5 KB

3

Hi @sangeethaneelavannan1 , thank you for quick response. But my scenario is need check both sheet names( data, temp) in the input file. If both the sheets are present then only read the both sheets .if not throw exception.

4

Hi @rdrameshraj53d

The easiest way would be to use Classic activity Get Workbook Sheets and then use sheets.Contains(“sheetName”)

image
image758Ă—825 49 KB

5

@GT_Ropa thank you

1 Like
6

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