Overview This is a VB.NET-based application that compares two Excel files and highlights the differences. It uses Microsoft Excel 16.0 Object Library (COM Interop) to open, read, and manipulate Excel files directly without needing to convert them into other formats.
The program allows you to:
Load two Excel files (.xlsx or .xls) Compare sheets cell-by-cell Highlight differences (optionally save the comparison result) Provide a summary of matching and mismatched cells
Requirements .NET Framework 4.7.2 or later Microsoft Excel installed (2016 or newer recommended)
Microsoft Excel 16.0 Object Library reference added to the project:
In Visual Studio, go to: Project → Add Reference → COM → Microsoft Excel 16.0 Object Library