From 20ffcfb5507daf34f81346ca3dfa4c031e7b2fe3 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期日, 27 四月 2025 22:13:53 +0800
Subject: [PATCH] 0427
---
internal_system_v1/exporttofile.cpp | 18 ++++++++++++++++--
1 files changed, 16 insertions(+), 2 deletions(-)
diff --git a/internal_system_v1/exporttofile.cpp b/internal_system_v1/exporttofile.cpp
index 1f5e8db..366e933 100644
--- a/internal_system_v1/exporttofile.cpp
+++ b/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 涔熷彲浠�
--
Gitblit v1.8.0