使用Qt/C++编程操作Microsoft Office软件的应用

Microsoft office系列软件在日常工作中应用广泛。我单位在工程项目中大量使用Office软件进行数据处理及交换,对这些原始数据采取适当的方法分析挖掘,可以极大地缩短设计与试验周期、降低成本。由于项目产生的临时数据常以不同格式存放在各种办公软件中,且数量巨大,所以需要一个可以控制Office系列办公软件的程序来完成原始信息的收集及输出。给出了通过使用基于C++的Qt框架并结合COM、ODBC技术获取、处理数据,并输出至数据库或XML文档的实现方法。

Application of Processing Microsoft Office File Using Qt/C++ Framework

ABSTRACT Microsoft Office Series software has been widely applied in our daily work.Large amounts of data have been generated during the course of Data Exchange and Transaction.The costs and cycles reduction of both design and authentication can be implemented by analysis and mining raw data through an appropriate procedure.The temporary data generated by project items usually saved in different kinds of Office software,therefore,an application is needed to control Office series software for raw data acquisition,analysis and output.In this paper,the programming platform is Qt Framework based on C++,raw data acquired and analyzed by ODBC and COM API,data export in database or XML format.