Qt之操作Excel

//写入

    QXlsx::Document xlsx;

    if(!xlsx.selectSheet("ziv"))//选择表格，若不存在，则新建一张

    {

        xlsx.addSheet("ziv");

    }

    xlsx.write("A1", "View the properties through:");

    xlsx.write("A2", "Office Button -> Prepare -> Properties option in Excel");

    if(!xlsx.selectSheet("agv"))

    {

        xlsx.addSheet("agv");

    }

    xlsx.write("A1","ip");

    xlsx.write("A2","192.168");

    xlsx.saveAs("book1.xlsx"); //添加后，必须保存至表格中

    QXlsx::CellRange range;//获取表格的行数、列数

    range=xlsx.dimension();

    int rowCount = range.rowCount() ; //行数

    int colCount = range.columnCount() ; //列数

    //更新某一行

    for(int i=1; i<rowCount+1; i++)

    {

        if ( xlsx.cellAt( i ,1)->value().toString()=="192.168" )

        {

            xlsx.write(i,1,"192.168.31");

        }

    }

    xlsx.saveAs("book1.xlsx");//更新后一定要保存

    xlsx1.selectSheet("agv");

    //读取agv表中的所有信息

    for (int  i = 1; i <=rowCount; i++)

    {

        for (int j=1; j<=colCount; j++)

        {

            qDebug() << i  <<j <<xlsx1.cellAt(i, j)->value().toString() ;

        }

    }

    qDebug() << rowCountt <<colCountt <<xlsx1.currentSheet()->sheetName();//打印出表单的名字

    bool flag=  xlsx.deleteSheet("agv");//删除某一表，删除后必须保存

    if(flag)

    {

        qDebug() <<"true" ;

    }

    else

    {

        qDebug() <<"false" ;

    }

    xlsx.saveAs("book1.xlsx");

    xlsx.copySheet("ziv","chen");//无格式拷贝

    xlsx.selectSheet("chen");

    xlsx.write(4,2,"On the Copy Sheet");

    xlsx.saveAs("book1.xlsx");

    //读取

    QXlsx::Document xlsx1("book1.xlsx");

    xlsx1.selectSheet("ziv");

    QStringList sheetname_tmp = xlsx1.sheetNames();//表单名

    qDebug() << "表单名" <<sheetname_tmp;

    QString tmp = sheetname_tmp.join(",");

    qDebug() <<"tmp" << tmp;

    xlsx1.selectSheet("ziv");

    qDebug()<<xlsx1.read("A1").toString()<<xlsx1.read("A2").toInt()<<xlsx1.read("A3").toBool();

若想判断单元格是不是空白

 QString filepath=  "D:/LgvResource/dxfInfo.xlsx" ;
    QXlsx::Document xlsx(filepath);//读取excel
    //选择表SiteInfo //ID、posX、posY、nature、startx、starty width height
    if(!xlsx.selectSheet("SiteInfo"))
    {
        qDebug()<<"表格不存在"+filepath + "SiteInfo";
        return;
    }
    QXlsx::Cell *cell = xlsx.cellAt(2,1);
    if(cell == NULL)
    {
        qDebug()<<"null";
    }
    else {
        qDebug()<<cell->value().toString();
    }