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.
Can you elaborate little more!!
cannot able to send the files
You can refer the thread for compare the DataTable.
this i know but how to write it into another excel
- 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