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 component.
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:
Code:
' 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.
workbook.Save("NewWorkbook.xls")