Filter after Get Workbook Sheets

Help Studio
, ,
1

Is it possible, after I use the Get Workbook Sheets activity, that I would be able to take that list and filter it by a defined criteria, putting the result into a variable???
Ex. I have a workbook with two sheets {“Sheet1”, “TBO 20220429”}. I used the Get Workbook Sheets activity and now I have a List with the two sheet names. What I need to have is a variable that I can use to tell UiPath to use the sheet containing the “TBO”. They date will always change but the TBO will always be the same.
Any suggestions???

2

Hi,

Can you try the following?

image
image790×510 20.3 KB 

 sheets = sheets.Where(Function(s) s.Contains("TBO")).ToList()

Regards,

3

What did you name the Get Workbook Sheets?

4

Hi,

What did you name the Get Workbook Sheets?

Do you mean variable name in Sheets property? if so, the following helps you.

image
image1197×523 31.6 KB

Regards,

5

So, once I do this, I need to get a variable that I can use to tell UiPath in the Read Range to tell it to Read that Sheet.
This is so helpful!!! Thank you!

6

@Yoichi thank you so much. I have it now. Once I was able to filter the list I did a For Each and Assigned the CurrentSheet variable to sheet.ToString and it worked great!
Thank you for all your help!! I learned something new today so this is a good day!!!

1 Like
7

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