Last post Apr 23, 2018 07:29 AM by Yohann Lu
Apr 20, 2018 08:45 PM|MikeT89|LINK
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?
Apr 20, 2018 10:38 PM|PaulTheSmith|LINK
Why a C# program? Excel can do this natively - use the VLOOKUP function.
Apr 23, 2018 07:29 AM|Yohann Lu|LINK
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:
2: Merging data through DataSet
3: Create a create Excel file using OpenXML
For more detailed, please see : How to Create Excel file in ASP.NET C#