CN108197114A - Detection method, device, storage medium and the electronic device of list data - Google Patents
Detection method, device, storage medium and the electronic device of list data Download PDFInfo
- Publication number
- CN108197114A CN108197114A CN201810055422.7A CN201810055422A CN108197114A CN 108197114 A CN108197114 A CN 108197114A CN 201810055422 A CN201810055422 A CN 201810055422A CN 108197114 A CN108197114 A CN 108197114A
- Authority
- CN
- China
- Prior art keywords
- table element
- rule
- detected
- data
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a kind of detection method of list data, device, storage medium and electronic devices.Wherein, this method includes:The first table element is obtained in list data detection client, wherein, for list data detection client for being detected to the first table element, the first table element is table element to be detected;Obtain target detection rule file corresponding with the first table element mark that the first table element carries, wherein, table element mark and detected rule file with correspondence are stored in list data detection client, target detection rule file is used to indicate the target detection rule that the target table data carried in the first table element should meet;Whether detection target table data meet target detection rule, obtain testing result;First table element, target table data and testing result of the display with correspondence in list data detection client.The present invention solves the technical issues of detection efficiency is relatively low when being detected to list data.
Description
Technical field
The present invention relates to the communications field, in particular to a kind of detection method of list data, device, storage medium
And electronic device.
Background technology
Allocation list quantity of the application program during exploitation and operation can be more and more, and table content is with version updating
Can largely it increase.The planning of application and operation personnel are susceptible to form or logic error when editing a large amount of table contents, lead
Cause the flow of follow-up test-modification-re-test that can waste the plenty of time of planning, operation and tester.Therefore, it is necessary to plan
The content of table is detected with operation personnel.Traditional detection method is that planning and operation personnel estimate detection table knot
Fruit writes program in machine code in form document table content is detected.Both methods all there are it is larger the shortcomings that.
It is huge to manpower consumption by the scheme for planning to estimate detection table results with operation personnel.The a large amount of tables of artificial detection are easily seen
Again or table content is leaked through, while estimate detection to find out whether form is correct, it is impossible to detect the correctness of logic.In table
Program in machine code is write in lattice file to the scheme that table content is detected to personnel requirement height.Write program in machine code requirement planning
There is certain logical thinking ability and programming basis with operation personnel, most of planning and operation personnel do not have programming energy
Power, and the personnel for having program capability do not know table content detected rule, communication cost between the two is huge.
For it is above-mentioned the problem of, currently no effective solution has been proposed.
Invention content
An embodiment of the present invention provides a kind of detection method of list data, device, storage medium and electronic device, so that
The technical issues of detection efficiency is relatively low when few solution is detected list data.
One side according to embodiments of the present invention provides a kind of detection method of list data, including:In table number
The first table element is obtained in client according to detecting, wherein, the list data detection client is used for first table
Element is detected, and first table element is table element to be detected;Obtain what is carried with first table element
First table element identifies corresponding target detection rule file, wherein, it is stored with tool in the list data detection client
The table element mark and detected rule file, the target detection rule file for having correspondence are used to indicate first table
The target detection rule that the target table data carried in lattice element should meet;Detect whether the target table data meet institute
Target detection rule is stated, obtains testing result;Display has described in correspondence in list data detection client
First table element, the target table data and the testing result.
Another aspect according to embodiments of the present invention additionally provides a kind of detection device of list data, including:First obtains
Modulus block, for obtaining the first table element in list data detection client, wherein, the list data detects client
For being detected to first table element, first table element is table element to be detected;Second obtains mould
Block, for obtaining target detection rule file corresponding with the first table element mark that first table element carries,
In, table element mark and detected rule file with correspondence, institute are stored in the list data detection client
It states target detection rule file and is used to indicate the target inspection that the target table data carried in first table element should meet
Gauge is then;Detection module for detecting whether the target table data meet the target detection rule, obtains detection knot
Fruit;Display module, for the list data detection client on display with correspondence first table element,
The target table data and the testing result.
Another aspect according to embodiments of the present invention additionally provides a kind of storage medium, which is characterized in that the storage is situated between
Computer program is stored in matter, wherein, the computer program is arranged to perform described in any of the above-described during operation
Method.
Another aspect according to embodiments of the present invention additionally provides a kind of electronic device, including memory and processor,
It is characterized in that, computer program is stored in the memory, and the processor is arranged to hold by the computer program
Method described in row any of the above-described.
In embodiments of the present invention, the first table element is obtained using in list data detection client, wherein, table
For Data Detection client for being detected to the first table element, the first table element is table element to be detected;It obtains
Target detection rule file corresponding with the first table element mark that the first table element carries, wherein, list data detection
Table element mark and detected rule file with correspondence are stored in client, target detection rule file is used to refer to
Show the target detection rule that the target table data carried in the first table element should meet;Whether detection target table data accord with
Target detection rule is closed, obtains testing result;First table of the display with correspondence in list data detection client
The mode of element, target table data and testing result obtains the first table to be detected in list data detection client
Element, and target detection rule file corresponding with first table element is obtained, it is automatically right by list data detection client
Whether the target table data in the first table element meet the target detection rule in target detection rule file, then will detection
As a result it is shown in list data detection client, realizes automatic detection and the batch detection of list data, it is achieved thereby that
The technique effect of detection efficiency when being detected to list data is improved, and then solves and is examined when being detected to list data
Survey the technical issues of less efficient.
Description of the drawings
Attached drawing described herein is used to provide further understanding of the present invention, and forms the part of the application, this hair
Bright illustrative embodiments and their description do not constitute improper limitations of the present invention for explaining the present invention.In the accompanying drawings:
Fig. 1 is a kind of schematic diagram of the detection method of optional list data according to embodiments of the present invention;
Fig. 2 is a kind of application environment schematic diagram of the detection method of optional list data according to embodiments of the present invention;
Fig. 3 is a kind of schematic diagram of the detection device of optional list data according to embodiments of the present invention;
Fig. 4 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
One;
Fig. 5 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
Two;
Fig. 6 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
Three;
Fig. 7 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
Four;
Fig. 8 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
Five;
Fig. 9 is a kind of application scenarios schematic diagram of the detection method of optional list data according to embodiments of the present invention
Six;And
Figure 10 is a kind of schematic diagram of optional electronic device according to embodiments of the present invention.
Specific embodiment
In order to which those skilled in the art is made to more fully understand the present invention program, below in conjunction in the embodiment of the present invention
The technical solution in the embodiment of the present invention is clearly and completely described in attached drawing, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
Member's all other embodiments obtained without making creative work should all belong to the model that the present invention protects
It encloses.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be the object for distinguishing similar, and specific sequence or precedence are described without being used for.It should be appreciated that it uses in this way
Data can be interchanged in the appropriate case, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment
Those steps or unit clearly listed, but may include not listing clearly or for these processes, method, product
Or the intrinsic other steps of equipment or unit.
One side according to embodiments of the present invention provides a kind of detection method of list data, as shown in Figure 1, should
Method includes:
S102 obtains the first table element in list data detection client, wherein, list data detection client is used
It is detected in the first table element, the first table element is table element to be detected;
S104 obtains target detection rule file corresponding with the first table element mark that the first table element carries,
Wherein, table element mark and detected rule file with correspondence, target are stored in list data detection client
Detected rule file is used to indicate the target detection rule that the target table data carried in the first table element should meet;
Whether S106, detection target table data meet target detection rule, obtain testing result;
S108, first table element, target table number of the display with correspondence in list data detection client
According to and testing result.
Optionally, in the present embodiment, the detection method of above table data can be applied to electronics as shown in Figure 2 and set
In standby 202 hardware environment formed.As shown in Fig. 2, list data detection client 204, electricity are installed in electronic equipment 202
Sub- equipment 202 is used to obtain the first table element in list data detection client, wherein, list data detection client is used
It is detected in the first table element, the first table element is table element to be detected;Acquisition is taken with the first table element
First table element of band identifies corresponding target detection rule file, wherein, it is stored with tool in list data detection client
The table element mark and detected rule file, target detection rule file for having correspondence are used to indicate in the first table element
The target detection rule that the target table data of carrying should meet;Whether detection target table data meet target detection rule,
Obtain testing result;First table element, target table number of the display with correspondence in list data detection client
According to and testing result.
Optionally, in the present embodiment, the detection method of above table data can be, but not limited to be applied to applying journey
In the scene that the list data in form document in sequence is detected.Wherein, above application program can be, but not limited to be each
The application of type, for example, online education application, instant messaging application, community space application, game application, shopping application, clear
Look at device application, financial application, multimedia application, live streaming application etc..Specifically, it can be, but not limited to be applied to above-mentioned to game
In the scene that the list data in form document in application program is detected or can with but be not limited to be applied to above-mentioned
In the scene being detected to the list data in the form document in instant messaging application program, to improve detection efficiency.On
It is only a kind of example to state, and any restriction is not done to this in the present embodiment.
Optionally, in the present embodiment, the detection method of above table data can be, but not limited to be applied to above table
Data Detection client.
Optionally, in the present embodiment, table element can be, but not limited to include:Work in form document, form document
Make the row in table, worksheet, the row in worksheet, cell etc..
Optionally, in the present embodiment, the first table element mark that the first table element carries can be by table member
The subordinate relation that the title of element represents.Such as:First table element is that the third in the worksheet 3 in form document 1 arranges, table
The entitled A of file of file 1, the entitled BBB of worksheet 3, tertial entitled CC.Then the first table element mark can be
A-BBB-CC。
Optionally, in the present embodiment, the first table element identifies the mesh carried in corresponding target detection rule file
Mark detected rule can be obtained by user into edlin or according to to the target table data in table element
Content or the requirement of structure automatically generate.
In an optional embodiment, list data detection client obtains the first table element input by user,
The mode of acquisition can input store path by user or can be that the list of table element is illustrated in list data inspection
It surveys in client, is selected by users.List data detection client obtains the first table carried with the first table element
The corresponding target detection rule file of component identification, and detect whether target table data meet target detection rule, it is examined
It surveys as a result, again showing the first table element with correspondence, target table data and testing result.
As it can be seen that by above-mentioned steps, the first table element to be detected is obtained, and obtain in list data detection client
Target detection rule file corresponding with first table element is taken, by list data detection client automatically to the first table member
Whether the target table data in element meet the target detection rule in target detection rule file, then testing result is included
In list data detection client, automatic detection and the batch detection of list data are realized, it is achieved thereby that improving to table
The technique effect of detection efficiency when data are detected, and then it is relatively low to solve detection efficiency when being detected to list data
The technical issues of.
As a kind of optional scheme, the corresponding target of the first table element mark carried with the first table element is obtained
Detected rule file includes:
S1 obtains the second table element in list data detection client, wherein, the second table element is inspection to be edited
The table element of gauge then, the second table element include the first table element;
S2 obtains the corresponding detected rule set of the second table element, wherein, detected rule set includes one or more
A first kind detected rule and/or, one or more Second Type detected rules, first kind detected rule be the second table
The detected rule that list data in lattice element need to unconditionally meet, the detected rule of Second Type is in the second table element
List data needs the detected rule met in the case where meeting goal condition;
S3, generation carry the detected rule file of the second table element mark and detected rule set, wherein, the second table
Lattice element carries the second table element mark;
S4 obtains the target detection rule file for carrying the first table element mark from detected rule file.
Optionally, in the present embodiment, list data detection client can detect client by user in list data
The edit operation performed on end obtains the corresponding detected rule set of the second table element or can also be by analyzing the second table
The content and structure of data automatically derives the corresponding detected rule set of the second table element in lattice element.
Optionally, in the present embodiment, detected rule can be, but not limited to include two kinds of detected rule, Yi Zhongwei
The detected rule that list data in second table element need to unconditionally meet, another kind are the table number in the second table element
According to the detected rule for needing to meet in the case where meeting goal condition, goal condition can be set by user according to testing requirements
It puts.
Optionally, in the present embodiment, detected rule is generated to editor's information of basic detected rule by receiving, used
Family can carry out edit operation to basic detected rule, form editor's information, be sent to list data detection client, table number
Corresponding edit operation is performed to corresponding basic detected rule according to the editor's information received according to detection client, so as to obtain
The specific detected rule in the corresponding detected rule set of the second table element is taken, and generates detected rule set.
Such as:First editor's information and/or second editor's information are received in list data detection client, wherein, the
One editor's information is used to indicate the first edit operation for being carried out to first foundation detected rule to obtain one or more first kind
Type detected rule, second editor's information are used to indicate under goal condition the second editor that basic detected rule carries out to second and grasp
Make to obtain the corresponding Second Type detected rule of goal condition, first foundation detected rule and the second basic detected rule are
Preset detected rule in list data detection client, first editor's information of response perform first foundation detected rule
The one or more first kind detected rules of first edit operation generation and/or, second editor's information of response examines the second basis
Gauge then performs the one or more Second Type detected rules of the second edit operation generation, and one or more first kind are detected
Rule and/or, one or more Second Type detected rules are determined as detected rule set.
Optionally, in the present embodiment, the corresponding detected rule of table element can be obtained by editing process, Yong Huke
To select the second table element for needing to edit detected rule, and in rule editing interface in list data detection client
To the corresponding detected rule of the second table element into edlin, such as:Add rule, deletion rule, edit condition, setting ginseng
Number, selection rule type, setting perform intensity (such as:Strict implement) etc..
Optionally, in the present embodiment, basic detected rule detects preset detection in client for list data
Rule.Such as:Be more than, be less than, including, with ... start etc..
Optionally, in the present embodiment, list data detection client can obtain the execution for being used to indicate detected rule
The detection ordering information of sequence, and carried in detected rule file, so that detected rule is held according to execution sequence
Row.Such as:List data detection client can obtain detection ordering information, wherein, detection ordering information is used to indicate detection
The detected rule that regular collection includes performs sequence, and will carry the second table element mark and detection ordering information
Detected rule set is determined as detected rule file.
Optionally, in the present embodiment, the execution sequence of detected rule can be detected client according to inspection by list data
Gauge then sets rule generation with scheduled sequence, can also be configured by user when editing detected rule.
Optionally, in the present embodiment, the detected rule file of generation can be saved as detected rule template, be applied to
In the detection process of other table elements, so as to simplify the process for obtaining detected rule, the detection effect of list data is improved
Rate.Such as:After the detected rule file for carrying the second table element mark and detected rule set in generation, it can will examine
Survey rule file and save as detected rule template, the detected rule template being saved can be used for pair in the second table element
The table element that the data structure of list data matches is detected
As a kind of optional scheme, first table member of the display with correspondence in list data detection client
Element, target table data and testing result include:
S1 is the first mark of the first table element distribution that testing result is target table data fit target detection rule
Know, and be testing result be target table data do not meet target detection rule the first table element distribute second identifier;
S2, first table element of the display with first flag in list data detection client, and with first
Display target list data in first table element of mark;
S3, first table element of the display with second identifier in list data detection client, and with second
Display target list data in first table element of mark.
Optionally, in the present embodiment, first flag and second identifier can be, but not limited to for different cell colors,
The mark of different icon, different text colors etc. form, to differentiate the list data of different testing results.
Optionally, in the present embodiment, after the list data for obtaining different testing results, testing result can be carried out
Displaying, so that user quickly and effectively changes the list data for mistake occur.Such as:Client is detected in list data
After upper first table element of the display with correspondence, target table data and testing result, can have detecting
In the case that first table element of first flag has been performed the first operation, first table element of the display with first flag
Corresponding testing result in the case where detecting that the first table element with second identifier has been performed the second operation, is shown
Show the corresponding testing result of the first table element with second identifier.
Optionally, in the present embodiment, user can be directly in list data detection client to there is target table
The list data that data do not meet target detection rule is modified, and modification result is automatically saved in the first table element
In.
As a kind of optional scheme, whether detection target table data meet target detection rule, obtain testing result
Including:
S1 obtains the form document where the first table element, and the first table element place is searched from form document
Worksheet;
S2 extracts the column data in the corresponding target column of the first table element from worksheet, and column data is determined as
Target table data, wherein, column data includes the data that one or more cell in target column carries;
S3, the data input target detection rule that each cell carries in the data that one or more cell is carried
Then, the corresponding testing result of each cell is obtained;
S4 determines that the first unit lattice of the data fit target detection rule carried in one or more cell correspond to
First testing result, the second unit lattice that the data carried in one or more cell do not meet target detection rule correspond to
Second testing result.
Optionally, in the present embodiment, in the case of the first table element as the row in worksheet, the process of detection can with but
It is not limited to the data in cell each in row being input in target detection rule as input parameter, to determine the data
Whether the rule is met, so as to obtain the testing result of each unit lattice data in the row.
It should be noted that for aforementioned each method embodiment, in order to be briefly described, therefore it is all expressed as a series of
Combination of actions, but those skilled in the art should know, the present invention is not limited by described sequence of movement because
According to the present invention, certain steps may be used other sequences or be carried out at the same time.Secondly, those skilled in the art should also know
It knows, embodiment described in this description belongs to preferred embodiment, and involved action and module are not necessarily of the invention
It is necessary.
Through the above description of the embodiments, those skilled in the art can be understood that according to above-mentioned implementation
The method of example can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but it is very much
In the case of the former be more preferably embodiment.Based on such understanding, technical scheme of the present invention is substantially in other words to existing
The part that technology contributes can be embodied in the form of software product, which is stored in a storage
In medium (such as ROM/RAM, magnetic disc, CD), used including some instructions so that a station terminal equipment (can be mobile phone, calculate
Machine, server or network equipment etc.) perform method described in each embodiment of the present invention.
Other side according to embodiments of the present invention additionally provides a kind of detection side for being used to implement above table data
The detection device of the list data of method, as shown in figure 3, the device includes:
1) the first acquisition module 32, for obtaining the first table element in list data detection client, wherein, table
For Data Detection client for being detected to the first table element, the first table element is table element to be detected;
2) the second acquisition module 34, for obtaining the corresponding mesh of the first table element mark carried with the first table element
Detected rule file is marked, wherein, table element mark and inspection with correspondence are stored in list data detection client
Rule file is surveyed, target detection rule file is used to indicate the mesh that the target table data carried in the first table element should meet
Mark detected rule;
3) detection module 36 for detecting whether target table data meet target detection rule, obtain testing result;
4) display module 38, for first table member of the display with correspondence in list data detection client
Element, target table data and testing result.
Optionally, in the present embodiment, the detection device of above table data can be applied to electronics as shown in Figure 2 and set
In standby 202 hardware environment formed.As shown in Fig. 2, list data detection client 204, electricity are installed in electronic equipment 202
Sub- equipment 202 is used to obtain the first table element in list data detection client, wherein, list data detection client is used
It is detected in the first table element, the first table element is table element to be detected;Acquisition is taken with the first table element
First table element of band identifies corresponding target detection rule file, wherein, it is stored with tool in list data detection client
The table element mark and detected rule file, target detection rule file for having correspondence are used to indicate in the first table element
The target detection rule that the target table data of carrying should meet;Whether detection target table data meet target detection rule,
Obtain testing result;First table element, target table number of the display with correspondence in list data detection client
According to and testing result.
Optionally, in the present embodiment, the detection device of above table data can be, but not limited to be applied to applying journey
In the scene that the list data in form document in sequence is detected.Wherein, above application program can be, but not limited to be each
The application of type, for example, online education application, instant messaging application, community space application, game application, shopping application, clear
Look at device application, financial application, multimedia application, live streaming application etc..Specifically, it can be, but not limited to be applied to above-mentioned to game
In the scene that the list data in form document in application program is detected or can with but be not limited to be applied to above-mentioned
In the scene being detected to the list data in the form document in instant messaging application program, to improve detection efficiency.On
It is only a kind of example to state, and any restriction is not done to this in the present embodiment.
Optionally, in the present embodiment, the detection device of above table data can be, but not limited to be applied to above table
Data Detection client.
Optionally, in the present embodiment, table element can be, but not limited to include:Work in form document, form document
Make the row in table, worksheet, the row in worksheet, cell etc..
Optionally, in the present embodiment, the first table element mark that the first table element carries can be by table member
The subordinate relation that the title of element represents.Such as:First table element is that the third in the worksheet 3 in form document 1 arranges, table
The entitled A of file of file 1, the entitled BBB of worksheet 3, tertial entitled CC.Then the first table element mark can be
A-BBB-CC。
Optionally, in the present embodiment, the first table element identifies the mesh carried in corresponding target detection rule file
Mark detected rule can be obtained by user into edlin or according to to the target table data in table element
Content or the requirement of structure automatically generate.
In an optional embodiment, list data detection client obtains the first table element input by user,
The mode of acquisition can input store path by user or can be that the list of table element is illustrated in list data inspection
It surveys in client, is selected by users.List data detection client obtains the first table carried with the first table element
The corresponding target detection rule file of component identification, and detect whether target table data meet target detection rule, it is examined
It surveys as a result, again showing the first table element with correspondence, target table data and testing result.
As it can be seen that by above device, the first table element to be detected is obtained, and obtain in list data detection client
Target detection rule file corresponding with first table element is taken, by list data detection client automatically to the first table member
Whether the target table data in element meet the target detection rule in target detection rule file, then testing result is included
In list data detection client, automatic detection and the batch detection of list data are realized, it is achieved thereby that improving to table
The technique effect of detection efficiency when data are detected, and then it is relatively low to solve detection efficiency when being detected to list data
The technical issues of.
As a kind of optional scheme, the second acquisition module includes:
1) first acquisition unit, for obtaining the second table element in list data detection client, wherein, the second table
Lattice element is the table element of detected rule to be edited, and the second table element includes the first table element;
2) second acquisition unit, for obtaining the corresponding detected rule set of the second table element, wherein, detected rule collection
Conjunction include one or more first kind detected rules and/or, one or more Second Type detected rules, the first kind
Detected rule is the detected rule that the list data in the second table element need to unconditionally meet, and the detected rule of Second Type is
List data in second table element needs the detected rule met in the case where meeting goal condition;
3) generation unit, for generating the detected rule text for carrying the second table element mark and detected rule set
Part, wherein, the second table element carries the second table element mark;
4) third acquiring unit, for obtaining the target inspection for carrying the first table element mark from detected rule file
Survey rule file.
Optionally, in the present embodiment, list data detection client can detect client by user in list data
The edit operation performed on end obtains the corresponding detected rule set of the second table element or can also be by analyzing the second table
The content and structure of data automatically derives the corresponding detected rule set of the second table element in lattice element.
Optionally, in the present embodiment, detected rule can be, but not limited to include two kinds of detected rule, Yi Zhongwei
The detected rule that list data in second table element need to unconditionally meet, another kind are the table number in the second table element
According to the detected rule for needing to meet in the case where meeting goal condition, goal condition can be set by user according to testing requirements
It puts.
Optionally, in the present embodiment, detected rule is generated to editor's information of basic detected rule by receiving, used
Family can carry out edit operation to basic detected rule, form editor's information, be sent to list data detection client, table number
Corresponding edit operation is performed to corresponding basic detected rule according to the editor's information received according to detection client, so as to obtain
The specific detected rule in the corresponding detected rule set of the second table element is taken, and generates detected rule set.
Such as:Second acquisition unit includes:Receiving subelement is compiled for receiving first in list data detection client
Information and/or second editor's information are collected, wherein, first editor's information is used to indicate first carried out to first foundation detected rule
To obtain one or more first kind detected rules, second editor's information is used to indicate under goal condition to for edit operation
The second edit operation that two basic detected rules carry out is to obtain the corresponding Second Type detected rule of goal condition, first foundation
Detected rule and the second basic detected rule are preset detected rule in list data detection client;Operator list
Member performs the one or more first kind of the first edit operation generation for responding first editor's information to first foundation detected rule
Type detected rule and/or, second editor's information of response to second basic detected rule perform the second edit operation generate one or
Multiple Second Type detected rules;First determination subelement, for by one or more first kind detected rules and/or, one
A or multiple Second Type detected rules are determined as detected rule set.
Optionally, in the present embodiment, the corresponding detected rule of table element can be obtained by editing process, Yong Huke
To select the second table element for needing to edit detected rule, and in rule editing interface in list data detection client
To the corresponding detected rule of the second table element into edlin, such as:Add rule, deletion rule, edit condition, setting ginseng
Number, selection rule type, setting perform intensity (such as:Strict implement) etc..
Optionally, in the present embodiment, basic detected rule detects preset detection in client for list data
Rule.Such as:Be more than, be less than, including, with ... start etc..
Optionally, in the present embodiment, list data detection client can obtain the execution for being used to indicate detected rule
The detection ordering information of sequence, and carried in detected rule file, so that detected rule is held according to execution sequence
Row.Such as:Generation unit includes:Subelement is obtained, for obtaining detection ordering information, wherein, detection ordering information is used to refer to
That shows the detected rule that detected rule set includes performs sequence;Second determination subelement, for the second table will to be carried
The detected rule set of component identification and detection ordering information is determined as detected rule file.
Optionally, in the present embodiment, the execution sequence of detected rule can be detected client according to inspection by list data
Gauge then sets rule generation with scheduled sequence, can also be configured by user when editing detected rule.
Optionally, in the present embodiment, the detected rule file of generation can be saved as detected rule template, be applied to
In the detection process of other table elements, so as to simplify the process for obtaining detected rule, the detection effect of list data is improved
Rate.Such as:Above device further includes:Preserving module, for detected rule file to be saved as detected rule template, wherein, inspection
Rule template is surveyed for pair being detected with the table element that the data structure of the list data in the second table element matches.
As a kind of optional scheme, display module includes:
1) allocation unit, for for the first table element that testing result is target table data fit target detection rule
First flag is distributed, and be testing result is that target table data do not meet the first table element of target detection rule and distribute the
Two marks;
2) the first display unit, for first table member of the display with first flag in list data detection client
Element, and the display target list data in the first table element with first flag;
3) the second display unit, for first table member of the display with second identifier in list data detection client
Element, and the display target list data in the first table element with second identifier.
Optionally, in the present embodiment, first flag and second identifier can be, but not limited to for different cell colors,
The mark of different icon, different text colors etc. form, to differentiate the list data of different testing results.
Optionally, in the present embodiment, after the list data for obtaining different testing results, testing result can be carried out
Displaying, so that user quickly and effectively changes the list data for mistake occur.Such as:Above device further includes:Third
Display unit, in the case where detecting that the first table element with first flag has been performed the first operation, showing
The corresponding testing result of the first table element with first flag;4th display unit, for detecting with the second mark
In the case that the first table element known has been performed the second operation, first table element of the display with second identifier is corresponding
Testing result.
Optionally, in the present embodiment, user can be directly in list data detection client to there is target table
The list data that data do not meet target detection rule is modified, and modification result is automatically saved in the first table element
In.
As a kind of optional scheme, detection module includes:
1) the 4th acquiring unit for obtaining the form document where the first table element, and is searched from form document
Worksheet where first table element;
2) extraction unit, for extracting the column data in the corresponding target column of the first table element from worksheet, and will
Column data is determined as target table data, wherein, column data includes the number that one or more cell in target column carries
According to;
3) input unit, the data carried for cell each in the data that carry one or more cell are defeated
Enter target detection rule, obtain the corresponding testing result of each cell;
4) determination unit, for determining the of the data fit target detection carried in one or more cell rule
One cell corresponds to the first testing result, and the data carried in one or more cell do not meet the of target detection rule
Two cells correspond to the second testing result.
Optionally, in the present embodiment, in the case of the first table element as the row in worksheet, the process of detection can with but
It is not limited to the data in cell each in row being input in target detection rule as input parameter, to determine the data
Whether the rule is met, so as to obtain the testing result of each unit lattice data in the row.
The application environment of the embodiment of the present invention can be, but not limited to reference to the application environment in above-described embodiment, the present embodiment
In this is repeated no more.An embodiment of the present invention provides for implementing, one kind of the connection method of above-mentioned real-time Communication for Power is optional to be had
Body application example.
As a kind of optional embodiment, the detection method of above table data can be, but not limited to be applied to such as Fig. 4 extremely
In the scene shown in Fig. 8 being detected to Excel list datas.The relative terms in this optional embodiment are carried out below
It illustrates and describes.It should be noted that above-mentioned detected rule can be referred to as regular in book optional embodiment.Above-mentioned table
Lattice are by taking Excel tables as an example, and above table element is in the case of the row in Excel worksheets.
Source code:Refer to the text file according to certain programming language specification writing, be the readable meter of series of human
Calculation machine sound instruction.Original program code (such as:C# codes) compiling after can generate computer program.
Xls file formats:The file format used before 2003 versions of Excel, binary file preserving type.xls
The maximum number of lines that file is supported is 65536 rows, and the maximum number of column of support is 256 row.
Xlsx file formats:The file format used after 2007 versions of Excel is substantially to compress packet mode with zip
The xml document set of preservation.The maximum number of lines that xlsx files are supported is 1048576 rows, and the maximum number of column of support is 16384 row.
VBA is macro:A kind of procedure script language that can be write in Excel completes the function specified by program.
Base rule:The base rule provided in itself by scheme, such as larger than, be less than, be equal to, comprising etc. based on unit
The primitive rule condition of lattice.
Custom rule expression formula:With the regular collection that the base rule of user's unrestricted choice is formed, include and/or
Relationship, so as to form logical expression.The structure of expression formula is similar to ((condition one and condition two) or (condition three and condition
Four) structure as), the logical relation between conditional expression can be by User Defined.
Custom rule group:It is added by user-defined regular expression and/or regular expression that relationship is formed
Set.The logical relation between regular expression in regular group is consistent.
Custom logic conditional branching:User is using custom rule group is as condition or as a result, what is formed is similar to:
The 1st, (if custom rule group one) so (custom rule group two);
2nd, else if (custom rule group three) so (custom rule group four);
3rd, else if (custom rule group five) so (custom rule group six);
…
9th, finally so (custom rule group N).
Above-mentioned logical relation can complete the covering in a variety of conditional branching paths.
Script:It, can be by applying journey according to the executable file that certain form is write using a kind of specific programming language
Sequence is called and is performed temporarily.Script is transcribed into machine recognizable instruction when being executed, by an interpreter of program, and
It is performed by program sequence.
Procedure set:A kind of intermediate command set containing metadata information by the compiling generation of certain programming language, can be with
It is dynamically loaded by application program, and generates corresponding code word.
Rule template:It is a kind of custom rule group or custom logic conditional branching to be preserved into independent rules file
Mode.Rule template can be applied mechanically in the same or similar Excel file content of content.
In this scene, according to Excel table contents, to required inspection in the worksheet in each Excel form documents
The column data of survey carries out the editor of custom rule, after being created that the detected rule for adapting to this table content, to specified work
Table content is detected, and generates testing result.
Optionally, in the present embodiment, the base rule that user can use client acquiescence to provide carries out self-defined rule
Then condition, custom rule group, custom condition branching logic editor, specified Excel file table content is examined
It surveys.If the base rule that system default provides, it is impossible to meet user demand, user can carry out secondary to open to base rule
Hair, writes new script to increase new base rule.
Optionally, in the present embodiment, the client provided can load Excel texts all under specified directory automatically
Part supports the file formats such as xls and xlsx, Excel file need not be closed in loading procedure, facilitate user to Excel file into
Other operations of row.
Optionally, in the present embodiment, user can to client executing following operating procedure, with using client to table
Lattice data are detected.
Operating procedure one:As shown in figure 4, user can select to edit the Excel of detected rule in main interface first
Form document, worksheet and column name.Client can list automatically Worksheetfile included by the form document chosen and
Column name in the worksheet chosen.For the blank column in worksheet, client can identify as [blank].Client
Can automatically in searching work table the first row for empty data row and labeled as column name.User can specify other not manually
It is empty row as column name.
Operating procedure two:As shown in figure 5, after user chooses the row for needing to edit rule, in regular design interface, pass through
Increase general rule or conditional plan or combination, provide the required regular collection of row that detection is chosen.It is wherein general
Drift is then the regular expression directly detected of not conditional, conditional plan meet for data " if " carry out " that after condition
" expression formula detection.General rule will be detected prior to conditional plan.User can be pressed by click " moving up ", " moving down "
What button or the regular frame of dragging voluntarily adjusted each rule performs sequence.
Operating procedure three:As shown in fig. 6, user can voluntarily add the rule in rule group and regular group, each rule
Between group or rule with or relationship be attached, can generate in this way similar to ((condition one with condition two) or (condition three with
Condition four)) as regular expression structure.Single rule is being more than, being less than, including, the base rules such as unique form.Commonly
Regular group directly applies to the column data chosen in itself, and with conditional rule group applied to chosen form document, work
Make table and column data, can realize the definition across the rule detection condition of table.
Operating procedure four:As shown in fig. 7, at rule detection interface, it can individually choose row to be detected or choose whole
All row or all forms file that a form document includes, are carried out at the same time Data Detection.User can be fast by editting function
Speed jumps to rule editing interface and modifies to rule.
Operating procedure five:As shown in figure 8, testing result interface shows entire worksheet data, and made mistake
Quantity, and vicious cell data are carried out with highlighted prompting.User can click error unit lattice and check specific miscue,
And quickly redirect next error unit lattice.The worksheet being verified can directly give prompting in a manner of highlighted.
Optionally, in the present embodiment, shared model file stream can be used to open Excel file, ensures user not
It can be also detected under the premise of closing Excel, secondly each cell content be traversed successively according to ranks sequence, for unit
Lattice content is empty or is not present, then saves as blank character string.
Optionally, in the present embodiment, secondary development is carried out for the ease of user, has used the foot for supporting C# form scripts
This engine carries out rule detection.Before starting client every time, the script locally possessed is verified, for newly changing
Script can re-start compiling, generate corresponding procedure set.And unmodified script is then loaded directly into corresponding existing journey
Sequence collection, to improve client terminal start-up speed.
Optionally, in the present embodiment, User Defined is supported to increase, delete, change script, user is facilitated not change
Expanded function in the case of client source code.The script file that user writes during secondary development needs to meet certain volume
Code specification, client can detect script code automatically during user writes and give miscue.
Optionally, in the present embodiment, as shown in figure 9, the rule that user edits can have following hierarchical organization knot
Structure:Each book rule includes multiple worksheets rule, and each worksheet rule includes multiple row rules.Each row rule packet
It is right to include multiple rules.Rule without condition is to for general rule, having conditional rule to for conditional plan.It is all common
Rule needs to meet simultaneously, but is mutex relation between condition regulation, as long as meeting wherein one.If all conditions are advised
Then relationship is all unsatisfactory for, then needs to meet final conditional plan.Each rule is had ready conditions in and regular two parts, wherein item
Part part can be sky, and it is general rule to represent current rule, without condition judgment.The condition and rule two of each rule centering
A part all includes multiple regular groups.Each rule group includes multiple list of rules, between each list of rules by " and/or " pass
System's connection represents to need to meet simultaneously between list of rules or individually meets one.Each list of rules includes multiple bases
Plinth rule, between each base rule by with or relationship connect, need simultaneously to meet or individually meet between expression base rule
One.
Optionally, in the present embodiment, rule template is provided for the row of same or similar structure that user uses
It supports, facilitates user that can share identical detected rule between different row, save user's edit session, reduce rule and go out
Wrong possibility.For using the rule of rule template, column data can no longer be stored in row regular interior, and can directly draw
With template content, template is individually preserved in itself.Such benefit is when changing template, and the row rule of all references is automatic
It modifies.Meanwhile can select to cancel or disconnect template connection, after cancelling template connection, regular content is arranged from rule
In template internal copy to independent rule.After disconnecting template connection, it can freely edit row rule or revert to rule again
Template.The row rule of rule template is quoted into template connection can be disconnected after edlin automatically, rule can be preserved simultaneously by preserving editor
Template content.
Optionally, in the present embodiment, the rule detection of list data can be carried out by below scheme:
Search rule file itself based on Excel file and loading.The rule of conditional is to cited in search rule
Excel file and loading.Traversal detection list, detects single Excel worksheets.Excel worksheets are traversed, obtain row rule
And column data, detect single row.Usual terms rule in traversal row rule, checks whether to meet, if any one is commonly advised
It is then unsatisfactory for, then directly reports an error.Conditional plan in traversal row rule, finds wherein meet condition one, performs this condition
Under rule detection.If can not find the condition of any satisfaction, the detection of final conditional plan is performed.Ergodic condition is to following
Regular Groups List, according to " and/or " relationship detects whether to meet all or any one list of rules.Under traversal rule group
The list of rules in face, according to or relationship detect whether to meet all or any one base rule.
Script engine is called, column data is passed into script, detects whether to meet basic detected rule.Export all detections
As a result, it is formatted as standard testing result.
In the present embodiment, a kind of detection mode of the Excel list datas based on custom rule is provided.Use this
Mode can detect the configuration error in Excel tables comprehensively and quickly, so as to modify.It can be big by the method
Amplitude reduces the testing time brought in application program configuration issuing process, saves the manpower money of planning, operation and tester
Source promotes the efficiency of application issued process.
Another aspect according to embodiments of the present invention additionally provides a kind of detection for being used to implement above table data
Electronic device, as shown in Figure 10, the electronic device include:One or more (one is only shown in figure) processors 1002, storage
Device 1004, sensor 1006, encoder 1008 and transmitting device 1010 are stored with computer program in the memory, at this
Reason device is arranged to perform the step in any of the above-described embodiment of the method by computer program.
Optionally, in the present embodiment, above-mentioned electronic device can be located in multiple network equipments of computer network
At least one network equipment.
Optionally, in the present embodiment, above-mentioned processor can be set to perform following steps by computer program:
S1 obtains the first table element in list data detection client, wherein, list data detection client is used for
First table element is detected, the first table element is table element to be detected;
S2 obtains target detection rule file corresponding with the first table element mark that the first table element carries,
In, table element mark and detected rule file with correspondence, target inspection are stored in list data detection client
It surveys rule file and is used to indicate the target detection rule that the target table data carried in the first table element should meet;
Whether S3, detection target table data meet target detection rule, obtain testing result;
S4, first table element of the display with correspondence, target table data in list data detection client
And testing result.
Optionally, it will appreciated by the skilled person that structure shown in Fig. 10 is only to illustrate, electronic device also may be used
To be smart mobile phone (such as Android phone, iOS mobile phones), tablet computer, palm PC and mobile internet device
The terminal devices such as (Mobile Internet Devices, MID), PAD.Figure 10 it does not make the structure of above-mentioned electronic device
Into restriction.For example, electronic device may also include the component more or less than shown in Figure 10 (such as network interface, display dress
Put) or with the configuration different from shown in Figure 10.
Wherein, memory 1002 can be used for storage software program and module, such as the list data in the embodiment of the present invention
Detection method and the corresponding program instruction/module of device, processor 1004 by operation be stored in it is soft in memory 1002
Part program and module so as to perform various functions application and data processing, that is, realize the controlling party of above-mentioned target element
Method.Memory 1002 may include high speed random access memory, can also include nonvolatile memory, such as one or more magnetism
Storage device, flash memory or other non-volatile solid state memories.In some instances, memory 1002 can further comprise
Relative to the remotely located memory of processor 1004, these remote memories can pass through network connection to terminal.Above-mentioned net
The example of network includes but not limited to internet, intranet, LAN, mobile radio communication and combinations thereof.
Above-mentioned transmitting device 1010 is used to receive via a network or transmission data.Above-mentioned network specific example
It may include cable network and wireless network.In an example, transmitting device 1010 includes a network adapter
(NetworkInterface Controller, NIC), can be connected by cable with other network equipments with router so as to
It can be communicated with internet or LAN.In an example, transmitting device 1010 for radio frequency (Radio Frequency,
RF) module is used to wirelessly be communicated with internet.
Wherein, specifically, memory 1002 is used to store application program.
The embodiment of the present invention additionally provides a kind of storage medium, and computer program is stored in the storage medium, wherein,
The computer program is arranged to perform the step in any of the above-described embodiment of the method during operation.
Optionally, in the present embodiment, above-mentioned storage medium can be set to store by performing based on following steps
Calculation machine program:
S1 obtains the first table element in list data detection client, wherein, list data detection client is used for
First table element is detected, the first table element is table element to be detected;
S2 obtains target detection rule file corresponding with the first table element mark that the first table element carries,
In, table element mark and detected rule file with correspondence, target inspection are stored in list data detection client
It surveys rule file and is used to indicate the target detection rule that the target table data carried in the first table element should meet;
Whether S3, detection target table data meet target detection rule, obtain testing result;
S4, first table element of the display with correspondence, target table data in list data detection client
And testing result.
Optionally, storage medium is also configured to store the step for performing included in the method in above-described embodiment
Computer program, this is repeated no more in the present embodiment.
Optionally, in the present embodiment, one of ordinary skill in the art will appreciate that in the various methods of above-described embodiment
All or part of step be that can be completed by program come command terminal device-dependent hardware, which can be stored in
In one computer readable storage medium, storage medium can include:Flash disk, read-only memory (Read-Only Memory,
ROM), random access device (Random Access Memory, RAM), disk or CD etc..
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
If the integrated unit in above-described embodiment is realized in the form of SFU software functional unit and is independent product
Sale or in use, the storage medium that above computer can be read can be stored in.Based on such understanding, skill of the invention
The part or all or part of the technical solution that art scheme substantially in other words contributes to the prior art can be with soft
The form of part product embodies, which is stored in storage medium, is used including some instructions so that one
Platform or multiple stage computers equipment (can be personal computer, server or network equipment etc.) perform each embodiment institute of the present invention
State all or part of step of method.
In the above embodiment of the present invention, all emphasize particularly on different fields to the description of each embodiment, do not have in some embodiment
The part of detailed description may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed client, it can be by others side
Formula is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, and only one
Kind of division of logic function, can there is an other dividing mode in actual implementation, for example, multiple units or component can combine or
It is desirably integrated into another system or some features can be ignored or does not perform.Another point, it is shown or discussed it is mutual it
Between coupling, direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
It connects, can be electrical or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unit
The component shown may or may not be physical unit, you can be located at a place or can also be distributed to multiple
In network element.Some or all of unit therein can be selected according to the actual needs to realize the mesh of this embodiment scheme
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
The above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (15)
1. a kind of detection method of list data, which is characterized in that including:
Obtain the first table element in list data detection client, wherein, list data detection client for pair
First table element is detected, and first table element is table element to be detected;
Target detection rule file corresponding with the first table element mark that first table element carries is obtained, wherein,
Table element mark and detected rule file with correspondence, the mesh are stored in the list data detection client
Mark detected rule file is used to indicate the target detection rule that the target table data carried in first table element should meet
Then;
It detects whether the target table data meet the target detection rule, obtains testing result;
First table element, the target table of the display with correspondence in list data detection client
Data and the testing result.
2. according to the method described in claim 1, it is characterized in that, obtain the first table with first table element carrying
The corresponding target detection rule file of component identification includes:
The second table element is obtained in list data detection client, wherein, second table element is to be edited
The table element of detected rule, second table element include first table element;
Obtain the corresponding detected rule set of second table element, wherein, the detected rule set include one or
Multiple first kind detected rules and/or, one or more Second Type detected rules, the first kind detected rule is
The detected rule that list data in second table element need to unconditionally meet, the detected rule of the Second Type is institute
Stating the list data in the second table element needs the detected rule met in the case where meeting goal condition;
Generation carries the detected rule file of the second table element mark and the detected rule set, wherein, described second
Table element carries the second table element mark;
The target detection rule file for carrying the first table element mark is obtained from the detected rule file.
3. according to the method described in claim 2, it is characterized in that, obtain the corresponding detection rule of second table element
Then set includes:
First editor's information and/or second editor's information are received in list data detection client, wherein, described first
Editor's information is used to indicate the first edit operation for being carried out to first foundation detected rule to obtain one or more of first
Type detection rule, the second editor information are used to indicate under the goal condition what the basic detected rule to second carried out
Second edit operation is to obtain the corresponding Second Type detected rule of the goal condition, the first foundation detected rule and institute
It is preset detected rule in the list data detection client to state the second basic detected rule;
It responds first editor's information and the first edit operation generation described one is performed to the first foundation detected rule
A or multiple first kind detected rules and/or, to described second, basic detected rule performs response second editor's information
Second edit operation generates one or more of Second Type detected rules;
And/or, one or more of Second Type detected rules are determined by one or more of first kind detected rules
For the detected rule set.
4. according to the method described in claim 2, it is characterized in that, generation carries the second table element mark and the detection
The detected rule file of regular collection includes:
Detection ordering information is obtained, wherein, the detection ordering information is used to indicate the inspection that the detected rule set includes
Gauge then perform sequence;
The detected rule set for carrying the second table element mark and the detection ordering information is determined as institute
State detected rule file.
5. according to the method described in claim 2, it is characterized in that, carry the second table element mark and the inspection in generation
It surveys after the detected rule file of regular collection, the method further includes:
The detected rule file is saved as into detected rule template, wherein, the detected rule template is for pair with described the
The table element that the data structure of list data in two table elements matches is detected.
6. according to the method described in claim 1, it is characterized in that, the list data detection client on display have pair
First table element, the target table data and the testing result that should be related to include:
For first table element point that the testing result is target detection rule described in the target table data fit
It is that the target table data do not meet described the first of the target detection rule with first flag, and for the testing result
Table element distributes second identifier;
The list data detection client on display with the first flag first table element, and with
The target table data are shown in first table element of the first flag;
The list data detection client on display with the second identifier first table element, and with
The target table data are shown in first table element of the second identifier.
7. according to the method described in claim 6, it is characterized in that, the list data detection client on display have pair
After first table element, the target table data and the testing result that should be related to, the method further includes:
In the case where detecting that first table element with the first flag has been performed the first operation, display tool
There is the corresponding testing result of first table element of the first flag;
In the case where detecting that first table element with the second identifier has been performed the second operation, display tool
There is the corresponding testing result of first table element of the second identifier.
8. according to the method described in claim 1, it is characterized in that, detect whether the target table data meet the target
Detected rule obtains the testing result and includes:
The form document where first table element is obtained, and first table element is searched from the form document
The worksheet at place;
The column data in the corresponding target column of first table element is extracted from the worksheet, and the column data is true
It is set to the target table data, wherein, one or more cell that the column data is included in the target column carries
Data;
The data that each cell carries in the data that one or more of cells are carried input the target detection
Rule obtains the corresponding testing result of each cell;
Determine the first unit lattice pair of target detection rule described in the data fit carried in one or more of cells
The first testing result is answered, the data carried in one or more of cells do not meet the second of the target detection rule
Cell corresponds to the second testing result.
9. a kind of detection device of list data, which is characterized in that including:
First acquisition module, for obtaining the first table element in list data detection client, wherein, the list data
For detection client for being detected to first table element, first table element is table element to be detected;
Second acquisition module, for obtaining target inspection corresponding with the first table element mark that first table element carries
Rule file is surveyed, wherein, table element mark and inspection with correspondence are stored in the list data detection client
Rule file is surveyed, the target detection rule file is used to indicate the target table data carried in first table element should
The target detection rule met;
Detection module for detecting whether the target table data meet the target detection rule, obtains testing result;
Display module, for first table member of the display with correspondence in list data detection client
Plain, described target table data and the testing result.
10. device according to claim 9, which is characterized in that second acquisition module includes:
First acquisition unit, for obtaining the second table element in list data detection client, wherein, described second
Table element is the table element of detected rule to be edited, and second table element includes first table element;
Second acquisition unit, for obtaining the corresponding detected rule set of second table element, wherein, the detected rule
Set include one or more first kind detected rules and/or, one or more Second Type detected rules, described the
The detected rule that one type detected rule need to unconditionally meet for the list data in second table element, second class
The detected rule of type is that the list data in second table element needs the detection met in the case where meeting goal condition
Rule;
Generation unit, for generating the detected rule file for carrying the second table element mark and the detected rule set,
Wherein, second table element carries the second table element mark;
Third acquiring unit is carried for being obtained from the detected rule file described in the first table element mark
Target detection rule file.
11. device according to claim 10, which is characterized in that described device further includes:
Preserving module, for the detected rule file to be saved as detected rule template, wherein, the detected rule template is used
In pair being detected with the table element that the data structure of the list data in second table element matches.
12. device according to claim 9, which is characterized in that the display module includes:
Allocation unit, for for the testing result is target detection rule described in the target table data fit described the
One table element distributes first flag, and is that the target table data do not meet the target detection rule for the testing result
First table element distribution second identifier then;
First display unit, for showing described first with the first flag in list data detection client
Table element, and show the target table data in first table element with the first flag;
Second display unit, for showing described first with the second identifier in list data detection client
Table element, and show the target table data in first table element with the second identifier.
13. device according to claim 9, which is characterized in that the detection module includes:
4th acquiring unit for obtaining the form document where first table element, and is looked into from the form document
Look for the worksheet where first table element;
Extraction unit, for extracting the column data in the corresponding target column of first table element from the worksheet, and
The column data is determined as the target table data, wherein, the column data include the target column in one or
The data that multiple cells carry;
Input unit, the data input carried for cell each in the data that carry one or more of cells
The target detection rule, obtains the corresponding testing result of each cell;
Determination unit, for determining target detection rule described in the data fit carried in one or more of cells
First unit lattice correspond to the first testing result, and the data carried in one or more of cells do not meet the target inspection
The second unit lattice of gauge then correspond to the second testing result.
14. a kind of storage medium, which is characterized in that computer program is stored in the storage medium, wherein, the computer
Program is arranged to perform the method described in any one of claim 1 to 8 during operation.
15. a kind of electronic device, including memory and processor, which is characterized in that computer journey is stored in the memory
Sequence, the processor are arranged to perform the side described in any one of claim 1 to 8 by the computer program
Method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810055422.7A CN108197114B (en) | 2018-01-19 | 2018-01-19 | Method and device for detecting table data, storage medium and electronic device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810055422.7A CN108197114B (en) | 2018-01-19 | 2018-01-19 | Method and device for detecting table data, storage medium and electronic device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108197114A true CN108197114A (en) | 2018-06-22 |
CN108197114B CN108197114B (en) | 2022-07-29 |
Family
ID=62590383
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810055422.7A Active CN108197114B (en) | 2018-01-19 | 2018-01-19 | Method and device for detecting table data, storage medium and electronic device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108197114B (en) |
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109408506A (en) * | 2018-09-05 | 2019-03-01 | 天津字节跳动科技有限公司 | Table data processing method and device |
CN109446493A (en) * | 2018-10-17 | 2019-03-08 | 网易(杭州)网络有限公司 | Data processing method, device, storage medium and electronic device |
CN109543160A (en) * | 2018-11-23 | 2019-03-29 | 网易(杭州)网络有限公司 | Inspection method, check device, storage medium and the processor of numerical tabular |
CN109981729A (en) * | 2019-02-14 | 2019-07-05 | 视联动力信息技术股份有限公司 | Document handling method, device, electronic equipment and computer readable storage medium |
CN110008446A (en) * | 2019-02-27 | 2019-07-12 | 深圳点猫科技有限公司 | The method and electronic equipment that a kind of language based on programming converts form document |
CN110413598A (en) * | 2019-06-17 | 2019-11-05 | 平安科技(深圳)有限公司 | List data amending method, device, electronic equipment and storage medium |
CN110472209A (en) * | 2019-07-04 | 2019-11-19 | 重庆金融资产交易所有限责任公司 | Table generation method, device and computer equipment based on deep learning |
CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易(杭州)网络有限公司 | Data table testing method, device, equipment and storage medium |
CN112231337A (en) * | 2020-10-20 | 2021-01-15 | 中国建设银行股份有限公司 | SAS statement detection device and method, electronic device and storage medium |
CN112650762A (en) * | 2021-03-15 | 2021-04-13 | 腾讯科技(深圳)有限公司 | Data quality monitoring method and device, electronic equipment and storage medium |
CN112765946A (en) * | 2020-12-31 | 2021-05-07 | 维沃移动通信有限公司 | Chart display method and device and electronic equipment |
CN113191128A (en) * | 2021-05-24 | 2021-07-30 | 中国工商银行股份有限公司 | Report form checking tool generation method and device and electronic equipment |
CN114185463A (en) * | 2021-11-17 | 2022-03-15 | 北京字跳网络技术有限公司 | Form processing method and device, electronic equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2007183916A (en) * | 2005-10-19 | 2007-07-19 | Ntt Docomo Inc | Method and apparatus for automatic form input on mobile devices |
CN102467561A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件(中国)有限公司 | Form data filtering method and device |
CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
-
2018
- 2018-01-19 CN CN201810055422.7A patent/CN108197114B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2007183916A (en) * | 2005-10-19 | 2007-07-19 | Ntt Docomo Inc | Method and apparatus for automatic form input on mobile devices |
CN102467561A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件(中国)有限公司 | Form data filtering method and device |
CN104239162A (en) * | 2014-09-09 | 2014-12-24 | 北京国双科技有限公司 | Data check method and data check device |
Non-Patent Citations (1)
Title |
---|
陈宗海主编: "《系统仿真技术及其应用 第12卷》", 31 July 2010, 中国科学技术大学出版社 * |
Cited By (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109408506B (en) * | 2018-09-05 | 2020-12-11 | 天津字节跳动科技有限公司 | Table data processing method and device |
CN109408506A (en) * | 2018-09-05 | 2019-03-01 | 天津字节跳动科技有限公司 | Table data processing method and device |
CN109446493A (en) * | 2018-10-17 | 2019-03-08 | 网易(杭州)网络有限公司 | Data processing method, device, storage medium and electronic device |
CN109446493B (en) * | 2018-10-17 | 2022-06-24 | 网易(杭州)网络有限公司 | Data processing method, data processing apparatus, storage medium, and electronic apparatus |
CN109543160A (en) * | 2018-11-23 | 2019-03-29 | 网易(杭州)网络有限公司 | Inspection method, check device, storage medium and the processor of numerical tabular |
CN109543160B (en) * | 2018-11-23 | 2023-08-25 | 网易(杭州)网络有限公司 | Checking method, checking device, storage medium and processor for numerical value table |
CN109981729A (en) * | 2019-02-14 | 2019-07-05 | 视联动力信息技术股份有限公司 | Document handling method, device, electronic equipment and computer readable storage medium |
CN110008446A (en) * | 2019-02-27 | 2019-07-12 | 深圳点猫科技有限公司 | The method and electronic equipment that a kind of language based on programming converts form document |
CN110413598A (en) * | 2019-06-17 | 2019-11-05 | 平安科技(深圳)有限公司 | List data amending method, device, electronic equipment and storage medium |
CN110472209A (en) * | 2019-07-04 | 2019-11-19 | 重庆金融资产交易所有限责任公司 | Table generation method, device and computer equipment based on deep learning |
CN110472209B (en) * | 2019-07-04 | 2024-02-06 | 深圳同奈信息科技有限公司 | Deep learning-based table generation method and device and computer equipment |
CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易(杭州)网络有限公司 | Data table testing method, device, equipment and storage medium |
CN111773728B (en) * | 2020-07-09 | 2024-06-21 | 网易(杭州)网络有限公司 | Data table testing method, device, equipment and storage medium |
CN112231337A (en) * | 2020-10-20 | 2021-01-15 | 中国建设银行股份有限公司 | SAS statement detection device and method, electronic device and storage medium |
CN112765946A (en) * | 2020-12-31 | 2021-05-07 | 维沃移动通信有限公司 | Chart display method and device and electronic equipment |
CN112765946B (en) * | 2020-12-31 | 2024-05-14 | 维沃移动通信有限公司 | Chart display method and device and electronic equipment |
CN112650762B (en) * | 2021-03-15 | 2021-07-02 | 腾讯科技(深圳)有限公司 | Data quality monitoring method and device, electronic equipment and storage medium |
CN112650762A (en) * | 2021-03-15 | 2021-04-13 | 腾讯科技(深圳)有限公司 | Data quality monitoring method and device, electronic equipment and storage medium |
CN113191128A (en) * | 2021-05-24 | 2021-07-30 | 中国工商银行股份有限公司 | Report form checking tool generation method and device and electronic equipment |
CN113191128B (en) * | 2021-05-24 | 2024-03-19 | 中国工商银行股份有限公司 | Report checking tool generation method and device and electronic equipment |
CN114185463A (en) * | 2021-11-17 | 2022-03-15 | 北京字跳网络技术有限公司 | Form processing method and device, electronic equipment and storage medium |
CN114185463B (en) * | 2021-11-17 | 2023-10-13 | 北京字跳网络技术有限公司 | Form processing method, form processing device, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108197114B (en) | 2022-07-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108197114A (en) | Detection method, device, storage medium and the electronic device of list data | |
CN109669688A (en) | Based on visual software development methodology, device, terminal device and storage medium | |
CN104268072B (en) | Graphical script editor and method for fast developing communication equipment testing script | |
CN108345456A (en) | Page code generation method, device, computer equipment and storage medium | |
CN107992458A (en) | The generation method and device of form rule | |
CN104317589B (en) | A kind of code automatic generation method and device for being used to load dynamic link library | |
CN104461895B (en) | The edit methods and system and automatization test system of cycle tests | |
CN107133345A (en) | Exchange method and device based on artificial intelligence | |
CN110389898A (en) | Acquisition methods, device, terminal and the computer readable storage medium of Test Strategy | |
CN107436787B (en) | Method for processing resource, device, storage medium and electronic device | |
CN105955888A (en) | Page debugging and previewing method and system | |
CN107305527A (en) | The treating method and apparatus of code file | |
CN104407901B (en) | The adding method and device of code | |
CN102073670B (en) | Method, equipment and system for debugging online webpage template | |
CN104035873A (en) | Method and device for generating testing codes | |
CN108008944A (en) | Regulation engine response method and system, regulation engine, service terminal, memory | |
CN107797826A (en) | A kind of regular collocation method, terminal and the equipment of rule-based engine | |
CN103309667A (en) | Method for positioning UI (user interface) control and picture modifying position in Android system | |
CN107122295A (en) | The generation method and device of test case script | |
CN107741950A (en) | Processing method, device, processor and the service end of data syn-chronization task | |
CN109634570A (en) | Front and back end integrated development method, device, equipment and computer readable storage medium | |
CN107797823A (en) | Business Rule Management method, apparatus, storage medium and computer equipment | |
CN109902251A (en) | Scheme Choice method, apparatus, terminal and readable storage medium storing program for executing based on decision tree | |
CN108874649A (en) | Generation method, device and its computer equipment of automatic test script | |
CN107346239A (en) | A kind of applicating and exploitation based on APP |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |