A verification system and method based on excel data structure

A data structure and data technology, applied in the direction of response errors, etc., can solve problems such as low accuracy and heavy workload of EXCEL file verification operations, so as to reduce uncertain factors and time spent, ensure verification and highly scalable effects

CN104915262BActive Publication Date: 2017-08-22G CLOUD TECH
2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Publication Date
2017-08-22

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

Embodiment Construction

[0041] See figure 1 , 2 As shown, the present invention consists of two parts, a configuration library and a validator, and is externally connected to standard input and output;

[0042] Configuration library: includes the associated configuration information of data structures and data sets, and provides a rule basis for the validator;

[0043] Validator: includes two validators for data structure and data set;

[0044] Standard input: the EXCEL file path to be verified;

[0045] Standard output: the path of the EXCEL file that has passed the verification and stored in categories

[0046] image 3 It shows the processing sequence diagram of the validator, and the detailed processing flow is:

[0047] In the first step, the validator is running;

[0048] The second step is to read the EXCEL file in the standard input directory;

[0049] The third step is to call the data structure validator to analyze whether the position of the data set in the EXCEL file matches the ex...