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 WinForms 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/ |
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
- Run the Visual Studio project, which shows the below window.
Charts comparison utility
- 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
- Double-click any image to view in it’s actual pixels.
Image in actual pixels
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
Conclusion
I hope you enjoyed learning about utility to compare chart images converted using Microsoft Excel and Syncfusion XlsIO.
You can refer to our WinForms XIsIO’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WinForms XIsIO documentation to understand how to present and manipulate data.
For current customers, you can check out our WinForms components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our WinForms XIsIO and other WinForms components.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!