Merge XLSB

How to merge XLSB files in C#

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

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

About XLSB File Format

XLSB file format specifies the Excel Binary File Format, which is a collection of records and structures that specify Excel workbook content. The content can include unstructured or semi-structured tables of numbers, text, or both numbers and text, formulas, external data connections, charts and images. Unlike XLSX (which is based on Open XML file format), the XLSB represents binary Excel workbook file.

Code Examples

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

Merge XLSB Live Demo

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

“Merge XLSB”