How to create dynamic excel files from a list of data in a column

Hi everyone,

I am trying to create a dynamic excel file that stores data from a column respectively.

For example in my ListofJobs excel sheet, under the Job column, I would need to extract the row information that contains the job “accountancy” into a new excel file titled “accountancy” together with its information in it.

my original ListofJob excel files
ListOfJobs.xlsx (9.2 KB)

Example: of the output
Doctor.xlsx (8.7 KB)
Accountancy.xlsx (8.7 KB)

Hello @Hey_hi

You can use filter datatable activity. In the filter property provide the column which you want to filter anddynamically pass the value from the excel to filter( use a for each row in datatable).

Then use write range to write thefiltered data to new excel( use Use excel activity and pass the name of the required excel, enable the property create file if doesnt exist)

1 Like

I have tried to follow this link: as it is relevance to what I am trying to do Creating Dynamic Excel Sheet Based on a Column - #4 by Hiba_B

Please look at attachd Xaml.
That’ll surely help you.
That’s the easiest way.
ExcelFilter.xaml (9.3 KB)

1 Like

Hai @Hey_hi
Please try the below steps.

  1. Read the “ListOfJobs” file
  2. Create “For each row”
  3. In which Read Current row of column Job and store in a variable.
  4. File Exist activity to check that file, where pass “variable.xlsx” where You have to check or add a file.
  5. If the file exists append the data to an excel file. if the file doesn’t exist Write range activity implement.
1 Like

Hi @loveleet_Saini,

Thank you for your help.
I would like to ask, if there is another new job entry for instance “Bank Manager” inside the ListOfJobs.xlsx file.

Can the program automatically create a new folder name “Bank Manager” with its details inside? Without doing another sequence or filtering manually?

Hi @Hey_hi,

The following .xaml will dynamically fulfill your request.

SimpleExampleFilter.xaml (9.3 KB)


1 Like

Hi @muhammedyuzuak ,

Thank you so much! It helps alot.

1 Like

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