Load Excel Files without Interop

VB C#

using IronXL;
using System;
using System.Linq;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];

// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;

// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;

// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();

// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

Imports IronXL
Imports System
Imports System.Linq

' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Select worksheet at index 0
Private workSheet As WorkSheet = workBook.WorkSheets(0)

' Get any existing worksheet
Private firstSheet As WorkSheet = workBook.DefaultWorkSheet

' Select a cell and return the converted value
Private cellValue As Integer = workSheet("A2").IntValue

' Read from ranges of cells elegantly.
For Each cell In workSheet("A2:A10")
	Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next cell

' Calculate aggregate values such as Min, Max and Sum
Dim sum As Decimal = workSheet("A2:A10").Sum()

' Linq compatible
Dim max As Decimal = workSheet("A2:A10").Max(Function(c) c.DecimalValue)

Install-Package IronXL.Excel

Load Excel Files without Interop

IronXL is an Excel Library for C# and .NET which allows developers to load/read Excel data from XLSX, XLS, XLSM, XLTX, CSV and TSV Documents without using Microsoft.Office.Interop.Excel. Although all the available file format can be read with Load method, LoadCSV method is recommended to use for CSV file format.

Selecting Worksheet

WorkSheet represents one page or tab within the WorkBook. Each WorkSheet can be selected to read and manipulate.

By worksheet's index position in worksheet collection: workBook.WorkSheets[0]
By worksheet's name as parameter in GetWorkSheet method: workBook.GetWorkSheet("workSheet")
By DefaultWorkSheet property from workbook: workBook.DefaultWorkSheet
Please note that this option will get the first worksheet in the workbook. If there were no worksheets, it will create and return a new worksheet with the name "Sheet1".

Furthermore, each individual Range, Row, and Column can be selected from WorkSheet to access/modify Cell's data and apply formula.

Navigate to Select Excel Range to know more about selecting Range, Row, and Column.