使用C ++从Excel文件中提取数据

#include<iostream>
#include <xlsxwriter.h>

int main() {
    // 创建一个Excel文件
    lxw_workbook *workbook = workbook_new("example.xlsx");

    // 创建一个工作表
    lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);

    // 写入一些数据
    worksheet_write_string(worksheet, 0, 0, "Hello", NULL);
    worksheet_write_number(worksheet, 1, 0, 123, NULL);

    // 关闭工作簿并保存文件
    workbook_close(workbook);

    // 打开文件并读取数据
    lxw_workbook *workbook_read = workbook_open("example.xlsx");
    lxw_worksheet *worksheet_read = workbook_get_worksheet_by_index(workbook_read, 0);

    // 读取数据
    const char *str = worksheet_read_string(worksheet_read, 0, 0);
    double num = worksheet_read_number(worksheet_read, 1, 0);

    // 输出数据
    std::cout << "String: "<< str<< std::endl;
    std::cout << "Number: "<< num<< std::endl;

    // 关闭工作簿
    workbook_close(workbook_read);

    return 0;
}