Template report generation method based on multistage container unloading

Abstract

The invention provides a template report generation method based on multistage container unloading. The template report generation method comprises the following steps of: 1) replacing cells of actualdata in a report template with labels; 2) reading the template and storing positions and content of the cells of the labels into an input container; 3) reading a field of the input container, performing original data extraction after analyzing the field, filtering the extracted original data, and storing the filtered original data in a filter container; 4) performing analysis and classification processing on the data to obtain data required by the report and corresponding cell information, and storing the data and the cell information into an output container; and 5) reading the template, andperforming result replacement on the data cells of the labels in the template according to the data of the output container to generate a report with complete content. According to the template report generation method disclosed by the invention, the output of a report focuses on the analysis of the data in a label form, and the development pressure of a report chart is reduced; through a container cooperative interaction mode, the performance optimization is greatly improved; and the idea of the template is adopted to meet the functional experience of different users.

Description

technical field [0001] The invention belongs to the technical field of automatic report generation, and in particular relates to a template report generation method based on multi-level container dumping. Background technique [0002] With the popularization of information digitization, the extraction and analysis of data has become particularly important, especially in business operation and maintenance, the output of reports will facilitate the overall analysis of business conditions. [0003] At present, for report output to different business vendors, the general practice is to first understand the actual Excel report output requirements of the business vendor, and then conduct special development according to its format and charts, and re-select and re-select the charts every time the code is changed or added. Arrangement, data analysis and graph development simultaneously meet, such as figure 1 shown. The business personnel output the system resource status through E...

AI Technical Summary

Problems solved by technology

Business personnel use Excel reports to output similar system resources and complex charts. The development or export of a report cannot meet the work scenarios of most people, which makes the development of reports complicated or difficult to implement.

At the same time, the report output is slow in the case of a large amount of data, and it may take a long time to wait for the output of a report

[0004] To sum up, the disadvantages of the existing technology include: 1) It is necessary to adapt the chart according to the actual situation of the manufacturer. Different business manufacturers need to understand their business and then carry out special chart development and layout, which leads to repeated analysis of data and report development. conduct

2) Complicated charts cannot be satisfied, and the corresponding chart output for complex business situations will also be more complicated, and some may be difficult to implement

3) It is difficult to achieve the format expected by the user. The perspective of development and the perspective of the user may deviate in actual implementation, which may not fully meet the format expected by the user. The format may need to be adjusted according to the export situation

4) The increase in workload has increased the work energy of business vendors and developers, which requires the cooperation of both parties

5) Poor performance, which reduces the user's functional experience, and cannot output reports quickly in some urgent scenarios

Images