資源簡介
* 該類通過COM來操作excel,主要使用QAxObject以及Excel VBA,須在.pro文件中添加 “QT += axcontainer”
*
* Excel的層次結構為 excel應用程序->工作簿->工作表->單元格
* 一個類對象可以創建多個工作簿,每個工作簿可以操作多張工作表
*
* 在新線程中使用要單獨初始化COM,OleInitialize(0);
*
* 使用流程:創建類對象->創建/打開工作簿->添加/打開/刪除工作表->添加表信息->關閉工作簿->刪除工作簿->關閉excel
代碼片段和文件信息
#include?“widget.h“
#include?
int?main(int?argc?char?*argv[])
{
????QApplication?a(argc?argv);
????Widget?w;
????w.show();
????return?a.exec();
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????10173??2019-03-23?12:00??testQWord\debug\excel.xlsx
?????文件??????69416??2019-03-23?11:22??testQWord\debug\main.obj
?????文件??????72805??2019-03-23?11:22??testQWord\debug\moc_widget.obj
?????文件?????496292??2019-03-23?11:22??testQWord\debug\qexcel.obj
?????文件?????412160??2019-03-23?12:00??testQWord\debug\testQWord.exe
?????文件????????638??2019-03-23?11:22??testQWord\debug\testQWord.exe.em
?????文件????????103??2019-03-23?11:22??testQWord\debug\testQWord.exe_manifest.rc
?????文件????????704??2019-03-23?11:22??testQWord\debug\testQWord.exe_manifest.res
?????文件????2159744??2019-03-23?12:00??testQWord\debug\testQWord.ilk
?????文件????3444736??2019-03-23?12:00??testQWord\debug\testqword.pdb
?????文件?????148861??2019-03-23?11:22??testQWord\debug\widget.obj
?????文件???????4376??2019-03-23?11:59??testQWord\GeneratedFiles\Debug\moc_widget.cpp
?????文件???????4057??2019-03-23?11:59??testQWord\GeneratedFiles\ui_widget.h
?????文件???53477376??2019-03-23?12:36??testQWord\ipch\testqword-7e26ab7d\testqword-6f3f6fa8.ipch
?????文件????????175??2019-03-23?10:39??testQWord\main.cpp
?????文件??????21033??2019-03-23?11:22??testQWord\Makefile
?????文件??????39233??2019-03-23?11:22??testQWord\Makefile.Debug
?????文件??????38216??2019-03-23?11:22??testQWord\Makefile.Release
?????文件??????17698??2019-03-23?11:56??testQWord\qexcel.cpp
?????文件??????11078??2018-09-30?09:31??testQWord\qexcel.h
?????文件????????423??2019-03-23?11:15??testQWord\testQWord.pro
?????文件??????18171??2019-03-23?11:23??testQWord\testQWord.pro.user
?????文件???18960384??2019-03-23?12:37??testQWord\testQWord.sdf
?????文件????????884??2019-03-23?11:26??testQWord\testQWord.sln
????..A..H.?????13312??2019-03-23?12:37??testQWord\testQWord.suo
?????文件??????13637??2019-03-23?11:23??testQWord\testQWord.vcxproj
?????文件???????3286??2019-03-23?11:23??testQWord\testQWord.vcxproj.filters
?????文件????????619??2019-03-23?11:23??testQWord\testQWord.vcxproj.user
?????文件???????1185??2019-03-23?11:59??testQWord\widget.cpp
?????文件????????618??2019-03-23?11:59??testQWord\widget.h
............此處省略35個文件信息
評論
共有 條評論