Writing in to excel

[arjun.reddy]

i have to write data to excel where columns will change. some time there will 4 columns sometimes there will 5 columns. columns names will also change.

[Gokul001 (Gokul Balaji)]

Hi @arjun.reddy

Can you elaborate little more!!

Regards
Gokul

[arjun.reddy]

Processing: AR.xlsx…

[arjun.reddy]

cannot able to send the files

[Gokul001 (Gokul Balaji)]

Hi @arjun.reddy

You can refer the thread for compare the DataTable.

Matching values from 2 datatable ( same structure ) without loop row

Hi @Mr.H Apart from using join I think this query can help in dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Scope”)= If(dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString))(0)(“Scope”).ToString, Nothing)) Use this code in invoke code with dt1 as in/out argument and dt2 as in argument here I am assuming that dt1 is Input Table dt2 is Output Table Hope it helps …

Regards
Gokul

[arjun.reddy]

this i know but how to write it into another excel

[Gokul001 (Gokul Balaji)]

Hi @arjun.reddy

• Use Build DataTable (Create the column name you want) Create a Output variable.
• Use If Activity (Compare the Datatable)
• Use for each row in DataTable Activity
  Inside for each
• Use Add data row Activity.
  Outside the for each.
• Use write excel activity