星星QT::读取excel （使用libxl）

一、上代码

#include "libxl.h"
#include <QDebug>
#include <QString>
#include <QElapsedTimer>
using namespace libxl;

// int ReadXlsTo(QString fileName )//将excel读取到内存中。
int main()
{
    QString filePath=QString::fromWCharArray(L"./Para.xls");
    Book *book = NULL;
    if(filePath.endsWith("xls", Qt::CaseInsensitive)) { //判断是否是.xls文件，不区分大小写
        book = xlCreateBook(); // xlCreateBook() for xls
    } else if(filePath.endsWith("xlsx", Qt::CaseInsensitive)) { //判断是否是.xlsx文件，不区分大小写
        book = xlCreateXMLBook(); // xlCreateXMLBook() for xlsx
    }
    //     版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
    //             原文链接：https://blog.csdn.net/wl362002000/article/details/118719400
    QElapsedTimer timer;
    if (book) {

        timer.start();
        // 打开 Excel 文件
        // if (book->load(L"./Para.xlsx")) {
        if (book->load(L"./Para.xls")) {
            //获取工作表的 数量。
            qDebug()<<"loadUseTime"<<timer.elapsed();timer.restart();
            int sheetCount = book->sheetCount();
            qDebug()<<sheetCount;
            // 遍历所有工作表。 row 行  col 列
            for (int sheetIndex = 0; sheetIndex < sheetCount; ++sheetIndex) {
                Sheet* sheet = book->getSheet(sheetIndex);

                if (sheet) {
                    qDebug()
                        << "Sheet:"
                        << QString::fromWCharArray(sheet->name())<<"\n"
                        <<"row:"<<sheet->lastRow()
                        <<" , col"<<sheet->lastCol();

                    // 获取行数和列数
                    int rowCount = sheet->lastRow();
                    int colCount = sheet->lastCol();

                    // 读取所有数据
                    for (int row = 0; row <= rowCount; ++row) {
                        for (int col = 0; col <= colCount; ++col) {
                            CellType cellType = sheet->cellType(row, col);

                            switch (cellType) {
                            case CELLTYPE_EMPTY:
                                qDebug() << "Row:" << row << ", Col:" << col << " - Empty cell";
                                break;
                            case CELLTYPE_NUMBER:
                                qDebug() << "Row:" << row << ", Col:" << col << " - Number:" << sheet->readNum(row, col);
                                break;
                            case CELLTYPE_STRING:
                                qDebug() << "Row:" << row << ", Col:" << col << " - String:" << QString::fromStdWString( sheet->readStr(row, col));
                                break;
                                // 处理其他数据类型...

                            default:
                                qDebug() << "Row:" << row << ", Col:" << col << " - Unknown cell type";
                                break;
                            }
                        }
                    }
                } else {
                    qDebug() << "Sheet not found.";
                }
            }

            // 关闭 Excel 文件
            book->release();
        } else {
            qDebug() << "Failed to load Excel file.";
        }
    } else {
        qDebug() << "Failed to create LibXL book.";
    }

    return 0;
}