Select Excel Range

VBC#

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

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

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

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

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

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

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

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

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Select Excel Range

IronXL allows us to easily select and work with ranges in any Excel WorkSheet. The code below demonstrates how ranges, rows, and columns can be easily selected. With IronXL, it is possible to apply further sorting or calculations to this collection of data using methods such as SortAscending(), SortDescending(), Sum(), Max(), Min(), and Avg(). However, be mindful that when applying methods that modify or move the value of a cell, the affected range, row, and column will also update their values accordingly.

Range

To select a range from A2 to A8, use var range = sheet["A2: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 the populated cells of all the rows, 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 the populated cells of all columns, including column A itself.