QT基础篇（14）QT操作office实例

1.QT操作office的基本方式

通过QT操作Office软件，可以使用Qt的QAxObject类来进行操作。下面是一个例子，展示了通过Qt操作Excel的基本方式：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject excel("Excel.Application");excel.setProperty("Visible", true);QAxObject *workbooks = excel.querySubObject("Workbooks");QAxObject *workbook = workbooks->querySubObject("Add");QAxObject *sheets = workbook->querySubObject("Sheets");QAxObject *sheet = sheets->querySubObject("Item(int)", 1);QAxObject *cell = sheet->querySubObject("Cells(int,int)", 1, 1);cell->setProperty("Value", "Hello, World!");workbook->dynamicCall("SaveAs(const QString&)", "C:\\path\\to\\file.xlsx");workbook->dynamicCall("Close(Boolean)", false);excel.dynamicCall("Quit()");delete cell;delete sheet;delete sheets;delete workbook;delete workbooks;return app.exec();
}

上述示例中，首先创建了一个QAxObject实例，指定了要操作的Office软件，这里是Excel。然后通过querySubObject方法来获取各种对象，例如Workbooks、Sheets和Cells。使用这些对象，可以执行各种操作，如添加工作簿、添加工作表、获取单元格并设置值等。最后，使用dynamicCall方法执行一些动态调用，例如保存工作簿，并关闭Excel应用程序。

通过类似的方式，你可以使用Qt来操作其他Office软件，如Word和PowerPoint。只需将上述示例中的"Excel.Application"替换为"Word.Application"或"PowerPoint.Application"即可。

需要注意的是，要在Qt项目中使用Qt的ActiveX模块，需要在Qt项目文件(.pro)中添加如下行：

QT += axcontainer

希望这个例子能帮到你，祝你成功操作Office软件！

2.QT对Excel/office的基本读写

通过Qt可以实现对Office软件（如Excel、Word和PowerPoint）的基本读写操作。以下是一些示例代码，展示了如何使用Qt来读取和写入Excel、Word和PowerPoint文档的基本方法：

读取Excel文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject excel("Excel.Application");excel.setProperty("Visible", true);QAxObject *workbooks = excel.querySubObject("Workbooks");QAxObject *workbook = workbooks->querySubObject("Open(const QString&)", "C:\\path\\to\\file.xlsx");QAxObject *sheets = workbook->querySubObject("Sheets");QAxObject *sheet = sheets->querySubObject("Item(int)", 1);QAxObject *cell = sheet->querySubObject("Cells(int,int)", 1, 1);QString value = cell->property("Value").toString();qDebug() << "Cell A1 value: " << value;workbook->dynamicCall("Close(Boolean)", false);excel.dynamicCall("Quit()");delete cell;delete sheet;delete sheets;delete workbook;delete workbooks;return app.exec();
}

写入Excel文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject excel("Excel.Application");excel.setProperty("Visible", true);QAxObject *workbooks = excel.querySubObject("Workbooks");QAxObject *workbook = workbooks->querySubObject("Open(const QString&)", "C:\\path\\to\\file.xlsx");QAxObject *sheets = workbook->querySubObject("Sheets");QAxObject *sheet = sheets->querySubObject("Item(int)", 1);QAxObject *cell = sheet->querySubObject("Cells(int,int)", 1, 1);cell->setProperty("Value", "Hello, World!");workbook->dynamicCall("Save()");workbook->dynamicCall("Close(Boolean)", false);excel.dynamicCall("Quit()");delete cell;delete sheet;delete sheets;delete workbook;delete workbooks;return app.exec();
}

读取Word文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject word("Word.Application");word.setProperty("Visible", true);QAxObject *documents = word.querySubObject("Documents");QAxObject *document = documents->querySubObject("Open(const QString&)", "C:\\path\\to\\file.docx");QAxObject *selection = word.querySubObject("Selection");QString text = selection->property("Text").toString();qDebug() << "Document content: " << text;document->dynamicCall("Close(Boolean)", false);word.dynamicCall("Quit()");delete selection;delete document;delete documents;return app.exec();
}

写入Word文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject word("Word.Application");word.setProperty("Visible", true);QAxObject *documents = word.querySubObject("Documents");QAxObject *document = documents->querySubObject("Add()");QAxObject *selection = word.querySubObject("Selection");selection->dynamicCall("TypeText(const QString&)", "Hello, World!");document->dynamicCall("SaveAs(const QString&)", "C:\\path\\to\\file.docx");document->dynamicCall("Close(Boolean)", false);word.dynamicCall("Quit()");delete selection;delete document;delete documents;return app.exec();
}

读取PowerPoint文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject powerpoint("PowerPoint.Application");powerpoint.setProperty("Visible", true);QAxObject *presentations = powerpoint.querySubObject("Presentations");QAxObject *presentation = presentations->querySubObject("Open(const QString&)", "C:\\path\\to\\file.pptx");QAxObject *slides = presentation->querySubObject("Slides");QAxObject *slide = slides->querySubObject("Item(int)", 1);QAxObject *shapes = slide->querySubObject("Shapes");int shapeCount = shapes->property("Count").toInt();qDebug() << "Number of shapes in slide: " << shapeCount;presentation->dynamicCall("Close(Boolean)", false);powerpoint.dynamicCall("Quit()");delete shapes;delete slide;delete slides;delete presentation;delete presentations;return app.exec();
}

写入PowerPoint文档：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject powerpoint("PowerPoint.Application");powerpoint.setProperty("Visible", true);QAxObject *presentations = powerpoint.querySubObject("Presentations");QAxObject *presentation = presentations->querySubObject("Add()");QAxObject *slides = presentation->querySubObject("Slides");QAxObject *slide = slides->querySubObject("Add(int, int)", 1, 1);QAxObject *shapes = slide->querySubObject("Shapes");QAxObject *textShape = shapes->querySubObject("AddTextEffect(int, const QString&, const QString&, double, double, double, double)");textShape->setProperty("Text", "Hello, World!");presentation->dynamicCall("SaveAs(const QString&)", "C:\\path\\to\\file.pptx");presentation->dynamicCall("Close(Boolean)", false);powerpoint.dynamicCall("Quit()");delete textShape;delete shapes;delete slide;delete slides;delete presentation;delete presentations;return app.exec();
}

请确保在Qt项目文件(.pro)中添加了QT += axcontainer以支持Qt的ActiveX模块。

希望以上示例能帮到你，祝你成功操作Office软件！

3.QT操作word应用

通过Qt可以使用ActiveX技术来操作Word应用。以下是一个示例代码，展示了如何使用Qt来打开Word应用、创建文档、写入内容和保存文档的基本方法：

#include <QApplication>
#include <QAxObject>int main(int argc, char *argv[])
{QApplication app(argc, argv);QAxObject word("Word.Application");word.setProperty("Visible", true);QAxObject *documents = word.querySubObject("Documents");QAxObject *document = documents->querySubObject("Add()");QAxObject *selection = word.querySubObject("Selection");selection->dynamicCall("TypeText(const QString&)", "Hello, World!");document->dynamicCall("SaveAs(const QString&)", "C:\\path\\to\\file.docx");document->dynamicCall("Close(Boolean)", false);word.dynamicCall("Quit()");delete selection;delete document;delete documents;return app.exec();
}

在该示例中，我们首先创建了一个QAxObject实例，用于表示Word应用。然后，我们设置了Visible属性为true，这样可以在打开的Word界面中看到操作过程。接下来，我们使用querySubObject方法获取了Documents对象，并通过Add方法创建了一个新的文档对象。然后，我们使用querySubObject方法获取了Selection对象，然后使用TypeText方法向文档中输入了"Hello, World!"的内容。最后，我们使用SaveAs方法将文档保存到指定路径，然后使用Close方法关闭文档。最后，我们调用Quit方法关闭Word应用。

请确保在Qt项目文件(.pro)中添加了QT += axcontainer以支持Qt的ActiveX模块。

希望以上示例能帮到你，祝你操作Word应用成功！