Hello Ashwitha,

I spend some time today trying to figure out how to combine two excel files. To be honest since I am not an expert I figure it that maybe through 6-7 modules that I tried is was not possible. Again do not take my word or experience as granted because this was my first attempt on this area.

But yesterday I was reading about "CSV files" take a look on those. I started working with them, and I think it would be easier to solve your problem like this.

I mean read and export your excel files into a CSV file, then combine them in one common and regenerate your excel file combined. ;)

This is the only solution that I can imagine for your problem.

In case that you want for fun to experiment with some code that I create to test your question I have posted under. It is nothing complicated and also have included some documentation to assist you with the explanation.

I hope my proposed solution did confused you more. My intention was to propose an alternative solution to your problem.

hello thanos1983, yeah the proposalit kinda confused me ;). But thanks a lot for replying.