Forum Discussion
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 do...
Hello,
it's hard to answer your question without seeing the structure of the two workbooks and the desired result of the merge.
Excel has Power Query as a free add-in for 2010 and 2013, called Get and Transform in Excel 2016. It is easy to use Power Query to merge files. You don't need code, no C# or Visual Studio, just a good understanding of the logic you want to apply and the ability to click icons in the ribbon.
If you can share some sample files and the desired merge result, things can be arranged.