Hi, there are quite a few approaches to achieve this, but to me one of the easiest ways would be with this VB.NET Excel
It presents a workbook content in a very intuitive hierarchical structure, also it has a simple and clean API.
Here is a sample how you can read Excel files in .NET
, make some simple changes on it and save it:
' Load Excel file.
Dim workbook = ExcelFile.Load("Workbook.xls")
' Select active worksheet.
Dim worksheet = workbook.Worksheets.ActiveWorksheet
' Change the value of the cell "A1".
worksheet.Cells("A1").Value = "Hello world!"
' Save the file in XLS format.