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 Demo which is on how to use Aspose.Cells for C++.
3. Open the Demo.sln with Visual Studio 2017 or higher version
4. main.cpp: this file shows how to code to test Aspose.Cells for C++
5. sourceFile/resultFile: these two folders are storage directories used in main.cpp

How to use Aspose.Cells for C++ on Linux OS

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 Demo which is on how to use Aspose.Cells for C++ for Linux.
3. Run “cd Demo” in your Linux command line
4. Run “rm -rf build;mkdir build;cd build”
5. Run “cmake ..” will create a Makefile by CMakeLists.txt in Demo folder
6. Run “make” to compile
7. Run “./demo” you will see the result

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"
int main(void)
{
	try
	{
		// Create a License object
		intrusive_ptr<License> license = new License();

		// Set the license of Aspose.Cells to avoid the evaluation limitations
		license->SetLicense(new String("Aspose.Cells.lic"));

		// Instantiate a Workbook object that represents Excel file.
		intrusive_ptr<IWorkbook> wb = Factory::CreateIWorkbook();

		// When you create a new workbook, a default "Sheet1" is added to the workbook.
		intrusive_ptr <IWorksheet> sheet = wb->GetIWorksheets()->GetObjectByIndex(0);

		// Access the "A1" cell in the sheet.
		intrusive_ptr <ICell> cell = sheet->GetICells()->GetObjectByIndex(new String("A1"));

		// Input the "Hello World!" text into the "A1" cell
		cell->PutValue((StringPtr)(new String("Hello World!")));

		// Save the Excel file.
		wb->Save(new String("MyBook_out.xlsx"));
	}
	catch (Exception& ex)
	{
		Console::WriteLine(ex.GetMessageExp());
	}
}

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"
/*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)
{
	try
	{
		// Create a License object
		intrusive_ptr<License> license = new License();

		// Set the license of Aspose.Cells to avoid the evaluation limitations
		//license->SetLicense(new String("Aspose.Cells.lic"));

		// Instantiate a Workbook object that represents Excel file.
		intrusive_ptr<IWorkbook> wb = Factory::CreateIWorkbook(new String("MyBook_out.xlsx"));

		// When you create a new workbook, a default "Sheet1" is added to the workbook.
		intrusive_ptr <IWorksheet> sheet = wb->GetIWorksheets()->GetObjectByIndex(0);

		// Access the "A1" cell in the sheet.
		intrusive_ptr <ICell> cell = sheet->GetICells()->GetObjectByIndex(new String("A1"));

		StringPtr strRet = cell->GetStringValue();
		//check value
		EXPECT_TRUE(StringHelperPal::Compare(strRet,(StringPtr)(new String("Hello World!")))==0);

		// Save the Excel file.
		wb->Save(new String("MyBook_out.xlsx"));

	}
	catch (Exception& ex)
	{
		Console::WriteLine(ex.GetMessageExp());
	}
}