Design And Implementation Of A Smart Document Report System

Now in every company information is the most important respect to apply business destinations.In order to make the full use of the adventure of enterprise's information resources. Each application will require an expansion, reliable, Web-based solutions for the statements, analysis and related personnel to provide information crucial task to ensure operational success.Mitsubishi give us a research projects (Excel-DB connection).Primarily to improve some previous technical defect. They hope that through our research to improve the operational efficiency of the reporting system. We made the design of system based on a fully expect demand analysis, through the proposed introduction of Mitsubishi, we achieved the smart document statement reporting systems.The entire system consists of the following components: GUI (graphical user interface), ActiveX (control), Servlet (server). Through inserts the ActiveX and the OLE Container into the Excel documents, produces the brand-new Excel documents.Joins the logical control into the new Excel documents to realize the smart documents report form. GUI component include JSP pages and Excel VBA page. ActiveX component mainly to retrieve the information stored in Ole containers and made the logic control and access the server. Servlet mainly to deal with client's request.The workflow of this system is as follow. Firstly, configuration the template Excel through Excel VBA on a PC. Secondly, save all cell's configure information to the OLE container witch hided in the Excel. Thirdly, upload the configured Excel to the server for client access through IE browser. Fourthly, through the VBA menu trigger control events, get the configuration information form OLE container witch hid in the Excel hidden sheet. Finally, get the data from database on server through the ActiveX, then show the data on Excel.