Merge XLSM

How to merge XLSM files in C#

GroupDocs.Merger allows developers to merge XLSM files when it’s needed to organize multiple XLSM 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 XLSM 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 XLSM files with several lines of C# code:

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

About XLSM File Format

Files with XLSM extension is a type of Spreasheet files that support Macros. From application point of view, a Macro is set of instructions that are used for automating processes. A macro is used to record the steps that are performed repeatedly and facilitates performing the actions by running the macro again. Macros are programmed with Microsoft’s Visual Basic for Applications (VBA) from within the Excel Workbook using the Visual Basic Editor and can be run/debug directly from there.

Code Examples

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

Merge XLSM Live Demo

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

“Merge XLSM”