0427

wumu

2025-04-27 20ffcfb5507daf34f81346ca3dfa4c031e7b2fe3

 internal_system_v1/exporttofile.cpp

@@ -23,6 +23,10 @@
    QDir dir(demoPath);
    if(!dir.exists()){
        demoPath = QDir::currentPath()+"/release/Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版_demo.xls";
        QDir dir_realse(demoPath);
        if(!dir_realse.exists()){
            demoPath = QDir::currentPath()+"/Data/附件2_内审统01表_单位及内部审计机构基本情况表-1.301版_demo.xls";
        }
    }
    QString dt = QDateTime::currentDateTime().toString("yyyyMMdd-HHmmss");
    QString savePath = QFileDialog::getSaveFileName(nullptr,"保存文件",QDir::currentPath()+QString("/内审统01表_%1_%2.xls").arg(QString::fromLocal8Bit(info.name)).arg(dt),"Excel File(*.xls;*.xlsx)");
@@ -232,7 +236,13 @@
    QDir dir(demoPath);
    if(!dir.exists()){
        demoPath = QDir::currentPath()+"/release/Data/三合一.xlsx";
        QDir dir_realese(demoPath);
        if(!dir_realese.exists()){
            demoPath = QDir::currentPath()+"/Data/三合一.xlsx";
        }
    }

    //QMessageBox::information(nullptr,"三合一路径",demoPath);
    QString dt = QDateTime::currentDateTime().toString("yyyyMMdd-HHmmss");
    QString savePath = QFileDialog::getSaveFileName(nullptr,"保存文件",QDir::currentPath()+QString("/三合一_%1_%2.xls").arg(name).arg(dt),"Excel File(*.xls;*.xlsx)");
    qDebug()<<"savepath:"<<savePath << endl << "demoPath:"<<demoPath;
@@ -358,6 +368,10 @@
    QDir dir(demoPath);
    if(!dir.exists()){
        demoPath = QDir::currentPath()+"/release/Data/附件4_内审统03表_内部审计统计综合表.xls";
        QDir dir_realse(demoPath);
        if(!dir_realse.exists()){
            demoPath = QDir::currentPath()+"/Data/附件4_内审统03表_内部审计统计综合表.xls";
        }
    }
    QString dt = QDateTime::currentDateTime().toString("yyyyMMdd-HHmmss");
    QString savePath = QFileDialog::getSaveFileName(nullptr,"保存文件",QDir::currentPath()+QString("/综合表_%1_%2.xls").arg(name).arg(dt),"Excel File(*.xls;*.xlsx)");
@@ -367,8 +381,7 @@

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

@@ -376,6 +389,7 @@
        excel.setProperty("DisplayAlerts",false);
        QAxObject * wbs = excel.querySubObject("WorkBooks");
        qDebug()<<"wbs:"<<wbs->className();
        //QAxObject * wb = wbs->querySubObject("Open(QString&)",demoPath);
        QAxObject * wb = wbs->querySubObject("Open(QString&)",demoPath);
        qDebug()<<"wb open ok";
        QAxObject * shs = wb->querySubObject("WorkSheets"); // WorkSheets 也可以