How to put data from a column of Excel sheet to list of string in

Help Studio
, ,
2

Hi @Vivek_Pandey2
you can try below sequence:

  1. For Each file in folder Activity → to get all excel files in your folder and start to iterate on it one by one.
  2. Excel scope Activity.
  3. Use excel Application activity → you will use the CurrentFile in the location.
  4. read range activity → to select the needed column to be used later.
  5. create for each data table activity → add the output datatable of above activity in this one.
  6. inside it you will use if activity and make the needed logic on it like currentrow(“Territory”).equals(“the needed value you will need”) in true sequence you will add the actions

Please try above and if there is any issue update us again :slight_smile:

1 Like