1. Products
  2.   Spreadsheet Merger

Spreadsheet Merger for .NET

Merge multiple spreadsheet files into one using the Spreadsheet Merger API.

Get Started

Spreadsheet Merger for .NET

The Spreadsheet Merger API enables merging multiple spreadsheet files into a single output, supporting formats such as XLSX, XLS, XLSB, CSV, ODS, and more. It provides a robust solution for combining data from various spreadsheets into a unified document within .NET applications.

Features

  • Merge multiple spreadsheets into a single file
  • Support for various spreadsheet formats (XLSX, XLS, XLSB, CSV, ODS, etc.)
  • Handle spreadsheets with different formats and merge into one
  • Preserve data, formulas, and formatting during merging
  • Easy integration with .NET applications
  • Customizable merging options

Benefits

  • Simplify data consolidation from multiple sources
  • Enhance productivity by automating the merging process
  • Reduce development time with ready-to-use merging features
  • Maintain data integrity and formatting
  • Handle large spreadsheets efficiently

How to Use Spreadsheet Merger?

Integrate the Spreadsheet Merger into your .NET project by following these steps:

  • Install the Spreadsheet Merger library via NuGet
  • Reference the library in your project
  • Set up the merging parameters according to your needs
  • Call the Process method to perform the merging

Getting Started with Spreadsheet Merger

To get started with the Spreadsheet Merger:

  • Download the Spreadsheet Merger library from NuGet.
  • Add a reference to the library in your .NET project.
  • Review the documentation to understand the available options and settings.
  • Implement the merger in your application code to enable spreadsheet merging features.

Frequently Asked Questions

What formats are supported for merging?

Spreadsheet Merger supports formats such as XLSX, XLS, XLSB, CSV, ODS, and more.

Can it handle spreadsheets with different formats?

Yes, it can merge spreadsheets with varying formats into a single output file.

Does it preserve formulas and formatting during merging?

Yes, the merger preserves data, formulas, and formatting when merging spreadsheets.

Is it possible to select specific sheets or ranges to merge?

Yes, you can specify particular sheets or ranges to include in the merged output.

Can I customize the output settings?

Yes, various output settings can be customized through the SpreadsheetSaveOptions, such as specifying the output format and handling of duplicate data.