Adding excel sheet names to a List variable

Hi All,

I’ve a use case wherein I’ve to loop through the excel sheet names and add those name to a List variable based on a check done with a predefined list.

Predefined List : New List(of String)(New String(){“COO”,“BSS”,“INTER BRANCH”,“LOCAL BRANCH TEST”,“AGENT COMMISSION”,“AGENT COMMISSION-HEALTH”})

Problem statement : I’m able to add the sheet name based on predefined list. Only for the agent commission-health value it is giving problem not able to add to the list variable. Tried split approach it is not working.

Have attached my excel input and xaml file for reference.

Any kind of assistance would be of great help. Thank you in advance.SampleData.xlsx (10.3 KB)
Main.xaml (14.3 KB)

1 Like

Hi IIangos ,
I have done changes in your workflow and attached it. please go through it and let me knowMain.xaml (14.1 KB)

4 Likes

Hi Mahaling,

This is what I exactly wanted :slight_smile: Thanks a ton bro for helping out :slight_smile:

1 Like

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