資源簡介
原文為《Qt中將QTableView中的數據導出為Excel文件>>,地址http://blog.csdn.net/superjoel/article/details/5321404,資源比較難下載,我下載好幫作者上傳下。實例可用,簡單易懂,對于QTableView導出為excel新手比較合適!謝謝原作者!
代碼片段和文件信息
#include?“exportexcelobject.h“
#include?
#include?
#include?
int?ExportExcelobject::export2Excel()
{
????if(fieldList.size()?<=?0)
????{
????????qDebug()?<“ExportExcelobject::export2Excel?failed:?No?fields?defined.“;
????????return?-1;
????}
????QSqlDatabase?db?=?QSqlDatabase::addDatabase(“QODBC“?“excelexport“);
????if(!db.isValid())
????{
????????qDebug()?<“ExportExcelobject::export2Excel?failed:?QODBC?not?supported.“;
????????return?-2;
????}
????//?set?the?dsn?string
????QString?dsn?=?QString(“DRIVER={Microsoft?Excel?Driver?(*.xls)};DSN=‘‘;FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\“%1\“;DBQ=%2“).
??????????????????arg(excelFilePath).arg(excelFilePath);
????db.setDatabaseName(dsn);
????if(!db.open())
????{
????????qDebug()?<“ExportExcelobject::export2Excel?failed:?Create?Excel?file?failed?by?DRIVER={Microsoft?Excel?Driver?(*.xls)}.“;
????????//QSqlDatabase::removeDatabase(“excelexport“);
????????return?-3;
????}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????401??2010-02-23?13:27??TestTableView.pro
?????文件???????2798??2010-02-23?12:03??exportexcelob
?????文件???????2971??2010-02-23?12:01??exportexcelob
?????文件????????344??2010-02-23?13:25??main.cpp
?????文件???????2093??2010-02-23?15:31??mainwindow.cpp
?????文件????????572??2010-02-23?13:32??mainwindow.h
?????文件???????2262??2010-02-23?13:32??mainwindow.ui
?????文件??????17892??2010-01-12?15:53??mytableview.cpp
?????文件???????5400??2010-01-11?17:01??mytableview.h
?????文件???????1145??2010-02-23?13:38??mytestmodel.cpp
?????文件????????481??2010-01-09?17:57??mytestmodel.h
-----------?---------??----------?-----??----
????????????????36359????????????????????11
評論
共有 條評論