Seeing issues in writing to excel file after merging excel files


I am facing some problem in writing to excelfile.

I have 2 excelfiles File1 and File2, i want to merge both the file into a single file and I name it as Masterfile.xlsx.
I am seeing both the files are getting merged successfully, but I am seeing a blank line in the middle, screen shot attached for the same and alos attaching my xamlfile


Move and Merge excel (34.3 KB)

If you are using Build data table activity, open the build wizard. You can see the empty rows there. Delete them by clicking ‘x’ associated with each row.


You have a blank row in your Build Data Table. Delete that and your blank row will be gone.


Thanks for this,it worked :grinning:

1 Like


It worked,thnaks