Aspose.Cells.Cpp 24.9.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.

What's new in the Aspose.Cells for C++ v24.9.0

Aspose.Cells for C++ 24.9 brings a host of new features and improvements for developers working with spreadsheet documents. This release enhances custom function capabilities, Object-type function support, and provides better math equation rendering.

New Features

• Custom Functions via AbstractCalculationEngine (CELLSCPP-1108):
  Developers can now implement custom functions using the AbstractCalculationEngine feature, allowing more flexibility in calculations.
• Object-Type Function Support (CELLSCPP-1109 & CELLSCPP-1110):
  Supports passing and returning Object-type objects as function parameters, enhancing data manipulation and calculations.
• MathML Export (CELLSNET-56319):
  Export equation content to MathML format, ensuring compatibility with modern web standards.

Enhancements

• Optimize PDF Conversion (CELLSNET-56593 & CELLSNET-56594):
  Optimized image resource release and data handling for faster PDF conversion.

Bug Fixes

• Incorrect Annotation Display (CELLSNET-56624):
  Fixed an issue where range names were not working in XLSB format.

For a complete list of features, enhancements, and bug fixes in this release please visit, Aspose.Cells for CPP 24.9 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