VB.Net 3.5 To Read and Wtrite Excel

cheer · February 23rd, 2009, 05:12 AM

Any easy VB.Net sample code to read and to write an Excel file?

RedDotVasilyev · December 9th, 2013, 03:30 AM

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")