How to Read and Write Excel file ? Update specific cell using C#

In this tutorial , i will explained how to Read and Write (insert) data to Excel file Sheet in ASP.Net using C#.

The data will be update using ( System.Runtime.InteropServices ) library based on supplied input argument.

let's have a look,

This is our excel file, as you can see first column is Name and Second column is Designation, if you want to update the Designation column for specific name then follow the steps below..






Step 1 : Open Visual studio and create the New Project as Console Application




Step 2 : Add Microsoft.Office.Interop.Excel library using Nuget Package Manager.





Step 3 : Add below code in your program.cs file and you are done.

Step 4 : Execute the program and see the results as expected.




Step 5 : You are done.




If you have any questions, post here. Also, provide your valuable suggestions and thoughts in form of comments in the section below.


Thank you !!!