Loop all file excel in folder?

Help Activities
, ,
1

Now my flow : Read sheetname in file Data\Input\input.xlsx and get sheetname (visible sheet & except sheet name Extra)

But I want add requirement as below.

  1. I want to Loop all file excel in folder and list SheetNames in list (visible sheet & except sheet Extra and Except Sheet that StartNameSheet = Con

Now My flow as attached. Sequence1.xaml (5.0 KB)
image

How to edit my code?

Uploading: Sequence1.xaml…

2

@fairymemay

check below post for your reference to get all the xlsx files in folder

Hope this will help you

Thanks

4

@Robinnavinraj_S And I want read only visible sheet & except sheet name Extra & Except Sheet that StartNameSheet = Con

How to edit from my code?
Type variable I want same format.

Please guide me for solve it.

5

Hi, Can you explain this in a simpler way the exact requirement.

thanks

6

@fairymemay

Inside the For each you can put the Get Visible Sheet activity, so you are passing the file name to the activity and activity will ouput the Visible sheets only

Hope this will help you

Thanks

1 Like
7

@Shikhar_Tandon Get sheetname from all file in folder input (except sheet name Extra , Sheet name that start name with Con , only sheet visible)

variable SheetNames = List
variable SheetsToExclude = String

Please guide me for solve my code.