Spreadsheet Merger

Sheetize Spreadsheet Merger for .NET

Sheetize Spreadsheet Merger empowers developers to unite multiple spreadsheet documents into a single, cohesive file, simplifying the aggregation of data from various sources for detailed reporting.

Core Capabilities

Consolidate Multiple Spreadsheets

Combine several spreadsheets while maintaining original formatting and data fidelity.

Step‑By‑Step Instructions

Merging Process Overview

  1. Instantiate the Merger – Create the SpreadsheetMerger component.
  2. Add Source Files – Register each spreadsheet you intend to merge.
  3. Specify Destination – Define the output path for the merged document.
  4. Execute Merge – Invoke the Process method to produce the combined file.

Sample: Merging Several XLSX Files 

var loadOptions = new Sheetize.LoadOptions();
var saveOptions = new SpreadsheetSaveOptions {
    OutputFile = @"D:\Merged.xlsx"
};

SpreadsheetMerger.Process(loadOptions, saveOptions, new string[] {
    @"D:\Input.xlsx",
    @"D:\Input2.xlsx",
});

This approach is perfect for generating consolidated reports or aggregating data from multiple origins without manual copying.

SEO‑Optimized Compatibility Details

Supported input formats include Xlsx, Xlsb, Xlsm, Xltm, Xlam, Excel97To2003, Excel95, SpreadsheetML, Xlt, Csv, Tsv, SqlScript, Dif, Xml, Epub, Azw3, Html, MHtml, Json. All of these can be merged into the following output types: Xlsx, Xlsb, Xlsm, Xltm, Xlam, Excel97To2003, Excel95, SpreadsheetML, Xlt, Html, MHtml. When source files use different formats, ensure that a valid license for the appropriate converter is installed to handle format conversion and preserve data integrity.

By leveraging Sheetize Spreadsheet Merger, developers obtain a robust, license‑compliant solution for unifying spreadsheet data across a wide range of file types, enhancing productivity and delivering polished, aggregated outputs.

 English