Compare XLSB Files in Java

Perform a line-by-line comparison between more than two XLSB files in Java. Retrieve a list of differences and save the compared files to a single document.


Download Free Trial

About GroupDocs.Comparison for Java API

Empower your Java applications with images and documents comparison features using GroupDocs.Comparison for Java API. It helps you identify the differences within paragraphs, words, characters, shapes, even the text styles of the compared documents of same format, allows merging the changes and export to a final document. It supports comparing and merging a wide range of documents including PDF, Word, Excel worksheets, PowerPoint presentations, Visio diagrams, Outlook emails, HTML, drawings and image file formats without using any external library.

Steps for Comparing XLSB Files in Java

GroupDocs.Comparison makes it easy for Java developers to compare XLSB files within their applications using a few lines of code.

  • Instantiate Comparer object with source document path or stream.
  • Call add method and specify target document path or stream.
  • Call compare method.

System Requirements

GroupDocs.Comparison for Java APIs are supported on all major platforms and operating systems. Before executing the code below, please make sure that you have the following prerequisites installed on your system.

  • Operating Systems: Microsoft Windows, Linux, MacOS
  • Development Environment: NetBeans, Intellij IDEA, Eclipse etc
  • Java Runtime Environment: J2SE 6.0 and above
  • Get the latest version of GroupDocs.Comparison for Java from Maven

// Compare documents from local file

try (Comparer comparer = new Comparer("C:\\source.xlsb")) {
    comparer.add("C:\\target.xlsb");
    comparer.compare("C:\\result.xlsb"); // Create result file with the specified name
}

// Compare documents from stream

try (Comparer comparer = new Comparer(new FileInputStream("C:\\source.xlsb"))) {
    comparer.add(new FileInputStream("C:\\target.xlsb"));
    comparer.compare(new FileOutputStream("C:\\result.xlsb")); // Create result file with the specified name
}

Result of Comparing Files

  • Elements that were inserted in the first file. – blue, by default
  • Elements wich were deleted from the first file – red, by default

Result of Comparing Files

Live Demos to Compare XLSB Files

Compare XLSB files right now by visiting GroupDocs.Comparison Live Demos website.
The live demo has the following benefits

No need to download API

No need to write any code

Just upload the source file

Get download link to save the file

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. XLSB files can be read and written to faster which makes them useful for working with large files. XLSB is seldom used to store workbooks as XLSX (and previously XLS) are the most common user selected file formats for saving workbooks. It can be opened by Microsoft Office 2007 and above.

Read More About XLSB File Format

Compare Other File Formats

Multi format images & documents comparison API for Java. Compare some of the popular file formats below without any external software.

Compare PDF Files

(Adobe Portable Document Format)

Compare DOC Files

(Microsoft Word Document)

Compare DOCM Files

(Microsoft Word Macro-Enabled Document)

Compare DOCX Files

(Microsoft Word Open XML Document)

Compare DOT Files

(Microsoft Word Document Template)

Compare DOTM Files

(Microsoft Word Macro-Enabled Template)

Compare DOTX Files

(Word Open XML Document Template)

Compare RTF Files

(Rich Text File Format)

Compare TXT Files

(Plain Text File Format)

Compare XLS Files

(Microsoft Excel Binary File Format)

Compare XLSX Files

(Microsoft Excel Open XML Spreadsheet)

Compare XLTM Files

(Microsoft Excel macro-enabled template)

Compare XLSM Files

(Microsoft Excel Macro-Enabled Spreadsheet)

Compare CSV Files

(Comma Separated Values File)

Compare PPT Files

(PowerPoint Presentation)

Compare PPS Files

(Microsoft PowerPoint Slide Show)

Compare PPTX Files

(PowerPoint Open XML Presentation)

Compare PPSX Files

(PowerPoint Open XML Slide Show)

Compare POT Files

(Microsoft PowerPoint template)

Compare POTX Files

(Microsoft PowerPoint Open XML Template)

Compare ODS Files

(Open Document Spreadsheet)

Compare ODP Files

(OpenDocument Presentation File Format)

Compare OTP Files

(Origin Graph Template)

Compare ODT Files

(Open Document Text)

Compare OTT Files

(Open Document Template)

Compare VST Files

(Microsoft Visio 2003-2010 XML Drawing)

Compare JPEG Files

(JPEG Image)

Compare PNG Files

(Portable Network Graphic)

Compare GIF Files

(Graphical Interchange Format File)

Compare BMP Files

(Bitmap File Format)

Compare HTML Files

(Hyper Text Markup Language)

Compare MHTML Files

(MIME Encapsulation of Aggregate HTML)

Compare MSG Files

(Microsoft Outlook E-mail Message)

Compare EML Files

(E-mail Message)

Compare EMLX Files

(Apple Mail E-mail File)

Compare ONE Files

(Microsoft OneNote)

Compare VSD Files

(Microsoft Visio 2003-2010 Drawing)

Compare VSDX Files

(Microsoft Visio Drawing)

Compare VSS Files

(Microsoft Visio 2003-2010 Stencil)

Compare VST Files

(Microsoft Visio 2003-2010 Template)

Compare VDX Files

(Microsoft Visio 2003-2010 XML Drawing)

Compare CS Files

(CSharp Language)

Compare Java Files

(Java Language)

Compare CPP Files

(C++ Language)

Compare JS Files

(JavaScript Language)

Compare PY Files

(Python Language)

Compare RB Files

(Ruby Language)

Back to top
 English