Table data processing method, apparatus and device, and computer readable medium

Abstract

The embodiment of the invention discloses a table data processing method and device, equipment and a computer readable medium. A specific embodiment of the method comprises the following steps: receiving value table data sent by a user terminal; an identification result is obtained; in response to determining that the identification result meets the preset identification result condition, executing the following steps: generating marked value table data; obtaining updated value table data; obtaining value information of each user; obtaining a payment result; for each payment result in the obtained payment results, in response to determining that the payment result meets a preset payment result condition, performing encryption processing on the user value information and the payment result to obtain encrypted information; and sending each piece of obtained encrypted information to each user terminal corresponding to each piece of user value information. According to the embodiment, the efficiency and accuracy of identifying the error information in the value table data can be improved, and waste of computing resources during encryption and sending can be reduced.

Description

Technical Field

[0001] Embodiments of the present disclosure relate to the field of computer technology, and in particular to a table data processing method, apparatus, device, and computer-readable medium. Background Art

[0002] Table data processing refers to the process of collecting, storing, retrieving, processing, transforming and transmitting the obtained table data. For example, when processing business data, it is very important to ensure that the written table data does not contain erroneous information that does not comply with relevant regulations and to encrypt the correct table data before sending it to relevant technical personnel.

[0003] At present, when processing value table data, the method usually adopted is: the technician identifies the error information in the value table data according to relevant regulations and modifies the error information. Then, each user value information is extracted from the modified value table data. Then, the corresponding operation is performed according to each user value information. Finally, the user value information and the operation result are sent to the user terminal.

[0004] However, when the value table data is processed in the above manner, the following technical problems often occur:

[0005] When the confidentiality of data is high, only processing the data by technicians without any encryption measures can easily lead to data leakage and reduce data security. In addition, the efficiency and accuracy of identifying and modifying the value table data by technicians alone are low, which can easily lead to the situation that the data sent to the user terminal after encryption still contains wrong information, resulting in the need to encrypt and send the sent data again, resulting in a waste of computing resources during encryption and sending.

[0006] The above information disclosed in this Background section is only for enhancement of understanding of the background of the inventive concept and therefore it may contain information that does not form the prior art that is already known in this country to a person of ordinary skill in the art. Summary of the invention

[0007] The content of this disclosure is used to introduce concepts in a brief form, which will be described in detail in the detailed implementation section below. The content of this disclosure is not intended to identify the key features or essential features of the technical solution claimed for protection, nor is it intended to limit the scope of the technical solution claimed for protection.

[0008] Some embodiments of the present disclosure propose a value table data updating method, apparatus, device, and computer-readable medium to solve one or more of the technical problems mentioned in the above background technology section.

[0009] In a first aspect, some embodiments of the present disclosure provide a method for updating value table data, the method comprising: receiving value table data sent by a user terminal, wherein the value table data comprises information of each cell, each of the cell information corresponds to a row number, a column number and content information, and the value table data comprises value information of each user; performing identification processing on the value table data to obtain an identification result; in response to determining that the identification result satisfies a preset identification result condition, performing the following steps: based on the identification result, generating marked value table data; performing update processing on the marked value table data to obtain updated value table data; performing data extraction processing on the updated value table data to obtain value information of each user; based on each user value information in the user value information, executing a payment task corresponding to the user value information to obtain a payment result; for each payment result in the obtained payment results, in response to determining that the payment result satisfies the preset payment result condition, performing encryption processing on the user value information and the payment result to obtain encrypted information; and sending the obtained encrypted information to each user terminal corresponding to the user value information.

[0010] In a second aspect, some embodiments of the present disclosure provide a value table data updating device, the device comprising: a receiving unit, configured to receive value table data sent by a user terminal, wherein the value table data includes information of each cell, each of the cell information corresponds to a row number, a column number and content information, and the value table data includes value information of each user; an identification unit, configured to perform identification processing on the value table data to obtain an identification result; an execution unit, configured to perform the following steps in response to determining that the identification result satisfies a preset identification result condition: based on the identification result, generate marked value table data; update the marked value table data to obtain updated value table data; perform data extraction processing on the updated value table data to obtain value information of each user; based on each user value information in the user value information, execute a payment task corresponding to the user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result satisfies the preset payment result condition, encrypt the user value information and the payment result to obtain encrypted information; and send the obtained encrypted information to each user terminal corresponding to the user value information.

[0011] In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device on which one or more programs are stored, and when the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any implementation manner of the above-mentioned first aspect.

[0012] In a fourth aspect, some embodiments of the present disclosure provide a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the method described in any implementation manner of the above-mentioned first aspect is implemented.

[0013] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table data processing method of some embodiments of the present disclosure, the efficiency of identifying erroneous information in the value table data can be improved, and the waste of computing resources can be reduced. Specifically, the reason for the low efficiency of identifying erroneous information in the value table data and the waste of computing resources is that when the confidentiality of the data is high, only processing the data by technicians without any encryption measures on the data is likely to cause data leakage and reduce the security of the data. And the efficiency and accuracy of identifying and modifying the value table data by technicians alone are low, which is likely to cause the data sent to the user terminal after encryption to still contain erroneous information, resulting in the need to encrypt and send the sent data again, resulting in the waste of computing resources during encryption and sending. Based on this, the table data processing method of some embodiments of the present disclosure, first, receives the value table data sent by the user terminal, wherein the above-mentioned value table data includes each cell information, each cell information in the above-mentioned cell information corresponds to the number of rows, the number of columns and the content information, and the above-mentioned value table data includes each user value information. Thus, the value table data to be identified can be obtained. Secondly, the above-mentioned value table data is identified and processed to obtain the identification result. Thus, it can be identified whether the value table data contains keywords such as "name". Then, in response to determining that the above recognition result meets the preset recognition result condition, the following steps are performed: First, based on the above recognition result, the marked value table data is generated. Thus, the content information of each cell information in the value table data can be compared with the preset detection keywords to identify the cell information containing error information, and the identified cell information is marked to obtain the marked value table data, which can improve the efficiency and accuracy of recognition. Secondly, the above marked value table data is updated to obtain the updated value table data. Thus, the error information in the value table data can be changed by marking the value table data to obtain the updated value table data. Then, the above updated value table data is subjected to data extraction processing to obtain each user value information. Thus, each user value information can be extracted from the updated value table data, and the error information in each user value information can be reduced. Then, based on each user value information in the above user value information, the payment task corresponding to the above user value information is executed to obtain the payment result. Thus, the corresponding payment task can be executed according to each user value information. Then, for each of the obtained payment results, in response to determining that the payment result satisfies the preset payment result condition, the user value information and the payment result are encrypted to obtain encrypted information. Thus, the payment result and user value information of each user can be encrypted to obtain encrypted information corresponding to each user. Finally, the obtained encrypted information is sent to each user terminal corresponding to each user value information.Thus, the encrypted information can be sent to the user terminal. Also, because the content information of each cell information in the value table data can be compared with each preset detection keyword to identify the cell information containing error information, the efficiency and accuracy of recognition can be improved, thereby reducing the situation where the data sent to the user terminal after encryption still contains error information, thereby reducing the number of times the same data is encrypted and sent, and reducing the waste of computing resources during encryption and sending. Also, because the user value data can be encrypted before being sent to the user terminal, the probability of data leakage can be reduced and the security of the data can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that components and elements are not necessarily drawn to scale.

[0015] Figure 1 is a flow chart of some embodiments of the table data processing method according to the present disclosure;

[0016] Figure 2 is a schematic diagram of the structure of some embodiments of the table data processing device according to the present disclosure;

[0017] Figure 3 is a schematic diagram of the structure of an electronic device suitable for implementing some embodiments of the present disclosure;

[0018] Figure 4 It is a schematic screenshot of an internal test operation page for marking detection keywords included in the marked value table data according to the table data processing method disclosed in the present invention. DETAILED DESCRIPTION

[0019] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments set forth herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0020] It should also be noted that, for ease of description, only the parts related to the invention are shown in the drawings. In the absence of conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other.

[0021] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0022] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0023] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0024] The present disclosure will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

[0025] Figure 1 The process 100 of some embodiments of the table data processing method according to the present disclosure is shown. The table data processing method comprises the following steps:

[0026] Step 101, receiving value table data sent by a user terminal.

[0027] In some embodiments, the execution subject (e.g., computing device) of the value table data updating method may receive the value table data sent by the user terminal. The user terminal may be a terminal device corresponding to the user. The value table data may be table data used to characterize the user value information corresponding to the user. The user value information may be information related to the value corresponding to the user. The user value information may include, but is not limited to: user name, user department, user ID number, user contact information, value information (e.g., salary to be paid). The value table data includes each cell information. The cell information is a cell in the value table data. Each cell information in the cell information corresponds to a row number, a column number, and content information. The row number may be the row number where the cell information is located. The column number may be the column number where the cell information is located. The content information may be the content in the cell information. The execution subject may be a computing device. In practice, the execution subject may receive the value table data sent by the user terminal. The value table data may be information related to the user value corresponding to the corresponding table header. In addition to the table header, each row represents a user, and each column represents information related to each user and the corresponding column in the table header. As an example: when the first column in the table header is "Name", the first column of all rows except the header is the name of each user; when the second column in the table header is "ID Number", the second column of all rows except the header is the ID number of each user.

[0028] Step 102, performing recognition processing on the value table data to obtain a recognition result.

[0029] In some embodiments, the execution subject may perform recognition processing on the value table data to obtain a recognition result. The recognition result may be the cell information to be recognized that contains the target content or empty. The target content may be the content used to represent "name". For example, the target content may include but is not limited to: "name", "user name", "name". In practice, first, the execution subject may determine the cell information that meets the preset recognition conditions in the cell information included in the value table data as the cell information to be recognized. Then, the target content may be recognized from the content information corresponding to the cell information to be recognized through the API interface (Application Programming Interface) to obtain a recognition result. The preset recognition condition may be that the number of rows corresponding to the cell information is less than the preset recognition value. The preset recognition value may be a preset value. Here, there is no limitation on the specific setting of the preset recognition value. The API interface may be ApachePOI.

[0030] Step 103, in response to determining that the recognition result meets the preset recognition result condition, perform the following steps:

[0031] Step 1031, generating tag value table data based on the recognition result.

[0032] In some embodiments, the execution subject may generate marked value table data based on the recognition result. The preset recognition result condition may be that the recognition result is not empty. The marked value table data may be table data obtained by marking the value table data.

[0033] In some optional implementations of some embodiments, the execution subject may generate the marked value table data based on the recognition result through the following steps:

[0034] The first step is to determine the header row information based on the above recognition result. The header row information can be used to represent the row where each to-be-recognized cell information that needs to be processed in the above value table data is located. In practice, the above execution entity can determine the row where the to-be-recognized cell information corresponding to the above recognition result is located as the header row information.

[0035] In the second step, each to-be-identified cell information corresponding to the above-mentioned header row information is determined as each header cell information.

[0036] The third step is to determine the data processing information corresponding to the value table data based on the above-mentioned header cell information, wherein the above-mentioned data processing information may be information used to characterize the processing method used when processing the above-mentioned value table data.

[0037] The fourth step is to mark the above-mentioned header cell information based on the above-mentioned data processing information to obtain the marked value table data. The above-mentioned marked value table data can be the value table data after the marking process.

[0038] In some optional implementations of some embodiments, the execution subject may determine the data processing information corresponding to the value table data based on the information of each header cell through the following steps:

[0039] The first step is to identify and process the above-mentioned various title cell information to obtain a title recognition result. Among them, the above-mentioned title recognition result can be information used to characterize the type corresponding to each title cell information. For example, the above-mentioned title recognition result can be a "single-layer header" or a "multi-layer header". The types corresponding to the above-mentioned title cell information may include a single-layer header and a multi-layer header. In practice, the above-mentioned execution entity can identify and process the above-mentioned various title cell information through ApachePOI to obtain a title recognition result.

[0040] In the second step, in response to determining that the title recognition result satisfies the preset title recognition condition, the first preset processing mode is determined as data processing information. The preset title recognition condition may be that the title recognition result is "single-layer header". The first preset processing mode may be information on a processing method used when processing the value table data when the title recognition result is "single-layer header". For example, the first preset processing mode may be "single-layer header processing".

[0041] In the third step, in response to determining that the title recognition result does not meet the preset title recognition condition, the following steps are performed:

[0042] The first sub-step is to determine each title cell information corresponding to the above title recognition result as each hierarchical title cell information. Among them, each hierarchical title cell information in the above hierarchical title cell information corresponds to a layer number. The above layer number can be used to characterize the number of rows in the cell. For example, when the cell is not divided, the number of layers corresponding to the above cell is one; when the cell is divided into two rows, the number of layers corresponding to the above cell is two. In practice, the above execution entity can determine each title cell information whose corresponding title recognition result is "multi-layer header" in the above each title cell information as each hierarchical title cell information.

[0043] The second sub-step is to determine the target number of layers that satisfies a preset number of layers condition among the number of layers corresponding to the above-mentioned layer title cell information. The above-mentioned preset number of layers condition may be that the value corresponding to the number of layers is the largest.

[0044] The third sub-step is, in response to determining that the target number of layers is equal to the preset number, determining the second preset processing mode as data processing information. The preset number may be a pre-set value. Here, there is no limitation on the specific setting of the preset number. The second preset processing mode may be information for characterizing the processing method used when processing the value table data when the target number of layers is equal to the preset number. For example, the second preset processing mode may be "double-layer header processing".

[0045] The fourth sub-step is, in response to determining that the target number of layers is greater than the preset number, performing the following steps:

[0046] Sub-step 1, generating early warning prompt information. The early warning prompt information may be information for prompting the user to modify the value table data. For example, the early warning prompt information may be "This type of file is not supported, please modify it". In practice, the execution entity may generate the early warning prompt information through a preset template engine. The template engine may be a rule engine for outputting corresponding prompt information when the input data meets certain conditions.

[0047] Sub-step two: sending the above-mentioned warning prompt information to the above-mentioned user terminal.

[0048] In some optional implementations of some embodiments, the execution subject may perform marking processing on each of the header cell information based on the data processing information to obtain the marked value table data through the following steps:

[0049] In the first step, in response to determining that the data processing information satisfies the first preset processing condition, the following steps are performed:

[0050] The first sub-step is to obtain each detection keyword. Among them, the above-mentioned first preset processing condition can be that the above-mentioned data processing information is "single-layer header processing". The above-mentioned detection keyword can be the content that needs to be detected and marked in the above-mentioned each marked cell information. The above-mentioned each detection keyword is preset by the technician. In practice, the above-mentioned execution entity can obtain the above-mentioned each detection keyword from a preset database. Among them, the above-mentioned preset database can be a preset database for storing detection keywords.

[0051] In the second sub-step, each content information corresponding to each of the above-mentioned title cell information is determined as each title content information.

[0052] In the third sub-step, for each of the above-mentioned title content information, the above-mentioned title content information is compared with each of the above-mentioned detection keywords to obtain a comparison result. The above-mentioned comparison result can be a label used to characterize whether any of the above-mentioned detection keywords exists in the above-mentioned title content information. For example, the above-mentioned comparison result can be "existence" or "non-existence".

[0053] The fourth sub-step is to determine the comparison results that meet the first preset comparison result condition among the obtained comparison results as the target comparison results. The first preset comparison result condition may be that the comparison result is "existent".

[0054] The fifth sub-step is to determine each title cell information corresponding to each of the above target comparison results as the title cell information to be marked.

[0055] The sixth sub-step is to mark each of the above-mentioned header cell information to be marked to obtain the marked value table data. In practice, the above-mentioned execution subject can add corresponding marking information to each of the above-mentioned header cell information to be marked through the AddComment method in VBA (Visual Basic for Applications) to mark each of the above-mentioned header cell information to be marked. Then, the value table data after the marking process can be determined as the marked value table data.

[0056] In the process of adopting technical solutions to solve the above technical problems, the following problems are often accompanied:

[0057] Technical personnel are easily disturbed by subjectivity when identifying erroneous information, and are prone to marking correct information as erroneous information, which in turn requires the technical personnel to re-check the marked information and unmark the correct information, resulting in low data processing efficiency and waste of network resources during marking.

[0058] Faced with the above technical problems, we decided to adopt the following solutions:

[0059] In some optional implementations of some embodiments, the execution subject may perform marking processing on each of the header cell information based on the data processing information to obtain the marked value table data through the following steps:

[0060] In the first step, in response to determining that the data processing information satisfies the second preset processing condition, the following steps are performed:

[0061] The first sub-step is to obtain each detection keyword. The second preset processing condition may be that the data processing information is "double-layer header processing".

[0062] In the second sub-step, each content information corresponding to each of the above-mentioned title cell information is determined as each title content information.

[0063] In the third sub-step, for each of the above-mentioned title content information, the above-mentioned title content information is compared with each of the above-mentioned detection keywords to obtain a comparison result. The above-mentioned comparison result can be a label used to characterize whether any of the above-mentioned detection keywords exists in the above-mentioned title content information. For example, the above-mentioned comparison result can be "existence" or "non-existence".

[0064] The fourth sub-step is to determine the comparison results that meet the first preset comparison result condition among the obtained comparison results as the target comparison results. The first preset comparison result condition may be that the comparison result is "existent".

[0065] The fifth sub-step is to determine each header cell information corresponding to each target comparison result as each target cell information.

[0066] The sixth sub-step is to determine each target cell information that meets the preset double-layer condition in the above-mentioned target cell information as each double-layer cell information. Among them, the above-mentioned preset double-layer condition can be that the type corresponding to the target cell information is a multi-layer header. Each double-layer cell information in the above-mentioned double-layer cell information includes first cell information and each second cell information. The above-mentioned first cell information can be a cell located in the first layer of the double-layer cell information. The above-mentioned second cell information can be a cell located in the second layer of the double-layer cell information. The above-mentioned first cell information corresponds to first content information. The above-mentioned first content information can be content information corresponding to the above-mentioned first cell information. Each second cell information in the above-mentioned second cell information corresponds to second content information. The above-mentioned second content information can be content information corresponding to the above-mentioned second cell information.

[0067] The seventh sub-step is to generate each double-layer cell information to be marked based on the above double-layer cell information, wherein the above double-layer cell information to be marked may be the first cell information or the second cell information containing the above detection keyword in the corresponding content information.

[0068] In an eighth sub-step, each target cell information that does not satisfy the preset double-layer condition among the above target cell information is determined as each single-layer cell information to be marked.

[0069] The ninth sub-step is to determine the above-mentioned information of each double-layer cell to be marked and the determined information of each single-layer cell to be marked as the information of each cell to be marked.

[0070] The tenth sub-step is to mark the above-mentioned various cell information to be marked to obtain the marked value table data. In practice, the above-mentioned execution subject can add corresponding marking information to the above-mentioned various header cell information to be marked through the AddComment method in VBA (Visual Basic for Applications) to mark the above-mentioned various header cell information to be marked. Then, the value table data after the marking process can be determined as the marked value table data.

[0071] The above technical solution and its related contents, as an inventive point of an embodiment of the present disclosure, solve the problem of "waste of network resources". The factors that lead to low efficiency of data processing and waste of network resources during marking are often as follows: technicians are easily disturbed by subjectivity when identifying wrong information, and are prone to marking correct information as wrong information, which in turn causes the technicians to check the marked information again and cancel the marking of the correct information, resulting in low efficiency of data processing and waste of network resources during marking. If the above factors are solved, the efficiency of data processing can be improved and the waste of network resources during marking can be reduced. In order to achieve this effect, the present disclosure first, in response to determining that the above data processing information meets the second preset processing condition, performs the following steps: First, obtain each detection keyword. Thus, each detection keyword that needs to be identified from the content information corresponding to each cell information can be obtained. Then, each content information corresponding to the above title cell information is determined as each title content information. Thus, each content information that needs to be identified can be obtained. Then, for each title content information in the above title content information, the above title content information is compared with each detection keyword in the above detection keywords to obtain a comparison result. Thus, it is possible to directly determine whether the title content information contains any detection keyword by comparison, which can improve the efficiency and accuracy of data processing. Then, the comparison results that meet the first preset comparison result conditions in the obtained comparison results are determined as the target comparison results. Thus, the comparison results of specific conditions can be screened out. Then, the title cell information corresponding to the above-mentioned target comparison results is determined as the target cell information. Thus, the title cell information containing any detection keyword in the corresponding content information can be screened out. Then, the target cell information that meets the preset double-layer conditions in the above-mentioned target cell information is determined as the double-layer cell information, wherein each double-layer cell information in the above-mentioned double-layer cell information includes the first cell information and each second cell information, the first cell information corresponds to the first content information, and each second cell information in the above-mentioned second cell information corresponds to the second content information. Thus, the double-layer cell information can be screened out from the title cell information containing any detection keyword. Then, based on the above-mentioned double-layer cell information, each double-layer cell information to be marked is generated. Thus, the cell information that needs to be marked in the double-layer cell information can be determined. Then, the target cell information that does not meet the preset double-layer condition among the target cell information is determined as the single-layer cell information to be marked. Thus, the single-layer target cell information can be obtained. Then, the double-layer cell information to be marked and the determined single-layer cell information to be marked are determined as the cell information to be marked. Thus, all the cell information to be marked can be obtained.Finally, the above-mentioned cell information to be marked is marked to obtain the marked value table data. In this way, all the cell information to be marked can be marked directly. Also, because each cell information can be compared with each detection keyword to determine whether each cell information contains error information, and then the cell information containing error information is marked, the accuracy of marking can be improved, the efficiency of data processing can be improved, and the waste of network resources during marking can be reduced.

[0072] In the process of adopting technical solutions to solve the above technical problems, the following problems are often accompanied:

[0073] The structure of a double-layer header is more complicated than that of a single-layer header. When processing a large number of double-layer headers, technicians often make mistakes due to visual fatigue and easily identify correct information as incorrect information, resulting in a large number of marking errors. In turn, technicians need to check the marked information multiple times to obtain the marked value table data, resulting in slower data processing.

[0074] Faced with the above technical problems, we decided to adopt the following solutions:

[0075] In some optional implementations of some embodiments, the execution subject may generate each double-layer cell information to be marked based on the above-mentioned each double-layer cell information through the following steps:

[0076] In the first step, for each double-layer cell information in the above double-layer cell information, perform the following steps:

[0077] In the first sub-step, the first content information corresponding to the double-layer cell information is compared with each of the detection keywords to obtain a first content comparison result. The first content comparison result may be a label used to indicate whether the first content information contains any of the detection keywords. The first content comparison result may be "existent" or "non-existent".

[0078] The second sub-step is to compare each second content information in each second content information corresponding to the above double-layer cell information with each detection keyword in the above detection keywords to obtain a second content comparison result. The above second content comparison result may be a label used to indicate whether the above second content information contains any one of the above detection keywords. The above second content comparison result may be "existence" or "non-existence".

[0079] The third sub-step is, in response to determining that the first content comparison result satisfies the second preset comparison result condition, determining the first cell information included in the double-layer cell as the first cell information to be marked. The second preset comparison result condition may be that the first content comparison result is "existent".

[0080] The fourth sub-step is, in response to determining that each second content comparison result obtained satisfies a third preset comparison result condition, executing the following steps:

[0081] Sub-step 1: Determine each second content comparison result that satisfies the preset comparison condition among the above-mentioned second content comparison results as each target comparison result. Among them, the above-mentioned third preset comparison result condition can be that any second content comparison result among the above-mentioned second content comparison results is "existent". The above-mentioned preset comparison condition can be that the second content comparison result is "existent".

[0082] Sub-step two: determining each second cell information corresponding to each of the above target comparison results as each second cell information to be marked.

[0083] In the second step, the determined first cell information to be marked and the determined second cell information to be marked are determined as double-layer cell information to be marked.

[0084] The above technical solution and its related contents, as an inventive point of the embodiment of the present disclosure, solve the problem of "slow data processing speed". The factors that lead to slow data processing speed are often as follows: the structure of the double-layer header is more complicated than that of the single-layer header, and when processing a large number of double-layer headers, technicians often make mistakes due to visual fatigue, and are prone to identifying correct information as wrong information, resulting in a large number of marking errors, which in turn causes the technicians to need to check the marked information multiple times before obtaining the marked value table data, resulting in slow data processing speed. If the above factors are solved, the speed of data processing can be improved. In order to achieve this effect, the present disclosure firstly performs the following steps for each double-layer cell information in the above-mentioned double-layer cell information: firstly, the first content information corresponding to the above-mentioned double-layer cell information is compared with each detection keyword in the above-mentioned detection keywords to obtain the first content comparison result. Thus, it is possible to obtain information whether the first content information contains the detection keyword. Secondly, for each second content information in each second content information corresponding to the above-mentioned double-layer cell information, the above-mentioned second content information is compared with each detection keyword in the above-mentioned detection keywords to obtain the second content comparison result. Thus, information on whether each second content information contains a detection keyword can be obtained. Then, in response to determining that the first content comparison result satisfies the second preset comparison result condition, the first cell information included in the double-layer cell is determined as the first cell information to be marked. Thus, when the first content information contains the detection keyword, the cell information corresponding to the first content information is determined as the cell information to be marked. Then, in response to determining that the obtained second content comparison results meet the third preset comparison result condition, the following steps are performed: first, the second content comparison results that meet the preset comparison condition in the above-mentioned second content comparison results are determined as the target comparison results. Thus, the second content comparison results that meet the specific conditions can be screened out. Then, the second cell information corresponding to the above-mentioned target comparison results is determined as the second cell information to be marked. Thus, the second cell information containing any one of the detection keywords in the corresponding content information can be obtained. Finally, the determined first cell information to be marked and the determined second cell information to be marked are determined as the double-layer cell information to be marked. Thus, all the cell information to be marked can be determined. Also, because the first content information and each second content information can be compared with each detection keyword in turn, and then it can be directly determined whether the corresponding cell information needs to be marked, and there is no need to check again, the speed of data processing can be improved.

[0085] Step 1032, update the marked value table data to obtain updated value table data.

[0086] In some embodiments, the execution entity may update the marked value table data to obtain updated value table data.

[0087] In some optional implementations of some embodiments, the marked value table data includes each marked cell information, each of the marked cell information corresponds to marking information, and the marking information includes marking reasons and modification information. The execution subject can update the marked value table data through the following steps to obtain updated value table data:

[0088] The first step is to send the above-mentioned marked value table data to the server. Among them, the above-mentioned marked cell information can be a cell in the above-mentioned marked value table data. Each of the above-mentioned marked cell information corresponds to marking information, an acceptance control and an ignore control. The above-mentioned marking information can be the content information marked when marking the title cell information. The above-mentioned marking information can include marking reasons and modification information. The above-mentioned marking reason can be the reason for marking the title cell information. The above-mentioned modification information can be information used to prompt the user how to modify. As an example, when the content information corresponding to the above-mentioned title cell information is "fine", and "fine" belongs to the above-mentioned detection keyword, the above-mentioned marking reason can be "the enterprise has no administrative penalty authority", and the above-mentioned modification information can be "deduction". The above-mentioned acceptance control can be a command button for replacing the modification information corresponding to the marked cell information with the content information of the marked cell information. The above-mentioned ignore control can be a command button for ignoring the modification information corresponding to the marked cell information and refusing to modify the marked cell information.

[0089] For example, Figure 4 This is a schematic screenshot of an internal test operation page for marking the detection keywords contained in the marked value table data according to the table data processing method disclosed in the present invention, showing the operation page for marking the detection keywords in the marked value table data. Among them, "Salary Slip Ultimate Test Enterprise" can be the name corresponding to the operation page. "Add Desktop Shortcut" can be used to add Figure 4The corresponding operation page is added to the desktop control. "Settings" is a functional control for adjusting the above operation page. Among them, the above adjustment operations may include but are not limited to: zooming in and out of the screen. The above "Online Customer Service" may be a control for communicating with technical personnel. Payroll, salary analysis, intelligent reports, data management, employee files, orders / invoices may be the functional modules corresponding to the above execution subjects. The above payroll may be a functional module for displaying the above value table data and processing the above value table data. The above payroll may include uploading the payroll, checking the payroll, and sending the payroll. The above upload of the payroll may be a functional module for the above execution subject to receive the value table data. The above check of the payroll may be a functional module for performing the processing operations corresponding to steps 102-1035 on the received value table data. The above sending of the payroll may be a functional module for sending the encrypted information obtained after processing to each user terminal. The "Successful association (1 item) can be issued payroll" in the above check of the payroll may be a prompt information for indicating that the above value table data has been successfully received. "Selection form" may be a functional module for indicating the type of the received value table data. For example, the types of value table data may include, but are not limited to: employee value table (e.g., salary table), item value table (e.g., item unit price table). "Actual salary" may be used to characterize the type of data corresponding to the value table data. The module corresponding to "name / mobile phone number" may be a functional module for searching in table data through the name or mobile phone number input by the user. The table in the payroll slip may be value table data after being marked. The row where "Chinese name" is located may be the title row information corresponding to the above value table data. "Chinese name", "deductions", and "payable salary" may be the information of each title cell included in the above title row information. Among them, the cell information corresponding to "deductions" may be the double-layer cell information that meets the above-mentioned preset double-layer conditions. "Deductions" is the first cell information corresponding to the above double-layer cell information. "Late fine", "sick leave fine", "regularization compensation", and "total deductions" are the second cell information corresponding to the above double-layer cell information. "Late fine" and "sick leave fine" may be the second cell information corresponding to the content information containing the detection keyword. The risk word reminder corresponding to the above "late fine" may be the tag information corresponding to the above "late fine". The "Late fine is suggested to be replaced with late deduction" in the risk word reminder can be the modification information in the tag information corresponding to the "Late fine". The "Replacement reason" in the risk word reminder can be the tag reason in the tag information corresponding to the "Late fine". "Ignore" can be the ignore control. Direct replacement can be the accept control. "Cancel association" in "Operation" can be a control for deleting the currently associated value table data.The salary analysis may be a functional module for the execution entity to process all received employee value tables. The intelligent report may be a functional module for capturing, integrating, and other processing all received value table data to generate a report. The data management may be a functional module for the execution entity to delete, copy, modify, and other processing all received value table data. The employee profile may be a functional module for storing employee value data. The order / invoice may be a functional module for storing the payment result corresponding to the payment task.

[0090] In the second step, for each of the marked cell information included in the marked value table data, in response to detecting a selection operation acting on the marked cell information, the following steps are performed:

[0091] The first sub-step is, in response to determining that the above selection operation satisfies the first preset selection condition, executing the following steps:

[0092] Sub-step 1: Determine the target marking information from the marking information corresponding to the marking cell information. The selection operation may be a click operation on the acceptance control or the ignore control corresponding to the marking cell information. The first preset selection condition may be that the control corresponding to the selection operation is an acceptance control.

[0093] Sub-step two: determining the modification information included in the target marking information as the content information corresponding to the marking cell, so as to update the marking cell and obtain an updated marking cell.

[0094] Sub-step three: determining the updated marked cell information as the updated cell information.

[0095] The second sub-step is, in response to determining that the selection operation satisfies a second preset selection condition, determining the marked cell information as updated cell information. The second preset selection condition may be that the control corresponding to the selection operation is an ignored control.

[0096] The third sub-step is to update the marked value table data based on the determined updated cell information to obtain updated marked value table data. In practice, the execution subject may replace the marked cell information included in the marked value table data with the corresponding updated cell information to update the marked value table data to obtain updated marked value table data.

[0097] The third step is to determine the updated marked value table data as the updated value table data.

[0098] Step 1033, extracting and processing the updated value table data to obtain value information of each user.

[0099] In some embodiments, the execution subject may perform data extraction processing on the updated value table data to obtain the value information of each user. In practice, first, the execution subject may extract each row of data except the header from the updated value table data through a data extraction function. Then, each row of data extracted may be respectively connected to the header in the updated value table data through a connection function to obtain the value information of each user. The data extraction function may be a read function in pandas. The connection function may be a pd.concat function.

[0100] Step 1034, based on each user value information in each user value information, execute the payment task corresponding to the user value information to obtain the payment result.

[0101] In some embodiments, the execution subject may execute the payment task corresponding to the user value information based on each user value information in the user value information to obtain the payment result. The payment result may be a label used to characterize the success or failure of the payment. For example, the payment result may be "payment success" or "payment failure". In practice, first, the execution subject may be connected to the bank system through the API interface. Then, the user value information and the pre-acquired forwarding account information may be filled into the template provided by the bank system to obtain the payment request information. Then, the payment request information may be sent to the bank system through the API interface. Then, the payment information sent by the bank system may be received. Finally, the information related to the payment result may be found from the payment information through the string search function. For example, the execution subject may search "payment success" or "payment failure" from the payment information through the string search function to obtain the payment result. The bank system may be: a value transfer system. The forwarding account information may be an account used to transfer value to the user account. The payment request information may be payment related information. The payment request information may include but is not limited to: user name, user account, payment attribute, forwarding account information. The payment information may be payment related information obtained after executing the payment task. The payment information may include: payment time, payment result. The string search function may be find().

[0102] Step 1035, for each of the obtained payment results, in response to determining that the payment result meets the preset payment result condition, encrypt the user value information and the payment result to obtain encrypted information.

[0103] In some embodiments, the execution entity may, for each of the payment results obtained, encrypt the user value information and the payment result in response to determining that the payment result satisfies a preset payment result condition to obtain encrypted information. The preset payment result condition may be that the payment result is "payment successful". The encrypted information may be information obtained by encrypting the user value information and the payment result corresponding to the user value information. In practice, the execution entity may encrypt the user value information and the payment result corresponding to the user value information by an encryption algorithm to obtain encrypted information. The encryption algorithm may be a Blowfish algorithm.

[0104] Step 1036: Send the obtained encrypted information to each user terminal corresponding to each user value information.

[0105] In some embodiments, the execution subject may send the obtained encrypted information to the user terminals corresponding to the user value information, wherein the user terminals may be the terminal devices of the users corresponding to the user value information.

[0106] Optionally, after step 103, the execution entity may further perform the following steps:

[0107] In the first step, in response to determining that the above recognition result does not meet the above preset recognition result condition, the following steps are performed:

[0108] The first sub-step is to generate modification prompt information. The modification prompt information may be information for prompting the user to modify the value table data. For example, the modification prompt information may be "Please modify the value table data". In practice, the execution entity may generate the modification prompt information through the template engine.

[0109] The second sub-step is to send the modification prompt information to the user terminal. In practice, the execution entity may send the modification prompt information to the user terminal.

[0110] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the table data processing method of some embodiments of the present disclosure, the efficiency of identifying erroneous information in the value table data can be improved, and the waste of computing resources can be reduced. Specifically, the reason for the low efficiency of identifying erroneous information in the value table data and the waste of computing resources is that when the confidentiality of the data is high, only processing the data by technicians without any encryption measures on the data is likely to cause data leakage and reduce the security of the data. And the efficiency and accuracy of identifying and modifying the value table data by technicians alone are low, which is likely to cause the data sent to the user terminal after encryption to still contain erroneous information, resulting in the need to encrypt and send the sent data again, resulting in the waste of computing resources during encryption and sending. Based on this, the table data processing method of some embodiments of the present disclosure, first, receives the value table data sent by the user terminal, wherein the above-mentioned value table data includes each cell information, each cell information in the above-mentioned cell information corresponds to the number of rows, the number of columns and the content information, and the above-mentioned value table data includes each user value information. Thus, the value table data to be identified can be obtained. Secondly, the above-mentioned value table data is identified and processed to obtain the identification result. Thus, it can be identified whether the value table data contains keywords such as "name". Then, in response to determining that the above recognition result meets the preset recognition result condition, the following steps are performed: First, based on the above recognition result, the marked value table data is generated. Thus, the content information of each cell information in the value table data can be compared with the preset detection keywords to identify the cell information containing error information, and the identified cell information is marked to obtain the marked value table data, which can improve the efficiency and accuracy of recognition. Secondly, the above marked value table data is updated to obtain the updated value table data. Thus, the error information in the value table data can be changed by marking the value table data to obtain the updated value table data. Then, the above updated value table data is subjected to data extraction processing to obtain each user value information. Thus, each user value information can be extracted from the updated value table data, and the error information in each user value information can be reduced. Then, based on each user value information in the above user value information, the payment task corresponding to the above user value information is executed to obtain the payment result. Thus, the corresponding payment task can be executed according to each user value information. Then, for each of the obtained payment results, in response to determining that the payment result satisfies the preset payment result condition, the user value information and the payment result are encrypted to obtain encrypted information. Thus, the payment result and user value information of each user can be encrypted to obtain encrypted information corresponding to each user. Finally, the obtained encrypted information is sent to each user terminal corresponding to each user value information.Thus, the encrypted information can be sent to the user terminal. Also, because the content information of each cell information in the value table data can be compared with each preset detection keyword to identify the cell information containing error information, the efficiency and accuracy of recognition can be improved, thereby reducing the situation where the data sent to the user terminal after encryption still contains error information, thereby reducing the number of times the same data is encrypted and sent, and reducing the waste of computing resources during encryption and sending. Also, because the user value data can be encrypted before being sent to the user terminal, the probability of data leakage can be reduced and the security of the data can be improved.

[0111] Further references Figure 2 As an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of a value table data updating device. These device embodiments are similar to Figure 2 Corresponding to the method embodiments shown, the device can be specifically applied to various electronic devices.

[0112] like Figure 2 As shown, the value table data updating device 200 of some embodiments includes: a receiving unit 201 , an identifying unit 202 and an executing unit 203 . Among them, the receiving unit 201 is configured to receive value table data sent by the user terminal, wherein the above-mentioned value table data includes each cell information, each cell information in the above-mentioned cell information corresponds to the number of rows, the number of columns and content information, and the above-mentioned value table data includes each user value information; the identification unit 202 is configured to perform identification processing on the above-mentioned value table data to obtain an identification result; the execution unit 203 is configured to perform the following steps in response to determining that the above-mentioned identification result meets the preset identification result condition: based on the above-mentioned identification result, generate marked value table data; update the above-mentioned marked value table data to obtain updated value table data; perform data extraction processing on the above-mentioned updated value table data to obtain each user value information; based on each user value information in the above-mentioned user value information, execute the payment task corresponding to the above-mentioned user value information to obtain the payment result; for each of the obtained payment results, in response to determining that the above-mentioned payment result meets the preset payment result condition, encrypt the above-mentioned user value information and the above-mentioned payment result to obtain encrypted information; and send the obtained encrypted information to each user terminal corresponding to the above-mentioned user value information.

[0113] It is understood that the units described in the device 200 are similar to those described in the reference Figure 1 Therefore, the operations, features and beneficial effects described above for the method are also applicable to the device 200 and the units included therein, and will not be described in detail here.

[0114] Reference below Figure 3 , which shows a schematic structural diagram of an electronic device (such as a computing device) 300 suitable for implementing some embodiments of the present disclosure. Figure 3 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0115] like Figure 3 As shown, the electronic device 300 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 301, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 302 or a program loaded from a storage device 308 into a random access memory (RAM) 303. In the RAM 303, various programs and data required for the operation of the electronic device 300 are also stored. The processing device 301, the ROM 302, and the RAM 303 are connected to each other via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0116] Typically, the following devices may be connected to the I / O interface 305: input devices 306 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 307 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 308 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 309. The communication devices 309 may allow the electronic device 300 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 3 The electronic device 300 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead. Figure 3 Each block shown in the figure may represent one device, or may represent multiple devices as required.

[0117] In particular, according to some embodiments of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, some embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In some such embodiments, the computer program can be downloaded and installed from the network through the communication device 309, or installed from the storage device 308, or installed from the ROM 302. When the computer program is executed by the processing device 301, the above-mentioned functions defined in the method of some embodiments of the present disclosure are executed.

[0118] It should be noted that the computer-readable medium recorded in some embodiments of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In some embodiments of the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device. In some embodiments of the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. This propagated data signal may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

[0119] In some embodiments, the client and the server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0120] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device. The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: receives value table data sent by a user terminal, wherein the value table data includes information of each cell, each of which corresponds to a row number, a column number and content information, and the value table data includes value information of each user; performs recognition processing on the value table data to obtain a recognition result; in response to determining that the recognition result satisfies a preset recognition result condition, performs the following steps: based on the recognition result, generates marked value table data; performs update processing on the marked value table data to obtain updated value table data; performs data extraction processing on the updated value table data to obtain value information of each user; based on each user value information in the user value information, performs a payment task corresponding to the user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result satisfies a preset payment result condition, performs encryption processing on the user value information and the payment result to obtain encrypted information; and sends the obtained encrypted information to each user terminal corresponding to the user value information.

[0121] Computer program code for performing the operations of some embodiments of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0122] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0123] The units described in some embodiments of the present disclosure may be implemented by software or hardware. The units described may also be set in a processor, for example, it may be described as: a processor includes a receiving unit, an identification unit, and an execution unit. The names of these units do not constitute a limitation on the units themselves in some cases, for example, the receiving unit may also be described as a "unit for receiving value table data sent by a user terminal".

[0124] The functions described above herein may be performed at least in part by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0125] The above descriptions are only some preferred embodiments of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the embodiments of the present disclosure is not limited to the technical solutions formed by a specific combination of the above-mentioned technical features, but should also cover other technical solutions formed by any combination of the above-mentioned technical features or their equivalent features without departing from the above-mentioned inventive concept. For example, the above-mentioned features are replaced with the technical features with similar functions disclosed in the embodiments of the present disclosure (but not limited to) and the technical solutions formed.

Claims

1. A table data processing method, comprising: Receiving value table data sent by a user terminal, wherein the value table data includes information of each cell, each of the cell information corresponds to a row number, a column number and content information, and the value table data includes value information of each user; Performing recognition processing on the value table data to obtain a recognition result; In response to determining that the recognition result satisfies a preset recognition result condition, performing the following steps: Based on the recognition result, generating marked value table data; performing update processing on the marked value table data to obtain updated value table data; Performing data extraction processing on the updated value table data to obtain value information of each user; Based on each user value information in the respective user value information, executing a payment task corresponding to the user value information to obtain a payment result; For each of the obtained payment results, in response to determining that the payment result satisfies a preset payment result condition, encrypting the user value information and the payment result to obtain encrypted information; The obtained encrypted information is sent to each user terminal corresponding to each user value information.

2. The method according to claim 1, wherein: The method further comprises: In response to determining that the recognition result does not meet the preset recognition result condition, performing the following steps: Generate modification prompt information; The modification prompt information is sent to the user terminal.

3. The method according to claim 1, wherein: The generating of the marked value table data based on the recognition result includes: Based on the recognition result, determining the header row information; Determine each to-be-identified cell information corresponding to the header row information as each header cell information; Determining data processing information corresponding to the value table data based on the information of each title cell; Based on the data processing information, each title cell information is marked to obtain marked value table data.

4. The method according to claim 3, wherein: The step of determining data processing information corresponding to the value table data based on the information of each title cell includes: Identify and process the information of each title cell to obtain a title recognition result; In response to determining that the title recognition result satisfies a preset title recognition condition, determining a first preset processing mode as data processing information; In response to determining that the title recognition result does not meet the preset title recognition condition, performing the following steps: Determine each title cell information corresponding to the title recognition result as each hierarchical title cell information, wherein each hierarchical title cell information in each hierarchical title cell information corresponds to a number of layers; Determine the number of layers that meets the preset number of layers condition among the number of layers corresponding to the information of the layered title cells as the target number of layers; In response to determining that the target number of layers is equal to a preset number, determining a second preset processing mode as data processing information; In response to determining that the target number of layers is greater than the preset number, performing the following steps: Generate early warning information; The warning prompt information is sent to the user terminal.

5. The method according to claim 3, wherein: Based on the data processing information, the information of each title cell is marked to obtain marked value table data, including: In response to determining that the data processing information satisfies a first preset processing condition, performing the following steps: Get each detection keyword; Determine each content information corresponding to each title cell information as each title content information; For each piece of title content information in the various pieces of title content information, the title content information is compared with each piece of detection keyword in the various detection keywords to obtain a comparison result; Determining the comparison results that meet the first preset comparison result condition among the obtained comparison results as target comparison results; Determine each title cell information corresponding to each target comparison result as the title cell information to be marked; Marking processing is performed on the information of each title cell to be marked to obtain marked value table data.

6. The method according to claim 1, wherein: The marked value table data includes each marked cell information, each of the marked cell information corresponds to marking information, and the marking information includes marking reason and modification information; And the updating process of the marked value table data to obtain updated value table data includes: Sending the marked value table data to the server; For each of the marked cell information included in the marked value table data, in response to detecting a selection operation acting on the marked cell information, the following steps are performed: In response to determining that the selection operation satisfies a first preset selection condition, performing the following steps: Determine target marking information using marking information corresponding to the marking cell information; Determining the modification information included in the target marking information as the content information corresponding to the marking cell, so as to update the marking cell and obtain an updated marking cell; Determine the updated marked cell information as updated cell information; In response to determining that the selection operation satisfies a second preset selection condition, determining the marked cell information as updated cell information; Based on the determined updated cell information, the marked value table data is updated to obtain updated marked value table data; The updated marked value table data is determined as the updated value table data.

7. A table data processing device, comprising: A receiving unit is configured to receive value table data sent by a user terminal, wherein the value table data includes information of each cell, each of the information of each cell corresponds to a row number, a column number and content information, and the value table data includes value information of each user; an identification unit configured to perform identification processing on the value table data to obtain an identification result; The execution unit is configured to execute the following steps in response to determining that the recognition result satisfies a preset recognition result condition: based on the recognition result, generate marked value table data; update the marked value table data to obtain updated value table data; perform data extraction on the updated value table data to obtain each user value information; based on each user value information in the each user value information, execute a payment task corresponding to the user value information to obtain a payment result; for each payment result in the each payment result obtained, in response to determining that the payment result satisfies a preset payment result condition, encrypt the user value information and the payment result to obtain encrypted information; and send each encrypted information obtained to each user terminal corresponding to the each user value information.

8. An electronic device comprising: one or more processors; a storage device having one or more programs stored thereon; When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 6.

9. A computer readable medium having a computer program stored thereon, wherein: When the program is executed by a processor, the method according to any one of claims 1 to 6 is implemented.

Images