如何使用<em>Qt</em>来操作Excel

SpreadSheets\images\gotocell.png
............\......\save.png
............\......\paste.png
............\......\icon.png
............\......\new.png
............\......\find.png
............\......\open.png
............\......\copy.png
............\......\cut.png
............\spreadsheet.cpp
............\sortdialog.cpp
............\sortdialog.h
............\mainwindow.h
............\sortdialog.ui
............\finddialog.cpp
............\spreadsheet.pro
............\gotocelldialog.ui
............\spreadsheet.h
............\mainwindow.cpp
............\finddialog.h
............\gotocelldialog.h
............\gotocelldialog.cpp
............\main.cpp
............\spreadsheet.qrc
............\cell.h
............\cell.cpp
............\images

1、显示当前窗口：
excel.setProperty("Visible", true);
2、更改 Excel 标题栏：
excel.setProperty("Caption", "Invoke Microsoft Excel");
3、添加新工作簿：
QAxObject * workbooks = excel.querySubObject("WorkBooks");
workbooks->dynamicCall("Add");
4、打开已存在的工作簿：
workbooks->dynamicCall("Open (const QString&)", QString("c:/test.xls"));
5、获取活动工作簿：
QAxObject * workbook = excel.querySubObject("ActiveWorkBook");
6、获取所有的工作表：
QAxObject * worksheets = workbook->querySubObject("WorkSheets");
7、获取工7a686964616fe59b9ee7ad94333作表数量：
int intCount = worksheets->property("Count").toInt();
8、获取第一个工作表：
QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", 1);
9、获取cell的值：
QAxObject * range = worksheet->querySubObject("Cells(int,int)", 1, 1 );
QAxWidget excel("Excel.Application"); 1) 显示当前窗copy口：百 excel.setProperty("Visible", true); 2) 更改 Excel 标题栏：度 excel.setProperty("Caption", "Invoke Microsoft Excel");

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
if(!db.isValid())
{
qDebug() << "export2Excel failed: QODBC not supported.";
return ;
}
QString xlsFile = "D:/test.xls";
QString dsn = QString("DRIVER={Microsoft Excel Driver (*.xls)};Readonly=0;DriverId=790;DBQ=%1").arg(xlsFile);
db.setDatabaseName(dsn);
if(!db.open())
{
//错误处理
return;
}
QString queryystr = "select * from [sheet1$]";
SqlTableModel*excelTableModel = new SqlTableModel(this, db);
QString tableName = "[sheet1$]";
excelTableModel->setTable(tableName);
QSqlQuery querry(queryystr, db);
excelTableModel->setQuery(querry);
excelTableModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
excelTableModel->setSort(0, Qt::AscendingOrder);
bool ok = excelTableModel->select(); //选取整个表的所有行

ui.tableView_2->setModel(excelTableModel);
int i = 0;
foreach(QString heardName, heardList)
{
excelTableModel->setHeaderData(i, Qt::Horizontal, heardName);
i++;
}
int sqlTableCount = m_sqlTableModel->rowCount();
int excelTableCount = excelTableModel->rowCount();
QList<QSqlRecord> tmprecord;
for (int row = 0; row < excelTableCount; row++ )
{
QSqlRecord excelRecord = excelTableModel->record(row);
tmprecord << excelRecord;
}

db.close();
bool open = m_dba.open();

foreach(QSqlRecord record, tmprecord)
{
bool ok = m_sqlTableModel->insertRow(sqlTableCount); //添加一行
for (int k = 0; k<5;k++)
{
if (k == 0)
{
bool suc= m_sqlTableModel->setData(m_sqlTableModel->index(sqlTableCount,k),record.value(k), Qt::CheckStateRole);
}
bool suc= m_sqlTableModel->setData(m_sqlTableModel->index(sqlTableCount,k),record.value(k), Qt::EditRole);
}
sqlTableCount++;
}
AlterButtonClicked();

initWindow(TEACHERMANAGECLICKED);
AlterButtonClicked()
{
m_sqlTableModel->database().transaction(); //开始事务操作
if (m_sqlTableModel->submitAll())
{
m_sqlTableModel->database().commit(); //提交
}
else
{
m_sqlTableModel->database().rollback(); //回滚
QMessageBox::warning(this, tr("Model"), tr("数据库错误: %1").arg(m_sqlTableModel->lastError().text()));
}
}

initWindow(int index)
{
int i = 0;
heardList.clear();
if (index == STUDENTMANAGECLICKED)
{
heardList << "选择" << "编号" << "姓名" << "性别" << "班级" << "备注e799bee5baa6e79fa5e98193e59b9ee7ad94366";

m_sqlTableModel->setTable("\"StudentInfo\"");
m_sqlTableModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
m_sqlTableModel->setSort(0, Qt::AscendingOrder);
m_sqlTableModel->select(); //选取整个表的所有行
ui.tableView_2->setModel(m_sqlTableModel);
foreach(QString heardName, heardList)
{
m_sqlTableModel->setHeaderData(i, Qt::Horizontal, heardName);
i++;
}
}
else if (index == TEACHERMANAGECLICKED)
{
heardList << "选择" << "用户名" << "姓名" << "性别" << "角色" << "备注";
m_sqlTableModel->setTable("\"TeacherInfo\"");
m_sqlTableModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
m_sqlTableModel->setSort(0, Qt::AscendingOrder);
bool ok1 = m_sqlTableModel->select(); //选取整个表的所有行
ui.tableView_2->setModel(m_sqlTableModel);

foreach(QString heardName, heardList)
{
m_sqlTableModel->setHeaderData(i, Qt::Horizontal, heardName);
i++;
}
}
//m_sqlTableModel->insertColumn(0);

ui.tableView_2->resizeColumnsToContents();

}