How to Read Data from Excel in C#

Or download the DLL directly here

using IronXL; using System.Linq; WorkBook workbook = WorkBook.Load("Demo.xlsx"); WorkSheet sheet = workbook.WorkSheets.First(); int cellValue = sheet["A1"].IntValue; foreach (var cell in sheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); }

Imports IronXL Imports System.Linq Private workbook As WorkBook = WorkBook.Load("Demo.xlsx") Private sheet As WorkSheet = workbook.WorkSheets.First() Private cellValue As Integer = sheet("A1").IntValue For Each cell In sheet("A2:A10") Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text) Next cell