Info needed for excel file

[surya_teja.k]

HI All,

I had 10 excel files with the same structure, i want to loop through all the files and open each file and filter some columns for each file and write to new sheet to another folder.

can anyone suggest how I can solve the problem?

[Gresilda_Balla]

Hello Surya,
Can you be more specific

[surya_teja.k]

Thanks for reply Gresilda.

I am having Folder in which i am having 10 Excel files with the same columns , i have to read all the excel files at a time and i have to filter 3to4 columns from each file which is same column names from each excel file and i have to write the filtered data in to new excel file everytime ,so total i should get again 10 sheets which is filtered data .

[prasath_S]

Hi @surya_teja.k

Please find the sample workflow for this.

Main.xaml (8.1 KB)

Steps

1. Loop the folder using for each and fetch only excel files.

2. read the excel file and store in a datatable.

3. filter the datatable using filter datatable activity.

4. write the filtered datatable in a excel file (sheet name is dynamic).

Thanks

[surya_teja.k]

Thanks Prasath