Merging excel files into one

Help
1

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
2

How are you merging the files?

3

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:

4

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

Chees

1 Like
5

Thanks

6

Is that working buddy @Tanvi_Sharma

7

Yes it is working

1 Like
8

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

Cheers

Keep going