Loop sheet name?

Help Activities
, ,
4

Hello,
Basically, it totally depends on how you are going to use the DT. The idea goes like this when you are going through the DT as per row you are also reading the Sheet’s DataTable. You can do it by separating the sheet names into an array and then reading the data table individually with For Each Activity. This For Each activity will iterate through the array and read each of the sheets.

I have created a sample workflow that will be able to read all the sheets separated by a comma. You can go through it and let me know for further queries.

LoopSheetName.xaml (15.9 KB)

2 Likes