How to Write Data to an Excel File Using C++

A detailed guide on writing data to an Excel file using C++ and the openxlsx library. This article provides the necessary steps to create and write data to an Excel file easily.

In this article, we will learn how to write data to an Excel file using C++. We will use the openxlsx library, which makes it easy to manipulate Excel files without requiring Microsoft Office installation.

C++ code

#include <iostream>
#include <openxlsx.hpp>

int main() {
    // Create a new workbook
    openxlsx::Workbook workbook;

    // Create a new worksheet
    openxlsx::Worksheet* sheet = workbook.addWorksheet("Sheet1");

    // Write headers to cells
    sheet->write("A1", "Name");
    sheet->write("B1", "Age");
    sheet->write("C1", "Address");

    // Write data to cells
    sheet->write("A2", "Nguyen Van A");
    sheet->write("B2", 30);
    sheet->write("C2", "Hanoi");

    sheet->write("A3", "Tran Thi B");
    sheet->write("B3", 25);
    sheet->write("C3", "Da Nang");

    // Save the Excel file
    workbook.saveToFile("data.xlsx");

    std::cout << "Successfully wrote content to the Excel file!" << std::endl;
    return 0;
}

Detailed explanation

1. Library openxlsx.hpp: This library provides the necessary functions to work with Excel files.
2. Workbook: Creates a new workbook to hold data.
3. addWorksheet("Sheet1"): Creates a new worksheet named "Sheet1".
4. write(...): Writes data to cells in the worksheet. You can write both strings and numbers.
5. saveToFile("data.xlsx"): Saves the workbook as an Excel file named "data.xlsx".
6. std::cout: Prints a message to the console.

System Requirements:

• C++11 or later
• openxlsx library

How to install the libraries needed to run the C++ code above:

1. Download the openxlsx library from Github.
2. Add the library path to your project.
3. Compile the source code along with the installed library.

Tips:

• Make sure you have installed the correct version of the openxlsx library to avoid compilation errors.
• Validate input data before writing it to the Excel file to ensure accuracy.

---