Table data processing method and device, computer equipment and storage medium

Abstract

The invention relates to a table data processing method and device and computer equipment. The method comprises the following steps: displaying a to-be-input table template; in response to click operation determination on a target cell in the to-be-input table template, a preset selectable data set associated with a target parent cell to which the target cell belongs is obtained, and the target cell is in an input limiting state; displaying each piece of selectable data at a preset position corresponding to the target cell, and in response to a click operation on the target selectable data corresponding to the limitation removal identifier in each piece of selectable data, converting the target cell from an input limitation state to an input state; obtaining target input data, verifying the target input data, and when the target input data passes verification, obtaining an updated selectable data set based on the target input data and a preset selectable data set; and obtaining an updated table template corresponding to the to-be-input table template based on the updated selectable data set. By adopting the method, the table template updating efficiency can be improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a table data processing method, device, computer equipment, storage medium and computer program product. Background Art

[0002] In today's data age, especially in data centers, huge amounts of data are accumulated to support various business functions. For example, a large amount of business information and personnel information is stored in the banking system. In order to manage data information, data needs to be entered into the backend database table. Due to the large amount of data, in order to improve data entry efficiency, table templates are usually formulated for unified data entry.

[0003] However, the existing data entry method cannot change the form template at any time, and the latest form template needs to be re-made, which leads to the problem of low efficiency in updating the form template. Summary of the invention

[0004] Based on this, it is necessary to provide a table data processing method, device, computer equipment, computer-readable storage medium and computer program product that can efficiently update table templates in response to the above technical problems.

[0005] In a first aspect, the present application provides a table data processing method, comprising:

[0006] Display the form template to be entered;

[0007] In response to a click operation on a target cell in the table template to be entered, a target parent cell to which the target cell belongs is determined based on the position of the target cell, and a preset optional data set associated with the target parent cell is obtained, and the target cell is in an input restriction state;

[0008] Displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from an input restriction state to an input-enabled state;

[0009] The target input data is obtained based on the inputtable state of the target cell, and the target input data is verified. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set;

[0010] An updated table template corresponding to the table template to be entered is obtained based on the updated optional data set, and a target parent cell in the updated table template is associated with the updated optional data set.

[0011] In a second aspect, the present application further provides a table data processing device, comprising:

[0012] Display module, used to display the form template to be entered;

[0013] A data acquisition module, for responding to a click operation on a target cell in a table template to be entered, determining a target parent cell to which the target cell belongs based on a position of the target cell, and acquiring a preset optional data set associated with the target parent cell, wherein the target cell is in an input restriction state;

[0014] A data display module, used to display each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, convert the target cell from an input restriction state to an input-enabled state;

[0015] A data verification module is used to obtain target input data based on the inputtable state of the target cell and verify the target input data. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set.

[0016] The updating module is used to obtain an updated table template corresponding to the table template to be entered based on the updated optional data set, and the target parent cell in the updated table template is associated with the updated optional data set.

[0017] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0018] Display the form template to be entered;

[0019] In response to a click operation on a target cell in the table template to be entered, a target parent cell to which the target cell belongs is determined based on the position of the target cell, and a preset optional data set associated with the target parent cell is obtained, and the target cell is in an input restriction state;

[0020] Displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from an input restriction state to an input-enabled state;

[0021] The target input data is obtained based on the inputtable state of the target cell, and the target input data is verified. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set;

[0022] An updated table template corresponding to the table template to be entered is obtained based on the updated optional data set, and a target parent cell in the updated table template is associated with the updated optional data set.

[0023] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0024] Display the form template to be entered;

[0025] In response to a click operation on a target cell in the table template to be entered, a target parent cell to which the target cell belongs is determined based on the position of the target cell, and a preset optional data set associated with the target parent cell is obtained, and the target cell is in an input restriction state;

[0026] Displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from an input restriction state to an input-enabled state;

[0027] The target input data is obtained based on the inputtable state of the target cell, and the target input data is verified. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set;

[0028] An updated table template corresponding to the table template to be entered is obtained based on the updated optional data set, and a target parent cell in the updated table template is associated with the updated optional data set.

[0029] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:

[0030] Display the form template to be entered;

[0031] In response to a click operation on a target cell in the table template to be entered, a target parent cell to which the target cell belongs is determined based on the position of the target cell, and a preset optional data set associated with the target parent cell is obtained, and the target cell is in an input restriction state;

[0032] Displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from an input restriction state to an input-enabled state;

[0033] The target input data is obtained based on the inputtable state of the target cell, and the target input data is verified. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set;

[0034] An updated table template corresponding to the table template to be entered is obtained based on the updated optional data set, and a target parent cell in the updated table template is associated with the updated optional data set.

[0035] The above table data processing method, device, computer equipment, storage medium and computer program product display the corresponding preset optional data set at a preset position by displaying the user's selection operation of the target cell in the table template to be entered. When it is checked that the user clicks the target optional data corresponding to the restriction release mark, it indicates that the currently displayed preset optional data set is not the data that the user needs to enter, and the target cell is converted from the input restriction state to the input state, allowing the user to enter data into the target cell. Then, the target entry data corresponding to the target cell is obtained, and the target entry data is verified to ensure that the target entry data meets the data entry requirements of the table template to be entered, meet the user's customized needs, and improve the flexibility of data entry. When the target entry data is verified, an updated optional data set is obtained based on the target entry data and the preset optional data set, and the preset optional data set can be directly updated using the target entry data to obtain an updated optional data set, and then an updated table template is generated according to the updated optional data set and the table template to be entered, thereby improving the update efficiency of the table template. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0037] Figure 1 An application environment diagram of a table data processing method in one embodiment;

[0038] Figure 2 A schematic diagram of a flow chart of a table data processing method in one embodiment;

[0039] Figure 3 A schematic diagram of a flow chart of table data processing steps in one embodiment;

[0040] Figure 4 is a structural block diagram of a table data processing device in one embodiment;

[0041] Figure 5 is an internal structure diagram of a computer device in one embodiment;

[0042] Figure 6 FIG. 4 is a diagram showing the internal structure of a computer device in another embodiment. DETAILED DESCRIPTION

[0043] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0044] The table data processing method provided in the embodiment of the present application can be applied to Figure 1 In the application environment shown. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. The terminal 102 displays the table template to be entered; the terminal 102 responds to the click operation of the target cell in the table template to be entered, determines the target parent cell to which the target cell belongs based on the position of the target cell, and obtains the preset optional data set associated with the target parent cell, and the target cell is in the input restriction state; the terminal 102 displays each optional data in the preset optional data set at the preset position corresponding to the target cell, and responds to the click operation of the target optional data corresponding to the restriction release mark in each optional data, and converts the target cell from the input restriction state to the input state; the terminal 102 obtains the target entry data based on the input state of the target cell, and verifies the target entry data. When the target entry data passes the verification, the updated optional data set is obtained based on the target entry data and the preset optional data set; the terminal 102 obtains the updated table template corresponding to the table template to be entered based on the updated optional data set, and the target parent cell in the updated table template is associated with the updated optional data set. The terminal 102 may send the updated form template to the server 104. The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, etc. The portable wearable device may be a smart watch, a smart bracelet, a head-mounted device, etc. The server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.

[0045] In an exemplary embodiment, Figure 2 As shown, a table data processing method is provided, which is applied to Figure 1 The terminal in is taken as an example to illustrate, including the following steps 202 to 206. Among them:

[0046] Step 202, displaying a form template to be entered.

[0047] Step 204, in response to a click operation on a target cell in the table template to be entered, determining a target parent cell to which the target cell belongs based on the position of the target cell, and obtaining a preset optional data set associated with the target parent cell, the target cell is in an input restriction state.

[0048] Among them, the table template to be entered refers to a pre-set table to be filled with a fixed format and entry rules. The target cell refers to the cell clicked by the user. The target parent cell refers to the cell associated with the target cell position that is pre-set with the entry data, which is used to indicate the data type of the entry data in the target cell. The preset optional data set refers to the pre-set user-selectable data. The input restriction state refers to the state of the cell restricting the entry of data in the non-optional data set.

[0049] Specifically, in response to the user's data entry operation based on the target table identifier, the terminal can download the table template information corresponding to the target table identifier from the server, or obtain the table template information corresponding to the target table identifier from the local cache. The table template information is used to generate the table template to be entered. The terminal generates the table template to be entered based on the table template information and displays it. Generally, the table template information includes the template creation time. The terminal downloads the table template information of the latest template creation time from the server, or obtains the table template information of the latest template creation time from the local cache. The table template information also includes the preset optional data sets associated with each parent cell in the table template to be entered.

[0050] In response to the user's click operation on the target cell in the table template to be entered, the terminal obtains the coordinate position of the target cell in the table template to be entered, and determines the target parent cell associated with the target cell according to the coordinate position. Then the terminal obtains the preset optional data set associated with the target parent cell from the table template information, which can be a preset optional data set associated with the data entered in the target parent cell. The preset optional data set can be a data set that pre-encapsulates the various optional data corresponding to the data entered in the target parent cell, and then establishes an association relationship between the preset optional data set and the data entered in the target parent cell. When the terminal generates the table template to be entered, it limits the data entry function of each cell in the table template to be entered, and each cell in the table template to be entered is in an input restriction state, including the target cell being in an input restriction state.

[0051] Step 206, display each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, convert the target cell from the input restriction state to the input enable state.

[0052] The target optional data refers to the optional data selected by the user. The input-enabled state refers to the state in which the cell is allowed to enter data in a non-optional data set. The restriction release flag refers to the flag that releases the input restriction of the cell.

[0053] Specifically, the terminal displays each optional data in the preset optional data set at a preset position corresponding to the target cell, such as the bottom edge position or the right edge position of the target cell. The preset optional data set includes functional optional data and non-functional optional data. The functional optional data is an identifier that represents the modification operation of the preset optional data set, such as the optional data of the restriction release identifier. A specific symbol can be used as the restriction release identifier, such as " / " as the optional data of the restriction release identifier, or a specific field can be used as the restriction release identifier, such as "custom input" as the optional data of the restriction release identifier. Non-functional optional data refers to an identifier of the same data type as the data entered in the corresponding parent cell. For example, if the data entered in the parent cell is "name", then each optional data in the corresponding preset optional data set is a name identifier such as "Zhang San" or "Li Si".

[0054] In response to the user's click operation on the target optional data marked with restriction release in each optional data, indicating that there is no data that the user needs to input in the preset optional data set, the terminal converts the target cell from the input restriction state to the input-enabled state. Specifically, the restriction release command can be called and executed for the target cell.

[0055] Step 208, obtaining target input data based on the inputtable state of the target cell, and verifying the target input data. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set.

[0056] The target input data refers to the data input into the target cell by the user.

[0057] Specifically, when the target cell is in an inputtable state, the user is allowed to input data into the target cell. After the terminal detects that the user has completed the data input into the target cell, the terminal obtains the target input data input into the target cell by the user, and uses the preset data verification information to verify the target input data. The preset data verification information refers to the data input requirement information of the cell, which is used to verify whether the input data in the cell meets the input requirement. It can be to verify whether the data type of the input data meets the preset data type, whether the value of the input data meets the preset value range, and whether the data length of the input data meets the preset data length.

[0058] After the terminal detects that the target input data has passed verification, the preset optional data set is updated using the target input data, which may be to add the target input data to the preset optional data set to obtain an updated optional data set.

[0059] In one embodiment, the functional optional data in the preset optional data set also includes optional data corresponding to the data modification identifier, such as "data modification" as the optional data of the data modification identifier. In response to the user's click operation on the optional data of the data modification identifier, the terminal instructs the user to determine the optional data to be modified in each non-functional optional data, and in response to the user's click operation on the optional data to be modified, fills the optional data to be modified into the target cell, and converts the target cell from the input restriction state to the input state. The terminal obtains the target modification data after the user modifies the optional data to be modified, verifies the target modification data, and when the target modification data passes the verification, the terminal uses the target modification data to update the preset optional data set, which can be to replace the optional data to be modified with the target modification data to obtain an updated optional data set.

[0060] Step 210 , obtaining an updated table template corresponding to the table template to be entered based on the updated optional data set, and associating a target parent cell in the updated table template with the updated optional data set.

[0061] Specifically, the terminal detects the update of the optional data set, and associates the update optional data set with the target parent cell, thereby obtaining an update table template corresponding to the table template to be entered.

[0062] In one embodiment, after obtaining the update optional data set, the terminal generates an update record according to the target input data, and then sends the update table template and the update record to the server. The server stores the update table template and updates the corresponding data in the server according to the update record.

[0063] In the above table data processing method, by displaying the user's selection operation of the target cell in the table template to be entered, the corresponding preset optional data set is displayed at a preset position. When it is checked that the user clicks the target optional data corresponding to the restriction release mark, it indicates that the currently displayed preset optional data set is not the data that the user needs to enter, and the target cell is converted from the input restriction state to the input state, allowing the user to enter data into the target cell. Then the target entry data corresponding to the target cell is obtained, and the target entry data is verified to ensure that the target entry data meets the data entry requirements of the table template to be entered, meet the user's customized needs, and improve the flexibility of data entry. When the target entry data is verified, an updated optional data set is obtained based on the target entry data and the preset optional data set, and the preset optional data set can be directly updated using the target entry data to obtain an updated optional data set, and then an updated table template is generated based on the updated optional data set and the table template to be entered, thereby improving the update efficiency of the table template.

[0064] In one embodiment, Figure 3As shown, in step 202, before displaying the form template to be entered, it also includes:

[0065] Step 302, in response to the form template creation instruction, display the initial form;

[0066] Step 304, in response to the selection operation of the initial parent cell in the initial table, obtaining the input data and data index corresponding to the initial parent cell, and obtaining the parent cell based on the input data and the initial parent cell;

[0067] Step 306: obtaining an optional data set of input data from a preset database based on the data index corresponding to the parent cell, and associating the optional data set with the parent cell;

[0068] Step 308, obtaining data verification information corresponding to the parent cell, and obtaining a table template to be entered based on the initial table, the parent cell, the optional data set corresponding to the parent cell, and the data verification information.

[0069] The initial table refers to a blank table without fixed format and data entry rules. The initial parent cell refers to the parent cell specified by the user without input data. The data index is the index used to find the optional data set.

[0070] Specifically, the terminal responds to the table template creation instruction and displays the initial table. Then, the terminal responds to the user's selection operation on the initial parent cell, the initial parent cell is in an input-enabled state, and the input data and data index input by the user to the initial parent cell are obtained. The terminal fills the input data into the initial parent cell to obtain the parent cell. The data index can be a data query address, such as the storage address of employee information of Department A.

[0071] The terminal generates a data acquisition request according to the input data and data index corresponding to the parent cell, and sends the data acquisition request to the preset database. The preset database obtains the data set to be queried according to the data index in the data acquisition request, and then searches for the target query data set in the data set to be queried according to the input data, and sends the target query data set to the terminal. For example, the data index is the storage address of the employee information of Department A, and the input data is "contact information". The preset database obtains the employee information of Department A according to the storage address of the employee information of Department A, including the name, work number, gender, telephone number and other information of the employees of Department A, and then the preset database obtains the target query data set according to the "contact information" as the telephone numbers of all employees of Department A. The terminal receives the target query data set returned by the preset database and encapsulates it as an optional data set, and then the terminal associates the optional data set with the parent cell.

[0072] Then the terminal obtains the data validation information set by the user for the parent cell, such as the value range, integer type, data length, etc. The terminal generates the table template information according to the initial table, the parent cell, the optional data set corresponding to the parent cell and the data validation information, and generates the table template to be entered according to the table template information. The terminal can also send the table template information to the server for storage.

[0073] In this embodiment, table template information is generated according to the initial table, parent cells, optional data sets corresponding to the parent cells, and data verification information, so that the terminal obtains the table template information to generate a table template to be entered. The optional data sets of each parent cell can be obtained from the table template information and displayed, avoiding frequent interaction between the terminal and the database to obtain the optional data sets of each parent cell, thereby saving data transmission resources.

[0074] In one embodiment, step 204, determining the target parent cell to which the target cell belongs based on the position of the target cell, includes:

[0075] The column coordinates corresponding to the target cell are obtained, and the parent cell in the same column is determined in the table template to be entered based on the column coordinates, and the parent cell in the same column is determined as the target parent cell to which the target cell belongs.

[0076] Specifically, when the terminal detects that the vertical coordinates of each parent cell in the table to be entered are the same, it means that the parent cells are arranged horizontally. The terminal obtains the column coordinates corresponding to the target cell, and determines the parent cells in the same column in the table template to be entered according to the column coordinates, and determines the parent cells in the same column as the target parent cells to which the target cell belongs.

[0077] The terminal can also detect that when the row coordinates of the parent cells in the table to be entered are the same, it means that the parent cells are arranged vertically. The terminal obtains the row coordinates corresponding to the target cell, determines the parent cell of the same row in the table template to be entered according to the horizontal coordinate, and determines the parent cell of the same row as the target parent cell to which the target cell belongs.

[0078] In this embodiment, the target parent cell is determined according to the position of the target cell so that the preset optional data set corresponding to the target parent cell is subsequently displayed, thereby improving the accuracy of data entry.

[0079] In one embodiment, step 206 displays each optional data in the preset optional data set at a preset position corresponding to the target cell, including:

[0080] When the data type corresponding to the target parent cell is an associated data type, the parent optional data set is obtained from the preset optional data set, and each parent optional data in the optional data set is displayed at the preset position corresponding to the target cell;

[0081] In response to a click operation on target upper-level optional data among the upper-level optional data, acquiring a to-be-selected lower-level optional data set associated with the target upper-level optional data from the preset optional data;

[0082] Each candidate lower-level optional data in the candidate lower-level optional data set is displayed at a preset position corresponding to the target upper-level optional data.

[0083] Among them, the associated data type refers to the data type of the associated data in the preset optional data set corresponding to the parent cell. The upper optional data refers to the optional data that is displayed first in the associated data. The lower optional data set refers to the optional data set that is associated with the upper optional data and displayed later. The lower optional data set to be selected refers to the optional data set that is associated with the target upper optional data and displayed later.

[0084] Specifically, the terminal detects that the data type corresponding to the target parent cell is an associated data type, such as an address data type, and obtains the upper optional data set from the preset optional data set, the upper optional data set, such as the identification set of each province name, and the terminal displays each upper optional data in the optional data set at the preset position corresponding to the target cell, such as the right edge position of the target cell. Then the terminal detects the user's click operation on the target optional data in each upper optional data, obtains the target upper optional data associated with the lower optional data set from the preset optional data, such as the identification set of each city name associated with a certain province name identification, and then the terminal displays each lower optional data to be selected in the lower optional data set to be selected at the preset position corresponding to the target upper optional data, such as the right edge data of the target upper optional data. The terminal can also detect the user's click operation on the target optional data in each upper optional data, hide each upper optional data, and directly display each lower optional data to be selected in the lower optional data set to be selected at the preset position corresponding to the target cell.

[0085] In this embodiment, by detecting that the data type corresponding to the target parent cell is an associated data type, upper-level optional data and associated lower-level optional data are displayed in sequence, thereby improving the accuracy of data entry.

[0086] In one embodiment, in step 210, after obtaining an updated table template corresponding to the table template to be entered based on the updated optional data set, and associating the target parent cell in the updated table template with the updated optional data set, the following further comprises:

[0087] Fill the target input data into the target cell in the update table template to obtain the update table corresponding to the update table template;

[0088] In response to the confirmation operation on the update form, the update form and the update form template are sent to the preset database, so that the preset database stores the update form template, extracts the update entry data in the update form, and updates the historical entry data in the preset database based on the update entry data.

[0089] Specifically, the terminal fills the target input data into the target cell in the update table template to obtain the update table corresponding to the update table template. In response to the confirmation operation on the update table, the terminal sends the update table and the update table template to the preset database. The preset database stores the update table template, and then parses the update table line by line to obtain the update input data in the update table, and the update input data refers to the input data of each cell in the update table. The preset database searches for the corresponding historical input data according to the table identifier of the update table, and updates the historical input data according to the update input data. For example, the table identifier of the update table is "A Department Employee Enrollment Information Table", and the information of the newly-employed employees is recorded line by line in the update table. The preset database parses the update input information of each row of cells in the update table line by line, for example, the name, work number, age and other information of employee A recorded in the nth row of the update table. The preset database searches for the historical input information as the employee information of Department A according to the table identifier, and adds the employee information of each employee in the update table to the employee information of Department A. The terminal may also generate an update record according to the target input data, and send the update form template and the update record to a preset database, which stores the update form template and updates the historical input data corresponding to the form identifier according to the update record.

[0090] In this embodiment, the update form and the update form template are sent to the preset database so that the preset database updates the historical input data and stores the update form template, thereby ensuring the consistency of the database and the terminal data.

[0091] In one embodiment, the table data processing method further includes:

[0092] When the target input data passes the verification, the target input data is filled into the template of the table to be input, and the updated input table corresponding to the table to be input is obtained;

[0093] In response to a confirmation operation on the update entry form, the update entry form is sent to a preset database, so that the preset database extracts the update entry data in the update entry form, updates the historical entry data in the preset database based on the update entry data, and updates the to-be-entered form template in the preset database based on the update entry data to obtain an update form template;

[0094] Receive template update notification sent by the preset database, and obtain updated table template from the preset database.

[0095] Specifically, when the terminal detects that the target input data has passed the verification, the target input data is filled into the template of the table to be input, and an updated input form corresponding to the table to be input is obtained. Then, in response to the confirmation operation on the updated input form, the terminal sends the updated input form to the preset database. The preset database parses the updated form line by line to obtain the updated input data in the updated form. The preset database searches for the corresponding historical input data according to the table identifier of the updated form, and updates the historical input data according to the updated input data.

[0096] The preset database obtains the table template to be entered, obtains the preset optional data set corresponding to each parent cell in the table template to be entered, and then the preset data can extract the update entry data of each cell corresponding to each parent unit in the update table. The preset database updates the preset optional data set corresponding to each parent cell according to the update entry data of each cell corresponding to each parent unit to obtain an updated optional data set, for example, adding the update entry data that does not exist in the preset optional data set to the corresponding preset optional data set, or replacing the corresponding historical optional data in the preset optional data set according to the update entry data. The preset database determines that the table template to be entered is an updated table template based on the updated optional data set, and generates a template update notification and sends it to the terminal. The terminal receives the template update notification sent by the preset database and downloads the updated table template from the preset database.

[0097] In this embodiment, the updated entry form is sent to a preset database, and the template of the entry form is updated through the preset database, thereby saving terminal template update resources.

[0098] In a specific embodiment, the table data processing method can be applied to the business information entry scenario of the banking system. The user terminal downloads the loan customer registration form template from the database, and the terminal detects that the user clicks the to-be-entered cell corresponding to the parent cell of the name identifier in the loan customer registration form template, obtains the registered customer name set corresponding to the parent cell of the name identifier, and the terminal displays the names of each registered customer in the registered customer name set at the right edge of the cell to be entered. The terminal detects that the user clicks the "custom input" option in the registered customer name set, and converts the cell to be entered from the restricted input state to the input state. The terminal obtains the name of the new customer entered by the user, adds the name of the new customer to the registered customer name set corresponding to the parent cell of the name identifier, obtains the updated registered customer name set corresponding to the parent cell of the name identifier, and fills the new customer's name into the cell to be entered.

[0099] Then the user clicks the cell to be entered corresponding to the parent cell of the gender identifier, obtains the parent cell of the gender identifier, and the terminal displays the gender identifiers "male" and "female" at the right edge of the cell to be entered. The terminal detects that the user clicks the option of the gender identifier "male" and fills the gender identifier "male" into the cell to be entered.

[0100] The terminal detects the user's confirmation operation on the data-filled loan customer registration form template, obtains the loan customer registration form, and obtains the loan customer registration form update template according to the updated optional data set of each parent cell in the loan customer registration form. Then the terminal sends the loan customer registration form and the loan customer registration form update template to the database, and the database stores the loan customer registration form update template so that other terminals can download the loan customer registration form update template from the database, and the database adds the loan information of the new customer in the loan customer registration form to the historical loan customer information.

[0101] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0102] Based on the same inventive concept, the embodiment of the present application also provides a table data processing device for implementing the table data processing method involved above. The implementation solution provided by the device to solve the problem is similar to the implementation solution recorded in the above method, so the specific limitations in one or more table data processing device embodiments provided below can refer to the limitations of the table data processing method above, and will not be repeated here.

[0103] In an exemplary embodiment, Figure 4 As shown, a table data processing device 400 is provided, comprising: a display module 402, a data acquisition module 404, a data display module 406, a data verification module 408 and an update module 410, wherein:

[0104] A display module 402 is used to display a form template to be entered;

[0105] The data acquisition module 404 is used to respond to a click operation on a target cell in the table template to be entered, determine a target parent cell to which the target cell belongs based on the position of the target cell, and acquire a preset optional data set associated with the target parent cell, wherein the target cell is in an input restriction state;

[0106] The data display module 406 is used to display each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, convert the target cell from an input restriction state to an input-enabled state;

[0107] The data verification module 408 is used to obtain the target input data based on the inputtable state of the target cell, and verify the target input data. When the target input data passes the verification, an updated optional data set is obtained based on the target input data and a preset optional data set;

[0108] The updating module 410 is used to obtain an updated table template corresponding to the table template to be entered based on the updated optional data set, and associate a target parent cell in the updated table template with the updated optional data set.

[0109] In one embodiment, the table data processing apparatus 400 further includes:

[0110] A template creation unit is used to display an initial table in response to a table template creation instruction; in response to a selection operation on an initial parent cell in the initial table, obtain input data and a data index corresponding to the initial parent cell, and obtain a parent cell based on the input data and the initial parent cell; obtain an optional data set of input data from a preset database based on the data index corresponding to the parent cell, and associate the optional data set with the parent cell; obtain data verification information corresponding to the parent cell, and obtain a table template to be entered based on the initial table, the parent cell, the optional data set corresponding to the parent cell, and the data verification information.

[0111] In one embodiment, the data acquisition module 404 includes:

[0112] The cell determination unit is used to obtain the column coordinates corresponding to the target cell, determine the parent cell in the same column in the table template to be entered based on the column coordinates, and determine the parent cell in the same column as the target parent cell to which the target cell belongs.

[0113] In one embodiment, the data display module 406 includes:

[0114] An associated display unit is used to obtain an upper-level optional data set from a preset optional data set when the data type corresponding to the target parent cell is an associated data type, and to display each upper-level optional data in the optional data set at a preset position corresponding to the target cell; in response to a click operation on a target upper-level optional data in each upper-level optional data, obtain a to-be-selected lower-level optional data set associated with the target upper-level optional data from the preset optional data; and display each to-be-selected lower-level optional data in the to-be-selected lower-level optional data set at a preset position corresponding to the target upper-level optional data.

[0115] In one embodiment, the table data processing apparatus 400 further includes:

[0116] A data update unit is used to fill the target input data into the target cell in the update table template to obtain an update table corresponding to the update table template; in response to a confirmation operation on the update table, the update table and the update table template are sent to a preset database so that the preset database stores the update table template, and the update input data in the update table is extracted, and the historical input data in the preset database is updated based on the update input data.

[0117] In one embodiment, the table data processing apparatus 400 further includes:

[0118] An update notification unit is used to fill the target entry data into the template of the table to be entered when the target entry data is verified, so as to obtain an updated entry form corresponding to the table to be entered; in response to a confirmation operation on the updated entry form, the updated entry form is sent to a preset database, so that the preset database extracts the updated entry data in the updated entry form, updates the historical entry data in the preset database based on the updated entry data, and updates the template of the table to be entered in the preset database based on the updated entry data to obtain an updated form template; receives a template update notification sent by the preset database, and obtains the updated form template from the preset database.

[0119] Each module in the above table data processing device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module.

[0120] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Figure 5As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. Among them, the processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data such as form templates to be entered. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a form data processing method is implemented.

[0121] In an exemplary embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Figure 6 As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a table data processing method is realized. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0122] Those skilled in the art will understand that Figure 5-6The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0123] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0124] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0125] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0126] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0127] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0128] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0129] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A table data processing method, characterized in that: The method comprises: Display the form template to be entered; In response to a click operation on a target cell in the table template to be entered, determining a target parent cell to which the target cell belongs based on a position of the target cell, and acquiring a preset optional data set associated with the target parent cell, wherein the target cell is in an input restriction state; Displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from the input restriction state to the input-enabled state; Acquire target input data based on the inputtable state of the target cell, and verify the target input data, and when the target input data passes the verification, obtain an updated optional data set based on the target input data and the preset optional data set; An updated table template corresponding to the table template to be entered is obtained based on the updated optional data set, and the target parent cell in the updated table template is associated with the updated optional data set.

2. The method according to claim 1, characterized in that Before displaying the form template to be entered, it also includes: In response to the form template creation instruction, display an initial form; In response to a selection operation on an initial parent cell in the initial table, obtaining input data and a data index corresponding to the initial parent cell, and obtaining a parent cell based on the input data and the initial parent cell; Acquire an optional data set of the input data from the preset database based on the data index corresponding to the parent cell, and associate the optional data set with the parent cell; The data verification information corresponding to the parent cell is obtained, and the table template to be entered is obtained based on the initial table, the parent cell, the optional data set corresponding to the parent cell, and the data verification information.

3. The method according to claim 1, characterized in that The step of determining the target parent cell to which the target cell belongs based on the position of the target cell includes: The column coordinates corresponding to the target cell are obtained, and the parent cell in the same column is determined in the table template to be entered based on the column coordinates, and the parent cell in the same column is determined as the target parent cell to which the target cell belongs.

4. The method according to claim 1, characterized in that: The step of displaying each optional data in the preset optional data set at a preset position corresponding to the target cell includes: When the data type corresponding to the target parent cell is an associated data type, obtaining a parent optional data set from the preset optional data set, and displaying each parent optional data in the optional data set at a preset position corresponding to the target cell; In response to a click operation on a target upper-level optional data among the respective upper-level optional data, acquiring a to-be-selected lower-level optional data set associated with the target upper-level optional data from the preset optional data; Each of the candidate lower-level optional data in the candidate lower-level optional data set is displayed at a preset position corresponding to the target upper-level optional data.

5. The method according to claim 1, characterized in that After obtaining the updated table template corresponding to the table template to be entered based on the updated optional data set, and associating the target parent cell in the updated table template with the updated optional data set, the method further includes: Fill the target input data into the target cell in the update table template to obtain an update table corresponding to the update table template; In response to a confirmation operation on the update form, the update form and the update form template are sent to the preset database, so that the preset database stores the update form template, extracts the update entry data in the update form, and updates the historical entry data in the preset database based on the update entry data.

6. The method according to claim 1, characterized in that The method further comprises: When the target input data passes the verification, the target input data is filled into the to-be-entered form template to obtain an updated input form corresponding to the to-be-entered form; In response to a confirmation operation on the update entry form, the update entry form is sent to the preset database, so that the preset database extracts the update entry data in the update entry form, updates the historical entry data in the preset database based on the update entry data, and updates the to-be-entered form template in the preset database based on the update entry data, thereby obtaining the update form template; Receive a template update notification sent by the preset database, and obtain the updated form template from the preset database.

7. A table data processing device, characterized in that: The device comprises: Display module, used to display the form template to be entered; a data acquisition module, for responding to a click operation on a target cell in the table template to be entered, determining a target parent cell to which the target cell belongs based on the position of the target cell, and acquiring a preset optional data set associated with the target parent cell, wherein the target cell is in an input restriction state; A data display module, used for displaying each optional data in the preset optional data set at a preset position corresponding to the target cell, and in response to a click operation on the target optional data corresponding to the restriction release mark in each optional data, converting the target cell from the input restriction state to the input-enabled state; A data verification module, used for obtaining target input data based on the inputtable state of the target cell, and verifying the target input data, and when the target input data passes the verification, obtaining an updated optional data set based on the target input data and the preset optional data set; An updating module is used to obtain an updated table template corresponding to the table template to be entered based on the updated optional data set, wherein the target parent cell in the updated table template is associated with the updated optional data set.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images