We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Utility to compare chart images converted using Microsoft Excel and Syncfusion XlsIO

Chart comparison utility is a c# project developed to compare images of charts converted using Microsoft Excel and Syncfusion XlsIO. This article explains the steps to run the utility.

 

Assemblies Required

  • Syncfusion.XlsIO.Base.dll
  • Syncfusion.Compression.Base.dll
  • Syncfusion.ExcelChartToImageConverter.dll
  • Syncfusion.SfChart.WPF.dll
  • Microsoft.Office.Interop.Excel.dll

 

Refer the assemblies to project

 

  • Install XlsIO assemblies with NuGet - In Visual Studio, select Tools -> NuGet Package Manager -> Package Manager Console and execute the below command for the Console project.

 

Install-package Syncfusion. ExcelChartToImageConverter.WPF45 –source http://nuget.syncfusion.com/windows-forms/

 

Note: The number at the end of the NuGet package name represents .NET Framework version. In the above command "Syncfusion. ExcelChartToImageConverter.WPF45" represents the XlsIO libraries for .NET Framework 4.5 (Syncfusion. ExcelChartToImageConverter.WPF40 represents the libraries for .NET Framework 4.0 respectively).

 

  • Interop assembly can be referred from its installed location.

For Ex.: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\Office14\Microsoft.Office.Interop.Excel.dll

 

Steps to run the application

  1. Run the Visual Studio project, which shows the below window.

Charts comparison utility

 

  1. Browse an Excel file with charts to compare or drag and drop the file into the application to load the charts in the workbook for comparison.

Utility loaded with charts of an Excel document

 

  1. Double-click any image to view in it’s actual pixels.

 

Image in actual pixels

 

NOTE:

i) Excel documents without chart will throw a message “Workbook has no chart!”.

ii) Excel document with more charts can be compared by scrolling down the charts as shown in the below screen shot.

 

System Requirements

  • .NET Framework 4.0
  • Microsoft Excel 2003 or above
  • Visual Studio 2010 or above
Article ID: Published Date: Last Revised Date: Platform: Control: .NET Framework:
7563 03/14/2017 03/15/2017 Windows Forms XlsIO 4
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon