CN112114891A - Plug-in-based visual Word report generation system - Google Patents
Plug-in-based visual Word report generation system Download PDFInfo
- Publication number
- CN112114891A CN112114891A CN202010773963.0A CN202010773963A CN112114891A CN 112114891 A CN112114891 A CN 112114891A CN 202010773963 A CN202010773963 A CN 202010773963A CN 112114891 A CN112114891 A CN 112114891A
- Authority
- CN
- China
- Prior art keywords
- data
- template
- module
- user
- plug
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000000007 visual effect Effects 0.000 title claims abstract description 11
- 238000000034 method Methods 0.000 claims description 14
- 238000007689 inspection Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000012360 testing method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000004883 computer application Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44521—Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
- G06F9/44526—Plug-ins; Add-ons
Abstract
The application provides a visual Word report generation system based on plug-in, dynamic data in a template is defined through a template data definition module, a template editing module starts a local Word from a browser through a custom protocol to open a template file on a server to be edited, a report generation module uses a specified template and combines template data definition and service data to generate a report, the problems that the template editing is complex and the display mode and format of the data cannot be set are solved, and meanwhile, the reusability of the data is improved.
Description
Technical Field
The application relates to the field of computer application, in particular to a visual Word report generating system based on a plug-in.
Background
In the inspection and testing industry, a large number of inspection reports are generated every day, and most of the inspection reports are in word format for the sake of generality and convenience. In order to improve the efficiency of report formulation and improve the accuracy of report data and the timeliness of reports, a technology for realizing the automatic generation of Word reports is urgently needed. At present, some technologies for automatically generating word reports exist, which mainly insert bookmarks into words as templates, and then locate data according to the bookmarks and perform replacement. However, this method has some disadvantages, mainly including the following: 1) the bookmark positioning data is used, and the display mode, format and the like of the data cannot be set; 2) template editing needs to be carried out by developers, and if the template changes, the template is very troublesome to modify; 3) the data reusability is poor.
Disclosure of Invention
The application provides a plug-in-based visual Word report generation system, which solves the problems that the template editing is complex and the display mode and format of data cannot be set, and simultaneously improves the reusability of the data.
The application provides a visual Word report generating system based on plug-in, comprising:
the template data definition module is used for defining dynamic data in the template, and the defined data is used for being quoted by a user when the user edits the template;
the template editing module is used for opening a template file on the server through the Word plug-in to edit; after editing is finished, automatically synchronizing to a server for storage;
the report generation module is used for generating a report by using a template specified by a user according to a user instruction and combining the template data definition and the service data;
and the database module is used for storing the dynamic data in the template defined by the module data definition module.
Further, the template data defines the module, and the defined data includes: the data display name, the data unique mark, the data label, the data type and the data acquisition method.
Further, the template data defines the functions of the module, and further includes:
and providing an operation interface for a user to edit the template data definition.
Further, the template editing module is used for opening a template file on the server through a Word plug-in to edit, and comprises:
the Word plug-in dynamically acquires a data list defined by the template data definition module according to the template type; and inserting dynamic data through the dialog box, and setting the display mode and format of the dynamic data.
Further, the report generating module is configured to generate a report according to a user instruction, by using a template specified by a user and combining the template data definition and the service data, and includes:
the report generation module obtains a template specified by a user and analyzes a user-defined mark from the template;
obtaining the data type and the data acquisition method of the data in a template data definition table according to the custom mark name;
and acquiring corresponding data from the database according to the data type and the data acquisition method and displaying the data.
The application provides a visual Word report generation system based on plug-in, dynamic data in a template is defined through a template data definition module, a template editing module starts a local Word from a browser through a custom protocol to open a template file on a server to be edited, a report generation module uses a specified template and combines template data definition and service data to generate a report, the problems that the template editing is complex and the display mode and format of the data cannot be set are solved, and meanwhile, the reusability of the data is improved.
Drawings
FIG. 1 is a block diagram of a plug-in based visual Word report generation system provided by the present application;
FIG. 2 is a flow chart illustrating the generation of a plug-in based visualized Word report according to the present application.
Detailed Description
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present application. This application is capable of implementation in many different ways than those herein set forth and of similar import by those skilled in the art without departing from the spirit of this application and is therefore not limited to the specific implementations disclosed below.
Fig. 1 is a structural diagram of a plug-in based visual Word report generating system provided in the present application, and as can be seen from the diagram, the system includes 4 parts, which are a template data defining module, a template editing module, a report generating module and a database module, respectively, wherein,
and the template data definition module is used for defining dynamic data in the template, and the defined data is used for being quoted by a user when the user edits the template. The defined data includes: data display name, data unique mark, data label, data type, data acquisition method (can be SQL statement, storage process or data acquisition interface). The data defined herein is for reference by a user when editing the template. The template data definition module also provides an operation interface for a user to edit the template data definition, and can be maintained by developers or business personnel.
The template editing module is used for opening a template file on the server through the Word plug-in to edit; and after the editing is finished, automatically synchronizing to the server for storage. The template editing module is realized through a word plug-in, and comprises functions of template downloading, editing, automatic storage to a server and the like. The Word plug-in dynamically acquires a data list defined by the template data definition module according to the template type, inserts dynamic data through a dialog box, and sets the display mode and format of the dynamic data. Specifically, a Word plug-in user positions through a cursor at a place where dynamic data needs to be inserted, opens a data insertion dialog box, displays a data list in the dialog box, selects data to be inserted from the data list, sets a data display form and format, clicks and stores the data, and inserts a unique mark of the selected data into the template as a custom mark at the moment. The data display name needs to be set as a name which is easy to understand by business personnel, so that the business personnel can edit the template without the participation of developers.
And the report generation module is used for generating a report by using a template specified by a user according to the user instruction and combining the template data definition and the service data. The report generation module firstly obtains a template appointed by a user, analyzes a user-defined mark from the template, then obtains the data type and the data acquisition method of the data in a template data definition table according to the name of the user-defined mark, and then obtains and displays the corresponding data in a database according to the data type and the data acquisition method.
And the database module is used for storing the dynamic data in the template defined by the module data definition module.
In a specific application embodiment, as shown in fig. 2, a test report generation function is generally used as a sub-module of a test service management system and deployed at a server; the template editing plug-in is installed on a computer of a user and serves as a client, and meanwhile the user can use a browser to access a server to conduct operations such as template management, report generation and template data definition. The user defines and explains the data in the report through the template data definition module, and the data definition comprises a display name, a unique identifier, a data type and a data acquisition method (which can be SQL statements, stored procedures or a data acquisition interface) of the data. The data definition is stored in a database and can be common to all templates. And the user enhances the word function by means of a word plug-in, directly starts a local word from the browser by a user-defined protocol to open a template file on the server for editing, and automatically synchronizes to the server for storage after editing is completed. The user can conveniently perform template editing operation like editing a local word file. And if the dynamic data needs to be inserted, positioning the cursor to the place where the data needs to be inserted, then selecting the data according to the display name of the data through a custom dialog box, and setting the display form, format and the like of the data according to the needs. And generating a report according to the template and the data definition, and inserting the unique identifier of the dynamic data inserted by the user into the template as a self-defined mark when the user edits the template. The custom mark format is: { { data unique identification | display form | format } }. When a report is generated, a data acquisition method of the data is found in the data definition table according to the custom mark in the template, and the data is obtained by calling and then displayed according to the format and the form set by the user. Report generation can be performed on-line or directly through a template editing plug-in.
The application provides a visual Word report generation system based on plug-in, dynamic data in a template is defined through a template data definition module, a template editing module starts a local Word from a browser through a custom protocol to open a template file on a server to edit, a report generation module uses a specified template and combines template data definition and service data to generate a report, the generation efficiency of the report in the inspection and detection industry can be effectively improved, and the accuracy and timeliness of report data are improved. The problems that template editing is complex and the display mode and format of the data cannot be set are solved, and the reusability of the data is improved.
Finally, it should be noted that: although the present invention has been described in detail with reference to the above embodiments, it should be understood by those skilled in the art that various changes may be made and equivalents may be substituted for elements thereof without departing from the spirit and scope of the invention.
Claims (5)
1. A visual Word report generation system based on plug-in, comprising:
the template data definition module is used for defining dynamic data in the template, and the defined data is used for being quoted by a user when the user edits the template;
the template editing module is used for opening a template file on the server through the Word plug-in to edit; after editing is finished, automatically synchronizing to a server for storage;
the report generation module is used for generating a report by using a template specified by a user according to a user instruction and combining the template data definition and the service data;
and the database module is used for storing the dynamic data in the template defined by the module data definition module.
2. The system of claim 1, wherein the template data defines a module, the defined data comprising: the data display name, the data unique mark, the data label, the data type and the data acquisition method.
3. The system of claim 1, wherein the template data defines functions of a module, further comprising:
and providing an operation interface for a user to edit the template data definition.
4. The system of claim 1, wherein the template editing module is configured to open a template file on the server for editing through a Word plug-in, and comprises:
the Word plug-in dynamically acquires a data list defined by the template data definition module according to the template type; and inserting dynamic data through the dialog box, and setting the display mode and format of the dynamic data.
5. The system of claim 1, wherein the report generation module, configured to generate the report according to the user instruction by using the user-specified template in combination with the template data definition and the service data, comprises:
the report generation module obtains a template specified by a user and analyzes a user-defined mark from the template;
obtaining the data type and the data acquisition method of the data in a template data definition table according to the custom mark name;
and acquiring corresponding data from the database according to the data type and the data acquisition method and displaying the data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010773963.0A CN112114891A (en) | 2020-08-04 | 2020-08-04 | Plug-in-based visual Word report generation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010773963.0A CN112114891A (en) | 2020-08-04 | 2020-08-04 | Plug-in-based visual Word report generation system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112114891A true CN112114891A (en) | 2020-12-22 |
Family
ID=73799499
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010773963.0A Pending CN112114891A (en) | 2020-08-04 | 2020-08-04 | Plug-in-based visual Word report generation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112114891A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113850059A (en) * | 2021-12-01 | 2021-12-28 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100174981A1 (en) * | 2004-08-24 | 2010-07-08 | Oracle International Corporation | Rtf template and xsl/fo conversion: a new way to create computer reports |
| CN101976235A (en) * | 2010-09-21 | 2011-02-16 | 天津神舟通用数据技术有限公司 | Extensible Word report automatically-generating method based on dynamic web page |
| CN104657340A (en) * | 2015-02-10 | 2015-05-27 | 上海创景计算机系统有限公司 | Expandable script-based Word report generating system and method |
| CN109299446A (en) * | 2018-08-03 | 2019-02-01 | 新华三大数据技术有限公司 | Report-generating method and device |
| CN109359284A (en) * | 2018-09-25 | 2019-02-19 | 深圳市稳大网络技术有限公司 | A kind of reporting and processing method, device and terminal device |
| CN110705209A (en) * | 2019-09-29 | 2020-01-17 | 武汉海昌信息技术有限公司 | Method and system for on-line amending manuscript |
-
2020
- 2020-08-04 CN CN202010773963.0A patent/CN112114891A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100174981A1 (en) * | 2004-08-24 | 2010-07-08 | Oracle International Corporation | Rtf template and xsl/fo conversion: a new way to create computer reports |
| CN101976235A (en) * | 2010-09-21 | 2011-02-16 | 天津神舟通用数据技术有限公司 | Extensible Word report automatically-generating method based on dynamic web page |
| CN104657340A (en) * | 2015-02-10 | 2015-05-27 | 上海创景计算机系统有限公司 | Expandable script-based Word report generating system and method |
| CN109299446A (en) * | 2018-08-03 | 2019-02-01 | 新华三大数据技术有限公司 | Report-generating method and device |
| CN109359284A (en) * | 2018-09-25 | 2019-02-19 | 深圳市稳大网络技术有限公司 | A kind of reporting and processing method, device and terminal device |
| CN110705209A (en) * | 2019-09-29 | 2020-01-17 | 武汉海昌信息技术有限公司 | Method and system for on-line amending manuscript |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113850059A (en) * | 2021-12-01 | 2021-12-28 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
| CN113850059B (en) * | 2021-12-01 | 2022-03-22 | 北京一起教育科技有限责任公司 | Method and device for generating evaluation report and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9207933B2 (en) | Identifying authors of changes between multiple versions of a file | |
| CA3152833C (en) | Webpage editing method and device | |
| MXPA04000611A (en) | System and method for real-time observation assessment. | |
| CN111881037A (en) | Test case management method and device and electronic equipment | |
| CN108170727A (en) | A kind of automatic processing method and device for interlocking data | |
| CN115293124A (en) | Automatic generation method and device for software engineering document | |
| CN111061696A (en) | Method and device for analyzing transaction message log | |
| CN112114891A (en) | Plug-in-based visual Word report generation system | |
| CN103913672B (en) | A kind of satellite low frequency interface automatization test system | |
| CN111242578A (en) | Method, device and system for distributing operation program | |
| CN109492036A (en) | A kind of electronization test report system | |
| CN109086985A (en) | Professional test information management system towards spacecraft | |
| CN113360383A (en) | Automatic test software data dynamic synchronization method of comprehensive detection equipment | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN116028647A (en) | Knowledge-graph-based fusion education intelligent comment method and system | |
| CN113901097A (en) | Method and system for quickly searching service link and service under micro-service architecture | |
| CN109447844A (en) | A kind of management method of electronization test report | |
| CN105607957B (en) | A kind of data acquisition analysis system based on OPC DA | |
| CN111435372A (en) | Data display method and system, data editing method and system, equipment and medium | |
| CN113312260B (en) | Interface test method, device, equipment and storage medium | |
| CN113840110A (en) | Video processing method and device for workflow and storage medium | |
| CN116136880A (en) | Data display method and device, electronic equipment and storage medium | |
| Perrone et al. | Enhancing the credibility of wireless network simulations with experiment automation | |
| CN112508535A (en) | Jbpm-based method and device for improving approval workflow | |
| CN111783391A (en) | Online artificial text marking system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201222 |
|
| RJ01 | Rejection of invention patent application after publication |