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# Forumfor getting suitable help.
Usually, we can process excel and merge related data in ASP.NET program.
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Star
11464 Points
2439 Posts
Re: Processing and mapping two excel file
Apr 23, 2018 07:29 AM|Yohann Lu|LINK
Hi MikeT89,
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