Worksheet.SelectRange

Worksheet.SelectRange method

Selects a range.

public void SelectRange(int startRow, int startColumn, int totalRows, int totalColumns, 
    bool removeOthers)
ParameterTypeDescription
startRowInt32The start row.
startColumnInt32The start column
totalRowsInt32The number of rows.
totalColumnsInt32The number of columns
removeOthersBooleanTrue means removing other selected range and only select this range.

Examples

using System;
using Aspose.Cells;

namespace AsposeCellsExamples
{
    public class WorksheetMethodSelectRangeWithInt32Int32Int32Int32BooleanDemo
    {
        public static void Run()
        {
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            
            // Select range from row 1, column 1 to row 5, column 5 (B2:F6) and make it active
            worksheet.SelectRange(1, 1, 5, 5, true);
            
            Console.WriteLine("Active cell: " + worksheet.ActiveCell);
        }
    }
}

See Also