Merge XLSX

How to merge XLSX files in C#

GroupDocs.Merger allows developers to merge XLSX files when it’s needed to organize multiple XLSX files into single document or send fewer attachments etc. And you can do this without¬†any third-party software or manual work involved. With GroupDocs.Merger it is possible to combine XLSX documents of any size and structure - all text, images, tables, graphs, forms and other content will be preserved.

The following example demonstrates how to merge XLSX files with several lines of C# code:

  • Create an instance of Merger class and pass source XLSX file path as a constructor parameter. You may specify absolute or relative file path as per your requirements.
  • Add another XLSX file to merge with Join method. Repeat this step for other XLSX documents you want to merge.
  • Call Merger class Save method and specify the filename for the merged XLSX file as parameter.
// Load the source XLSX file
using (Merger merger = new Merger(@"c:\sample1.xlsx"))
{
    // Add another XLSX file to merge
    merger.Join(@"c:\sample2.xlsx");
    // Merge XLSX files ans save result
    merger.Save(@"c:\merged.xlsx");
}

About XLSX File Format

XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. The underlying structure and files can be examined by simply unzipping the .xlsx file.

Code Examples

Please find more use-cases and complete C# sources of our backend and frontend examples and try them for free!

Merge XLSX Live Demo

GroupDocs.Merger for .NET provides an online XLSX Merger App, which allows you to try it for free and check its quality and accuracy.

“Merge XLSX”