Tabular data processing methods, apparatus, devices and computer-readable media

By employing a processing method that receives, identifies, updates, and encrypts valuable table data, the problems of data leakage and wasted computing resources are solved, thereby improving identification efficiency and data security.

CN119760733BActive Publication Date: 2026-03-10BEIJING UFIDA DIGITAL TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-11-04
Publication Date
2026-03-10

AI Technical Summary

Technical Problem

Existing technologies are prone to leakage when processing valuable tabular data, even when data security is high. Furthermore, the efficiency of technical personnel in identifying and modifying such data is low, resulting in wasted computing resources and reduced data security.

Method used

By receiving value table data from user terminals, identifying and processing it, generating marked value table data, updating it, extracting user value information, and encrypting and sending it when conditions are met, the transmission of erroneous information is reduced.

Benefits of technology

It improves the efficiency and accuracy of error message identification, reduces the waste of computing resources, enhances data security, and lowers the probability of data leakage.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119760733B_ABST
    Figure CN119760733B_ABST
Patent Text Reader

Abstract

This disclosure discloses a method, apparatus, device, and computer-readable medium for processing tabular data. One specific implementation of the method includes: receiving value table data sent by a user terminal; obtaining an identification result; and, in response to determining that the identification result meets preset identification result conditions, performing the following steps: generating marked value table data; obtaining updated value table data; obtaining value information for each user; obtaining a payment result; for each payment result obtained, in response to determining that the payment result meets preset payment result conditions, encrypting the user value information and the payment result to obtain encrypted information; and sending the obtained encrypted information to the respective user terminals corresponding to the respective user value information. This implementation can improve the efficiency and accuracy of identifying erroneous information in the value table data and can reduce the waste of computational resources during encryption and transmission.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The embodiments of this disclosure relate to the field of computer technology, and more specifically to tabular data processing methods, apparatus, devices, and computer-readable media. Background Technology

[0002] Spreadsheet data processing refers to the process of collecting, storing, retrieving, processing, transforming, and transmitting tabular data. For example, when processing business data, it is crucial to ensure that the compiled spreadsheet data does not contain any errors that do not comply with relevant regulations and to encrypt the correct spreadsheet data before sending it to the relevant technical personnel.

[0003] Currently, the typical approach to processing value table data is as follows: technical personnel identify and correct errors in the value table data according to relevant regulations. Then, they extract individual user value information from the corrected value table data. Based on this user value information, appropriate operations are performed. Finally, the user value information and operation results are sent to the user's terminal.

[0004] However, when processing value table data using the above method, the following technical problems often arise:

[0005] When data security is high, relying solely on technical personnel to process the data without any encryption measures can easily lead to data leakage and reduce data security. Furthermore, relying solely on technical personnel to identify and modify value table data is inefficient and inaccurate, potentially resulting in encrypted data sent to user terminals still containing errors. This necessitates re-encrypting and re-sending the data, wasting computational resources during encryption and transmission.

[0006] The information disclosed in this background section is only intended to enhance the understanding of the background of the inventive concept, and therefore may contain information that does not constitute prior art known to those skilled in the art. Summary of the Invention

[0007] The summary portion of this disclosure is intended to provide a brief overview of the concepts, which will be described in detail in the detailed description portion. This summary portion is not intended to identify key or essential features of the claimed technical solutions, nor is it intended to limit the scope of the claimed technical solutions.

[0008] Some embodiments of this disclosure provide methods, apparatus, devices, and computer-readable media for updating value table data to address one or more of the technical problems mentioned in the background section above.

[0009] In a first aspect, some embodiments of this disclosure provide a method for updating value table data. The method includes: receiving value table data sent by a user terminal, wherein the value table data includes information for each cell, each cell corresponding to a number of rows, columns, and content information, and the value table data includes various user value information; performing identification processing on the value table data to obtain an identification result; and, in response to determining that the identification result meets preset identification result conditions, performing the following steps: generating marked value table data based on the identification result; updating the marked value table data to obtain updated value table data; performing data extraction processing on the updated value table data to obtain various user value information; performing a payment task corresponding to each user value information based on each user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result meets preset payment result conditions, encrypting the user value information and the payment result to obtain encrypted information; and sending the obtained encrypted information to each user terminal corresponding to each user value information.

[0010] Secondly, some embodiments of this disclosure provide a value table data updating apparatus, the apparatus 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 cell corresponding to a number of rows, a number of columns, and content information, and the value table data includes various user value information; an identification unit configured to perform identification processing on the value table data to obtain an identification result; and an execution unit configured to, in response to determining that the identification result meets preset identification result conditions, perform the following steps: generating marked value table data based on the identification result; updating the marked value table data to obtain updated value table data; performing data extraction processing on the updated value table data to obtain various user value information; executing a payment task corresponding to each user value information based on each user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result meets preset payment result conditions, encrypting the user value information and the payment result to obtain encrypted information; and sending the obtained encrypted information to each user terminal corresponding to each user value information.

[0011] Thirdly, some embodiments of this disclosure provide an electronic device, including: one or more processors; and a storage device having one or more programs stored thereon, wherein 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 of the first aspect above.

[0012] Fourthly, some embodiments of this disclosure provide a computer-readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the method described in any of the implementations of the first aspect above.

[0013] The various embodiments of this disclosure have the following beneficial effects: the table data processing method of some embodiments of this disclosure can improve the efficiency of identifying error information in value table data and reduce the waste of computing resources. Specifically, the reason for the low efficiency of identifying error information in value table data and the waste of computing resources is that when the data security is high, simply processing the data by technicians without any encryption measures can easily lead to data leakage and reduce data security. Moreover, the efficiency and accuracy of identifying and modifying value table data by technicians alone are low, which can easily lead to the situation that the encrypted data sent to the user terminal still contains error information, resulting in the need to encrypt and send the data again, causing a waste of computing resources during encryption and transmission. Based on this, the table data processing method of some embodiments of this disclosure first receives value table data sent by the user terminal, wherein the value table data includes information of each cell, and each cell information corresponds to the number of rows, the number of columns and content information, and the value table data includes various user value information. Thus, the value table data to be identified can be obtained. Secondly, the value table data is processed for identification to obtain the identification result. Therefore, it is possible to identify whether the value table data contains keywords such as "name". Then, in response to determining that the above identification results meet the preset identification result conditions, the following steps are performed: First, based on the above identification results, marked value table data is generated. This allows comparison of the content information of each cell in the value table data with preset detection keywords to identify cells containing erroneous information. The identified cells are then marked, resulting in marked value table data, which improves the efficiency and accuracy of identification. Second, the marked value table data is updated to obtain updated value table data. This allows correction of erroneous information in the value table data by marking the value table data. Then, data extraction processing is performed on the updated value table data to obtain individual user value information. This allows extraction of individual user value information from the updated value table data, reducing erroneous information in each user value information. Finally, based on each user value information, a payment task corresponding to that user value information is executed, resulting in a payment result. This allows for the execution of corresponding payment tasks based on each user value information. Then, for each payment result obtained, in response to determining that the payment result meets the preset payment result conditions, the user value information and the payment result are encrypted to obtain encrypted information. Thus, the payment result and user value information for each user can be encrypted to obtain encrypted information corresponding to each user. Finally, the obtained encrypted information is sent to the respective user terminals corresponding to the aforementioned user value information.Therefore, encrypted information can be sent to the user terminal. Because the content of each cell in the value table data can be compared with preset detection keywords to identify cells containing erroneous information, the efficiency and accuracy of identification can be improved. This reduces the likelihood of encrypted data still containing errors sent to the user terminal, thus reducing the number of times the same data needs to be encrypted and sent, and minimizing the waste of computational resources during encryption and transmission. Furthermore, because user value data can be encrypted before being sent to the user terminal, the probability of data leakage can be reduced, improving data security. Attached Figure Description

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

[0015] Figure 1 This is a flowchart of some embodiments of the tabular data processing method according to this disclosure;

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

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

[0018] Figure 4 This is a screenshot of an illustrative internal test operation page showing the tagging of detection keywords contained in the tag value table data according to the tabular data processing method disclosed herein. Detailed Implementation

[0019] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0020] It should also be noted that, for ease of description, only the parts relevant to the invention are shown in the accompanying drawings. Unless otherwise specified, the embodiments and features described in this disclosure can be combined with each other.

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

[0022] It should be noted that the terms "a" and "a plurality of" used in this disclosure are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".

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

[0024] This disclosure will now be described in detail with reference to the accompanying drawings and embodiments.

[0025] Figure 1 A flow 100 of some embodiments of a tabular data processing method according to the present disclosure is shown. The tabular data processing method includes the following steps:

[0026] Step 101: Receive the value table data sent by the user terminal.

[0027] In some embodiments, the executing entity (e.g., a computing device) of the value table data update method can receive value table data sent by a user terminal. The user terminal can be a terminal device corresponding to a user. The value table data can be table data representing user value information. The user value information can be value-related information corresponding to the user. The user value information can include, but is not limited to: user name, user department, user ID number, user contact information, and value information (e.g., salary payable). The value table data includes cell information. The cell information refers to the cells in the value table data. Each cell information corresponds to a row number, a column number, and content information. The row number can be the row number of the cell information. The column number can be the column number of the cell information. The content information can be the content in the cell information. The executing entity can be a computing device. In practice, the executing entity can receive value table data sent by a user terminal. The value table data can have a header containing user value-related information, where each row represents a user and each column represents information related to the corresponding column in the header for each user. As an example: when the first column in the table header is "Name", the first column of all rows except the table 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 table header is the ID number of each user.

[0028] Step 102: Perform identification processing on the value table data to obtain the identification results.

[0029] In some embodiments, the execution entity can perform identification processing on the value table data to obtain identification results. The identification results can be cell information containing target content or empty. The target content can be content representing "name". For example, the target content can include, but is not limited to, "name", "user name", or "name". In practice, firstly, the execution entity can determine each cell information in the value table data that meets preset identification conditions as each cell information to be identified. Then, it can identify the target content from the content information corresponding to each cell information to be identified through an API (Application Programming Interface) to obtain identification results. The preset identification condition can be that the number of rows corresponding to the cell information is less than a preset identification value. The preset identification value can be a pre-set numerical value. Here, the specific setting of the preset identification value is not limited. The API interface can be Apache POI.

[0030] Step 103: In response to determining that the recognition result meets the preset recognition result conditions, the following steps are executed:

[0031] Step 1031: Based on the identification results, generate a label value table of data.

[0032] In some embodiments, the executing entity may generate a labeled value table based on the identification result. The preset identification result condition may be that the identification result is not empty. The labeled value table data may be table data obtained by labeling the value table data.

[0033] In some optional implementations of certain embodiments, the aforementioned executing entity may generate a tag value table data based on the aforementioned identification results through the following steps:

[0034] The first step, based on the above identification results, is to determine the header row information. This header row information can be used to represent the row containing each cell of information to be identified in the aforementioned value table data. In practice, the executing entity can determine the row containing the cell of information to be identified corresponding to the above identification results as the header row information.

[0035] The second step is to identify the cell information to be recognized corresponding to the above header row information as the header cell information.

[0036] The third step is to determine the data processing information corresponding to the value table data based on the information in each of the header cells. This data processing information can be information that characterizes the processing method used when processing the value table data.

[0037] The fourth step involves marking the information in each header cell based on the data processing described above, resulting in a marked value table. This marked value table can be the value table data after the marking process.

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

[0039] The first step is to process the information in each of the header cells to obtain the header recognition result. This header recognition result can be information representing the type of each header cell. For example, the header recognition result could be "single-level header" or "multi-level header." The type corresponding to the header cell information can include single-level header or multi-level header. In practice, the executing entity can use Apache POI to process the header cell information and obtain the header recognition result.

[0040] The second step involves determining that the title recognition result meets the preset title recognition conditions, and then setting the first preset processing mode as data processing information. The preset title recognition conditions can be that the title recognition result is "single-level header". The first preset processing mode can be information about the processing method used when processing the value table data when the title recognition result is "single-level header". For example, the first preset processing mode can be "single-level header processing".

[0041] Third, in response to the determination that the above title recognition result does not meet the above preset title recognition conditions, the following steps are executed:

[0042] The first sub-step involves identifying the header cell information corresponding to the aforementioned header recognition results as hierarchical header cell information. Each hierarchical header cell information corresponds to a layer number. This layer number can be used to represent the number of rows in the cell. For example, when the cell is not divided, the layer number is one; when the cell is divided into two rows, the layer number is two. In practice, the executing entity can identify the header cell information whose header recognition result is "multi-level header" as hierarchical header cell information.

[0043] The second sub-step involves determining the target layer number from among the layers corresponding to the above-mentioned hierarchical header cell information that meets the preset layer number condition. The preset layer number condition can be that the value corresponding to the layer number is the maximum.

[0044] The third sub-step involves determining the second preset processing mode as data processing information in response to the determination that the target number of layers equals a preset quantity. The preset quantity can be a pre-set value. The specific setting of the preset quantity is not limited here. The second preset processing mode can be information characterizing the processing method used when processing the value table data when the target number of layers equals the preset quantity. For example, the second preset processing mode can be "two-layer header processing".

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

[0046] Sub-step one: Generate early warning information. This early warning information can be used to prompt the user to modify the data in the aforementioned value table. For example, the early warning information could be "This type of file is not supported, please modify." In practice, the executing entity can generate the early warning information using a preset template engine. This template engine can be a rule engine that outputs corresponding prompts when the input data meets certain conditions.

[0047] Sub-step two: Send the aforementioned warning message to the aforementioned user terminal.

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

[0049] First, in response to determining that the above data processing information meets the first preset processing condition, the following steps are executed:

[0050] The first sub-step involves acquiring each detection keyword. The first preset processing condition can be "single-layer header processing" for the data processing information. The detection keywords can be the content that needs to be detected and marked in each of the marked cell information. These detection keywords are preset by technical personnel. In practice, the executing entity can acquire the detection keywords from a preset database. This preset database can be a pre-defined database used to store detection keywords.

[0051] The second sub-step involves determining the content information corresponding to each of the above-mentioned title cell information as the title content information.

[0052] The third sub-step involves comparing each piece of title content information with each of the aforementioned detection keywords to obtain a comparison result. This comparison result can be a tag indicating whether any of the aforementioned detection keywords exists in the title content information. For example, the comparison result can be "exists" or "does not exist".

[0053] The fourth sub-step involves identifying each comparison result that satisfies the first preset comparison result condition as a target comparison result. The first preset comparison result condition can be that the comparison result is "existent".

[0054] The fifth sub-step involves determining the header cell information corresponding to each of the above target comparison results as the header cell information to be marked.

[0055] The sixth sub-step involves marking the information in each of the aforementioned title cells to be marked, resulting in a marked value table. In practice, the executing entity can use the AddComment method in VBA (Visual Basic for Applications) to add corresponding marker information to each of the title cells to be marked, thus performing the marking process. The marked value table data can then be identified as the marked value table data.

[0056] In the process of adopting technical solutions to address the aforementioned technical problems, the following issues often arise:

[0057] Technicians are easily influenced by subjectivity when identifying erroneous information, and may mark correct information as incorrect. This leads to technicians having to re-verify the marked information and unmark the correct information, resulting in low data processing efficiency and wasted network resources during the marking process.

[0058] In response to the aforementioned technical problems, the following solution was adopted:

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

[0060] First, in response to determining that the above data processing information meets the second preset processing condition, the following steps are executed:

[0061] The first sub-step involves acquiring each detection keyword. The second preset processing condition mentioned above can be "double-layer header processing" for the data processing information.

[0062] The second sub-step involves determining the content information corresponding to each of the above-mentioned title cell information as the title content information.

[0063] The third sub-step involves comparing each piece of title content information with each of the aforementioned detection keywords to obtain a comparison result. This comparison result can be a tag indicating whether any of the aforementioned detection keywords exists in the title content information. For example, the comparison result can be "exists" or "does not exist".

[0064] The fourth sub-step involves identifying each comparison result that satisfies the first preset comparison result condition as a target comparison result. The first preset comparison result condition can be that the comparison result is "existent".

[0065] The fifth sub-step involves determining the header cell information corresponding to each of the above target comparison results as the target cell information.

[0066] The sixth sub-step involves identifying the target cell information that meets the preset two-layer condition as each two-layer cell. The preset two-layer condition can be that the target cell information corresponds to a multi-level header type. Each two-layer cell includes a first cell and several second cells. The first cell can be a cell located in the first layer of the two-layer cell information. The second cell can be a cell located in the second layer of the two-layer cell information. The first cell corresponds to first content information. The first content information can be the content information corresponding to the first cell. Each second cell corresponds to second content information. The second content information can be the content information corresponding to the second cell.

[0067] The seventh sub-step involves generating information for each double-layered cell to be labeled based on the aforementioned information. This information can be either the first or second cell containing the detected keyword.

[0068] The eighth sub-step involves identifying the target cell information that does not meet the preset two-layer condition as the single-layer cell information to be marked.

[0069] The ninth sub-step involves determining the information of each double-layer cell to be marked and the information of each single-layer cell to be marked as the information of each cell to be marked.

[0070] The tenth sub-step involves marking the information in each of the cells to be marked, resulting in a marked value table. In practice, the executing entity can use the AddComment method in VBA (Visual Basic for Applications) to add corresponding marker information to each of the header cells to be marked, thus marking the header cells. The marked value table data can then be identified as the marked value table data.

[0071] The above-described technical solution and its related content, as an inventive point of this disclosure, solve the problem of "waste of network resources." Factors leading to low data processing efficiency and wasted network resources during labeling often include: technicians are easily influenced by subjectivity when identifying erroneous information, easily marking correct information as incorrect, thus requiring technicians to re-verify and cancel the marking of correct information, resulting in low data processing efficiency and wasted network resources during labeling. Solving these factors can improve data processing efficiency and reduce wasted network resources during labeling. To achieve this effect, this disclosure firstly, in response to determining that the above-described data processing information meets the second preset processing condition, performs the following steps: First, obtain each detection keyword. This yields each detection keyword that needs to be identified from the content information corresponding to each cell. Then, determine each content information corresponding to each title cell as each title content information. This yields each content information that needs to be identified. Then, for each title content information, compare it with each detection keyword to obtain a comparison result. Therefore, by comparing, it can be directly determined whether the title content contains any detection keyword, which can improve the efficiency and accuracy of data processing. Then, the comparison results that meet the first preset comparison result condition are identified as target comparison results. This allows for the filtering of comparison results based on specific conditions. Next, the title cell information corresponding to the above target comparison results is identified as target cell information. This allows for the filtering of title cell information containing any detection keyword in the corresponding content information. Then, the target cell information that meets the preset double-layer condition is identified as double-layer cell information. Each double-layer cell information includes a first cell and several second cells. The first cell corresponds to first content information, and each second cell corresponds to second content information. This allows for the filtering of double-layer cell information from title cell information containing any detection keyword. Then, based on the above double-layer cell information, several double-layer cell information to be marked is generated. This allows for the determination of the cell information to be marked within the double-layer cell information. Then, the target cell information that does not meet the preset two-layer condition is identified as the single-layer cell information to be marked. Thus, the single-layer target cell information can be obtained. Then, the two-layer cell information to be marked and the identified single-layer cell information are identified as the cell information to be marked. Thus, all cell information that needs to be marked can be obtained.Finally, the information in each cell to be labeled is processed to obtain a labeling value table. This allows for direct labeling of all cells that need labeling. Furthermore, by comparing each cell with each detection keyword to determine if it contains errors, and then labeling cells with errors, the accuracy of labeling can be improved, data processing efficiency increased, and network resource waste reduced during labeling.

[0072] In the process of adopting technical solutions to address the aforementioned technical problems, the following issues often arise:

[0073] The structure of double-layer headers is more complex than that of single-layer headers. When processing a large number of double-layer headers, technicians often make mistakes due to visual fatigue, easily misidentifying correct information as incorrect information, resulting in a large number of labeling errors. Consequently, technicians need to check the labeled information multiple times to obtain the labeled value table data, which slows down the data processing speed.

[0074] In response to the aforementioned technical problems, the following solution was adopted:

[0075] In some optional implementations of certain embodiments, the execution entity described above can generate information about each double-layered cell to be marked based on the aforementioned double-layered cell information through the following steps:

[0076] The first step is to perform the following steps for each of the above double-layered cell information:

[0077] The first sub-step involves comparing the first content information corresponding to the aforementioned double-layer cell information with each of the aforementioned detection keywords to obtain a first content comparison result. This first content comparison result can be a tag used to characterize whether the aforementioned first content information contains any one of the aforementioned detection keywords. The first content comparison result can be either "present" or "absent".

[0078] The second sub-step involves comparing each piece of second content information corresponding to the aforementioned two-layer cell information with each of the aforementioned detection keywords to obtain a second content comparison result. This second content comparison result can be a tag indicating whether the second content information contains any one of the aforementioned detection keywords. The second content comparison result can be either "present" or "absent".

[0079] The third sub-step involves determining, in response to the determination that the first content comparison result satisfies the second preset comparison result condition, the first cell information included in the above-mentioned double-layered cell is identified as the first cell information to be marked. The second preset comparison result condition can be that the first content comparison result is "existent".

[0080] The fourth sub-step, in response to determining that each of the obtained second content comparison results meets the third preset comparison result condition, executes the following steps:

[0081] Sub-step one: Determine each second content comparison result that meets the preset comparison conditions from the aforementioned second content comparison results as the respective target comparison results. The aforementioned third preset comparison result condition can be that any one of the aforementioned second content comparison results is "existent". The aforementioned preset comparison condition can be that the second content comparison result is "existent".

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

[0083] The second step is to determine the first cell information to be marked and the second cell information to be marked as the double-layer cell information to be marked.

[0084] The above-described technical solution and related content, as an inventive point of this disclosure, solve the problem of "slow data processing speed." Factors contributing to slow data processing speed often include: the structure of a double-layer header is more complex than that of a single-layer header; and when processing a large number of double-layer headers, technicians often make mistakes due to visual fatigue, easily misidentifying correct information as incorrect information, leading to numerous labeling errors. This necessitates technicians repeatedly verifying the labeled information to obtain the labeled value table data, resulting in slow data processing speed. Solving these factors can improve data processing speed. To achieve this effect, this disclosure first performs the following steps for each double-layer cell information: First, the first content information corresponding to the double-layer cell information is compared with each detection keyword in the various detection keywords to obtain a first content comparison result. This allows us to determine whether the first content information contains detection keywords. Second, for each second content information corresponding to the double-layer cell information, the second content information is compared with each detection keyword in the various detection keywords to obtain a second content comparison result. Therefore, information on whether each second content information contains a detection keyword can be obtained. Then, in response to determining that the above first content comparison result meets the second preset comparison result condition, the first cell information included in the above double-layer cell is determined as the first cell information to be marked. Thus, when the first content information contains a 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 each obtained second content comparison result meets the third preset comparison result condition, the following steps are performed: First, each second content comparison result that meets the preset comparison condition is determined as each target comparison result. Thus, each second content comparison result that meets specific conditions can be filtered out. Then, each second cell information corresponding to each target comparison result is determined as each second cell information to be marked. Thus, each second cell information containing any one detection keyword in the corresponding content information can be obtained. Finally, each determined first cell information to be marked and each determined second cell information to be marked are determined as each double-layer cell information to be marked. Thus, all cell information to be marked can be determined. 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 without having to check again, the speed of data processing can be improved.

[0085] Step 1032: Update the value table data to obtain updated value table data.

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

[0087] In some optional implementations of certain embodiments, the aforementioned tag value table data includes information about each tag cell, and each tag cell corresponds to tag information, which includes the tagging reason and modification information. The executing entity can update the aforementioned tag value table data through the following steps to obtain updated value table data:

[0088] The first step is to send the aforementioned tag value table data to the server. The tag cell information can be any cell in the aforementioned tag value table data. Each tag cell information corresponds to tag information, an accept control, and an ignore control. The tag information can be the content information tagged when tagging the title cell information. The tag information can include the tagging reason and modification information. The tagging reason can be the reason for tagging the title cell information. The modification information can be information used to prompt the user on how to make modifications. As an example, when the content information corresponding to the title cell information is "fine," and "fine" is one of the aforementioned detection keywords, the tagging reason can be "The company does not have the authority to impose administrative penalties," and the modification information can be "deduction." The accept control can be a command button used to replace the modification information corresponding to the tag cell information with the content information of the tag cell information. The ignore control can be a command button used to ignore the modification information corresponding to the tag cell information, refusing to modify the tag cell information.

[0089] For example, Figure 4 This is a screenshot of an internal test operation page illustrating the tagging of detection keywords contained in the tag value table data according to the tabular data processing method of this disclosure. It shows the operation page for tagging detection keywords in the tag value table data. "Payslip Flagship Edition Test Enterprise" can be the name of the operation page. "Add Desktop Shortcut" can be used to... Figure 4The corresponding operation page is added to the desktop control. "Settings" is a functional control for adjusting the above operation page. These adjustments may include, but are not limited to, zooming in and out. "Online Customer Service" is a control for communicating with technical personnel. Payslip, Salary Analysis, Intelligent Reports, Data Management, Employee Files, and Orders / Invoices are the respective functional modules corresponding to the above-mentioned executing entity. The "Payslip" is a functional module for displaying and processing the above-mentioned value table data. The "Payslip" may include uploading payroll, verifying payroll, and sending payroll. Uploading payroll is a functional module for receiving value table data. Verifying payroll is a functional module for performing steps 102-1035 on the received value table data. Sending payslip is a functional module for sending the processed encrypted information to each user terminal. "Successfully Associated (1) Payslip Available" in the above-mentioned payroll verification table is a prompt indicating successful receipt of the above-mentioned value table data. "Select Form" is a functional module indicating the type of received value table data. For example, the types of value table data can include, but are not limited to: employee value tables (e.g., payroll), and item value tables (e.g., item unit price tables). "Net Salary" can be used to characterize the type of data in the value table data. The module corresponding to "Name / Mobile Number" can be a functional module that searches the table data using the user's entered name or mobile number. The table in the payslip can be value table data after being marked. The row containing "Chinese Name" can be the header row information corresponding to the aforementioned value table data. "Chinese Name," "Deductions," and "Gross Salary" can be the header cell information included in the aforementioned header row information. The cell information corresponding to "Deductions" can be double-layered cell information that meets the aforementioned preset double-layered conditions. "Deductions" is the first cell information corresponding to the aforementioned double-layered cell information. "Late Arrival Penalty," "Sick Leave Penalty," "Probationary Period Compensation," and "Total Deductions" are the second cell information corresponding to the aforementioned double-layered cell information. "Late Arrival Penalty" and "Sick Leave Penalty" can be the second cell information corresponding to content information containing detection keywords. The risk word reminder corresponding to the aforementioned "Late Arrival Penalty" can be the marking information corresponding to the aforementioned "Late Arrival Penalty." The "Late arrival penalty suggested replacing it with late arrival deduction" in the risk word alert can be the modification information in the tag information corresponding to "Late Arrival Penalty". The "Reason for Replacement" in the risk word alert can be the tag reason in the tag information corresponding to "Late Arrival Penalty". "Ignore" can be the aforementioned ignore control. Direct replacement can be the aforementioned accept control. "Unassociate" in "Operation" can be a control used to delete the currently associated value table data.The aforementioned salary analysis module is a functional module for the executing entity to process all received employee value tables. The aforementioned intelligent reporting module is a functional module for capturing, integrating, and processing all received value table data to generate reports. The aforementioned data management module is a functional module for the executing entity to delete, copy, and modify all received value table data. The aforementioned employee files are a functional module for storing employee value data. The aforementioned orders / invoices are a functional module for storing the payment results corresponding to the aforementioned payment tasks.

[0090] The second step involves performing the following steps for each tag cell in the aforementioned tag value table data, in response to detecting a selection operation applied to the aforementioned tag cell information:

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

[0092] Sub-step one involves determining the target marker information corresponding to the marker information in the aforementioned marked cells. The selection operation can be a click operation on the accept control or ignore control corresponding to the marker cell information. The first preset selection condition can be that the control corresponding to the selection operation is an accept control.

[0093] Sub-step two involves determining the modification information included in the target marker information as the content information corresponding to the marker cell, and updating the marker cell to obtain the updated marker cell.

[0094] Sub-step three: Determine the updated marker cell information as the updated cell information.

[0095] The second sub-step involves determining that the selection operation satisfies the second preset selection condition, and then setting the marked cell information as the updated cell information. The second preset selection condition can be that the control corresponding to the selection operation is an ignored control.

[0096] The third sub-step involves updating the tag value table data based on the determined update cell information, resulting in updated tag value table data. In practice, the aforementioned executing entity can replace the tag cell information included in the tag value table data with the corresponding update cell information to update the tag value table data and obtain updated tag value table data.

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

[0098] Step 1033: Perform data extraction processing on the updated value table data to obtain the value information of each user.

[0099] In some embodiments, the execution entity can perform data extraction processing on the updated value table data to obtain the value information of each user. In practice, firstly, the execution entity can extract each row of data from the updated value table data (excluding the header) using a data extraction function. Then, it can use a join function to join each extracted row of data with the header of the updated value table data to obtain the value information of each user. The data extraction function can be the `read` function in pandas, and the join function can be the `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 executing entity can execute a payment task corresponding to each user value information in the aforementioned user value information to obtain a payment result. The payment result can be a label indicating payment success or failure. For example, the payment result can be "payment successful" or "payment failed". In practice, firstly, the executing entity can interface with a bank system via an API. Then, it can fill the aforementioned user value information and pre-acquired forwarding account information into a template provided by the bank system to obtain payment request information. Then, it can send the payment request information to the bank system via the API. Then, it can receive payment information sent by the bank system. Finally, it can use a string search function to find information related to the payment result from the payment information. For example, the executing entity can use the string search function to search for "payment successful" or "payment failed" from the payment information to obtain the payment result. The bank system can be a value transfer system. The forwarding account information can be an account used to transfer value to a user account. The payment request information can be payment-related information. The payment request information can include, but is not limited to, user name, user account, payment attributes, and forwarding account information. The payment information mentioned above can be payment-related information obtained after executing the payment task. This payment information may include: payment time and payment result. The string search function mentioned above can be find().

[0102] Step 1035: For each payment result obtained, in response to determining that the payment result meets the preset payment result conditions, the user value information and the payment result are encrypted to obtain encrypted information.

[0103] In some embodiments, the executing entity may, for each payment result obtained, encrypt the user value information and the payment result in response to determining that the payment result meets 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 corresponding payment result. In practice, the executing entity may use an encryption algorithm to encrypt the user value information and the corresponding payment result to obtain encrypted information. The encryption algorithm may be the Blowfish algorithm.

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

[0105] In some embodiments, the executing entity may send the obtained encrypted information to the respective user terminals corresponding to the user value information. The user terminals may be the terminal devices of the users corresponding to the user value information.

[0106] Optionally, after step 103, the aforementioned executing entity may also perform the following steps:

[0107] The first step, in response to the determination that the above recognition result does not meet the above preset recognition result conditions, is to perform the following steps:

[0108] The first sub-step involves generating a modification prompt message. This message can be used to instruct the user to modify the data in the value table. For example, the prompt message could be "Please modify the value table data." In practice, the executing entity can use the template engine to generate the modification prompt message.

[0109] The second sub-step involves sending the aforementioned modification prompt message to the aforementioned user terminal. In practice, the executing entity can send the aforementioned modification prompt message to the aforementioned user terminal.

[0110] The various embodiments of this disclosure have the following beneficial effects: the table data processing method of some embodiments of this disclosure can improve the efficiency of identifying error information in value table data and reduce the waste of computing resources. Specifically, the reason for the low efficiency of identifying error information in value table data and the waste of computing resources is that when the data security is high, simply processing the data by technicians without any encryption measures can easily lead to data leakage and reduce data security. Moreover, the efficiency and accuracy of identifying and modifying value table data by technicians alone are low, which can easily lead to the situation that the encrypted data sent to the user terminal still contains error information, resulting in the need to encrypt and send the data again, causing a waste of computing resources during encryption and transmission. Based on this, the table data processing method of some embodiments of this disclosure first receives value table data sent by the user terminal, wherein the value table data includes information of each cell, and each cell information corresponds to the number of rows, the number of columns and content information, and the value table data includes various user value information. Thus, the value table data to be identified can be obtained. Secondly, the value table data is processed for identification to obtain the identification result. Therefore, it is possible to identify whether the value table data contains keywords such as "name". Then, in response to determining that the above identification results meet the preset identification result conditions, the following steps are performed: First, based on the above identification results, marked value table data is generated. This allows comparison of the content information of each cell in the value table data with preset detection keywords to identify cells containing erroneous information. The identified cells are then marked, resulting in marked value table data, which improves the efficiency and accuracy of identification. Second, the marked value table data is updated to obtain updated value table data. This allows correction of erroneous information in the value table data by marking the value table data. Then, data extraction processing is performed on the updated value table data to obtain individual user value information. This allows extraction of individual user value information from the updated value table data, reducing erroneous information in each user value information. Finally, based on each user value information, a payment task corresponding to that user value information is executed, resulting in a payment result. This allows for the execution of corresponding payment tasks based on each user value information. Then, for each payment result obtained, in response to determining that the payment result meets the preset payment result conditions, the user value information and the payment result are encrypted to obtain encrypted information. Thus, the payment result and user value information for each user can be encrypted to obtain encrypted information corresponding to each user. Finally, the obtained encrypted information is sent to the respective user terminals corresponding to the aforementioned user value information.Therefore, encrypted information can be sent to the user terminal. Because the content of each cell in the value table data can be compared with preset detection keywords to identify cells containing erroneous information, the efficiency and accuracy of identification can be improved. This reduces the likelihood of encrypted data still containing errors sent to the user terminal, thus reducing the number of times the same data needs to be encrypted and sent, and minimizing the waste of computational resources during encryption and transmission. Furthermore, because user value data can be encrypted before being sent to the user terminal, the probability of data leakage can be reduced, improving data security.

[0111] Further reference Figure 2 As an implementation of the methods shown in the above figures, this disclosure provides some embodiments of a value table data updating device, which 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 update device 200 in some embodiments includes: a receiving unit 201, an identification unit 202, and an execution unit 203. The receiving unit 201 is configured to receive value table data sent by a user terminal. The value table data includes information for each cell, and each cell has a number of rows, columns, and content information. The value table data includes value information for each user. The identification unit 202 is configured to perform identification processing on the 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 identification result meets preset identification result conditions: generating marked value table data based on the identification result; updating 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 for each user; performing a payment task corresponding to each user value information based on each user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result meets preset payment result conditions, encrypting the user value information and the payment result to obtain encrypted information; and sending the encrypted information to the respective user terminals corresponding to the respective user value information.

[0113] It is understandable that the units described in the device 200 are related to the reference. Figure 1 The steps in the described method correspond to each other. Therefore, the operations, features, and beneficial effects described above for the method also apply to the device 200 and the units contained therein, and will not be repeated here.

[0114] The following is for reference. Figure 3 It shows a schematic diagram of the structure 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 merely an example and should not be construed as limiting the functionality and scope of the embodiments of this disclosure.

[0115] like Figure 3 As shown, the electronic device 300 may include a processing unit (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. The RAM 303 also stores various programs and data required for the operation of the electronic device 300. The processing unit 301, ROM 302, and RAM 303 are interconnected via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0116] Typically, the following devices can be connected to I / O interface 305: input devices 306 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 307 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 308 including, for example, magnetic tapes, hard disks, etc.; and communication devices 309. Communication device 309 allows electronic device 300 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 3 An electronic device 300 with various devices is shown; however, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively. Figure 3 Each box shown can represent a device or multiple devices as needed.

[0117] In particular, according to some embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, some embodiments of this disclosure include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication device 309, or installed from storage device 308, or installed from ROM 302. When the computer program is executed by processing device 301, it performs the functions defined in the methods of some embodiments of this disclosure.

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

[0119] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0120] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device. The aforementioned computer-readable medium carries one or more programs. When the aforementioned one or more programs are executed by the electronic device, the electronic device causes the following actions: receiving value table data sent by a user terminal, wherein the value table data includes information of each cell, each cell corresponding to a number of rows, columns, and content information, and the value table data includes value information of each user; performing identification processing on the value table data to obtain an identification result; and, in response to determining that the identification result meets preset identification result conditions, performing the following steps: generating marked value table data based on the identification result; updating 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; performing a payment task corresponding to each user value information based on each user value information to obtain a payment result; for each payment result obtained, in response to determining that the payment result meets preset payment result conditions, encrypting the user value information and the payment result to obtain encrypted information; and sending the obtained encrypted information to each user terminal corresponding to each user value information.

[0121] Computer program code for performing operations of some embodiments of this disclosure can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone 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 remote computers, the remote computer can 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 can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0122] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0123] The units described in some embodiments of this disclosure can be implemented in software or hardware. The described units can also be housed in a processor; for example, a processor may be described as including a receiving unit, an identification unit, and an execution unit. The names of these units do not necessarily limit the specific unit; for example, a receiving unit may also be described as "a unit that receives value table data sent by a user terminal."

[0124] The functions described above in this document can be performed, at least in part, by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: Field Programmable Gate Arrays (FPGAs), Application-Specific Integrated Circuits (ASICs), Application Standard Products (ASSPs), System-on-Chip (SoCs), Complex Programmable Logic Devices (CPLDs), and so on.

[0125] The above description is merely a selection of preferred embodiments of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of the invention involved in the embodiments of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described inventive concept. For example, technical solutions formed by substituting the above-described features with (but not limited to) technical features with similar functions disclosed in the embodiments of this disclosure.

Claims

1. A table data processing method, comprising: receiving value table data sent by a user terminal, wherein the value table data comprises respective cell information, each of the respective cell information corresponds to a row number, a column number and content information, and the value table data comprises respective user value information; 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: generating marked value table data based on the identification result, wherein the marked value table data comprises respective marked cell information, each of the respective marked cell information corresponds to marked information, and the marked information comprises a marking reason and modification information; performing update processing on the marked value table data to obtain updated value table data, wherein the update processing on the marked value table data to obtain the updated value table data comprises: sending the marked value table data to a server; for each of the respective marked cell information included in the marked value table data, in response to detecting a selection operation acting on the marked cell information, performing the following steps: in response to determining that the selection operation satisfies a first preset selection condition, performing the following steps: determining the marked information corresponding to the marked cell information as target marked information; determining the modification information included in the target marked information as content information corresponding to the marked cell, so as to update the marked cell to obtain an updated marked cell; determining 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 the updated cell information; updating the marked value table data based on the determined updated cell information to obtain updated marked value table data; determining the updated marked value table data as the updated value table data; performing data extraction processing on the updated value table data to obtain the respective user value information; based on each of the respective user value information, performing a payment task corresponding to the user value information to obtain a payment result; for each of the obtained respective payment results, in response to determining that the payment result satisfies a preset payment result condition, performing encryption processing on the user value information and the payment result to obtain encryption information; sending the obtained respective encryption information to respective user terminals corresponding to the respective user value information.

2. The method of claim 1, wherein, The method further comprises: in response to determining that the identification result does not satisfy the preset identification result condition, performing the following steps: generating modification prompt information; sending the modification prompt information to the user terminal.

3. The method of claim 1, wherein, The generating marked value table data based on the identification result comprises: determining title row information based on the identification result; determining respective to-be-identified cell information corresponding to the title row information as respective title cell information; determine data processing information corresponding to the value table data based on the title cell information; perform marking processing on the title cell information based on the data processing information to obtain marked value table data.

4. The method of claim 3, wherein, The determining of the data processing information corresponding to the value table data based on the title cell information includes: performing identification processing on the title cell information to obtain a title identification result; in response to determining that the title identification result meets a preset title identification condition, determining a first preset processing mode as the data processing information; in response to determining that the title identification result does not meet the preset title identification condition, performing the following steps: determining each title cell information corresponding to the title identification result as each hierarchical title cell information, wherein each hierarchical title cell information of the hierarchical title cell information corresponds to a layer number; determining a layer number meeting a preset layer number condition from each layer number corresponding to the hierarchical title cell information as a target layer number; in response to determining that the target layer number is equal to a preset number, determining a second preset processing mode as the data processing information; in response to determining that the target layer number is greater than the preset number, performing the following steps: generating a warning prompt information; sending the warning prompt information to the user terminal.

5. The method of claim 3, wherein, The performing of the marking processing on the title cell information based on the data processing information to obtain the marked value table data includes: in response to determining that the data processing information meets a first preset processing condition, performing the following steps: obtaining each detection keyword; determining each content information corresponding to the title cell information as each title content information; for each title content information of the title content information, comparing the title content information with each detection keyword of the detection keywords to obtain a comparison result; determining each comparison result meeting a first preset comparison result condition from the obtained comparison results as each target comparison result; determining each title cell information corresponding to the target comparison result as a to-be-marked title cell information; performing marking processing on the to-be-marked title cell information to obtain the marked value table data.

6. A table data processing apparatus, comprising: a receiving unit configured to receive value table data sent by a user terminal, wherein the value table data includes each cell information, each cell information corresponds to a row number, a column number and content information, and the value table data includes each user value information; an identification unit configured to perform identification processing on the value table data to obtain an identification result; The execution unit is configured to, in response to determining that the identification result meets a preset identification result condition, perform the following steps: generating marked value table data based on the identification result, wherein the marked value table data includes respective marked cell information, each of the respective marked cell information corresponds to marked information, and the marked information includes a marked reason and modification information; performing update processing on the marked value table data to obtain updated value table data, wherein the update processing on the marked value table data to obtain the updated value table data includes: sending the marked value table data to a server; for each of the respective marked cell information included in the marked value table data, in response to detecting a selection operation acting on the marked cell information, performing the following steps: in response to determining that the selection operation meets a first preset selection condition, performing the following steps: determining the marked information corresponding to the marked cell information as target marked information; determining the modification information included in the target marked information as content information corresponding to the marked cell, to update the marked cell to obtain an updated marked cell; determining the updated marked cell information as updated cell information; in response to determining that the selection operation meets a second preset selection condition, determining the marked cell information as the updated cell information; based on the determined updated cell information, updating the marked value table data to obtain updated marked value table data; determining the updated marked value table data as the updated value table data; performing data extraction processing on the updated value table data to obtain respective user value information; based on each of the respective user value information, performing a payment task corresponding to the user value information to obtain a payment result; for each of the obtained respective 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 the obtained respective encrypted information to respective user terminals corresponding to the respective user value information. 7.An electronic device, comprising: one or more processors; storage storing one or more programs; when the one or more programs are executed by the one or more processors, the one or more processors implement the method of any one of claims 1-5.

8. A computer readable medium having stored thereon a computer program, wherein, The program is executed by the processor to implement the method of any one of claims 1-5.

Citation Information

Patent Citations

  • Order information processing method and device, electronic equipment and computer readable medium

    CN113393287A

  • Method and device for reading table, method and device for proofreading payment data, and storage medium

    CN116663507A