IronXL How-Tos Select Range How to Select Range Chaknith Bin Updated:July 28, 2025 IronXL provides a convenient way to select and manipulate ranges within an Excel Worksheet without using Office Interop. How to Select Range in Excel Download the C# library to select range Use workSheet ["A2:B8"] directly after the WorkSheet object to select a range of cells Utilize the GetRow method to select a row of a worksheet Select a column of the given worksheet with the GetColumn method Combine ranges easily with the '+' operator Get started with IronXL Start using IronXL in your project today with a free trial. First Step: Start for Free Select Range Example With IronXL, you can perform various operations on selected ranges, such as sorting, calculations, and aggregations. Please noteWhen applying methods that modify or move cell values, the affected range, row, or column will update its values accordingly. TipsIronXL allows us to combine more than one IronXL.Ranges.Range using the '+' operator. Select Range To select a range from cell A2 to B8, you can use the following code: :path=/static-assets/excel/content-code-examples/how-to/select-range-range.cs using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get range from worksheet var range = workSheet["A2:B8"]; Imports IronXL 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:B8") $vbLabelText $csharpLabel Select Row To select the 4th row, you can use the GetRow(3) method with zero-based indexing. This will include all cells in the 4th row, even if some corresponding cells in other rows are empty. :path=/static-assets/excel/content-code-examples/how-to/select-range-row.cs using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get row from worksheet var row = workSheet.GetRow(3); Imports IronXL Imports System.Linq Private workBook As WorkBook = WorkBook.Load("sample.xls") Private workSheet As WorkSheet = workBook.WorkSheets.First() ' Get row from worksheet Private row = workSheet.GetRow(3) $vbLabelText $csharpLabel Select Column To select column C, you can use the GetColumn(2) method or specify the range address as workSheet ["C:C"]. Like the GetRow method, it will include all relevant cells, whether they are filled in the specified column or not. :path=/static-assets/excel/content-code-examples/how-to/select-range-column.cs using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get column from worksheet var column = workSheet.GetColumn(2); Imports IronXL Imports System.Linq Private workBook As WorkBook = WorkBook.Load("sample.xls") Private workSheet As WorkSheet = workBook.WorkSheets.First() ' Get column from worksheet Private column = workSheet.GetColumn(2) $vbLabelText $csharpLabel TipsAll the row and column index positions adhere to zero-based indexing. Combine Ranges IronXL provides the flexibility to combine multiple IronXL.Ranges.Range objects using the '+' operator. By using the '+' operator, you can easily concatenate or merge ranges together to create a new range. Please noteCombining rows and columns directly using the '+' operator is not supported. Combining ranges will modify the original range. In the code snippet below, the variable range will be modified to include the combined ranges. :path=/static-assets/excel/content-code-examples/how-to/select-range-combine-range.cs using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get range from worksheet var range = workSheet["A2:B2"]; // Combine two ranges var combinedRange = range + workSheet["A5:B5"]; Imports IronXL 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:B2") ' Combine two ranges Private combinedRange = range + workSheet("A5:B5") $vbLabelText $csharpLabel Frequently Asked Questions How can I select a range in Excel using IronXL? To select a range from cell A2 to B8 using IronXL, load your Excel workbook and worksheet, then use the syntax `worksheet["A2:B8"]`. What is the method to select a row in IronXL? You can select a row by using the `GetRow` method with zero-based indexing. For example, to select the 4th row, use `worksheet.GetRow(3)`. How do I select a column using IronXL? To select a column, use the `GetColumn` method with zero-based indexing. For example, to select column C, use `worksheet.GetColumn(2)` or specify the range as `worksheet["C:C"]`. Can I combine multiple ranges in IronXL? Yes, you can combine multiple `IronXL.Ranges.Range` objects using the '+' operator. This allows you to merge two or more ranges into a new range. Does IronXL support zero-based indexing? Yes, IronXL uses zero-based indexing for rows and columns. Is Office Interop required to use IronXL for selecting ranges? No, IronXL provides a way to select and manipulate Excel ranges without using Office Interop. What operations can I perform on selected ranges in IronXL? Once you've selected a range in IronXL, you can perform operations such as sorting, calculations, and aggregations. What happens to the original range when combining ranges? When you combine ranges using the '+' operator, the original range is modified to include the combined ranges. Chaknith Bin Chat with engineering team now Software Engineer Chaknith is the Sherlock Holmes of developers. It first occurred to him he might have a future in software engineering, when he was doing code challenges for fun. His focus is on IronXL and IronBarcode, but he takes pride in helping customers with every product. Chaknith leverages his knowledge from talking directly with customers, to help further improve the products themselves. His anecdotal feedback goes beyond Jira tickets and supports product development, documentation and marketing, to improve customer’s overall experience.When he isn’t in the office, he can be found learning about machine learning, coding and hiking. Ready to Get Started? Free NuGet Download Total downloads: 1,487,525 View Licenses