How to Integrate Spire.XLS for C++ in a C++ Application

Spire.XLS for C++ is an Excel library built for developers to manipulate Excel documents (XLS, XLSX, XLSB and XLSM) in any type of C++ applications. This article demonstrates how to integrate Spire.XLS for C++ into your C++ application in two different ways.

Install Spire.XLS for C++ via NuGet

Step 1

Create a C++ project in Visual Studio 2022.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 2

Right-click 'References' in the Solution Explorer and choose 'Manage NuGet Package' in the popup menu.

How to Integrate Spire.XLS for C++ in a C++ Application

Click 'Browse', search for 'spire.xls.cpp', and install it in your project.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 3

Right-click 'Source Files' in the Solution Explorer, choose 'Add' and then 'New Item'.

How to Integrate Spire.XLS for C++ in a C++ Application

Create a .cpp file.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 4

Click the .cpp file you just created to write code. Before starting, you need to include the header file “Spire.Xls.o.h” by adding the following line of code to your program.

  • C++
#include "Spire.Xls.o.h"

The code example below shows you how to create a simple Excel file using Spire.XLS for C++.

How to Integrate Spire.XLS for C++ in a C++ Application

Install Spire.XLS for C++ by Manually Importing Libraries

Step 1

Download Spire.XLS for C++ package and unzip it somewhere on your disc to get the following files.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 2

Create a C++ project in Visual Studio 2022.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 3

Copy the 'include' folder and the 'lib' folder from the product package to your project, and save them under the same folder where the .sln file exists.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 4

Right-click the project name and select 'Properties'.

How to Integrate Spire.XLS for C++ in a C++ Application

Configure output directory. Depending on the build mode (Debug or Release) you choose, you can set the output directory to '..\lib\x64\debug' or '..\lib\x64\release'.

How to Integrate Spire.XLS for C++ in a C++ Application

Click 'C/C++', select 'Command Line', and then input '/bigobj' in the 'Additional Options' field.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 5

Right-click 'Source Files' in the Solution Explorer, choose 'Add' and then 'New Item'.

How to Integrate Spire.XLS for C++ in a C++ Application

Create a .cpp file.

How to Integrate Spire.XLS for C++ in a C++ Application

Step 6

Click the .cpp file you just created to write code. Before starting, you need to include the following two lines of code to your program.

  • C++
#include "../include/Spire.Xls.o.h"
#pragma comment(lib,"../lib/x64/debug/Spire.Xls.Cpp.lib")

The code example below shows you how to create a simple Excel file using Spire.XLS for C++.

How to Integrate Spire.XLS for C++ in a C++ Application