Write data table to specific columns in excel

Help
1

Hello,

Quick question, how can write content of severals excel files to one excel file, on specifics columns and add the rows of all the serverals files.

Thank you guys :slight_smile:

1 Like
2

Hi
For this we can merge the datatable obtained from each excel files with MERGE DATATABLE ACTIVITY
kindly have a view on this

Cheers @Maroua302

3

Thank you for u response @Palaniyappan

I’ve tried all the way u gave me! but won’t work.

myTest.7z (23.1 KB)

Can u please see what’s the issue ? still need the filter to filtre some columns in all the 3 files. and merge data to save to a new excel file

Thanks in advance :slight_smile:

5

@Palaniyappan can you help me on last comment please to filtre my data from the three files, can you check my last exemple please

1 Like
6

Hi
Sorry for the delayed response
I would like to have a clarification
Is all the three excelnhave same number of column and same order of columns

Cheers @Maroua302

7

yes @Palaniyappan the same as what inside the zipe file, thank in advance

1 Like