A verification system and method based on excel data structure

Abstract

The invention relates to the field of computer application technology, in particular to a verification system and method based on an EXCEL data structure. The system of the present invention is composed of two parts, a configuration library and a validator, and is externally connected with standard input and output. The configuration library includes the associated configuration information of the data structure and the data set, and provides a rule basis for the validator; the validator specifically refers to the two validators of the data structure and the data set. The EXCEL file is analyzed and matched for the first time through the structure validator, and a prompt will be displayed if the matching fails; otherwise, the data set validator is used to analyze and match the file for the second time on the basis of the successful matching of the first time, and the matching result only needs to satisfy A subset of the data set, the result conforms to the rules and the files are classified and stored, otherwise it is considered illegal. The invention configures and stores the EXCEL data structure and data sets, has the characteristics of good expansibility, wide application range and high identification, and can be applied to verify the legality of files in various business systems.

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