Spreadsheet Merger

The Sheetize Spreadsheet Merger for .NET allows developers to merge multiple spreadsheet files into one, ideal for consolidating data from different sources into a unified report.

Key Features

Merge Multiple Spreadsheets

Combine multiple spreadsheets into a single file, preserving data integrity and formatting.

Detailed Guide

Merging Spreadsheets

To merge multiple spreadsheets into one:

  1. Initialize the Merger: Create an instance of SpreadsheetMerger.
  2. Add Input Files: Add all the spreadsheets to be merged.
  3. Specify Output Path: Set the output file path for the merged spreadsheet.
  4. Execute the Merge: Call the Process method to merge the files.

Example: Merge Multiple XLSX Files

// Step 1: Initialize the Spreadsheet Merger
var merger = new SpreadsheetMerger();

// Step 2: Add input files
merger.AddInput(new FileDataSource("input1.xlsx"));
merger.AddInput(new FileDataSource("input2.xlsx"));

// Step 3: Set the output file path
merger.AddOutput(new FileDataSource("merged_output.xlsx"));

// Step 4: Run the merge process
merger.Process();

This functionality is especially useful for creating unified reports or consolidating data from multiple sources without manual intervention.

 English