How to combine two Excel spreadsheets into one Sheet, side-by-side in C#?
Hi, I am currently doing a project that requires Excel. I am trying to combine information from two Excel spreadsheets together and save it into a new file so that I can convert it into a Word document for Mail Merge. So far, I have found Solution 1 from https://www.codeproject.com/Tips/715976/Solutions-to-Merge-Multiple-Excel-Worksheets-int to work, however the result produced in the picture is not the same as the one that I have generated (the spreadsheet generated on my end stacks both files on top of one another instead of side-by-side like in the picture). I would like to see if there is a way to produce the desired result that I want (which is two Excel spreadsheets merged together, separated into two columns). Any help would be appreciated. Would also appreciate some C# code as well. Thank you.