CompareExcelFiles 1.0.8

The owner has unlisted this package. This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore. 
dotnet add package CompareExcelFiles --version 1.0.8
NuGet\Install-Package CompareExcelFiles -Version 1.0.8
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="CompareExcelFiles" Version="1.0.8" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add CompareExcelFiles --version 1.0.8
#r "nuget: CompareExcelFiles, 1.0.8"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install CompareExcelFiles as a Cake Addin
#addin nuget:?package=CompareExcelFiles&version=1.0.8

// Install CompareExcelFiles as a Cake Tool
#tool nuget:?package=CompareExcelFiles&version=1.0.8

Sample Usage::

string BaseFile= @"C:\Test1.xlsx"; string CompareFile= @"C:\Test2.xlsx";

//To compare two excel files cell by cell and just return true or false based on whether they matched or not use the following method Bool compareresult = ExcelFileManagement.ExcelPrograms.CompareExcelReports(BaseFile, CompareFile, "Sheet1")

//To compare two excel files cell by cell and return the mismatched cell reference use the following method. List<string> result = new List<string>(); result =ExcelFileManagement.ExcelPrograms.CompareExcelReportsinDetail(BaseFile, CompareFile, "Sheet1"); //In the above method if Baseline file has more number of fields it is compared against the comparefile and if compare file is greater than basefile then it compares it against the basefile.

//To find results with Cell Reference and Values use the following method List<ExcelFileManagement.DataTable> Results = ExcelFileManagement.ExcelPrograms.DetailedCompareExcelReports(BaseFile, CompareFile, "Sheet1");

//To find difference between 2 Excel based on a column use the following method - column is specified as a number starting from 0 . List<ExcelFileManagement.DataTable> Results = ExcelFileManagement.ExcelPrograms.CompareExcelBasedOnASingleColumn(basefile, comparefile, "Sheet1", 2); }

//DataTable class from above has the following /* public string CellReference public string CellValues */

Note: Excel should be installed in the system where you are using this dll

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated

Added new method to compare 2 Excel file based on a column.