Aspose.Cells for .NET logo

We are pleased to announce the release of Aspose.Cells for .NET v19.1, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly - is fully documented. Please check the [document][2] on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features and other enhancements while keeping the product more stable and feature rich API. We also included important bug fixes as a part of this release. Moreover, fixing bugs and issues leads us to new enhancements and features which increases our customer base.

Please check the [release notes][3] which cover all the new features, enhancements and list of bugs that are resolved in this new version. New features are always introduced while enhancing this product which helps us to compete with the ever-growing software industry. Exceptions handling empowers the developers to keep control of the applications and assist users in a better way to continue using the application without any interruption. You will get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET.

Show Report Filter Pages Option in Pivot Table

MS Excel supports creating PivotTables, adding report filters, and enabling the “Show Report Filter Pages” option. Aspose.Cells has also provided this support now to enable the “Show Report Filter Pages” option on the created pivot table. As a result of this option, the created workbook will contain more worksheets in it. It will split every possible value of the report filter in a separate worksheet.

For a working example refer to the following article:

Work with Legacy Excel 95/5.0

MS Excel 95 support was not available earlier which was causing issues when using legacy Excel 95/5.0 files. This support is available now and these older file formats can be used now. For this purpose FileFormatType.Excel95 is introduced which can be used for opening these file formats.

For a working example refer to the following article:

Specify How to Cross String in Output PDF and Image

When the cell contains text or string but it is larger than the width of the cell, then the string overflows if the next cell in the next column is null or empty. When the MS Excel file is saved into PDF/Image, we can control this overflow by specifying the cross-type using the TextCrossType enumeration. It has the values TextCrossType.Default, TextCrossType.CrossKeep, TextCrossType.CrossOverride and TextCrossType.StrictInCell. This feature will create a similar output as Excel while rendering sheets to PDF and images.

For a working example refer to the following article:

Sorting Data Based on Cell Background Color

MS Excel provides a feature to sort data based on the background color. The same feature was required by some users while using Aspose.Cells. This feature is provided now by using DataSorter where SortOnType.CellColor can be used in the AddKey method to sort data based on the background color. All the cells which contain specified color in the AddKey(), function are placed on top or bottom according to the SortOrder setting, and the order of the rest of the cells is not changed at all.

For a working example refer to the following article:

Using custom functions from Add-in

In a common scenario, there can be custom formulas that we want to include as an Excel add-in. Setting the Cell.Formula value to some function, built-in functions work fine however there can be a need to set the custom functions or formulas using the add-in functions. Aspose.Cells provides features to register to add-in functions using Worksheets.RegisterAddInFunction method. Afterward when we set Cell.Formula attribute, the output Excel file shall contain the calculated value from the AddIn function. This feature is available now where an add-in can be registered and function from the newly added add-in can be called.

For a working example refer to the following article:

Other Enhancements and Fixes

There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows:

  • Detect if generated MHT file is a worksheet or not
  • Handled an exception that raised while converting to the Open Strict XML format
  • Handled an exception when loading an XLSB/XLSX file format
  • Handled an exception while calling Cells.DeleteBlankRows

In Aspose.Cells 19.1, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, using PageSetup options, importing objects into the worksheet, manipulating rows and columns, refreshing and calculating pivot tables, rendering and manipulating charts and shapes, [rendering images from Excel worksheets][4], [rendering images files from charts][5] and [exporting Excel workbooks to PDF format][6] have been resolved in the release. Moreover, Aspose.Cells formula calculation engine is further improved.

Changes to the Public API

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET:

  • Adds PivotTable.ShowReportFilterPageByName (string fieldName) method, shows all the report filter pages according to PivotField’s name, the PivotField must be located in the PageFields.

  • Adds PivotTable.ShowReportFilterPageByIndex(int posIndex) method , shows all the report filter pages according to the position index in the PageFields.

  • Adds **PivotTable.ShowReportFilterPage(PivotField pageField) method, **shows all the report filter pages according to PivotField, the PivotField must be located in the PageFields.

  • Adds **DataSorterKey and DataSorterKeyCollection class **, represents the key of the data sorter.

  • Adds **DataSorter.AddKey(Int32,SortOnType,SortOrder,Object) method, **adds the sort key such as cell’s background color, font color.

  • Adds **Aspose.Cells.DataSorter.Keys property, **gets all keys of the data sorter.

  • Adds **SortOnType enum, **represents the type of sorted data.

  • Adds ODSLoadOptions class, represents the options of loading ODS file.

  • Adds **HTMLLoadOptions.ProgId property, **gets the program id of creating the file. used only for MHT files.

  • Adds **PdfSaveOptions.TextCrossType property, **gets or sets displaying text type when the text width is larger than cell width.

  • Adds **TextCrossType enum class, **Enumerates displaying text type when the text width is larger than cell width.

  • Adds **WorksheetCollection.RegisterAddInFunction() methods, **replacement of Cell.SetAddInFormula(), a more convenient and efficient way for users to add and use addin functions.

  • Obsoletes **Cell.SetAddInFormula() method,**register the addin functions firstly by WorksheetCollection.RegisterAddInFunction() and then set the formula for Cell by Cell.Formula/Cell.SetFormula() instead.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks:

  • [Home of Aspose.Cells for .NET API][7].
  • Install Aspose for .NET APIs from NuGet repository
  • [Aspose.Cells for .NET Documentation][8] – up-to-date documentation containing Programmer’s Guide, Knowledge Base and much more.
  • [Aspose.Cells for .NET API Reference Guide][9] – detailing the publicly exposed classes, methods, properties, constants & interfaces.
  • [Aspose.Cells Product Family Forum][10] – post your technical questions and queries, or any other problem you are facing while working with Aspose.Cells APIs.
  • [Aspose.Cells for .NET Examples][11] – we have published our code examples on the social coding website GitHub.com. Anyone could explore the code examples for learning purposes.

[2]: https://docs.aspose.com/display/cellsnet/Installation#Installation-InstallAspose.Cells for .NETthroughNuGet [3]: https://docs.aspose.com/display/cellsnet/Aspose.Cells+for+.NET+19.1+Release+Notes [4]: https://docs.aspose.com/display/cellsnet/Converting+Worksheet+to+Different+Image+Formats [5]: https://docs.aspose.com/display/cellsnet/Chart+Rendering [6]: https://docs.aspose.com/display/cellsnet/Convert+Excel+Workbook+to+PDF [7]: https://products.aspose.com/cells/net [8]: https://docs.aspose.com/display/cellsnet/home [9]: https://reference.aspose.com/ [10]: https://forum.aspose.com/c/cells [11]: https://github.com/aspose-cells/Aspose.Cells-for-.NET