C++ APIs to manipulate Excel spreadsheets

Build C++ application having the ability to Create, Read, Edit, Render or Convert Excel spreadsheets without requiring Microsoft Excel.

  Download Free Trial
Aspose.Cells for C++

Aspose.Cells for C++

 
 

Aspose.Cells for C++ is a native C++ library that offers a set of high-level APIs for most commonly used spreadsheet formats such as XLS, XLSX, XLSM and XLSB. Aspose.Cells for C++ allows you to build high performance C++ applications having the capabilities to create, manipulate, convert or render Excel spreadsheets without relying on Office Automation or Microsoft Excel application.

 

Advanced C++ Excel Spreadsheet API Features

Aspose.Cells for C++ includes the following features:

 

Load & save Excel files using streams

 

Create & manipulate charts

 

Set data validation to restrict input

 

Organize data by grouping rows & columns

 

Manipulate built-in & custom properties

 

Add & manipulate hyperlinks

 

Create & manipulate Pivot Tables

 

Change the look of your workbook using themes

 

Create tables & list objects

 

Manipulate drawing objects

 

Apply styles and formatting to cells, rows, columns or ranges

 

Trace Precedents & Dependents

 

Read, write & calculate complex formulas

 

Add or extract OLE objects

 

Create conditional formatting rules

 

Create and implement user-defined Functions

 

Convert Chart to PDF format

 

Convert Chart to Image format

Zero Dependency on Microsoft Excel

Aspose APIs are totally independent and are not affiliated with, nor authorized, sponsored, or otherwise approved by Microsoft Corporation. Aspose.Cells for C++ never needs Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats.

Simple & Reliable Conversion of Excel Formats

Aspose.Cells for C++ is a powerful set of APIs that provide the ability to inter-convert Excel file formats without worrying about the format specific details. The API allows you to convert spreadsheets from any supported format to any other supported format with just two lines of code. It is that simple!

Save spreadsheet in different formats - C++

// load the file to be converted
intrusive_ptr<IWorkbook> book = Factory::CreateIWorkbook(dir->StringAppend(new String("template.xls")));
// save in different formats
book->Save(dir->StringAppend(new String("output.xlsx")), SaveFormat_Xlsx);
book->Save(dir->StringAppend(new String("output.xlsb")), SaveFormat_Xlsb);
book->Save(dir->StringAppend(new String("output.csv")), SaveFormat_CSV);

Comprehensive Spreadsheet Formatting

Aspose.Cells for C++ gives you complete control over how you wish to present your data onto the worksheet, by offering advanced formatting features. You can apply formatting to individual row, column, cell, or you can create a range of cells and apply formatting to it. You can also add rich text to a cell, apply borders, set background patterns or tweak font related styling aspects.

Visualize Data With Charts

Aspose.Cells for C++ offers a comprehensive set of APIs to dynamically create all of the standard and custom chart types supported by Excel application. The API also provides the ability to update the data source for an existing chart and refresh it.

Render Excel Worksheets as Images

Aspose.Cells for C++ has its own rendering engine specially designed for rendering with highest of fidelity to the Microsoft Excel. It offers distinctive feature such as rendering Excel worksheets to images in popular formats including BMP, TIFF, PNG, JPEG & EMF. The Sheet2Image process is flexible thus allowing you to choose options such as controlling the resultant image's resolution.

Manipulate Rows & Columns

Aspose.Cells for C++ allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width or auto resize the cell dimensions according to the contents in it. The API also offers the means to insert & delete, hide & un-hide as well as group & un-group rows and columns.

Accurately Convert Excel Spreadsheets to PDF

The Excel C++ library provides the ability to convert Excel spreadsheets to PDF format while retaining the same quality as the original document. This fact makes Aspose.Cells for C++ a perfect choice for the organizations which require to exchange documents in industry standard formats as PDF.

 

Support and Learning Resources