1030

wumu

2024-10-30 162311be680b94a0dcd5250acbf36aead6350cb1

1030

 Data/¸½¼þ2_ÄÚÉóͳ01±í_µ¥Î»¼°ÄÚ²¿Éó¼Æ»ú¹¹»ù±¾Çé¿ö±í-1.301°æ(1).xls

Binary files differ

 internal_system_v1/converinfo2.cpp

@@ -570,136 +570,137 @@

                // å››ã€å†…审人员配备基本情况
                // ç¼–制数
                QVariant organazationNum = valRows[56].toList().at(4);
                //QVariant organazationNum = valRows[56].toList().at(4);
                QVariant organazationNum = valRows[60].toList().at(4);
                if(organazationNum.isValid()){
                    curComInfo.organazationNum = organazationNum.toInt();
                    qDebug()<<"organazationNum"<<organazationNum;
                }
                // å®žæœ‰äººå‘˜æ•°
                QVariant realNum = valRows[56].toList().at(4);
                QVariant realNum = valRows[60].toList().at(6);
                if(realNum.isValid()){
                    curComInfo.realNum = realNum.toInt();
                    qDebug()<<"realNum"<<realNum;
                }
                // ä¸“职人员数
                QVariant professionalNum = valRows[56].toList().at(4);
                QVariant professionalNum = valRows[60].toList().at(8);
                if(professionalNum.isValid()){
                    curComInfo.professionalNum = professionalNum.toInt();
                    qDebug()<<"professionalNum"<<professionalNum;
                }
                // æ‹¥æœ‰CIA人员数
                QVariant CIANum = valRows[56].toList().at(4);
                QVariant CIANum = valRows[61].toList().at(6);
                if(CIANum.isValid()){
                    curComInfo.CIANum = CIANum.toInt();
                    qDebug()<<"CIANum"<<CIANum;
                }
                // å­¦åŽ†ï¼šç¡•å£«åŠä»¥ä¸Š äººå‘˜æ•°
                QVariant masterNum = valRows[56].toList().at(4);
                QVariant masterNum = valRows[62].toList().at(6);
                if(masterNum.isValid()){
                    curComInfo.masterNum = masterNum.toInt();
                    qDebug()<<"masterNum"<<masterNum;
                }
                // å¤§å­¦æœ¬ç§‘
                QVariant undergraduatesNum = valRows[56].toList().at(4);
                QVariant undergraduatesNum = valRows[63].toList().at(6);
                if(undergraduatesNum.isValid()){
                    curComInfo.undergraduatesNum = undergraduatesNum.toInt();
                    qDebug()<<"undergraduatesNum"<<undergraduatesNum;
                }
                // ä¸“科及以下
                QVariant juniorNum = valRows[56].toList().at(4);
                QVariant juniorNum = valRows[64].toList().at(6);
                if(juniorNum.isValid()){
                    curComInfo.juniorNum = juniorNum.toInt();
                    qDebug()<<"juniorNum"<<juniorNum;
                }

                // èŒç§° é«˜çº§èŒç§°
                QVariant seniorNum = valRows[56].toList().at(4);
                QVariant seniorNum = valRows[65].toList().at(6);
                if(seniorNum.isValid()){
                    curComInfo.seniorNum = seniorNum.toInt();
                    qDebug()<<"seniorNum"<<seniorNum;
                }
                // ä¸­çº§èŒç§°
                QVariant intermediateNum = valRows[56].toList().at(4);
                QVariant intermediateNum = valRows[66].toList().at(6);
                if(intermediateNum.isValid()){
                    curComInfo.intermediateNum = intermediateNum.toInt();
                    qDebug()<<"intermediateNum"<<intermediateNum;
                }
                // åˆçº§èŒç§°
                QVariant primaryNum = valRows[56].toList().at(4);
                QVariant primaryNum = valRows[67].toList().at(6);
                if(primaryNum.isValid()){
                    curComInfo.primaryNum = primaryNum.toInt();
                    qDebug()<<"primaryNum"<<primaryNum;
                }
                // æ— èŒç§°
                QVariant noTitleNum = valRows[56].toList().at(4);
                QVariant noTitleNum = valRows[68].toList().at(6);
                if(noTitleNum.isValid()){
                    curComInfo.noTitleNum = noTitleNum.toInt();
                    qDebug()<<"noTitleNum"<<noTitleNum;
                }

                // å¹´é¾„结构 50岁以上
                QVariant upFiftyOldNum = valRows[56].toList().at(4);
                QVariant upFiftyOldNum = valRows[69].toList().at(6);
                if(upFiftyOldNum.isValid()){
                    curComInfo.upFiftyOldNum = upFiftyOldNum.toInt();
                    qDebug()<<"upFiftyOldNum"<<upFiftyOldNum;
                }
                // 30-50岁
                QVariant upThirtyOldNum = valRows[56].toList().at(4);
                QVariant upThirtyOldNum = valRows[70].toList().at(6);
                if(upThirtyOldNum.isValid()){
                    curComInfo.upThirtyOldNum = upThirtyOldNum.toInt();
                    qDebug()<<"upThirtyOldNum"<<upThirtyOldNum;
                }
                // 30岁以下
                QVariant downThirtyOldNum = valRows[56].toList().at(4);
                QVariant downThirtyOldNum = valRows[71].toList().at(6);
                if(downThirtyOldNum.isValid()){
                    curComInfo.downThirtyOldNum = downThirtyOldNum.toInt();
                    qDebug()<<"downThirtyOldNum"<<downThirtyOldNum;
                }

                // çŸ¥è¯†ç»“æž„ å®¡è®¡
                QVariant auditNum = valRows[56].toList().at(4);
                QVariant auditNum = valRows[72].toList().at(6);
                if(auditNum.isValid()){
                    curComInfo.auditNum = auditNum.toInt();
                    qDebug()<<"auditNum"<<auditNum;
                }
                // ä¼šè®¡
                QVariant accountingNum = valRows[56].toList().at(4);
                QVariant accountingNum = valRows[73].toList().at(6);
                if(accountingNum.isValid()){
                    curComInfo.accountingNum = accountingNum.toInt();
                    qDebug()<<"accountingNum"<<accountingNum;
                }
                // ç»æµŽ
                QVariant economyNum = valRows[56].toList().at(4);
                QVariant economyNum = valRows[74].toList().at(6);
                if(economyNum.isValid()){
                    curComInfo.economyNum = economyNum.toInt();
                    qDebug()<<"economyNum"<<economyNum;
                }
                // æ³•å¾‹
                QVariant lawNum = valRows[56].toList().at(4);
                QVariant lawNum = valRows[75].toList().at(6);
                if(lawNum.isValid()){
                    curComInfo.lawNum = lawNum.toInt();
                    qDebug()<<"lawNum"<<lawNum;
                }
                // ç®¡ç†
                QVariant managerNum = valRows[56].toList().at(4);
                QVariant managerNum = valRows[76].toList().at(6);
                if(managerNum.isValid()){
                    curComInfo.managerNum = managerNum.toInt();
                    qDebug()<<"managerNum"<<managerNum;
                }
                // ä¿¡æ¯æŠ€æœ¯
                QVariant itNum = valRows[56].toList().at(4);
                QVariant itNum = valRows[77].toList().at(6);
                if(itNum.isValid()){
                    curComInfo.itNum = itNum.toInt();
                    qDebug()<<"itNum"<<itNum;
                }
                // å·¥ç¨‹
                QVariant engineeringNum = valRows[56].toList().at(4);
                QVariant engineeringNum = valRows[78].toList().at(6);
                if(engineeringNum.isValid()){
                    curComInfo.engineeringNum = engineeringNum.toInt();
                    qDebug()<<"engineeringNum"<<engineeringNum;
                }
                // å…¶ä»–
                QVariant otherNum = valRows[56].toList().at(4);
                QVariant otherNum = valRows[79].toList().at(6);
                if(otherNum.isValid()){
                    curComInfo.otherNum = otherNum.toInt();
                    qDebug()<<"otherNum"<<otherNum;
@@ -1086,7 +1087,7 @@
    qDebug()<<"excel:"<<excel.className();
    QAxObject * wbs = excel.querySubObject("WorkBooks");
    qDebug()<<"wbs:"<<wbs->className();
    QAxObject * wb = wbs->querySubObject("Open(QString&)",path);
    QAxObject * wb = wbs->querySubObject("Open(QString&)",path); // å“ªä¸ªå¯¹è±¡æ˜¯Open的返回值，哪个就可以保存
    //QAxObject* pWorkBook = excel.querySubObject("ActiveWorkBook");
    //QAxObject* pWorkSheets = pWorkBook->querySubObject("Sheets");//获取工作表
    //QAxObject * shs = wb->querySubObject("Sheets"); // WorkSheets ä¹Ÿå¯ä»¥
@@ -1378,6 +1379,30 @@
            qDebug()<<"financeDepartment"<<financeDepartment;
        }
        // æ³•åŠ¡éƒ¨é—¨ã€å†…部控制部门、纪检部门、其他部门
        // éœ€è¦ç‰¹æ®ŠèŽ·å–
        QAxObject *checkBox = sheet->querySubObject("CheckBoxes(const QString&)", QString::fromLocal8Bit("财务部门"));
        if(checkBox){
            qDebug()<<"取到财务部门"<<checkBox->property("Value2").toInt()<<checkBox->property("Value").toInt()<<checkBox->property("Value2").toBool();
            if(checkBox->property("Value").toBool()){
                qDebug()<<"财务部门勾选";
            }else{
                qDebug()<<"财务部门未勾选";
            }
        }else{
            qDebug()<<"未取到财务部门";
        }

        QAxObject *checkBox1 = sheet->querySubObject("CheckBoxes(const QString&)", QString::fromLocal8Bit("法务部门"));
        if(checkBox1){
            qDebug()<<"取到法务部门"<<checkBox1->property("Value").toInt();
            if(checkBox1->property("Value").toBool()){
                qDebug()<<"法务部门勾选";
            }else{
                qDebug()<<"法务部门未勾选";
            }
        }else{
            qDebug()<<"未取到法务部门";
        }

        // å†…审机构层级
        QVariant intavalAuditLeval = valRows[56].toList().at(4);
@@ -1681,3 +1706,15 @@
{
    readInfo(); // åŠ è½½è¡¨æ ¼
}

void ConverInfo2::on_pushButton_save_to_file_clicked()
{
    QString name = ui->lineEdit_name->text();
    if(name.size()== 0){
        QMessageBox::information(this,"单位名称为空,请先选中一家单位","请先选中一家单位");
        return;
    }
    ExportToFile etf(this);
    ComInfo cif = m_nameAndComInfos[name];
    etf.saveToExcelFromComInfo(cif);
}

 internal_system_v1/converinfo2.h

@@ -7,6 +7,8 @@
#include <QAxObject>
#include "struct_data.h"
#include <QSqlError>
#include "exporttofile.h"
#include <QMessageBox>

namespace Ui {
class ConverInfo2;
@@ -48,6 +50,8 @@

    void showExcelSlot(); // åŠ è½½æ˜¾ç¤ºç”µå­è¡¨æ ¼çš„槽

    void on_pushButton_save_to_file_clicked(); // å¯¼å‡ºä¿å­˜

private:
    Ui::ConverInfo2 *ui;
    QMenu *m_menu;

 internal_system_v1/converinfo2.ui

@@ -38,8 +38,8 @@
      <widget class="QWidget" name="scrollAreaWidgetContents">
       <property name="geometry">
        <rect>
         <x>0</x>
         <y>0</y>
         <x>-215</x>
         <y>-1034</y>
         <width>1100</width>
         <height>1600</height>
        </rect>
@@ -3476,6 +3476,19 @@
         <string>手动加载</string>
        </property>
       </widget>
       <widget class="QPushButton" name="pushButton_save_to_file">
        <property name="geometry">
         <rect>
          <x>420</x>
          <y>1500</y>
          <width>241</width>
          <height>41</height>
         </rect>
        </property>
        <property name="text">
         <string>导出保存</string>
        </property>
       </widget>
       <zorder>label_70</zorder>
       <zorder>label_webSite</zorder>
       <zorder>label_townCode</zorder>
@@ -3670,6 +3683,7 @@
       <zorder>label_129</zorder>
       <zorder>pushButton_commit</zorder>
       <zorder>pushButton_laodFile</zorder>
       <zorder>pushButton_save_to_file</zorder>
      </widget>
     </widget>
    </item>

 internal_system_v1/exporttofile.cpp

@@ -1,5 +1,10 @@
#include "exporttofile.h"
#include <QFileDialog>
#include <QDebug>
#include <QAxObject>
#include <QFile>

#pragma execution_character_set("utf-8")
ExportToFile::ExportToFile(QObject *parent) : QObject(parent)
{

@@ -7,15 +12,211 @@

int ExportToFile::saveToExcelFromComInfo(ComInfo &info)
{
    // è¯»å–当前目录下的模板文件，然后往里写数据，修改保存

//    QString savePath = QFileDialog::getExistingDirectory(nullptr,"选择文件夹",QDir::currentPath());
//    qDebug()<<"savepath:"<<savePath;

    QString demoPath = QDir::currentPath()+"/Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版_demo.xls";
    QDir dir(demoPath);
    if(!dir.exists()){
        demoPath = QDir::currentPath()+"/release/Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版_demo.xls";
    }

    QString savePath = QFileDialog::getSaveFileName(nullptr,"保存文件",QDir::currentPath()+"/内审统01表.xls","Excel File(*.xls,*.xlsx)");
    qDebug()<<"savepath:"<<savePath <<endl << "demoPath:"<<demoPath;



    if(savePath.size() > 0){
        QAxObject excel("ket.Application");
        if(!excel.setControl("ket"
                             ".Application")){  // windows内核
            excel.setControl("Excel.Application"); // wps内核
        }

        excel.setProperty("Visible",false);
        excel.setProperty("DisplayAlerts",false);
        QAxObject * wbs = excel.querySubObject("WorkBooks");
        qDebug()<<"wbs:"<<wbs->className();
        QAxObject * wb = wbs->querySubObject("Open(QString&)",demoPath);
        qDebug()<<"wb open ok";
        QAxObject * shs = wb->querySubObject("WorkSheets"); // WorkSheets ä¹Ÿå¯ä»¥
        // èŽ·å–具体表格，行列
        QAxObject * sheet = shs->querySubObject("Item(int)", 1); // ç¬¬ä¸€ä¸ªè¡¨
        QAxObject *usedRange = sheet->querySubObject("UsedRange");
        int rows = usedRange->querySubObject("Rows")->property("Count").toInt();
        int columns = usedRange->querySubObject("Columns")->property("Count").toInt();
        qDebug()<<"r--c:"<<rows<<columns;

        // ä¿®æ”¹æŸä¸ªå€¼
        //sheet->querySubObject("Cells(int,int)", 1, 10)->dynamicCall("SetValue(const QString&)","1000200300");
//        QAxObject *cell1 = sheet->querySubObject("Range(QVariant, QVariant)", "D10");
//        qDebug()<<"B3原数据："<<cell1->dynamicCall("Value2()").toString();
//        /* ---- ä¿®æ”¹å•ä¸ªå•å…ƒæ ¼ä¸­çš„数据 ---- */
//        cell1->setProperty("Value2", "21321321312");
//        qDebug()<<"B3修改后的数据："<<cell1->dynamicCall("Value2()").toString();

//        QAxObject *cell2 = sheet->querySubObject("Range(QVariant, QVariant)", "G63");
//        qDebug()<<"B3原数据："<<cell2->dynamicCall("Value2()").toString();
//        /* ---- ä¿®æ”¹å•ä¸ªå•å…ƒæ ¼ä¸­çš„数据 ---- */
//        cell2->setProperty("Value2", "10");
//        qDebug()<<"G63修改后的数据："<<cell2->dynamicCall("Value2()").toString();

//        QAxObject *cell3 = sheet->querySubObject("Range(QVariant, QVariant)", "E57");
//        qDebug()<<"B3原数据："<<cell3->dynamicCall("Value2()").toString();
//        /* ---- ä¿®æ”¹å•ä¸ªå•å…ƒæ ¼ä¸­çš„数据 ---- */
//        cell3->setProperty("Value2", "4 å…¶ä»–");
//        qDebug()<<"E57修改后的数据："<<cell3->dynamicCall("Value2()").toString();

        // ä¾æ¬¡èµ‹å€¼
        // åŸºæœ¬æƒ…况
        sheet->querySubObject("Range(QVariant, QVariant)", "D10")->setProperty("Value2", info.creditCode); // ç»Ÿä¸€ä¿¡ç”¨ä»£ç 
        qDebug()<<1;
        sheet->querySubObject("Range(QVariant, QVariant)", "I10")->setProperty("Value2", QString::fromLocal8Bit(info.name)); // å•ä½åç§°
        qDebug()<<2;
        sheet->querySubObject("Range(QVariant, QVariant)", "D13")->setProperty("Value2", QString::fromLocal8Bit(info.comType)); // æœºæž„类型
        qDebug()<<3;
        sheet->querySubObject("Range(QVariant, QVariant)", "C19")->setProperty("Value2", QString::fromLocal8Bit(info.business)); // ä¸šåŠ¡æ´»åŠ¨
        qDebug()<<4;
        sheet->querySubObject("Range(QVariant, QVariant)", "E20")->setProperty("Value2", info.businessCode); // è¡Œä¸šä»£ç 
        qDebug()<<5;
        sheet->querySubObject("Range(QVariant, QVariant)", "B22")->setProperty("Value2", QString::fromLocal8Bit(info.addr)); // æ³¨å†Œåœ°åŠåŒºåˆ’
        qDebug()<<6;
        sheet->querySubObject("Range(QVariant, QVariant)", "C25")->setProperty("Value2", info.areaCode); // åŒºåŸŸä»£ç 
        qDebug()<<7;
        sheet->querySubObject("Range(QVariant, QVariant)", "G25")->setProperty("Value2", info.townCode); // åŸŽä¹¡ä»£ç 
        qDebug()<<8;
        sheet->querySubObject("Range(QVariant, QVariant)", "C26")->setProperty("Value2", QString::fromLocal8Bit(info.scale)); // å•ä½è§„模
        qDebug()<<9;
        sheet->querySubObject("Range(QVariant, QVariant)", "G27")->setProperty("Value2", info.people); // ä»Žä¸šäººå‘˜æ•°é‡
        qDebug()<<10;
        sheet->querySubObject("Range(QVariant, QVariant)", "E28")->setProperty("Value2", QString::fromLocal8Bit(info.representative)); // æ³•äºº
        qDebug()<<11;
        sheet->querySubObject("Range(QVariant, QVariant)", "I28")->setProperty("Value2", QString::fromLocal8Bit(info.standardType)); // æ‰§è¡Œä¼šè®¡æ ‡å‡†
        qDebug()<<12;
        sheet->querySubObject("Range(QVariant, QVariant)", "C32")->setProperty("Value2", info.trunkCode); // é•¿é€”区号
        qDebug()<<13;
        sheet->querySubObject("Range(QVariant, QVariant)", "C33")->setProperty("Value2", info.fixedTel); // å›ºå®šç”µè¯
        qDebug()<<14;
        sheet->querySubObject("Range(QVariant, QVariant)", "C34")->setProperty("Value2", info.postCode); // é‚®æ”¿ç¼–码
        qDebug()<<15;
        sheet->querySubObject("Range(QVariant, QVariant)", "F31")->setProperty("Value2", info.email); // ç”µå­é‚®ç®±
        qDebug()<<16;
        sheet->querySubObject("Range(QVariant, QVariant)", "F33")->setProperty("Value2", info.webSite); // ç½‘址
        qDebug()<<17;

        // äºŒ å•ä½ç»„织结构情况
        sheet->querySubObject("Range(QVariant, QVariant)", "E36")->setProperty("Value2", QString::fromLocal8Bit(info.hasUpLegal)); // æ˜¯å¦æœ‰ä¸Šä¸€çº§æ³•äºº
        qDebug()<<18;
        sheet->querySubObject("Range(QVariant, QVariant)", "H37")->setProperty("Value2", QString::fromLocal8Bit(info.upCreditCode)); // ä¸Šä¸€çº§ç»Ÿä¸€ç¤¾ä¼šä¿¡ç”¨ä»£ç 
        qDebug()<<19;
        sheet->querySubObject("Range(QVariant, QVariant)", "H38")->setProperty("Value2", QString::fromLocal8Bit(info.oldCreditCode)); // åŽŸç»„织机构代码
        qDebug()<<20;
        sheet->querySubObject("Range(QVariant, QVariant)", "H39")->setProperty("Value2", QString::fromLocal8Bit(info.upName)); // ä¸Šä¸€çº§å•ä½åç§°
        qDebug()<<21;

        // ä¸‰ æ€»å®¡è®¡å¸ˆä¸Žå†…部审计机构基本情况
        sheet->querySubObject("Range(QVariant, QVariant)", "E41")->setProperty("Value2", QString::fromLocal8Bit(info.hasChiefDesigner)); // æ˜¯å¦è®¾ç½®æ€»å®¡è®¡å¸ˆ
        qDebug()<<22;
        sheet->querySubObject("Range(QVariant, QVariant)", "E42")->setProperty("Value2", QString::fromLocal8Bit(info.ChiefDesignerLevel)); // æ€»å®¡è®¡å¸ˆèŒä½å±‚级
        qDebug()<<23;
        sheet->querySubObject("Range(QVariant, QVariant)", "E45")->setProperty("Value2", QString::fromLocal8Bit(info.employmentMode)); // æ€»å®¡ä»»èŒæ–¹å¼
        qDebug()<<24;
        sheet->querySubObject("Range(QVariant, QVariant)", "E48")->setProperty("Value2", QString::fromLocal8Bit(info.hasSetIntervalAudit)); // æ˜¯å¦è®¾ç½®å†…审机构
        qDebug()<<25;
        sheet->querySubObject("Range(QVariant, QVariant)", "E49")->setProperty("Value2", QString::fromLocal8Bit(info.internalName)); // å†…审机构名称
        qDebug()<<26;
        sheet->querySubObject("Range(QVariant, QVariant)", "E50")->setProperty("Value2", QString::fromLocal8Bit(info.leadingOrganization)); // é¢†å¯¼æœºæž„
        qDebug()<<27;
        sheet->querySubObject("Range(QVariant, QVariant)", "E54")->setProperty("Value2", QString::fromLocal8Bit(info.hasSetSeparateIA)); // æ˜¯å¦ç‹¬ç«‹è®¾ç½®å†…审机构
        qDebug()<<28;
        sheet->querySubObject("Range(QVariant, QVariant)", "E56")->setProperty("Value2", info.financeDepartment); // è´¢åŠ¡éƒ¨é—¨
        qDebug()<<29;
        sheet->querySubObject("Range(QVariant, QVariant)", "E56")->setProperty("Value2", info.legalDepartment); // æ³•åŠ¡éƒ¨é—¨
        qDebug()<<30;
        sheet->querySubObject("Range(QVariant, QVariant)", "E56")->setProperty("Value2", info.internalConDepart); // å†…部控制部门
        qDebug()<<31;
        sheet->querySubObject("Range(QVariant, QVariant)", "E56")->setProperty("Value2", info.disceplineInDepart); // çºªæ£€éƒ¨é—¨
        qDebug()<<32;
        sheet->querySubObject("Range(QVariant, QVariant)", "E56")->setProperty("Value2", info.otherDepart); // å…¶ä»–部门
        qDebug()<<33;
        sheet->querySubObject("Range(QVariant, QVariant)", "E57")->setProperty("Value2", QString::fromLocal8Bit(info.intavalAuditLeval)); // å†…审层级
        qDebug()<<34;

        // å›› å†…部审计人员配备基本情况
        sheet->querySubObject("Range(QVariant, QVariant)", "E61")->setProperty("Value2", info.organazationNum); // ç¼–制数量
        qDebug()<<35;
        sheet->querySubObject("Range(QVariant, QVariant)", "G61")->setProperty("Value2", info.realNum); // å®žæœ‰äººå‘˜æ•°
        qDebug()<<36;
        sheet->querySubObject("Range(QVariant, QVariant)", "I61")->setProperty("Value2", info.professionalNum); // ä¸“职人员数量
        qDebug()<<37;
        sheet->querySubObject("Range(QVariant, QVariant)", "G62")->setProperty("Value2", info.CIANum); // æ‹¥æœ‰CIA人数
        qDebug()<<38;
        sheet->querySubObject("Range(QVariant, QVariant)", "G63")->setProperty("Value2", info.masterNum); // ç¡•å£«å­¦åŽ†ä»¥ä¸Šäººæ•°
        qDebug()<<39;
        sheet->querySubObject("Range(QVariant, QVariant)", "G64")->setProperty("Value2", info.undergraduatesNum); // æœ¬ç§‘人数
        qDebug()<<40;
        sheet->querySubObject("Range(QVariant, QVariant)", "G65")->setProperty("Value2", info.juniorNum); // ä¸“科及以下人数
        qDebug()<<41;
        sheet->querySubObject("Range(QVariant, QVariant)", "G66")->setProperty("Value2", info.seniorNum); // é«˜çº§èŒç§°äººæ•°
        qDebug()<<42;
        sheet->querySubObject("Range(QVariant, QVariant)", "G67")->setProperty("Value2", info.intermediateNum); // ä¸­çº§èŒç§°äººæ•°
        qDebug()<<43;
        sheet->querySubObject("Range(QVariant, QVariant)", "G68")->setProperty("Value2", info.primaryNum); // åˆçº§èŒç§°äººæ•°
        qDebug()<<44;
        sheet->querySubObject("Range(QVariant, QVariant)", "G69")->setProperty("Value2", info.noTitleNum); // æ— èŒç§°äººæ•°
        qDebug()<<45;
        sheet->querySubObject("Range(QVariant, QVariant)", "G70")->setProperty("Value2", info.upFiftyOldNum); // 50岁以上人数
        qDebug()<<46;
        sheet->querySubObject("Range(QVariant, QVariant)", "G71")->setProperty("Value2", info.upThirtyOldNum); // 30-50岁人数
        qDebug()<<47;
        sheet->querySubObject("Range(QVariant, QVariant)", "G72")->setProperty("Value2", info.downThirtyOldNum); // 30岁以下人数
        qDebug()<<48;
        sheet->querySubObject("Range(QVariant, QVariant)", "G73")->setProperty("Value2", info.auditNum); // å®¡è®¡æ•°é‡
        qDebug()<<49;
        sheet->querySubObject("Range(QVariant, QVariant)", "G74")->setProperty("Value2", info.accountingNum); // ä¼šè®¡æ•°é‡
        qDebug()<<50;
        sheet->querySubObject("Range(QVariant, QVariant)", "G75")->setProperty("Value2", info.economyNum); // ç»æµŽæ•°é‡
        qDebug()<<51;
        sheet->querySubObject("Range(QVariant, QVariant)", "G76")->setProperty("Value2", info.lawNum); // æ³•å¾‹æ•°é‡
        qDebug()<<52;
        sheet->querySubObject("Range(QVariant, QVariant)", "G77")->setProperty("Value2", info.managerNum); // ç®¡ç†æ•°é‡
        qDebug()<<53;
        sheet->querySubObject("Range(QVariant, QVariant)", "G78")->setProperty("Value2", info.itNum); // ä¿¡æ¯æŠ€æœ¯æ•°é‡
        qDebug()<<54;
        sheet->querySubObject("Range(QVariant, QVariant)", "G79")->setProperty("Value2", info.engineeringNum); // å·¥ç¨‹æ•°é‡
        qDebug()<<55;
        sheet->querySubObject("Range(QVariant, QVariant)", "G80")->setProperty("Value2", info.otherNum); // å…¶ä»–数量
        qDebug()<<56;

        // åŽé¢çš„4个信息
        sheet->querySubObject("Range(QVariant, QVariant)", "B82")->setProperty("Value2", QString::fromLocal8Bit(info.statisticalConOfficer)); // ç»Ÿè®¡è´Ÿè´£äºº
        qDebug()<<57;
        sheet->querySubObject("Range(QVariant, QVariant)", "E82")->setProperty("Value2", QString::fromLocal8Bit(info.personFilling)); // å¡«è¡¨äºº
        qDebug()<<58;
        sheet->querySubObject("Range(QVariant, QVariant)", "B83")->setProperty("Value2", QString::fromLocal8Bit(info.officerTel)); // è”系电话
        qDebug()<<59;
        sheet->querySubObject("Range(QVariant, QVariant)", "E83")->setProperty("Value2", QString::fromLocal8Bit(info.fillingDateTime)); // å¡«æŠ¥æ—¥æœŸ
        qDebug()<<60;

        // å®Œäº‹äº†ï¼Œç»“束，保存或者退出
        wb->dynamicCall("SaveAs(const QString&)",QDir::toNativeSeparators(savePath));
        wbs->dynamicCall("Close()");
        excel.dynamicCall("Quit(void)");


    }
    return 0;

}

int ExportToFile::saveToExcelFromThreeMergePro()
{

    return 0;
}

int ExportToFile::saveToExcelFromNeiShenZonghe()
{

    return 0;
}