Select Excel Range

VB C#

using IronXL;
using System;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();

// Get range from worksheet
var range = workSheet["A2:A8"];

// Get column from worksheet
var columnA = workSheet.GetColumn(0);

// Get row from worksheet
var row1 = workSheet.GetRow(0);

// Iterate over the range
foreach (var cell in range)
{
    Console.WriteLine($"{cell.Value}");
}

// Select and print every row
var rows = workSheet.Rows;

foreach (var eachRow in rows)
{
    foreach (var cell in eachRow)
    {
        Console.Write($"  {cell.Value}  |");
    }
    Console.WriteLine($"");
}

Imports IronXL
Imports System
Imports System.Linq

Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()

' Get range from worksheet
Private range = workSheet("A2:A8")

' Get column from worksheet
Private columnA = workSheet.GetColumn(0)

' Get row from worksheet
Private row1 = workSheet.GetRow(0)

' Iterate over the range
For Each cell In range
	Console.WriteLine($"{cell.Value}")
Next cell

' Select and print every row
Dim rows = workSheet.Rows

For Each eachRow In rows
	For Each cell In eachRow
		Console.Write($"  {cell.Value}  |")
	Next cell
	Console.WriteLine($"")
Next eachRow

Install-Package IronXL.Excel

Select Excel Range

IronXL allows us to easily select and work with ranges in any Excel WorkSheet. The code above demonstrate how range, row, and column can be easily selected. With IronXL it is possible to apply further sorting or calculation with this collection of data such as SortAscending(), SortDescending(), Sum(), Max(), Min(), Avg(). However be mindful that when applying method that modify or move value of the cell. The affected range, row, and column will also update it's value accordingly.

Range

Use var range = sheet["A2:A8"] to select range from A2 to A8.

Row

To select row 1 use the method GetRow(0). The indexing follows zero-based numbering. The range of cells will be determined by the union of populated cell of all the row including row 1 itself.

Column

To select column A use the method GetColumn(0) or assign the range address as sheet["A:A"]. The range of cells will be determined by the union of populated cell of all the column including column A itself.