IRONSOFTWARE
  • PRODUCTS
  • ENTERPRISE
  • FREE TOOLS
  • USE CASES
  • COMPANY
  • CONTACT US
205 N. Michigan Ave. Chicago, IL 60601, USA
+1 (312) 500-3060
CONTACT US
Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
  • Sales
  • Support
  • Partnerships
  • Corporate
Live Chat 24/5
  • En
      Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    • English
    • Español
    • Deutsch
    • Français
    • 日本語
    • 简体中文
    • 繁體中文
  • Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    • Customers Case Studies
    • Industry White Papers
    Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    • About Us
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Company News
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Customers & Case Studies
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Environmental Commitments
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Startup Impact Grant
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Beta Program
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Year in Review: 2024
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Careers
      Icon Text Wearehiring related to 
									Combine Multiple Excel Ranges in C#
    • Consulting Partners
    • Content Creators
    • Resellers Partners
    • Technology Partners
    • Microsoft MVPs
    • Affiliates
    • Global Resellers
    • Merchant of Record
    • Trust Center
    • Sales
    • Support
    • Partnerships
    • Corporate
    Live Chat 24/5
    Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    Icon Logo Ironsuite related to 
									Combine Multiple Excel Ranges in C#

    IRONSUITE

    All 10 for the Price of 2

    Save 80% with Iron Suite
    Logo 1 Percent related to 
									Combine Multiple Excel Ranges in C#
    Logo IronPDF
    Logo IronPDF

    Create, read, and edit PDFs

    Logo IronPPT
    Logo IronPPT

    Edit PowerPoint Files. No Office Interop required

    Logo IronQR
    Logo IronQR

    Read and write QR codes with ML detection

    Logo IronWebscraper
    Logo IronWebscraper

    Extract structured data from website

    Logo IronWord
    Logo IronWord

    Edit DOCX Word Files. No Office Interop required

    Logo IronOCR
    Logo IronOCR

    Image to text in 127 languages

    Logo IronPrint
    Logo IronPrint

    Customized Printing Files

    Logo IronXL
    Logo IronXL

    Edit Excel & CSV Files. No Office Interop required

    Logo IronBarcode
    Logo IronBarcode

    Read and write Barcodes

    Logo IronZIP
    Logo IronZIP

    Zip and unzip archives

    Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    Icon Logo Ironsuite related to 
									Combine Multiple Excel Ranges in C#
    Icon Text Ironsuite related to 
									Combine Multiple Excel Ranges in C#

    Enterprise Licensing

    Icon Logo Ironsecuredoc related to 
									Combine Multiple Excel Ranges in C#
    Icon Text Ironsecuredoc related to 
									Combine Multiple Excel Ranges in C#

    PDF Security & Compliance

    Icon Triangle related to 
									Combine Multiple Excel Ranges in C#
    Icon Logo Irondrawing related to 
									Combine Multiple Excel Ranges in C#
    Icon Text Irondrawing related to 
									Combine Multiple Excel Ranges in C#

    System.Drawing.Common Replacement

    Icon Logo Ironfreetools related to 
									Combine Multiple Excel Ranges in C#
    Icon Text Ironfreetools related to 
									Combine Multiple Excel Ranges in C#

    Free Software Development Tools

    IronXL - Excel Library for C# .NET
    for
    .NET
    • .NET
    • Python
    • Home
    • Licensing
      • Licensing
      • EULA
      • Support & Update Extensions
      • License Upgrades
      • How to Use License Keys
      • Start Free Trial
    • Features
    • Demos
      • Code Examples
      • Book a Live Demo
    • Docs
      • Get Started
      • Tutorials
      • How-Tos
      • Troubleshooting
      • Product Updates
      • API Reference  
    Search
    Ctrl
    K
    Start for Free
    NuGet Download DLL Download Start Free Trial
    Logo Icon related to 
									Combine Multiple Excel Ranges in C#
    IronXL - Excel Library for C# .NET
    for
    • .NET
    • Python
    • IRONSOFTWARE HOME
    • PRODUCTS
      • IRONSUITE

      • IRONPDF
        UPDATED
      • IRONWORD
      • IRONXL
      • IRONPPT
      • IRONOCR
      • IRONBARCODE
      • IRONQR
      • IRONZIP
      • IRONPRINT
      • IRONWEBSCRAPER
    • ENTERPRISE
      • IRONSUITE ENTERPRISE
      • IRONSECUREDOC
    • OPEN SOURCE
      • IRONDRAWING
      • IRONFREETOOLS
    • ABOUT US
      • About Us
      • Company News
      • Customers
      • Environmental Commitments
      • Beta Program
      • Year in Review: 2024
      • Live Chat
      • Global Resellers
      • Join our team
    • CONTACT US
    • HOME
    • LICENSING
      • Licensing
      • EULA
      • Support & Update Extensions
      • License Upgrades
      • How to Use License Keys

      • Start Free Trial
    • FEATURES
    • DEMOS
      • Code Examples
      • Book a Live Demo
    • DOCS
      • Get Started
      • Tutorials
      • How-Tos
      • Troubleshooting
      • Product Updates

      • API Reference  
    Message icon
    IronXL Code Example
    Workbooks
    Create or Load Spreadsheets
    • Create a new Excel File
    • Load Excel Files without Interop
    • Load Excel From SQL Database
    Save or Export Formats
    • Export Excel Spreadsheets in C#
    • Convert Spreadsheet File Types
    • Convert Excel to HTML
    System.Data Objects
    • Excel to SQL via System.Data.DataSet
    • Excel to SQL and DataGrid via DataTable
    • Update Excel Database Records
    Edit Workbooks
    • Edit Excel Metadata in C#
    • Protect Excel Files
    • Excel Print Setup
    Worksheets
    Edit Formulas
    • Excel Formulas in C#
    Sort Data
    • Sort Excel Ranges in C#
    • Select Excel Range
    Create and Edit Charts
    • Create Excel Chart
    Edit Layout
    • Freeze Panes in Excel
    • Auto-Resize Excel Rows and Columns in C#
    Edit Worksheets
    • Insert New Rows & Columns
    • Group & Ungroup Rows & Columns
    • Repeat Rows & Columns in Excel via C#
    • Copy Excel Worksheets
    • Add, Extract, and Remove Images in Excel with C#
    Cell Ranges
    Cell Range Functions
    • Combine Multiple Excel Ranges in C#
    Style Cells
    • Style Cells, Borders, and Fonts in Excel with C#
    Maths Functions
    • Master Excel Aggregate Functions in C#
    Set Cell Data Formats
    • Excel Number Format
    • Excel Conditional Formatting
    Combine Multiple Excel Ranges in C#
    using IronXL;
    using System;
    using System.Linq;
    
    WorkBook workBook = WorkBook.Load("sample.xls");
    WorkSheet workSheet = workBook.WorkSheets.First();
    
    // Get a range from an Excel worksheet
    var range = workSheet["A2:A8"];
    
    // Combine two ranges
    var combinedRange = range + workSheet["A9:A10"];
    
    // Iterate over combined range
    foreach (var cell in combinedRange)
    {
        Console.WriteLine(cell.Value);
    }
    Imports IronXL
    Imports System
    Imports System.Linq
    
    Private workBook As WorkBook = WorkBook.Load("sample.xls")
    Private workSheet As WorkSheet = workBook.WorkSheets.First()
    
    ' Get a range from an Excel worksheet
    Private range = workSheet("A2:A8")
    
    ' Combine two ranges
    Private combinedRange = range + workSheet("A9:A10")
    
    ' Iterate over combined range
    For Each cell In combinedRange
    	Console.WriteLine(cell.Value)
    Next cell
    IronXL related to 
									Combine Multiple Excel Ranges in C#
    Install-Package IronXL.Excel

    Combine Multiple Excel Ranges in C#

    IronXL allows us to combine more than one IronXL.Ranges.Range using the '+' operator.

    Related Docs Links

    Report an Issue on this page

    Ready to get started? Version: 2025.4 just released

    Start for Free
    NuGet Download DLL Download Start Free Trial
    View Licenses >
    Try IronXL for Free
    Get Set Up in 5 Minutes
    Icon Lightbulb related to 
									Combine Multiple Excel Ranges in C#
    C# NuGet Library for PDF
    Install with NuGet
    Version: 2025.4
    Install-Package IronXL.Excel
    nuget.org/packages/IronXL.Excel/
    1. In Solution Explorer, right-click References, Manage NuGet Packages
    2. Select Browse and search "IronXL"
    3. Select the package and install
    C# PDF DLL
    Download DLL
    Version: 2025.4
    Download Now
    Manually install into your project
    1. Download and unzip IronXL to a location such as ~/Libs within your Solution directory
    2. In Visual Studio Solution Explorer, right click References. Select Browse, "IronXL.dll"
    Licenses from $749

    Have a question? Get in touch with our development team.

    15 1000 1
    Nuget Logo
    Now you've installed with Nuget
    Your browser is now downloading IronXL

    Next step: Start free 30-day Trial

    No credit card required

    • Test in a live environment
    • Fully-functional product
    • 24/5 technical support
    Get your free 30-day Trial Key instantly.
    Thank you.
    If you'd like to speak to our licensing team:

    badge_greencheck_in_yellowcircle
    The trial form was submitted
    successfully.

    Your trial key should be in the email.
    If it is not, please contact
    support@ironsoftware.com

    Schedule a call
    Have a question? Get in touch with our development team.
    No credit card or account creation required
    15 1000 1
    Nuget Logo
    Now you've installed with Nuget
    Your browser is now downloading IronXL

    Next step: Start free 30-day Trial

    No credit card required

    • Test in a live environment
    • Fully-functional product
    • 24/5 technical support
    Thank you.
    View your license options:
    Thank you.
    If you'd like to speak to our licensing team:
    View Licensing
    Schedule a call
    Have a question? Get in touch with our development team.
    Have a question? Get in touch with our development team.
    ironxl_for_dotnet

    Get started for FREE

    No credit card required

    Test in a live environment

    Test in production without watermarks.
    Works wherever you need it to.

    bullet_test
    Fully-functional product

    Get 30 days of fully functional product.
    Have it up and running in minutes.

    bullet_calendar
    24/5 technical support

    Full access to our support engineering team during your product trial

    bullet_support
    Support Team Member 6 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 3 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 14 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 4 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 2 related to 
									Combine Multiple Excel Ranges in C#
    ironxl_for_dotnet
    Get your free 30-day Trial Key instantly.

    bullet_checkedNo credit card or account creation required

    badge_greencheck_in_yellowcircle
    The trial form was submitted
    successfully.

    Your trial key should be in the email.
    If it is not, please contact
    support@ironsoftware.com

    Trusted by Millions of Engineers Worldwide
    • aetna_logo
    • wwf_logo
    • nasa_logo
    • usda_logo
    • 3m_logo
    • tesla_logo
    ironxl_for_dotnet

    Get started for FREE

    No credit card required

    Test in a live environment

    Test in production without watermarks.
    Works wherever you need it to.

    bullet_test
    Fully-functional product

    Get 30 days of fully functional product.
    Have it up and running in minutes.

    bullet_calendar
    24/5 technical support

    Full access to our support engineering team during your product trial

    bullet_support
    Support Team Member 6 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 3 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 14 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 4 related to 
									Combine Multiple Excel Ranges in C#									Support Team Member 2 related to 
									Combine Multiple Excel Ranges in C#
    ironxl_for_dotnet
    Get your free 30-day Trial Key instantly.
    Install with NuGet
    View Licensing

    Licenses from $749. Have a question? Get in touch.

    Trusted by Millions of Engineers Worldwide
    • aetna_logo
    • wwf_logo
    • nasa_logo
    • usda_logo
    • 3m_logo
    • tesla_logo
    IronXL
    Book Free Live Demo

    Book a 30-minute, personal demo.

    No contract, no card details, no commitments.

    Iron Software Product Demo Team
    Here's what to expect:
    • A live demo of our product and its key features
    • Get project specific feature recommendations
    • All your questions are answered to make sure you have all the information you need.
      (No commitment whatsoever.)
    CHOOSE TIME
    YOUR INFO
    Book your free Live Demo
    Booking Badge related to 
									Combine Multiple Excel Ranges in C#

    Trusted by Over 2 Million Engineers Worldwide

    Iron Software's customer logos
    Experience the full power of IronXL Start Free Trial
    Logo 1 Percent related to 
									Combine Multiple Excel Ranges in C#
    Textlogo Iron Suite related to 
									Combine Multiple Excel Ranges in C#

    IronXL is a part of IRONSUITE

    10 .NET API products for your office documents

    Get 10 products for the price of 2   Start Free Trial
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironpdf_logo
      - Create, read, and edit PDFs. HTML to PDF for .NET.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironword_logo
      - Edit DOCX Word Files. No Office Interop required.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironxl_logo
      - Edit Excel & CSV files. No Office Interop required.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironppt_logo
      - Create, read, and edit presentations. No Office Interop required.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironocr_logo
      - OCR (extract text from images) in 127 languages.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironbarcode_logo
      - Read and write QR & Barcodes.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironqr_logo
      - Read and write QR codes.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironzip_logo
      - Zip and unzip archives.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironprint_logo
      - Print documents in .NET applications.
    • Icon Hash related to 
									Combine Multiple Excel Ranges in C#
      ironwebscraper_logo
      - Scrape structured data from websites.
    1% for the Planet
    IronXL is a part of IRONSUITE

    10 .NET API products for your office documents

    Get 10 products for the price of 2
       Start Free Trial 
    • ironpdf_logo
      - Create, read, and edit PDFs. HTML to PDF for .NET.
    • ironword_logo
      - Edit DOCX Word Files. No Office Interop required.
    • ironxl_logo
      - Edit Excel & CSV files. No Office Interop required.
    • ironppt_logo
      - Create, read, and edit presentations. No Office Interop required.
    • ironocr_logo
      - OCR (extract text from images) in 127 languages.
    • ironbarcode_logo
      - Read and write QR & Barcodes.
    • ironqr_logo
      - Read and write QR codes.
    • ironzip_logo
      - Zip and unzip archives.
    • ironprint_logo
      - Print documents in .NET applications.
    • ironwebscraper_logo
      - Scrape structured data from websites.
    IronXL for .NET

    The Excel API you need, without the Office Interop hassle.

    Search

    CtrlK

    Documentation

    • Code Examples
    • How-Tos
    • API Reference
    • Features
    • Blog
    • Product Brochure

    Tutorials

    • Get Started
    • Read an Excel File in C#
    • Create Excel Files in .NET

    Licensing

    • Buy a License
    • Find a Reseller
    • License Upgrades
    • Product Update Renewals
    • How to Use License Keys
    • EULA

    Try IronXL Free

    • Download on NuGet
    • Download DLL

    • Start Free Trial
    1. IronXL
    2. Code Examples
    3. Combine Excel Ranges
    Back to top
    Iron Software
    205 N. Michigan Ave. Chicago, IL 60601 USA +1 (312) 500-3060
    • About Us
    • News
    • Customers
    • Careers
    • Academy
    • Contact Us
    • English
      • English
      • Español
      • Deutsch
      • Français
      • 日本語
      • 简体中文
      • 繁體中文
    Github related to 
									Combine Multiple Excel Ranges in C#									Youtube related to 
									Combine Multiple Excel Ranges in C#									Twitter X related to 
									Combine Multiple Excel Ranges in C#									Facebook related to 
									Combine Multiple Excel Ranges in C#									Linkedin related to 
									Combine Multiple Excel Ranges in C#
    Slack Icon related to 
									Combine Multiple Excel Ranges in C#									Join Iron Slack

    Supporting Teamseas

    Copyright © Iron Software LLC 2013-2025

    • Terms
    • Privacy
    • Cookie