Actually I have two workbooks(i.e two excel files). Each workbook is having one worksheet(i.e excel sheet). Let's say Workbook1 have mysheet1 and workbook2 have mysheet2.
So how can I merge these two workbooks to a new workbook called Workbook3 so that in that new workbook it will contain 2 worksheets as mysheet1 and mysheet2 by using c# and without any third party tool. If that third party tool is free then not an issue.
If anybody know, then please try to help me out.