Processing and mapping two excel file

Question

User869176912 posted

Hi All,

I want to create a c# program that would process and map two excel file together. The main excel file contains an id and all other data, the other excel file contains an ID and the email of each person on the main file. Is there a way I can process both file at the same time map the id and copy the email to the main excel file with the corresponding id?

Thank you

Answer 1

User303363814 posted

Why a C# program?  Excel can do this natively - use the VLOOKUP function.

Answer 2

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