Method for exporting high-throughput data report

Abstract

The invention discloses a method for exporting a high-throughput data report. The method comprises the following steps of: 1, requesting by a user and specifying a generation mode and a report rule; 2, initializing a report engine, saving the rule specified by the user and setting mode of data; 3, generating a Microsoft Office open extensible markup language (OOXML) folder; 4, loading the data according to a data generation mode provided by the user to generate a plurality of Excel SHEETs, generating a standard Excel data file, an XML file described by a diagram and the XML described by an Excel formula according to a Freemarker template defined by a template engine, and generating the XML file described by complex formats such as a merge cell and the like according to configuration or template; and 5, generating one or more Excel files according to size of data quantity, returning to the user for processing and deleting a temporary file generated by a system. The method has the advantages of high performance, compatibility and programming irrelevance, effectively improves the response speed of the report system and greatly reduces software development cost.

Description

technical field [0001] The invention relates to a method for exporting data, in particular to a method for exporting high-throughput data reports. Background technique [0002] With the popularization of computers and the development of networks, computers play an increasingly important role in people's work and life. With the development of company informatization, the IT data generated is becoming larger and larger, and the existing data processing software can no longer meet the requirements. The needs of the people, the main issues are as follows, [0003] 1. Generate report files based on binary format, resulting in high resource usage and low performance. When dealing with large amounts of data, it is easy to cause problems such as memory overflow. [0004] 2. It is difficult to customize reports and secondary development without programming knowledge. The designers of the existing report systems are not user-friendly, and it is difficult for users without programming...

AI Technical Summary

Problems solved by technology

[0003] 1. Generate report files based on binary format, resulting in high resource usage and low performance. When dealing with large amounts of data, it is easy to cause problems such as memory overflow

[0004] 2. It is difficult to customize reports and secondary development without programming knowledge. The designers of existing report systems are not user-friendly, and it is difficult for users without programming knowledge to customize reports

[0005] 3. It is difficult to integrate charts with Office. The charts of existing reports are all pictures generated separately, and it is difficult to integrate with Office software.

[0006] 4. The compatibility of office software is not good. The existing report technology only supports MS Office. When using WPS, Open Office will have problems

[0007] 5. Third-party system report integration, existing reports do not support grabbing existing reports from third-party systems

[0008] Existing data processing software is far from being able to meet people's increasing requirements for massive data processing

Images