Aspose.Cells.Cpp 24.10.0

Spreadsheet Conversion & Manipulation C++ Library

Aspose.Cells for C++ is a high-performance native C++ library designed to handle Microsoft Excel® files programmatically. It supports a wide range of Excel® file formats, including XLS, XLSX, XLSM, and XLSB, as well as other formats such as CSV, TSV, and OpenOffice XML. With powerful features like direct cell manipulation, dynamic data handling, interactive hyperlinking, conditional formatting, customizable themes, chart creation, and file format conversions (Excel® to PDF, images, etc.), Aspose.Cells for C++ allows developers to build robust Excel® automation solutions without needing Microsoft Office or any other external software. Whether working on Windows®, Linux, or macOS, this library simplifies Excel® file processing with a rich API for formatting, formulas, data analysis, and more.

Aspose.Cells for C++ 24.10 Release Notes

Overview

Aspose.Cells for C++ 24.10 introduces new features, enhancements, bug fixes, and API changes that enhance the functionality, performance, and flexibility of handling Excel files. Below is a summary of the key improvements:

New Features

Delete Covered Rows/Columns

Support for deleting blank rows and columns between user-specified ranges, while considering shapes and other drawing objects.

Pivot Table Sources

Added support to retrieve the source of pivot tables from external connections, including DataModelConnection.

Compact Pivot Tables

Added the ability to create compact pivot tables easily.

Enhancements

Improved Handling for Formulas

Enhanced handling of automatic calculation to prevent hangs while writing to specific ranges.

Enhanced OleObject Parsing

Improvements made to OleObject parsing to prevent invalid cell name exceptions.

Date Formatting & Conversion

Enhanced date formatting to mimic Excel behavior, including improvements to OLAP pivot table conversion and shared directory hyperlinks.

Bug Fixes

Aspect Ratio Lock

Fixed issues where locking the aspect ratio for shapes did not reflect properly.

Chart & Image Conversion

Resolved errors when converting charts and shapes to images or PDFs.

Custom Functions and Formats

Fixed issues with custom formats, where negative signs were being removed or SUM with XLOOKUP disappeared.

Excel to ODS Conversion

Addressed multiple issues, including file corruption and pivot table discrepancies when converting Excel to ODS.

File Saving Issues

Fixed bugs related to workbook resaving causing corruptions and loss of protection on chart sheets.

Public API and Backwards Incompatible Changes

DeleteBlankRows()/DeleteBlankColumns() Behavior Changes

The behavior for deleting rows or columns with drawing objects has been unified. Use DeleteBlankOptions to control the handling of drawings as blank.

PivotTable Refresh Behavior

Exception behavior during pivot table refresh has been modified to return a state instead of breaking the program flow.

New Methods for API Enhancement

• Added methods to Cell for specifying formulas with parsing options.
• Extended DeleteBlankOptions to specify ranges and determine whether drawing-related objects should be considered blank.
• Added new methods for ExternalConnection and PivotTableCollection to enhance control over connections and pivot table configurations.

Deprecated and Obsolete Methods

Some methods in PivotTable and ExternalConnection are deprecated. Refer to updated alternatives.

For a complete list of features, enhancements, and bug fixes in this release please visit, Aspose.Cells for CPP 24.10 Release Notes.

Direct Cell Manipulation

• Precise Cell Addressing: Navigate your data using specific cell addresses (e.g., "A1", "B2").
• Named Ranges: Assign names to cell ranges for easier reference.
• Active Cell Control: Manage the selected cell for streamlined data entry.
• Range Operations: Perform calculations and apply formatting across cell blocks.

Dynamic Data Handling

• Seamless Data Input: Directly populate spreadsheets or import from external sources.
• Data Validation: Define rules to control input types and ranges.
• Formulaic Power: Use C++ to create custom functions and complex formulas.
• Data Manipulation: Perform sorting, filtering, and calculations on data.
• Data Output: Export data from C++ applications to Excel® files.

Interactive Hyperlinking

• Effortless Linking: Embed clickable hyperlinks within your spreadsheet.
• Hyperlink Management: Programmatically create, modify, or remove hyperlinks.

Flexible Layout Control

• Row and Column Resizing: Dynamically adjust dimensions.
• AutoFit for Precision: Automatically optimize cell sizes for content.

Conditional Formatting

• Dynamic Styling: Apply formatting based on criteria.
• Rich Visualizations: Use data bars, color scales, and icons for better visuals.

Customizable Themes

• Tailored Aesthetics: Apply custom themes for a consistent look.
• Theme Management: Copy themes between workbooks and modify them as needed.

Calculation Engine

• Formulaic Precision: Execute complex calculations with a wide range of functions.
• Real-time Updates: Automatic recalculation when cell values change.

Cells Formatting

• Font, Fill, Border, and Number Formatting: Customize fonts, backgrounds, borders, and number formats.
• Alignment and Protection: Adjust text alignment, wrapping, and protect cells from edits.

Charts and Chart Rendering

• Chart Types: Create bar, line, pie, and other chart types.
• Chart Customization: Modify elements like titles, axes, and data labels.
• Chart Rendering: Export charts as images with customizable settings.

Convert and Export Options

• Convert Excel® to PDF: Save workbooks as PDFs with security options.
• Export to Images: Convert worksheets to PNG, JPEG, BMP, and more.

Copying and Moving Data

• Worksheet Copying/Moving: Duplicate and reorder sheets within or between workbooks.
• Row/Column Copying: Duplicate rows or columns with ease.
• Theme Copying: Copy themes across workbooks for consistent design.

Table and Pivot Table Management

• Create and Format Tables: Create, style, and manipulate Excel® tables.
• Pivot Tables: Generate and customize pivot tables for data analysis.

OLE Objects

• Insert/Extract OLE Objects: Embed and extract OLE objects (charts, images) from worksheets.

Find or Search Data

• Find/Replace: Search for and replace text or values.
• Advanced Search: Use wildcards or regular expressions for precise searches.

Subtotals and Grouping

• Subtotal Creation: Automatically insert subtotals for grouped data.
• Grouping/Ungrouping: Collapse or expand row and column groups.

Supported File Formats

System Requirements

Development Environment

Windows®

Linux

macOS

Installing Aspose.Cells for C++ in Windows®

Using NuGet Package Manager

• Search for Aspose.Cells.Cpp in the NuGet Package Manager.
• Simply execute Install-Package Aspose.Cells.Cpp. If you already have Aspose.Cells for C++ and want to upgrade the version, please execute Update-Package Aspose.Cells.Cpp to get the latest version.

Using Include and lib Folders

• Download the latest files and unzip them.
• Reference the "Include" and "lib / dll" directories in your project.

Installing Aspose.Cells for C++ in Linux

• Download the latest files and unzip them.
• Reference the "Include" and "libAspose.Cells.so" directories in your project.

Installing Aspose.Cells for C++ in macOS

• Download the latest files and unzip them.
• Reference the "Include" and "libAspose.Cells.dylib" directories in your project.

Aspose.Cells for C++ Code Samples

Insert Multiple Rows in Excel® Worksheet using Aspose.Cells for C++

Learn how to insert multiple rows into an Excel® worksheet programmatically using Aspose.Cells for C++. This step-by-step guide demonstrates the usage of the InsertRows method to efficiently add rows in any position within a worksheet, making spreadsheet manipulation easier in C++ applications.

// Initialize Aspose.Cells library
Aspose::Cells::Startup();

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

// Define the path to the input directory
U16String dirPath(u"");

// Define the path to the output directory
U16String outPath(u"");

// Define the path to the input Excel® file
U16String sampleInsertingDeletingRowsAndColumns = dirPath + u"sampleInsertingDeletingRowsAndColumns.xlsx";

// Define the path to the output Excel® file
U16String outputInsertingDeletingRowsAndColumns = outPath + u"outputInsertingDeletingRowsAndColumns.xlsx";

// Load the Excel® file into a workbook object
Workbook workbook(sampleInsertingDeletingRowsAndColumns);

// Access the first worksheet in the workbook
Worksheet worksheet = workbook.GetWorksheets().Get(0);

// Insert 10 rows starting from the 3rd row (index 2) in the worksheet
worksheet.GetCells().InsertRows(2, 10);

// Save the updated Excel® file
workbook.Save(outputInsertingDeletingRowsAndColumns);

// Cleanup Aspose.Cells library resources
Aspose::Cells::Cleanup();

Source*

Apply Conditional Formatting in a Worksheet

The following example demonstrates how to apply conditional formatting to cells A1 and B2. The conditional formatting rule hides the red background color in these cells when values greater than 100 are entered into cells A2 and B2.

// Initialize Aspose.Cells library
Aspose::Cells::Startup();

// Define the path for output Excel® file
U16String outPath(u"");
U16String outputApplyConditionalFormattingInWorksheet = outPath + u"outputApplyConditionalFormattingInWorksheet.xlsx";

// Create an empty workbook
Workbook wb;

// Access the first worksheet
Worksheet ws = wb.GetWorksheets().Get(0);

// Add a new empty conditional formatting rule
int idx = ws.GetConditionalFormattings().Add();
FormatConditionCollection fcs = ws.GetConditionalFormattings().Get(idx);

// Define the range for conditional formatting (A1 and B2)
CellArea ca = CellArea::CreateCellArea(u"A1", u"A1");
fcs.AddArea(ca);
ca = CellArea::CreateCellArea(u"B2", u"B2");
fcs.AddArea(ca);

// Add a condition to format cells when their values are between the specified range
idx = fcs.AddCondition(FormatConditionType::CellValue, OperatorType::Between, u"=A2", u"100");
FormatCondition fc = fcs.Get(idx);

// Set the background color to red
fc.GetStyle().SetBackgroundColor(Color{ 0xff,0xff ,0 ,0 });

// Add a user-friendly message to explain the conditional formatting effect
U16String msgStr = u"Red color in cells A1 and B2 is due to Conditional Formatting. "
                   u"Enter a value >100 in A2 and B2 to see the red background disappear.";
ws.GetCells().Get(u"A10").PutValue(msgStr);

// Save the output Excel® file
wb.Save(outputApplyConditionalFormattingInWorksheet);

// Cleanup Aspose.Cells library
Aspose::Cells::Cleanup();

Source*

Tags

Aspose | GroupDocs |Spreadsheet Manipulation | Excel File Formats | C++ Excel API | Conditional Formatting | Data Handling | Chart Rendering | PDF Export | Excel to PDF | File Conversion | Pivot Tables | OLE Objects | Cell Manipulation | Interactive Hyperlinking | Custom Themes | Linux Support | macOS Support | Windows Support | NuGet Package | Excel Automation | Excel API | Spreadsheet Processing | Excel Export | SpreadsheetML | OpenOffice XML | CSV Support | TSV Support | Image Export | API Integration | Workbook Manipulation | Worksheet Formatting | Table Creation | Pivot Table Management