The Research And Realization Of Delphi Dynamic Report By Utilizing OLE Automation And VBA

In view of in the researching topic of the 3S lab and deficiency to the traditional report form tool (face programmer's report form) of this text, providing one finding that Delphi realize resulting, user-oriented advanced picture and text report form print the technology of realizing. The user-oriented report form refers to users' following one's own requirement and carrying on adjusting, revise, add and report form deleted to the report form during the course of using. This kind of report form has strengthened the flexibility that the report form realizes and and users' interaction greatly, have met users' real-time requirement better. Meanwhile, this kind of report form has realized the code effectively and improved the systematic maintainability. This technology can imbed in various application systems simply conveniently, realize various complicated and dynamic report forms, and has carried on actual utilization in the MIS of Huangshi-Huangmei Highway electromechanical equipment, verify its exactness, dependability and flexibility .Through studying the memory mechanism and the internal data structure of the Microsoft Excel file, and obtained the internal detail of Excel file, and obtained the internal detail of Excel file, this text has researched develop the package interviewing Excel file on this basis. Microsoft for solve Windows communication problem that between the windows application software, get out of application program standardize OLE Company (Object Linkand Embedding ) and Windows application software of new generation one control the language VBA. VBA is a controlling languages common of Windows application software of new generation, it is that Microsoft Company is Office software development specially, it offer facing target procedure design method and introduce mechanism that incident urge use for the organization procedure.Through repeated test, this text has discussed utilizing Delphi support to OLE through probing into, solving the communication among Delphi, Excel and SQL Server, with Delphi strong data function and Excel fine making complicated report form function combine together, organic integration to realizedifferent application program, realize complicated making and report form of report form inquire about the possibility of the function.The realization of the concrete functional development of the dynamic report form is to use OLEAutomation technology in fact, by using OLE, users can control another application program (Excel) of object among one application program through programming,, it can be free according to the association with flexible one's own demand to report forms produced to reach finally by users, dismantle the purpose to grade. The mentality of designing is: Get one new record collection inquire , record centralized record write through Excel object of VBA into work of Excel Worksheet one by one and then, reveal, save, can print directly through Excel.Controls Excel in Delphi the method is first links the Excel table, carries on the operation in view of some Excel table;Next is controls WorkBook, Sheet, including establishes new WorkBook, Sheet, WorkBook, Sheet work and so on opens, the preservation, closes.This article has descripted the regular report form and the irregular report form realization used the code regarding to carry on separately in detail.