Seeing issues in writing to excel file after merging excel files

Help
, ,
1

All,

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

Regards,
Ram

Blankspace
Blankspace1218×512 69.4 KB
Move and Merge excel files.zip (34.3 KB)

2

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.

2 Likes
3

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

4

@Madhavi

Thanks for this,it worked :grinning:

1 Like
5

@Anthony_Humphries

It worked,thnaks