How to check if a sheet exist in an Excel file (StudioX)

Help StudioX
, ,
1

Hi everyone,

I saw one similar question asked before. ( How to check if a sheet exist in excel file - Help - UiPath Community Forum) And the problem is solved by Studio “Get workbook sheets” activity.

However, I now using StudioX and I cannot see any “Get workbook sheets” activity here. Is there any other solution? Thank you so much!

2

Hi @Low_Hua_Kuan
can u try the expression below

wb.GetSheets.Contains(“Sheet1”)

3

Hi @Low_Hua_Kuan

try this

Hope this works

4

I want to check if the sheet for this week exists so my expression in if activity should be wb.GetSheets.Contains(““WK”&weeknum(today(),16)”) right?

5

Hi @Low_Hua_Kuan

kindly try above two methods

6

HI @Low_Hua_Kuan

In studio X we having the Get Workbook sheet activity

Go to → Activity panel → Click on Filter → Enable the Show Developer

You can find the activity there.

image

image
image530×591 14.9 KB

Regards
Gokul

7

Hi @Gokul001 ,

I can’t see the filter symbol… :smiling_face_with_tear:

Annotation 2022-03-21 160513
Annotation 2022-03-21 160513311×915 31.7 KB

Do I need to install any packages in order to see the symbol?

8

Hi

Welcome to uipath forum

Go to https://cloud.UiPath.com and login with your credentials

Then click on help button at the left bottom of the screen and it will take you to the resource page

There download the latest version of studioX community edition and with that you won’t have this issue

Have a view on this for details

Cheers @Low_Hua_Kuan

9

Download the latest version of the StudioX @Low_Hua_Kuan

Regards
Gokul

10

Thanks everyone!! :smile:

11

Happy automation :grinning:

Regards
Gokul

12

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