Append The Data In To Excel

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi Team,

I want to append the output data to 1st rows.

Main Sheet :

Input data-

Result - Main Sheet-

Note : In Main Sheet The Header Positions Wont Change. All i wanted is i need to write input data to main sheet in starting of cells everytime when the bot runs!!

Thanks

[Krishna_Raj]

@Putta_Sri_Sai_Rishik_Chow

Activities - Append Range

check the thread

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Append range will work Ex- If in the sheet the data is up to A20 it will write from the A21

In my scenario everytime my bot has to write the data from A2 as i have attached snapshots

[supriya117 (Supriya Allada)]

Hi @Putta_Sri_Sai_Rishik_Chow

Use merge datatable activity

[Krishna_Raj]

@Putta_Sri_Sai_Rishik_Chow
You Use Write Cell Activity With Specify Cell Name

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

In Both sheets the headers are not same… It will work…?

Ex - Main sheet the header name is “Name”
Input file the header name is “User”

[supriya117 (Supriya Allada)]

@Putta_Sri_Sai_Rishik_Chow

It will work only if the two columns have same name and datatype.

So Change the column in the datatable(note: Your excel has your back up data)
dt2.Columns(“User”).ColumnName = “Name”

[Nawazish_Ahmad]

Hi @Putta_Sri_Sai_Rishik_Chow

DT1:

DT2:

Note: Use Assign Activity to Rename ColumnName of DT2

DT2.Columns(“User”).ColumnName = “Name”

Then, Use Merge Data Table Activity

OUTPUT:

Hope it will helps you
Cheers!!