Excel mapping1

Hi friends i have a question and I am stuck at this point.

I have Excel1 and excel2 both the headers are different.

I need to map excel1 ColumnA data with excel2 ColumnC
excel1 ColumnB data with excel2 ColumnD
excel1 ColumnC data with excel2 ColumnE

How to do mapping of data.

Can anyone please help me. Any help will be appreciated.

Hi @0bb4628e217fd43ac86ac9294

Can you share sample input and expected output.

Check this thread below too


Hi @0bb4628e217fd43ac86ac9294

Please check this


I am using studio version 2020 in that the activity u have mentioned is not there. How can I do that now


In Activities panel Enable Modern in Filter then you will be able to see

Hi @0bb4628e217fd43ac86ac9294

Check the below zip file. This is using classic Excel activities

BlankProcess20.zip (280.1 KB)

If possible provide the input, according to that I will make the required changes and give you updated code.


@vrdabberu please share images I am not able to open the xaml’s

Hi @0bb4628e217fd43ac86ac9294

Can you please share the excel files if possible.


Hi @0bb4628e217fd43ac86ac9294

Main.xaml (13.0 KB)

Copy Paste Macros Code.txt (1.0 KB)
Delete Sheet Macros Code.txt (372 Bytes)

If possible share the excel file in personal, so that I can check the excels.


Will try with this thank you