Merge 2 different Excel In 1st excel

Help Studio
, ,
11

Assumption:

  • side by side merge of Excel1 and Excel2
  • Repeat / fillup Excel1 rows for Excel2, when Excel2 Rows count greater then Excel1

Variables:
dtMerged | Datatype: DataTable

Flow:

  • Read excel1 with read range → dt1,
  • Reade excel2 with read range ->dt2
  • Assign Activity: dtMerged = dt1.Clone()
  • Merge DataTable Activity: destination: dtMerged | source: dt2.Clone()
  • Assign Activity:
    dtMerged =
(From d1 in dt1.AsEnumerable
From d2 in dt2.AsEnumerable
Let ra = d1.ItemArray.Concat(d2.ItemArray).toArray
Select r = dtMerged.Rows.Add(ra)).CopyToDataTable

then write back dtMerged to an Excel / new Worksheet