I attached the project so you can check it out. I tried Worksheet copy method and it copied the merged cells unmerged. I also tried copying the full range, but this one has not carried over the columns widths and still cells unmerged. Is there any workaround? Am I doing something wrong? I did some research and saw the Combine on Workbook, but it doesn’t fit my scenario. I need to copy the content over (can’t have files combined).
AsposeTest7.zip (17.8 KB)