Aspose.Cells.Cpp 20.7.0

Aspose.Cells for C++ is a native C++ API for Excel Spreadsheet manipulation. Applications can perform functions such as creating, converting and manipulating spreadsheet's Built-In and Custom Properties, Themes, Styles and Formatting, Data Validation, Conditional Formatting, Reading, Writing and Calculating Formulas, Grouping Rows and Columns and much more without relying on Office Automation or Microsoft Excel. API supports most commonly used spreadsheet formats such as XLS, XLSX, XLSM and XLSB.

Rich Set of Features

• Zero Dependency on Microsoft Excel®
• Simple and Reliable Conversion of Excel Formats
• Comprehensive Spreadsheet Formatting
• Render Excel Worksheets as Images
• Manipulate Rows and Columns
• Visualize Data With Charts

Free support for Aspose.Cells for C++ is provided on our support forum:
https://forum.aspose.com/
Aspose.Cells  for C++ API Reference:
https://apireference.aspose.com/cpp/cells

Install-Package Aspose.Cells.Cpp -Version 20.7.0
dotnet add package Aspose.Cells.Cpp --version 20.7.0
<PackageReference Include="Aspose.Cells.Cpp" Version="20.7.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells.Cpp --version 20.7.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

C++ Library for Excel File Formats

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.

Excel File Processing Features

New Features in Version 20.7

This release offers some enhancements. For the detailed notes, please visit Aspose.Cells for C++ 20.7 Release Notes Windows.

Read & Write Formats

Microsoft Excel: XLS, XLSX, XLSB
Text: CSV, TSV
OpenDocument: ODS
Others: HTML, MHTML

Save Spreadsheet Documents As

Microsoft Excel: XLSM, XLTX, XLTM, XLAM
Fixed Layout: PDF, XPS
Images: JPEG, PNG, BMP, TIFF, GIF, EMF, SVG

Getting Started with Aspose.Cells for C++

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 below snippet to see how API works in your environment or check the GitHub Repository for other common usage scenarios.

// 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);

Create a Custom Excel Chart with C++

// create a new workbook
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook();

// get first worksheet which is created by default
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// add sample data
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(100);
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(150);
worksheet->GetICells()->GetObjectByIndex(new String("A4"))->PutValue(110);
worksheet->GetICells()->GetObjectByIndex(new String("B1"))->PutValue(260);
worksheet->GetICells()->GetObjectByIndex(new String("B2"))->PutValue(12);
worksheet->GetICells()->GetObjectByIndex(new String("B3"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("B4"))->PutValue(100);

// add a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType::ChartType_Column, 5, 0, 20, 8);

// access the instance of the newly added chart
intrusive_ptr<Aspose::Cells::Charts::IChart> chart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);

// add SeriesCollection (chart data source) to the chart ranging from A1 to B4
chart->GetNISeries()->Add(new String("A1:B4"), true);

// set the chart type of 2nd NSeries to display as line chart
chart->GetNISeries()->GetObjectByIndex(1)->SetType(Aspose::Cells::Charts::ChartType::ChartType_Line);

// save the Excel file
workbook->Save(new String("output.xlsx")));

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

C++ Library for Excel File Formats

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.

Excel File Processing Features

New Features in Version 20.7

This release offers some enhancements. For the detailed notes, please visit Aspose.Cells for C++ 20.7 Release Notes Windows.

Read & Write Formats

Microsoft Excel: XLS, XLSX, XLSB
Text: CSV, TSV
OpenDocument: ODS
Others: HTML, MHTML

Save Spreadsheet Documents As

Microsoft Excel: XLSM, XLTX, XLTM, XLAM
Fixed Layout: PDF, XPS
Images: JPEG, PNG, BMP, TIFF, GIF, EMF, SVG

Getting Started with Aspose.Cells for C++

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 below snippet to see how API works in your environment or check the GitHub Repository for other common usage scenarios.

// 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);

Create a Custom Excel Chart with C++

// create a new workbook
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook();

// get first worksheet which is created by default
intrusive_ptr<IWorksheet> worksheet = workbook->GetIWorksheets()->GetObjectByIndex(0);

// add sample data
worksheet->GetICells()->GetObjectByIndex(new String("A1"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("A2"))->PutValue(100);
worksheet->GetICells()->GetObjectByIndex(new String("A3"))->PutValue(150);
worksheet->GetICells()->GetObjectByIndex(new String("A4"))->PutValue(110);
worksheet->GetICells()->GetObjectByIndex(new String("B1"))->PutValue(260);
worksheet->GetICells()->GetObjectByIndex(new String("B2"))->PutValue(12);
worksheet->GetICells()->GetObjectByIndex(new String("B3"))->PutValue(50);
worksheet->GetICells()->GetObjectByIndex(new String("B4"))->PutValue(100);

// add a chart to the worksheet
int chartIndex = worksheet->GetICharts()->Add(Aspose::Cells::Charts::ChartType::ChartType_Column, 5, 0, 20, 8);

// access the instance of the newly added chart
intrusive_ptr<Aspose::Cells::Charts::IChart> chart = worksheet->GetICharts()->GetObjectByIndex(chartIndex);

// add SeriesCollection (chart data source) to the chart ranging from A1 to B4
chart->GetNISeries()->Add(new String("A1:B4"), true);

// set the chart type of 2nd NSeries to display as line chart
chart->GetNISeries()->GetObjectByIndex(1)->SetType(Aspose::Cells::Charts::ChartType::ChartType_Line);

// save the Excel file
workbook->Save(new String("output.xlsx")));

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

Release Notes

https://docs.aspose.com/display/cellscpp/Aspose.Cells+for+CPP+20.7+Release+Notes+Windows

Dependencies

This package has no dependencies.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Aspose.Cells.Cpp:

Package Downloads
Aspose.Total.Cpp
Aspose.Total for C++ is a complete package of C++ libraries specifically designed to create, manipulate and convert popular file formats from Microsoft Office and PDF without requiring Office or Adobe Automation. C++ API package also includes a specialized library to generate and recognize barcode labels from images with advanced features to customize the barcode generation and recognition process.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
20.7.0 129 7/21/2020
19.11.0 481 11/27/2019
19.10.0 182 10/11/2019
19.8.2 186 8/29/2019
19.8.0 144 8/28/2019
19.4.0 294 4/10/2019
19.3.1 264 3/22/2019
19.1.0 262 1/23/2019
18.8.0 397 8/21/2018
18.5.0 435 5/18/2018