Merge DataTable | Append to Excel

Help
1

Hi all,

@Palaniyappan @sandeep13 @Lahiru.Fernando

I have to merge 2 excel files and write into the another excel file[FinalExcel].
Merged datatable contains 1000’s of rows.
This FinalExcel have extra columns with formula.
how can I write the data into FinalExcel File??

Thanks
Muthu

2

Fine
this can be done with MERGE DATATABLE ACTIVITY
the destination table mentioned will have the consolidated records
then for this

–use ADD DATA COLUMN to above destination mentioned datatable and add those missing columns

May i know where it has the formula, is it in the missing columns
Cheers @muthu.m

3

@Palaniyappan
@sandeep13
Pls find the attachment

01
01852×230 7.65 KB

02

The yellow colour columns are containing formulas…

Thanks
Muthu

1 Like
4

@muthu.m

This is the best way to do that but you use 3 different write range activity to write data in final excel like first three columns range from A1:C1
image
then
For UNIT you use D1 then E1 for Quantity

Thanks

2 Likes
5

Hi @sandeep13 ,

I tried, A1:C1 is OK. Then, write the data from DataTable to D1. Its overwriting the data from D1.
How to Write the Data in Column D1 only.

Thanks
Muthu

6

You get only unit column from datatable then use write range activity with E1 range.

3 Likes
7

Hi @sandeep13,

Any sample plzz…

Thanks
Muthu

8

Hi @Palaniyappan @sandeep13

Still facing the problem.
I cannot merge these 2 excel files.

Thanks in Advance
Muthu