User36583972 posted
Hi MikeT89,
I want to create a c# program that would process and map two excel file together.
What's the type of your C# program, Asp.net or Desktop App? If your app is a desktop application, you can go to the
Visual C# Forum
for getting suitable help.
Usually, we can process excel and merge related data in ASP.NET program.
You can refer the following samples.
1: Read and Import Excel File into DataSet or DataTable using C# and VB.Net in ASP.Net:
https://www.aspsnippets.com/Articles/Read-and-Import-Excel-File-into-DataSet-or-DataTable-using-C-and-VBNet-in-ASPNet.aspx
2: Merging data through DataSet
3: Create a create Excel file using OpenXML
and Microsoft.Office.Interop.Excel.
For more detailed, please see : How to Create Excel file in ASP.NET C#
https://www.c-sharpcorner.com/uploadfile/jayendra/how-to-create-excel-file-in-Asp-Net-C-Sharp/
Best Regards,
Yong Lu