[
Conversion of Excel spreadsheets to image formats always remains a hot topic. Sometimes, you claim the process takes too long. Others complain that the process gets stuck for larger files and they need to stop the process. Aspose.Cells has now included a useful feature where you can track the conversion progress in Sheet to image rendering in the way you want, you may notice which pages are being rendered in the process at the moment. Moreover, you can also convert your desired pages and skip other pages. There are some other useful features which might attract you. We suggest you to have a look at the release notes to get the complete list of features, enhancements and other fixes which are part of this new release. I would recommend you to review the release notes for your reference. To get details of the public release (Aspose.Cells for .NET v19.10), I am highlighting some new features and other enhancements available in it.
Track conversion progress of Excel files
Suppose you are working with large Excel files and converting them to other formats. Sometimes it might take a lot of time for conversion and you want your user to be aware of the progress. No worries!!! This latest release has provided the demanded feature to check the conversion progress of MS Excel files. Aspose.Cells has supported to track documents’ conversion progress by providing the IPageSavingCallback interface. The IPageSavingCallback interface provides PageStartSaving and PageEndSaving methods that you can implement in your custom class. You may specify your desired pages to be rendered as demonstrated in the T_estPageSavingCallback_ custom class. See the following sample code that reads the source excel file and shows its conversion progress in the console by using the TestPageSavingCallback custom class that implements the IPageSavingCallback interface.
The following is the code for the TestTiffPageSavingCallback custom class.
Console output:
The following article demonstrates the feature with sample code for your reference.
Track Conversion Progress of Excel to TIFF
Set custom DataSource for WorkbookDesigner in Smart Markers
We all know how useful is the Smart Markers feature when it comes to data binding or merging. Aspose.Cells allows you to set your custom data source for WorkbookDesigner class. The API provides an overloaded method WorkbookDesigner.SetDataSource which takes the name of the source as the first parameter and the instance of the class that implements ICellsDataTable as the second parameter. In the following document, you will learn this useful feature with example code and sample files for your complete reference.
Set custom DataSource for WorkbookDesigner
Support custom data sorting for the specific area in PivotTable report
You have a pivot table and you want to sort it on field values. This is easily achievable now as you can use PivotField.AutoSortField attribute by providing item index to sort. Using this feature you will get a variety of data representation for analysis and reporting purpose. In the following article, you will see the result of this function along with a detailed sample code and files for testing.
In the above article, the sample code snippet loads the sample Excel file and adds three pivot tables. The first pivot table is without custom sorting, the second pivot table is sorted on “SeaFood” row field values and the third pivot table is sorted on “28/07/2000” column field values.
Working with Content Type Properties
MS Excel file has some default attributes, like size, tag, title etc. and if you need to add more custom properties for your needs, Aspose.Cells has included this useful option by providing Workbook.ContentTypeProperties.Add function. You can also mark a property as optional by setting the ContentTypeProperty.IsNillable to true. Following are the sample code and image showing the newly added properties.
The following document demonstrates the feature with sample code for your reference.
Working with ContentTypeProperties
Other enhancements and fixes
- Raise Exception similar to Excel instead of hanging program.
- Extend Range.RemoveDuplicates.
- Range.Copy performance for large volume.
- Support for TEXTJOIN() function.
- OLE objects become pictures when copying worksheets.
- Fixed an error where Saving as HTML was throwing an exception when the cell has a file reference.
- Handled an exception when calling Workbook.RemoveUnusedStyles().
To use these features and avail other enhancements and fixes, I recommend you to try the release Aspose.Cells for .NET v19.10. Moreover, I would recommend you to see Developers’ Guide for complete details on what you can implement using Aspose.Cells APIs. Also, you are always welcome to share your review, concerns or feedback on forums.