Aspose.Cells.Cpp 24.8.0

C++ Library for Excel File Formats

Product Page | Docs | Demos | API Reference | Examples | Blog | Releases | Free Support | Temporary License

Aspose.Cells for C++ is a native C++ library to create, manipulate, process, and convert Microsoft Excel® files without needing Microsoft Office® or Automation. The Excel C++ API supports Excel 97-2003 (XLS), Excel 2007-2013/2016 (XLSX, XLSM, XLSB), OpenOffice XML, and other formats such as CSV, TSV, and more.

It allows the developers to work with spreadsheet rows, columns, data, formulas, pivot tables, worksheets, tables, charts, and drawing objects from their own C++ applications.

What is Aspose.Cells for C++?

Aspose.Cells for C++ is a native C++ on premise API to integrate Spreadsheet creation, manipulation and conversion features into your C++ Apps. It supports working with many popular spreadsheet file formats from Microsoft Excel (XLS, XLSX, XLSB, CSV, etc.) and OpenOffice/LibreOffice (ODS).

You can use Aspose.Cells for C++ to develop 32-bit (Windows® x86) & 64-bit applications in any development environment that supports C++, such as, Microsoft Visual Studio. Aspose.Cells for C++ is a native assembly that can be deployed by simply copying it. You do not have to worry about other services or modules.

Aspose.Cells for C++ allows you to work with the built-in as well as the custom document properties in Microsoft Excel. Supports high-quality conversion of Excel Workbooks to PDF/A compliant files. Work with formulas, pivot tables, worksheets, tables, ranges, charts, OLE objects and much more.

Supported Operating Systems

The Aspose.Cells for C++ library supports the following 64-bit or 32-bit operating systems and platform:

• Microsoft Windows®: Windows x86, Windows x86_64
• Linux: Linux x86_64
• macOS: macOS 11 or Later (arm64, x86_64)

Excel File Processing Features

• Open a spreadsheet file without Microsoft Excel.
• Open an Excel file via a path on the local computer or using a stream.
• Convert worksheet to different image formats.
• Apply conditional formatting as per your choice.
• Manipulate pivot tables in your spreadsheets.
• Convert table to range without losing formatting.
• Fetch a cell's name by providing the row and column index, similarly, fetch row and column index of the cell from its name.
• Create Pyramid chart, Line chart, Bubble chart, or a custom chart.
• Render charts to images or PDF.
• Insert an OLE object into the worksheet.
• Access all the OLE objects contained in the worksheet for extraction.

What's New in v.24.8.0

This release of Aspose.Cells for C++ includes several improvements, new features, enhancements, and bug fixes. Here are the key updates:

New Features:

• Enhanced Pivot Table Sorting: Added support for sorting Pivot Table by specific field items, including the ability to sort by Pivot Field Item (CELLSNET-46200, CELLSNET-55104).
• Improved Data Manipulation: Introduced support for the VALUETOTEXT function, allowing more flexibility in handling cell data (CELLSNET-56269).
• Picture Placement in Cells: Now you can easily visit all cells containing “Place in Cell” pictures, enhancing your ability to manage visual data in your spreadsheets (CELLSNET-56093).

Enhancements:

• Formula Editing: Enhanced the editing of formulas by supporting blank spaces, making formula creation more intuitive (CELLSNET-55865).
• Security Enhancement: Document properties are now excluded from encryption when encrypting files, ensuring that metadata remains accessible (CELLSNET-56354).

Bug Fixes:

• Excel to PDF Rendering: Resolved multiple issues where characters were rendered incorrectly, and text content was inconsistently rendered compared to Excel’s native PDF output (CELLSNET-56207, CELLSNET-56301).
• Chart and Image Rendering: Fixed various issues related to chart and image rendering, including missing labels and incorrect alignment of chart elements (CELLSNET-56198, CELLSNET-56280, CELLSNET-56290).
• Excel File Conversion Errors: Addressed problems where Excel files were converted into PDFs or other formats with multiple pages when only one was expected, and corrected errors related to underline display and HTML output (CELLSNET-56190, CELLSNET-56248, CELLSNET-56315).
• Pivot Table and Worksheet Integrity: Solved issues where formatting was lost or corrupted during save operations involving Pivot Tables and worksheets, and fixed errors that caused worksheets to crash when opened (CELLSNET-44955, CELLSNET-46995, CELLSNET-56234).
• Data Import/Export: Improved the handling of JSON data within Excel, preventing data misplacement and ensuring proper attribute export (CELLSNET-56240, CELLSNET-56241).

Public API Changes:

• New Enum and Methods: Introduced the MergedCellsShrinkType enum to manage how merged cells shrink when deleting blank rows/columns, and added new methods to support LaTeX and MathML conversion, as well as enhancing sorting capabilities in Pivot Tables (CELLSNET-56406, CELLSNET-56407).
• Enhanced HTML and JSON Handling: Added methods to handle HTML character entities as decimal codes and to manage JSON schemas during Excel to JSON conversions (CELLSNET-56354, CELLSNET-56407).

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

Supported Read & Write Formats

• Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, XML, OTS, TabDelimited, SpreadsheetML
• OpenOffice®: ODS, SXC, FODS
• Text: TXT, JSON
• Web: HTML, MHTML
• Numbers: Apple’s iWork office suite Numbers app documents
• eBook: EPUB

Supported Output Only Formats

• Microsoft Word®: DOCX
• Microsoft PowerPoint®: PPTX
• Microsoft Excel®: XLAM
• Fixed Layout: PDF, PDF/A, XPS
• Data Interchange: DIF
• Vector Graphics: SVG
• Image: TIFF, PNG, BMP, JPEG, GIF
• Metafile: EMF
• Markdown: MD
• Other: SQL, XHTML

Get Started

Are you ready to give Aspose.Cells for C++ a try? Simply execute Install-Package Aspose.Cells.Cpp from Package Manager Console in Visual Studio to fetch the NuGet package. 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.

Convert XLS to XLSX, XLSB & CSV using C++

Try executing the below snippet to see how API works in your environment or check the GitHub Repository for other common usage scenarios.

U16String dir(u"your path");
// load the file to be converted
Workbook book(dir + u"template.xls");
// save in different formats
book.Save(dir + u"output.xlsx", SaveFormat::Xlsx);
book.Save(dir + u"output.xlsb", SaveFormat::Xlsb);
book.Save(dir + u"output.csv", SaveFormat::CSV);
book.Save(dir + u"output.json", SaveFormat::Json);

Create a Custom Excel Chart with C++

// create a new workbook
Workbook workbook;

// get first worksheet which is created by default
Worksheet worksheet = workbook.GetWorksheets().Get(0);

// add sample data
worksheet.GetCells().Get(u"A1").PutValue(50);
worksheet.GetCells().Get(u"A2").PutValue(100);
worksheet.GetCells().Get(u"A3").PutValue(150);
worksheet.GetCells().Get(u"A4").PutValue(110);
worksheet.GetCells().Get(u"B1").PutValue(260);
worksheet.GetCells().Get(u"B2").PutValue(12);
worksheet.GetCells().Get(u"B3").PutValue(50);
worksheet.GetCells().Get(u"B4").PutValue(100);

// add a chart to the worksheet
int chartIndex = worksheet.GetCharts().Add(Aspose::Cells::Charts::ChartType::Column, 5, 0, 20, 8);

// access the instance of the newly added chart
Chart chart = worksheet.GetCharts().Get(chartIndex);

// add SeriesCollection (chart data source) to the chart ranging from A1 to B4
chart.GetNSeries().Add(u"A1:B4", true);

// set the chart type of 2nd NSeries to display as line chart
chart.GetNSeries().Get(1).SetType(
	Aspose::Cells::Charts::ChartType::Line);

// save the Excel file
workbook.Save(u"output.xlsx");

Product Page | Docs | Demos | API Reference | Examples | Blog | Releases | Free Support | Temporary License