UiPath excel related error

Help Robot
,
1

I have 2 excel files, how to write the columns having the same order number in new excel files ?
Thank You,

2

@UJJVAL_BHAGAT

Follow this Workflow steps:

  1. Read Range dt1

  2. Read Range dt2

  3. Assign activity:
    dtResult = dt1.Clone()

  4. For Each Row activity:
    For each row in dt1.Rows:
    DataRow newRow = dtResult.NewRow()
    For each column in dt1.Columns:
    newRow(column.ColumnName) = row(column.ColumnName)
    dtResult.Rows.Add(newRow)

  5. For Each Row activity:
    For each row in dt2.Rows:
    DataRow newRow = dtResult.NewRow()
    For each column in dt2.Columns:
    newRow(column.ColumnName) = row(column.ColumnName)
    dtResult.Rows.Add(newRow)

  6. Use Write Range