Here at Aspose we work hard to make developers’ lives easier by providing easy‑to‑use, powerful APIs for managing documents of many formats. Aspose.Cells for C++ lets developers dynamically create, manipulate, and convert spreadsheets without requiring Office Automation or Microsoft Excel. [Aspose.Cells for C++ 16.11.0][1] is a native C++ library now available for public use.
While you download the API build to try it, here is a list of supported features with a few code snippets for quick testing.
Load & Save Spreadsheets
The first release of Aspose.Cells for C++ supports loading and saving Excel 97‑2003 Workbook format (XLS) and Open Office XML format (XLSX) from a file path or stream. The Workbook class represents a Microsoft Excel spreadsheet and provides the properties and methods needed to work with spreadsheet files. To load an existing spreadsheet, pass the file path (or stream) to the Workbook constructor. Use the Workbook.Save method to save the spreadsheet or convert it. The Save method offers many overloads, including one that accepts a value from the SaveFormat enumeration to specify the output format.
Worksheet Manipulation
Aspose.Cells for C++ exposes the WorksheetCollection and Worksheet classes to access worksheets. These classes support a wide range of features, including:
- Add & remove worksheets
- Copy & move worksheets
- Manage page breaks
- Manage worksheet views
Cell Manipulation
A cell is the basic unit of a spreadsheet and can contain data, a formula, and formatting such as font and shading. In Aspose.Cells for C++, a cell is represented by the Cell class, while a collection of cells is represented by the CellsCollection class. Key capabilities include:
- Access a specific cell or a visible range
- Add or retrieve data from a cell
- Format a cell or a range of cells
- Find data or formulas
- Trace precedent and dependent cells
- Create subtotals
Row & Column Manipulation
Aspose.Cells for C++ provides Row and