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.
Combining two Functions
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinners” is in the year 2023. Or count all “Cooking” in the year 2024 no matter of if it is lunch or dinner.
