Calibration system and method based on EXCEL data structure

Abstract

The invention relates to the technical field of computer application, in particular to a calibration system and method based on an EXCEL data structure. The system is composed of two parts, namely a configuration library and calibrators, and externally connected with standard input and output; the configuration library comprises associated configuration information of a data structure and a data set, and provides rule bases for the calibrators; the two calibrators refer in particular to the data structure and the data set. First analysis matching is conducted on an EXCEL file through a structural calibrator, and if the matching fails, a prompt is given; if no prompt is given, on the basis of the successful first analysis matching, second analysis matching is conducted on the file by using a data calibrator, a matching result is only needed to meet a subclass of the data set, the file is stored in a classified mode according to the result and rules, otherwise, illegality is affirmed. The EXCEL data structure and the data set are stored in a configuration-based mode, the system has the advantages that the expansibility is good, the application range is wide, and the identifiability is high, and the system can be applied to multiple service-type systems to conduct legal check on files.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a verification system and method based on an EXCEL data structure. Background technique [0002] With the development of computer application technology, business systems tend to be more diversified. With the ever-growing business needs, the data association between application systems is getting closer and closer, and there is a large amount of data information interacting all the time. At present, report systems generally use EXCEL documents; however, the data structures in various EXCEL files are not uniform. When it is necessary to manually verify the format of these files and extract or blend the data, in addition to the problem of heavy workload, more considerations need to be made. The correctness of the data cannot be guaranteed. The legitimacy and correctness of data files is a concern for almost all business systems. When there are many types of data, t...

AI Technical Summary

Problems solved by technology

[0003] One of the technical problems solved by the present invention is to provide a verification system based on the EXCEL data structure in order to solve the problems of large workload and low accuracy of the EXCEL file verification operation; realize configuration flow management

[0004] The second technical problem solved by the present invention is to provide a verification method based on the verification system of the EXCEL data structure for the problems of large workload and low accuracy in the verification operation of EXCEL files; two verification methods are provided, both Layer protection, and supports the verification of multiple structural types, and provides a standard interface to ensure that the type can be extended

Images