Getting Started

This page will show you how to install Aspose Cells for C++ and create a Hello World application.

Installation

Install Aspose Cells through NuGet

NuGet is the easiest way to download and install Aspose.Cells for C++.

1. Create a Microsoft Visual Studio project for C++.
2. Include header file “Aspose.Cells.h”.
3. Open Microsoft Visual Studio and NuGet package manager.
4. Search “aspose.cells.cpp” to find the desired Aspose.Cells for C++.
5. Click on “Install”, Aspose.Cells for C++ will be downloaded and referenced in your project.

You can also download it from the nuget web page for aspose.cells: Aspose.Cells for C++ NuGet Package

More step for details

A demo for using Aspose.Cells for C++ on Windows

1. Download Aspose.Cells for C++ from the following page: Download Aspose.Cells for C++(Windows)
2. Unzip the package and you will find a example which is on how to use Aspose.Cells for C++.
3. Open the example.sln with Visual Studio 2017 or higher version
4. main.cpp: this file shows how to code to test Aspose.Cells for C++

A demo for using Aspose.Cells for C++ on Linux

1. Download Aspose.Cells for C++ from the following page: Download Aspose.Cells for C++(Linux)
2. Unzip the package and you will find a example which is on how to use Aspose.Cells for C++ for Linux.
3. Make sure you are in the path where example is located.
4. Run “cmake -S example -B example/build -DCMAKE_BUILD_TYPE=Release”
5. Run “cmake –build example/build”

A demo for using Aspose.Cells for C++ on Mac OS

1. Download Aspose.Cells for C++ from the following page: Download Aspose.Cells for C++(MacOS)
2. Unzip the package and you will find a example which is on how to use Aspose.Cells for C++ for MacOS.
3. Make sure you are in the path where example is located.
4. Run “cmake -S example -B example/build -DCMAKE_BUILD_TYPE=Release”
5. Run “cmake –build example/build”

Creating the Hello World Application

The steps below creates the Hello World application using the Aspose.Cells API:

1. Create an instance of the Workbook class.
2. If you have a license, then apply it. If you are using the evaluation version, skip the license related code lines.
3. Access any desired cell of a worksheet in the Excel file.
4. Insert the words “Hello World!” into a cell accessed.
5. Generate the modified Microsoft Excel file.

The implementation of the above steps is demonstrated in the examples below.

Code Sample: Creating a New Workbook

The following example creates a new workbook from the scratch, inserts “Hello World!” into cell A1 on the first worksheet and saves the Excel file.

#include "Aspose.Cells.h"
using namespace Aspose::Cells;
	
int main(void)
{
	Aspose::Cells::Startup();

	try
	{
		// Create a License object
		License license;

		// Set the license of Aspose.Cells to avoid the evaluation limitations
		license.SetLicense(u"Aspose.Cells.lic");

		// Instantiate a Workbook object that represents Excel file.
		Workbook wb;

		// When you create a new workbook, a default "Sheet1" is added to the workbook.
		Worksheet sheet = wb.GetWorksheets().Get(0);

		// Access the "A1" cell in the sheet.
		Cell cell = sheet.GetCells().Get(u"A1");

		// Input the "Hello World!" text into the "A1" cell
		cell.PutValue(u"Hello World!");

		// Save the Excel file.
		wb.Save(u"MyBook_out.xlsx");
	}
	catch (const CellsException& ex)
	{
		std::cout << ex.GetErrorMessage().ToUtf8() << std::endl;
	}

	Aspose::Cells::Cleanup();
}

Code Sample: Opening an Existing File

The following example opens an existing Microsoft Excel template file, gets a cell and checks the value in the cell A1.

#include "Aspose.Cells.h"
using namespace Aspose::Cells;
	
/*Check result*/
#define EXPECT_TRUE(condition) \
		if (condition) printf("--%s,line:%d -> Ok --\n", __FUNCTION__, __LINE__); \
			 else  printf("--%s,line:%d->>>> Failed!!!! <<<<--\n", __FUNCTION__, __LINE__);
int main(void)
{
	Aspose::Cells::Startup();

	try
	{
		// Create a License object
		License license;

		// Set the license of Aspose.Cells to avoid the evaluation limitations
		//license.SetLicense(u"Aspose.Cells.lic");

		// Instantiate a Workbook object that represents Excel file.
		Workbook wb;//(u"MyBook_out.xlsx");

		// When you create a new workbook, a default "Sheet1" is added to the workbook.
		Worksheet sheet = wb.GetWorksheets().Get(0);

		// Access the "A1" cell in the sheet.
		Cell cell = sheet.GetCells().Get(u"A1");

		U16String strRet = cell.GetStringValue();
		//check value
		EXPECT_TRUE(strRet == u"Hello World!");

		// Save the Excel file.
		wb.Save(u"MyBook_out.xlsx");

	}
	catch (const CellsException& ex)
	{
		std::cout << ex.GetErrorMessage().ToUtf8() << std::endl;
	}

	Aspose::Cells::Cleanup();
}