Follow on Google News News By Tag Industry News News By Place Country(s) Industry News
Follow on Google News |  Create, Manipulate Pivot Table, Manage Excel Tables & Document Properties in C++ AppsIt supports creation as well as manipulation of Pivot Tables. The API currently supports changing data at the source range of the PivotTable & then refreshes it. It also provides the ability to add conditional formatting rules to worksheet.
By: Aspose Aspose team is pleased to announce the new release of Aspose.Cells for C++ 16.12.0. This release has included many new features and enhancements that further improve the overall feature set of the API. This second release supports creation as well as the manipulation of the Pivot Tables. It also provides the IPivotTable class which represents a Pivot Table object whereas IPivotTableCollection represents a collection of Pivot Tables. The IPivotTableCollection can be accessed via the IWorksheet object and a new Pivot Table can be added to the collection. Besides creating new Pivot Tables, the APIs also support to manipulate existing Pivot Tables. The API currently supports to change the data at the source range of the Pivot Table and then refresh it. Once the Pivot Table has been manipulated as desired, it is best to use the new methods to refresh the Pivot Table against the updated data source. This release now provides the ability to add conditional formatting rules to the worksheet by exposing the IFormatCondition class. It also adds support for adding hyperlinks to the worksheet cells. Excel application supports 2 types of document properties such as System defined (built-in) and user-defined (custom). It also supports managing both types of document properties, built-in and custom. Aspose.Cells' IWorkbook class represents an Excel file. An Excel table is a matrix of cells containing any number of rows and columns whereas the same table is referred to be as a List Object in Aspose.Cells for C++ APIs. The Aspose::Cells:: · Apply Conditional formatting to the cells · Read/Write Custom Document Properties · Read/Write Built-in document properties · Add Hyperlinks to the cells · Support MS Excel Themes · Add and manipulate PivotTables in the spreadsheet · Group rows and columns in the worksheet · Add Table/List Object to the worksheet · License problem with Aspose.Cells for C++ APIs · Optimize the performance of saving XLS files Newly added documentation pages and articles Some new tips and articles have now been added into Aspose.Cells for C++ documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings. - Create Pivot Table inside the Worksheet: http://www.aspose.com/ - Manipulate Pivot Table inside the Worksheet: http://www.aspose.com/ Overview: Aspose.Cells for C++ Aspose.Cells is a C++ is a native C++ library that enables developers to create, read, edit & convert Excel spreadsheets programmatically without relying on Office automation or Microsoft Excel application. It offers a set of high-level API's to XLS and XLSX formats in the C++ language. Converting XLS to XLSX and XLSX to XLS is as easy and simple as a two liner code. It also supports saving and opening Excel files to and from streams, apply styles and formatting to Excel worksheets, filter data by using an AutoFilter , read and write complex formulae easily & more. More about Aspose.Cells for C++ - Homepage of Aspose.Cells for C++: http://www.aspose.com/ - Download Aspose.Cells for C++: http://downloads.aspose.com/ - Online documentation of Aspose.Cells for C++: http://www.aspose.com/ Contact Information Aspose Pty Ltd, Suite 163, 79 Longueville Road Lane Cove, NSW, 2066 Australia http://www.aspose.com/ sales@aspose.com Phone: 888.277.6734 Fax: 866.810.9465 End
|
| ||||||||||||||||||||||||||||||||||||||||||||
Account Phone Number