学步园

#include <QtSql/QSqlDatabase>
#include <QtSql/QSqlQuery>
#include <QFileDialog>
#include <QtDebug>

//调用方法，如下：
    QString fileName = QFileDialog::getSaveFileName(this, tr("Excel file"), qApp->applicationDirPath (), tr("Excel Files (*.xls)"));
    if (fileName.isEmpty())
    return;
    QMessageBox::about(this, tr("您将要建立的Excel文件"), fileName );
    if (excel(fileName)>0 )//调用导出Excel方法
    {
    QMessageBox::about(this, tr("Excel文件 导出完成"), fileName );
    QSqlDatabase::removeDatabase("excelexport");
    }

//对于excel的到处操作如下：
int ww::excel(QString fileName)
{
     QString sheetName;
     sheetName="mydatas";
     qDebug() <<"fileName"<<fileName;
     QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "excelexport");
     if(!db.isValid())
     {
      qDebug() << "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(fileName).arg(fileName);
         db.setDatabaseName(dsn);
         if(!db.open())
         {
           qDebug() << "export2Excel failed: Create Excel file failed by DRIVER={Microsoft Excel Driver (*.xls)}.";
           QSqlDatabase::removeDatabase("excelexport");
            return -3;
          }
             QSqlQuery query(db);
             //drop the table if it's already exists
             QString  sSql = QString("DROP TABLE [%1] ").arg(sheetName);
             query.exec(sSql);

             //create the table (sheet in Excel file)
             sSql = QString("CREATE TABLE [%1] (").arg(sheetName);
             sSql+="[网名] char(20) , [网站网址] char(20) ,[QQ号] char(20) ";
             sSql += ")";
             qDebug()<<"sSql"<<sSql;
             query.prepare(sSql);
             if(! query.exec())
             {
               qDebug() << "export2Excel failed: Create Excel sheet failed.";
                db.close();
                QSqlDatabase::removeDatabase("excelexport");
                return -4;
             }
         sSql =QString("INSERT INTO [%1] (").arg(sheetName);
         query.prepare( sSql+" 网名, 网站网址, QQ号) "
                         "VALUES (:name, :web, :qq)");
         query.bindValue(":name", "eeerrrrr");
         query.bindValue(":web", "http://www.satsuns.com");
         query.bindValue(":qq", 603031225);
         query.exec();
         return 1;
}