目录

qmake

QT += gui axcontainer
CONFIG += c++11 console
CONFIG -= app_bundle
DEFINES += QT_DEPRECATED_WARNINGS

QXLSX_PARENTPATH=./         # current QXlsx path is . (. means curret directory)
QXLSX_HEADERPATH=./header/  # current QXlsx header path is ./header/
QXLSX_SOURCEPATH=./source/  # current QXlsx source path is ./source/
include(./QXlsx.pri)

SOURCES += \
        exceloperator.cpp \
        main.cpp \
        mysqloperator.cpp \
        redisoperator.cpp

# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target

HEADERS += \
    exceloperator.h \
    mysqloperator.h \
    redisoperator.h

生成excel并写入保存

void use(){
    //生成一个excel
    QXlsx::Document xlsx;
    //覆盖写入
    xlsx.write(1,1, "Hello Qt!");
    //读取
    QVariant cell = xlsx.read(1,1);
    qDebug()<< cell.toString() ;
    //另存为
    xlsx.saveAs("../Test2.xlsx"); // save the document as 'Test.xlsx'

    //打开excel
    QXlsx::Document xlsxR("../Test2.xlsx");

    // 设置一些样式
    QXlsx::Format titleFormat;
    titleFormat.setBorderStyle(QXlsx::Format::BorderThin);  // 边框样式
    titleFormat.setHorizontalAlignment(QXlsx::Format::AlignHCenter);   // 设置对齐方式

    xlsxR.write(1,1, "Hello 123123123Qt!",titleFormat);

    qDebug()<< sizeof(A);
    //保存
    xlsxR.save();
}

读取excel

int use2(){
    QXlsx::Document xlsxR("../Test2.xlsx");
    TargetInfo targets[10];


    //生成一个excel
    QXlsx::Document xlsx;

    for(int i = 2;i < 12;i++){
        for(int j = 1;j <= 12;j++){

            qDebug()<<xlsxR.read(i,j);
            xlsx.write(i,j, xlsxR.read(i,j));
        }

        qDebug()<<"\n";
    }
    xlsx.saveAs("../Test22.xlsx");
}