Hi Everyone,
I am trying to merge two excel files and present the output in the third one.
The first excel file is extracted from a datatable while the second excel file is constructed using write cell activities.
When I used merge excel activity the files aren’t able to merge properly.
The new excel fie presents the data from the first file completely intact as it but the main problem is with the data from the second excel.
An additional row is added between the header and the information.
Can anybody help me resolve this problem.
Attached here are the snapshots of the excel files I am working on:
File 1:
File 2:
File 3: