How to Select Range

// Import necessary namespaces
using IronXL;
using System.Linq;

// Load the Excel workbook from the provided file path
WorkBook workBook = WorkBook.Load("sample.xls");

// Access the first worksheet within the workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Get a range from the worksheet, here capturing cells from column A to B, rows 2 to 8
Range range = workSheet["A2:B8"];

// Further operations on 'range' can be performed below, such as iterating through cells,
// reading values, checking for a specific condition, or modifying data.

' Import necessary namespaces

Imports IronXL

Imports System.Linq



' Load the Excel workbook from the provided file path

Private workBook As WorkBook = WorkBook.Load("sample.xls")



' Access the first worksheet within the workbook

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Get a range from the worksheet, here capturing cells from column A to B, rows 2 to 8

Private range As Range = workSheet("A2:B8")



' Further operations on 'range' can be performed below, such as iterating through cells,

' reading values, checking for a specific condition, or modifying data.

using IronXL;
using System.Linq;

// Load the Excel workbook from the specified file path
WorkBook workBook = WorkBook.Load("sample.xls");

// Select the first worksheet from the workbook
WorkSheet workSheet = workBook.WorkSheets.First();

// Get the row at index 3 (fourth row since index is zero-based) from the worksheet
var row = workSheet.Rows[3];

// Note: Add any required processing below for the 'row' variable. Depending on what you need to do with the row,
// you might enumerate through its cells, extract data, or perform some operations.

// Example: Iterate through each cell in the row and print its content.
foreach (var cell in row)
{
    System.Console.WriteLine(cell.Text);
}

// Additional processing can be done here based on requirements.

Imports IronXL

Imports System.Linq



' Load the Excel workbook from the specified file path

Private workBook As WorkBook = WorkBook.Load("sample.xls")



' Select the first worksheet from the workbook

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Get the row at index 3 (fourth row since index is zero-based) from the worksheet

Private row = workSheet.Rows(3)



' Note: Add any required processing below for the 'row' variable. Depending on what you need to do with the row,

' you might enumerate through its cells, extract data, or perform some operations.



' Example: Iterate through each cell in the row and print its content.

For Each cell In row

	System.Console.WriteLine(cell.Text)

Next cell



' Additional processing can be done here based on requirements.

using IronXL;
using System.Linq;

// Load the workbook from the specified Excel file.
WorkBook workBook = WorkBook.Load("sample.xls");

// Get the first worksheet in the workbook.
WorkSheet workSheet = workBook.WorkSheets.First();

// Get the entire column from the worksheet.
// Note: Columns are zero-indexed in IronXL, so column 2 refers to the third column in the sheet.
var column = workSheet.Columns[2];

// Iterate through the cell values in the column
foreach (var cell in column)
{
    // Process each cell. For example, print the cell's text to the console.
    Console.WriteLine(cell.StringValue);
}

Imports IronXL

Imports System.Linq



' Load the workbook from the specified Excel file.

Private workBook As WorkBook = WorkBook.Load("sample.xls")



' Get the first worksheet in the workbook.

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Get the entire column from the worksheet.

' Note: Columns are zero-indexed in IronXL, so column 2 refers to the third column in the sheet.

Private column = workSheet.Columns(2)



' Iterate through the cell values in the column

For Each cell In column

	' Process each cell. For example, print the cell's text to the console.

	Console.WriteLine(cell.StringValue)

Next cell

using IronXL;
using System.Linq;

// Load the workbook from the specified Excel file.
WorkBook workBook = WorkBook.Load("sample.xls");

// Select the first worksheet from the workbook.
WorkSheet workSheet = workBook.WorkSheets.First();

// Get a range of cells from the worksheet (from A2 to B2).
var range = workSheet["A2:B2"];

// To combine ranges, concatenate the Address strings and create the new range address.
// This combines the range "A2:B2" with the range "A5:B5".
string combinedAddress = $"A2:B2,A5:B5";

// Get a combined range from the specified combined addresses.
var combinedRange = workSheet[combinedAddress];

// Print out the combined range to check.
Console.WriteLine("Combined Range: " + combinedRange.ToString());

Imports IronXL

Imports System.Linq



' Load the workbook from the specified Excel file.

Private workBook As WorkBook = WorkBook.Load("sample.xls")



' Select the first worksheet from the workbook.

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Get a range of cells from the worksheet (from A2 to B2).

Private range = workSheet("A2:B2")



' To combine ranges, concatenate the Address strings and create the new range address.

' This combines the range "A2:B2" with the range "A5:B5".

Private combinedAddress As String = $"A2:B2,A5:B5"



' Get a combined range from the specified combined addresses.

Private combinedRange = workSheet(combinedAddress)



' Print out the combined range to check.

Console.WriteLine("Combined Range: " & combinedRange.ToString())