• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

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

Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

Aspose is proud to expand its APIs family with the addition of a new product known as Aspose.Cells for C++ 16.12.0 has been released. 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
- Manipulate Pivot Table inside the Worksheet

Overview: Aspose.Cells for C++

Aspose.Cells is a C++ component for spreadsheet reporting without using Microsoft Excel. Other features include creating spreadsheets, opening encrypted excel files, macros, VBA, unicode, formula settings, pivot tables, importing data from JDBC ResultSet and support of CSV, SpreadsheetML, PDF, ODS and all file formats from Excel 97 to Excel 2007. It is compatible with Windows, Linux & Unix and supports all advanced features of data management, formatting, worksheet, charting and graphics.

More about Aspose.Cells for C++

- Homepage of Aspose.Cells for C++
- Download Aspose.Cells for C++
- Online documentation of Aspose.Cells for C++

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Aspose - The .NET and Java component publisher
Phone: 888.277.6734
Fax: 866.810.9465
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    Bookmark Topic Watch Topic
  • New Topic