QString fileName = QFileDialog::getSaveFileName(this, tr("Excel file"), qApp->applicationDirPath(),tr("Excel Files (*.xls)"));
if (fileName.isEmpty())
return;
if (excel(fileName))//调用导出Excel方法
{
QMessageBox::about(this, QStringLiteral("提示"), QStringLiteral("Excel文件 导出完成") );
QSqlDatabase::removeDatabase("excelexport");
}
{
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "excelexport");
if(!db.isValid())
{
return false;
}
QString dsn = QString("DRIVER={Microsoft Excel Driver (*.xls)};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%1\";DBQ=%2").arg(fileName).arg(fileName);