CN108197114A

CN108197114A - Detection method, device, storage medium and the electronic device of list data

Info

Publication number: CN108197114A
Application number: CN201810055422.7A
Authority: CN
Inventors: 王�琦
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2018-01-19
Filing date: 2018-01-19
Publication date: 2018-06-22
Anticipated expiration: 2038-01-19
Also published as: CN108197114B

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

Detection method, device, storage medium and the electronic device of list data

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.

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.

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

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.

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：

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

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.