Merging excel files into one

We are merging two excel files having large amount of data.
We have first read those excel to data table then merged and have written it in another excel.
Now after that we are sending the final merged excel via email, but we are receiving the corrupt file. The final file is getting corrupted and we are unable to find the reason.

1 Like

How are you merging the files?

Hi @Tanvi_Sharma.

Please try adding a delay before sending it via email.
It may be because the system is still not finished saving it fully :slight_smile:

Buddy @Tanvi_Sharma
Try out this steps buddy that could resolve your issue and try to send that excel file manually buddy…if manually works fine it will work fine with our bots,

  1. Open Excel.
  2. Click on File > Options.
  3. Select Trust Center > Trust center settings.
  4. Select Protected view.
  5. Uncheck all the options under Protected View > OK.
  6. Restart Excel 2010 and try to open Excel documents.

Hope this would help you


1 Like


Is that working buddy @Tanvi_Sharma

Yes it is working

1 Like

Great …kindly make a solution buddy. @Tanvi_Sharma …that could help others looking for ideas under your topic


Keep going