Copy Range in Excel using C#

Copying range in Excel is a fundamental efficiency tool that eliminates manual data re-entry to prevent errors and save time, while preserving critical elements like formulas (with auto-adjusted relative references), formatting, validation rules, and comments. It enables non-destructive data movement for backups or reorganization, supports data consolidation across sheets/workbooks, and facilitates template reuse. Advanced operations via Paste Special (e.g., pasting values, formulas, or performing calculations) further enhance productivity, allowing dynamic chart updates, linking between files, and streamlined workflows—all while maintaining data integrity and structural consistency. Aspose.Cells supports all copy range features, including copy range data, copy range styles and so on. Let’s get started!

This article covers the following topics:

C# Excel Library to Copy Range

Aspose.Cells for .NET is a powerful Excel library that simplifies the process of copying range in Excel. It provides robust features for manipulating Excel files programmatically. Aspose.Cells for .NET is a mature and feature-rich library, offering many functions that are way beyond the simple data export capabilities of other components available on the market. API provides the capabilities to export data, format spreadsheets to the most granular level, import & export images, create charts & Pivot Tables, apply & calculate complex formulas using formula calculation engine, stream Excel data & save the result in various formats.

Aspose.Cells for .NET stands out due to its ease of integration and flexibility. Here are some key features:

  • Comprehensive API: Access a wide range of Excel functionalities.
  • Advanced Customization: Tailor charts and graphs to meet specific needs.
  • High Performance: Efficiently handle large datasets without compromising speed.
  • Multiple Format Support: Work with various Excel formats, including XLSX, XLS, and CSV.

Follow these simple steps to get started with Aspose.Cells for .NET:

  1. Download the library from the releases.
  2. Install it via NuGet Package Manager with the following command:
    PM> Install-Package Aspose.Cells

Copy Range in Excel using C#

Sample Data for Range Data

Sample Data for Range Data

Sample Data for Range Data

How to Copy Range Data Only

Sometimes, you need to copy data from one range of cells to another, copying the data only, not the formatting. Aspose.Cells offers this feature. Follow these steps to copy a range of data using C# with Aspose.Cells for .NET:

  1. Create a workbook.
  2. Add data to cells in the first worksheet.
  3. Create a Range.
  4. Create a Style object with specified formatting attributes.
  5. Apply the style formatting to the range.
  6. Create another range of cells.
  7. Copy data of the first range to this second range.

Here’s a C# code snippet that implements the above steps:

Copy Range Data Only in Excel using C#

Copy Range Data Only in Excel using C#

How to Copy Range Style Only

Follow these steps to copy range style only in Excel using C# with Aspose.Cells for .NET:

  1. Create a Range.
  2. Create a Style object with specified formatting attributes.
  3. Apply the style formatting to the range.
  4. Create a second range of cells.
  5. Copy the first range’s formatting to the second range.

Here’s a C# code snippet that implements the above steps:

Copy Range Style Only in Excel using C#

Copy Range Style Only in Excel using C#

How to Copy Range Data with Style

Aspose.Cells provides a range of classes and methods for working with range, for example, CreateRange(), StyleFlag and ApplyStyle(). Follow these steps to copy range style only in Excel using C# with Aspose.Cells for .NET:

  1. Creates a workbook.
  2. Fills a number of cells in the first worksheet with data.
  3. Create a Range.
  4. Create a Style object with specified formatting attributes.
  5. Applies the style to the data range.
  6. Creates a second range of cells.
  7. Copies data with the formatting from the first range to the second range.

Here’s a C# code snippet that implements the above steps:

Copy Range in Excel using C#

Copy Range in Excel using C#

How to Copy Range Row Heights Only

Sample Data for Copying Range Row Heights Only

Sample Data for Copying Range Row Heights Only

Sample Data for Copying Range Row Heights Only

Follow these steps to use PasteType.RowHeights enum to copy row heights of source range into destination range in Excel using C# with Aspose.Cells for .NET:

  1. Create a Range in source Worksheet.
  2. Set row heights of source Worksheet.
  3. Add destination Worksheet.
  4. Create a second Range in destination Worksheet.
  5. Copy the first range’s row heights to the second range.

Here’s a C# code snippet that implements the above steps:

Copy Range Row Heights Only in Excel using C#

Copy Range Row Heights Only in Excel using C#

Get a Free License

Interested in exploring Aspose products? Visit the license page to obtain a free temporary license. It’s easy to get started and unlock the full potential of Aspose.Cells for your projects!

Copy Range Excel: Free Resources

Don’t stop here! Explore additional resources to further enhance your understanding of Aspose.Cells. These resources will help you master Excel automation and strengthen your skills.

Conclusion

In this blog post, we explored how to copy range in Excel using C#. Aspose.Cells for .NET simplifies this process with its powerful features and flexibility. We encourage you to explore more about Aspose.Cells for .NET to enhance your project management capabilities.

If you have any questions or need further assistance, please feel free to reach out at our free support forum.

See Also