Create, Manipulate Pivot Table, Manage Excel Tables & Document Properties in C++ Apps

2024-11-01 11:14:32 Computer

1046

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::Tables namespace contains all the necessary classes that deals with the operations related to the List Objects. Most worth mentioning classes are IListObject and IListObjectCollection which allow to create and format List Objects and so on. Aspose.Cells for C++ API can be used to group rows & columns while using the ICells class which is basically the collection of all cells in a given worksheet. The ICells class offers the GroupRows and GroupColumns methods in order to group rows and columns respectively. There are several other enhancements with this release, such as the ability to apply the custom theme colors, ability to copy theme across workbooks and support for manipulation of theme colors. This release includes several enhanced features and bug fixes as listed below

? 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/docs/display/cellscpp/Create+Pivot+Table+inside+the+Worksheet

- Manipulate Pivot Table inside the Worksheet: http://www.aspose.com/docs/display/cellscpp/Manipulate+Pivot+Table+inside+the+Worksheet

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/products/cells/cpp

- Download Aspose.Cells for C++: http://downloads.aspose.com/cells/cpp

- Online documentation of Aspose.Cells for C++: http://www.aspose.com/docs/display/cellscpp/Home

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