Big data Excel parameterized configuration exporting method

Abstract

The invention relates to the technical field of data processing, and provides a big data Excel parameterized configuration exporting method. The method and the device aim at solving the problem that when Excel export supports template type data filling or the Excel is developed and assembled by using POI, the generation time of the Excel is too long during filling, the Excel needs to be generated in an asynchronous mode, or a large number of system resources are occupied, and operation of other services of a system is not smooth. According to the main scheme, the method comprises the following steps: converting an Excel template style to be generated into an xml configuration file; 2, reading the xml configuration file defined in the step 1 through a Digestor method, obtaining Excel configuration information, and obtaining excel attributes, sheet attributes and line attributes; according to the sheet attribute obtained in the step 2.2, assembling a sheet page in the excel file from the to-be-filled business data inquired from the database data; executing data filling operation according to the Excel configuration information obtained in the step 2 and the business data obtained in the step 3; and generating an Excel file, and compressing the Excel file.

Description

technical field [0001] The invention relates to the technical field of data processing, and provides a large data Excel parameterized configuration export method. Background technique [0002] This technology is applied to the scenario of exporting a large amount of data to generate Excel. This technology supports parametric configuration of Excel export-related attribute operations, which greatly reduces the development workload and export time of system big data Excel export. Through API encapsulation, the development difficulty and report generation time are reduced, and the efficiency of data processing and filling is improved, and the report generation time will not be too long due to the large amount of data, and the CPU overload will not affect the normal business processing of the system. [0003] technical background [0004] At present, the amount of data in the banking system is relatively large. When generating large data Excel reports, they all adopt the mecha...

AI Technical Summary

Problems solved by technology

[0008] The purpose of the present invention is to solve the problem that Excel export supports template data filling or use POI to develop and assemble Excel. As a result, when filling, Excel takes too long to generate and needs to be generated in an asynchronous form, or a large amount of system resources is occupied, resulting in other business operations of the system. Caton's problem

Images