Method, device, terminal device and storage medium for automatic import of excel data based on aviator

Abstract

The invention relates to the field of data processing, in particular to an Aviator-based Excel data automatic import method, device, terminal equipment and storage medium. The method comprises: obtaining and analyzing the typesetting mode of the excel data, determining the matching extraction rules of the Aviator expression; determining the absolute position and the relative position of the excel data based on the Aviator expression, and extracting the data object; assembling the data object, and configuring the view The associated information corresponding to the data and the mapping relationship with the standard output data; output standard json data. Utilize aviator technology, read the configuration through software, and automatically convert irregular, messy and complex excel into standard excel and output it to the application software system for any aviator expression configuration data matched by excel template, realizing the intelligence of excel import change.

Description

technical field [0001] The invention relates to the field of data processing, in particular to an Aviator-based Excel data automatic import method, device, terminal equipment and storage medium. Background technique [0002] Aviator is a high-performance, lightweight expression evaluation engine implemented in java language, mainly used for dynamic evaluation of various expressions. The basic process of Aviator is to directly translate the expression into the corresponding java bytecode for execution. The whole process can be scanned twice at most (enable the execution priority mode, and only one pass if it is in the compilation priority mode), so as to ensure its performance beyond Most of the explanatory expression engines have been tested to prove this; secondly, they do not rely on any third-party libraries except the commons-beanutils library (for reflection), so the overall is very lightweight, and the entire jar package size Even if it develops to the current version...

AI Technical Summary

Problems solved by technology

The method includes: encapsulating the data to be displayed into different data objects and setting the corresponding association relationship between the different data objects, drawing an Excel page template according to the encapsulated different data objects, and encapsulating the data corresponding to the encapsulated different data objects Fill in the corresponding Excel page template to generate the corresponding Sheet page data, and set the corresponding relationship between the corresponding Sheet page data according to the corresponding relationship between different data objects to generate an Excel report file; the Excel report The file generation method has the following deficiencies. When sorting and summarizing various types of Excel packages, users need to sort out and import the software system platform according to the standard excel template, which consumes manpower, and the work efficiency is low, and there are also errors.

Images