Do you need to track your Excel to PDF conversion for bigger files? Aspose.Cells can suit your needs; it provides a sort of callback event/mechanism that notifies you the progress of the conversion. All you need to do it is implement an interface and write your code using Aspose.Cells APIs for your needs. In this post, I will share how to track your conversions for Excel to PDF rendering. Moreover, Aspose.Cells now supports to convert combo charts precisely and elegantly from XLS to XLSX and vice versa. You may find these exciting features and other enhancements in the release. So let’s not wait another moment to review the release notes. To get essence of the public release (Aspose.Cells for .NET v19.7), I am giving you preview of the new features and other enhancements available in it.

C# Excel to PDF - Track Conversion Progress

Suppose, you are converting a huge Excel file to PDF, watching the loading screen and waiting for the program to finish the task. A lot of patience is required for this and you think there should be some means which shows the document conversion progress. We have achieved this functionality by providing the IPageSavingCallBack interface. Using this interface you will be able to get the total number of pages which are to be rendered to PDF along with the methods PageStartSaving and PageEndSaving. These methods should be implemented in some custom class which will continuously provide the current page number which is being rendered and the total number of pages, etc. Using this custom class you can design graphical controls or simply display text on console to show the document conversion progress page by page.

Here is a ready to run example along with a custom class sample where these methods implementation is demonstrated. Just copy this code and enjoy the new progress monitoring feature.

The following is the code for the TestPageSavingCallback custom class.

Here is the sample output of the program:

Start saving page index 0 of pages 11
End saving page index 0 of pages 11
Start saving page index 1 of pages 11
End saving page index 1 of pages 11
Start saving page index 2 of pages 11
End saving page index 2 of pages 11
Start saving page index 3 of pages 11
End saving page index 3 of pages 11
Start saving page index 4 of pages 11
End saving page index 4 of pages 11
Start saving page index 5 of pages 11
End saving page index 5 of pages 11
Start saving page index 6 of pages 11
End saving page index 6 of pages 11
Start saving page index 7 of pages 11
End saving page index 7 of pages 11
Start saving page index 8 of pages 11
End saving page index 8 of pages 11

Following is the summary of this new feature:

  • Get total number of pages which can be rendered
  • Get trigger when a page rendering is started with page index
  • Get trigger when a page rendering is finished with page index
  • Cancel or abort an operation at a particular page as per your requirement

Convert XLS to XLSX with Combo Chart

Older versions of Aspose.Cells were not converting the XSL to XLSX with Combo charts elegantly as these rendered charts might be flattened. The good news is that this shortcoming is no more there with the release of this new version as this issue is addressed and the charts can be rendered correctly.

Following comparisons show the results before and after this update.

The result before the update

The result after the update

To use these features and benefit other enhancements and fixes, I recommend you to try the release Aspose.Cells for .NET v19.7. Moreover, I recommend you to browse Developers’ Guide for your complete reference on what you can deliver using the APIs. Also, you are always welcome to share your review, concerns or feedback on forums.