Working with more sheets in an excel file

Learning & Development Programs Automation Starter
,
1

Hello,

In order to create an approval flow I decided to use for each approval flow a separate excel sheet (called Flow1, Flow2 and so on)
These sheets will contain names that compose the actual approval flow. Names will be listed in rows.

My question is:
How to structure the flow and what activities should I use in order to read the correct sheet and list the names?

  • the name of the sheet will be given as an input variable of the transaction item.

Best regards!

2

Hey!

We can use get workbook sheets - Output as List - ListSheets

Take one for each and pass the ListSheets variable

In each iteration you will get the available sheets in a excel file

Reference:

Regards,
NaNi

1 Like
3

Hi @Ioana_Renard

In this case you can try with Get Workbook Sheets activity to get all the sheet name dynamically.
Use Read range activity and pass the output of Get Workbook Sheets

image

Or

image

wkb.GetSheets()

Regards
Gokul

1 Like
4

Hello @Gokul001 and thank you for your reply

After proceeding the first example, who can I manage to list the names that I wrote in a specified Sheet?
I was thinking to use a For each to loop the list of sheets and check with an If condition if the current item (sheet) is the one that I want to list its content. But who can I list this content?

Regards

5

Hi @Ioana_Renard

Have a look on the XAML file

GetSheet.xaml (8.2 KB)

Regards
Gokul