using IronXL;
using System;
using System.Linq;

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

//  Obtener rango de la hoja de cálculo
var range = workSheet["A2:A8"];

//  Obtener columna de la hoja de cálculo
var columnA = workSheet.GetColumn(0);

//  Obtener fila de la hoja de cálculo
var row1 = workSheet.GetRow(0);

//  Iterar sobre el rango
foreach (var cell in range)
{
    Console.WriteLine($"{cell.Value}");
}

//  Seleccionar e imprimir cada fila
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()

'  Obtener rango de la hoja de cálculo
Private range = workSheet("A2:A8")

'  Obtener columna de la hoja de cálculo
Private columnA = workSheet.GetColumn(0)

'  Obtener fila de la hoja de cálculo
Private row1 = workSheet.GetRow(0)

'  Iterar sobre el rango
For Each cell In range
	Console.WriteLine($"{cell.Value}")
Next cell

'  Seleccionar e imprimir cada fila
Dim rows = workSheet.Rows

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