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 the 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 |
The number at the end of the NuGet package name represents the .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 it in its actual pixels.
Image in actual pixels
i) Excel documents without charts will throw a message "Workbook has no chart!".
ii) Excel documents with more charts can be compared by scrolling down the charts as shown in the below screenshot.
System Requirements
- .NET Framework 4.0
- Microsoft Excel 2003 or above
- Visual Studio 2010 or above
Take a moment to peruse the documentation where you can find basic Excel document processing options along with the features like import and export data, chart, formulas, conditional formatting, data validation, tables, pivot tables and protect the Excel documents, and most importantly, the PDF, CSV and Image conversions with code examples.
Conclusion
I hope you enjoyed learning about utility to compare chart images converted using Microsoft Excel and Syncfusion XlsIO.
You can refer to our XIsIO’s feature tour page to learn about its other groundbreaking features. Explore our UG documentation and online demos to understand how to manipulate data in Excel documents.
If you are an existing user, you can access our latest components from the License and Downloads page. For new users, you can try our 30-day free trial to check out XlsIO and other Syncfusion® components.
If you have any queries or require clarification, please let us know in the comments below or contact us through our support forums, Support Tickets, or feedback portal. We are always happy to assist you!
