Table data filling method, device, electronic device and storage medium

Abstract

The present disclosure relates to a table data filling method, device, electronic device, and storage medium, the method including: determining a copy target area in a first table in response to a copy operation on a first table; determining paste cells in a second table each corresponding to each copy cell in the copy target area, wherein the copy cell and the corresponding paste cell have at least one associated target parameter; and filling cell data in each copy cell into the corresponding paste cell.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS

[0001] This disclosure claims the full benefit of Chinese Patent Application No. 202310084583.X, entitled "Table Data Filling Method, Apparatus, Electronic Device and Storage Medium," filed with the State Intellectual Property Office of the People's Republic of China on January 16, 2023, the entire contents of which are incorporated herein by reference. [Technical Field]

[0002] The present disclosure relates to the field of computers, and more particularly to a table data filling method, apparatus, electronic device, and storage medium. [Background technology]

[0003] In daily work, various data often exist in different tables, not all in one table, and when you need to transfer data between two tables, you can only manually search the two tables and repeatedly perform copy and paste operations.

[0004] For example, the participant's name is registered in the application form, but some personal information (e.g., mobile phone number, gender, age, etc.) needs to be copied and pasted from a list that records complete personal information into the application form. In this case, the only way to do this is to manually select one participant's name from the application form, search for information corresponding to that participant's name from the list, copy and paste this information into the application form, and then continue searching for information corresponding to the next participant's name from the list, and repeat the above-mentioned operations.

[0005] This not only reduces the efficiency of data migration, but also makes it more likely that data errors will occur due to human error. Summary of the Invention

[0006] In a first aspect, the present disclosure provides a table data filling method, the method comprising: determining a copy target area in the first table in response to a copy operation on the first table; determining a paste cell corresponding to each copy cell in the copy target region in a second table, the copy cell and the corresponding paste cell having at least one associated target parameter; and filling the cell data in each copy cell into a corresponding paste cell.

[0007] In some embodiments, determining a paste cell in the second table corresponding to each copy cell in the region to be copied comprises: The method includes determining, by text recognition, paste cells in the second table that correspond to each copy cell in the region to be copied.

[0008] In some embodiments, determining the region to be copied in the first table comprises: The method includes determining an area consisting of each column related to a first cell area as an area to be copied, wherein the first cell area is a cell area corresponding to the copy operation.

[0009] In some embodiments, determining a paste cell in the second table corresponding to each copy cell in the region to be copied comprises: determining a paste target area in a second table, the paste target area including at least one column in the second table; determining a condition string in the second table and a search area in the first table; determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area based on the condition string and the search area.

[0010] In some embodiments, determining paste cells in the paste target area that correspond to each copy cell in the copy target area based on the condition string and the search area includes: Each line related to the paste target area is determined as a processing target line, and for each processing target line: determining cell data in the processing target row in the condition column as condition data; determining the condition data in the search area, and determining a row in which the condition data is present as a target row; determining an area consisting of copy cells in the target row in the copy target area as a sub-copy target area corresponding to the processing target row; For each copy cell in the sub-copy target area, determining a paste target cell from the processing target row that satisfies a set condition, the set condition indicating that the paste cell and the copy cell have the same relative position, the relative position representing the position of the paste cell in the processing target row or the position of the copy cell in the sub-copy target area; determining the paste target cell as a paste cell corresponding to the copy cell; Includes.

[0011] In some embodiments, determining the area to paste in the second table comprises: When the number of rows and the number of columns of the second cell area and the first cell area are the same, the area consisting of a certain column of the second cell area is determined as the area to be pasted, and the second cell area is an area corresponding to the paste operation on the second table.

[0012] In some embodiments, determining the area to paste in the second table comprises: For each column of the first cell region: determining column headings for said columns; When it is determined that a target column heading exists in the row headings of the second table that matches the column heading, an area consisting of a column corresponding to the target column heading is determined as a paste target area; Includes.

[0013] In some embodiments, determining a condition string in the second table and determining a search area in the first table comprises: If the first cell area and the second cell area each relate to only one row, determining a first cell data set corresponding to the row in which the first cell area is located and determining a second cell data set corresponding to the row in which the second cell area is located, the second cell area being an area corresponding to a paste operation on the second table; determining the same items between the first cell data set and the second cell data set, determining a column in the second table where the same items are located as a condition column, and determining a column in the first table where the same items are located as a search area; Includes.

[0014] In some embodiments, determining a condition string in the second table and determining a search area in the first table comprises: When the first cell area and the second cell area are both involved in N rows, where N is a natural number greater than 1, for each row involved in the first cell area: determining a third cell data set corresponding to said row; determining a row in the second cell region corresponding to the row; and determining a fourth cell data set corresponding to the corresponding row; determining the same itemsets in the third cell data set and the fourth cell data set; determining the same items of the same itemset corresponding to each row of the first cell area, determining the column in the second table in which the same items are located as a condition column, and determining the column in the first table in which the same items are located as a search area; wherein the second cell area is an area corresponding to a paste operation on the second table; Includes.

[0015] In some embodiments, determining the region to be copied in the first table comprises: determining a first set of column headings corresponding to the first table and a second set of column headings corresponding to a second table; determining associated column headings in the first set of column headings and the second set of column headings; determining a region of cells corresponding to the associated column header in a row related to the first cell region as a region to be copied, wherein the first cell region is a cell region corresponding to the copy operation; Includes.

[0016] In some embodiments, determining a paste cell in the second table corresponding to each copy cell in the region to be copied comprises: determining a paste target area in the second table, the paste target area including at least two cells in the same row in the second table; For each copy cell in the copy target area, determining a paste target cell from the paste target region that satisfies a set condition, the set condition corresponding to a column header to which the paste cell and the copy cell are associated; determining the paste target cell as a paste cell corresponding to the copy cell; Includes.

[0017] In some embodiments, determining the area to paste in the second table comprises: determining a region of cells corresponding to the associated column header in a row of a second cell region as a paste target region, wherein the second cell region is a region corresponding to a paste operation on the second table; Includes.

[0018] In some embodiments, filling the cell data in each of the copy cells into the corresponding paste cells includes: For each paste cell: creating a data fill formula based on the corresponding copied cells; Filling the paste cell with the data fill formula, the data fill expression indicates that cell data in the corresponding copy cell is to be displayed in the paste cell; Includes.

[0019] In a second aspect, the present disclosure provides a table data filling apparatus, the apparatus comprising: a copy area determination module configured to determine an area to be copied in the first table in response to a copy operation on the first table; a paste cell determination module configured to determine a paste cell corresponding to each copy cell in the copy target region in Table 2, wherein the copy cell and the corresponding paste cell have at least one associated target parameter; a data fill module configured to fill cell data in each copy cell into a corresponding paste cell, respectively; Includes.

[0020] In some embodiments, the paste cell determination module: The text recognition is configured to determine paste cells in the second table that correspond to each copy cell in the copy target area.

[0021] In some embodiments, the copy region determination module: The method is configured to determine an area consisting of each column related to a first cell area as a copy target area, and the first cell area is a cell area corresponding to the copy operation.

[0022] In some embodiments, the paste cell determination module: a paste area determination unit configured to determine a paste target area in a second table, the paste area determination unit comprising at least one column in the second table; a condition determination unit configured to determine a condition string in the second table and to determine a search area in the first table; a cell determination unit configured to determine, in the paste target area, paste cells corresponding to each copy cell in the copy target area, based on the condition string and the search area.

[0023] In some embodiments, the cell determination unit: a condition data determination subunit configured to execute a process of determining each row related to the paste target area as one processing target row, and determining, for each processing target row, cell data in the processing target row in the condition column as condition data; a target row determination subunit configured to determine the condition data in the search area and determine a row in which the condition data is located as a target row; a sub-copy target area determination subunit configured to determine an area consisting of copy cells in the target row in the copy target area as a sub-copy target area corresponding to the processing target row; For each copy cell in the sub-copy target area, determining a paste target cell from the processing target row that satisfies a set condition, the set condition indicating that the paste cell and the copy cell have the same relative position, the relative position representing the position of the paste cell in the processing target row or the position of the copy cell in the sub-copy target area; and a paste target cell determination subunit configured to perform the process of determining the paste target cell as a paste cell corresponding to the copy cell.

[0024] In some embodiments, the paste area determination unit comprises: When the number of rows and columns of the second cell area and the first cell area are the same, the area consisting of a certain column of the second cell area is determined as the paste target area, and the second cell area is the area corresponding to the paste operation on the second table.

[0025] In some embodiments, the paste area determination unit comprises: For each column of the first cell region: determining column headings for said columns; When it is determined that a target column heading that matches the column heading exists in the row headings of the second table, an area consisting of the column corresponding to the target column heading is determined as a paste target area.

[0026] In some embodiments, the condition data determination subunit comprises: When the first cell area and the second cell area each relate to only one row, the first cell area is configured to determine a first cell data set corresponding to a row, and the second cell area is configured to determine a second cell data set corresponding to a row, and the second cell area is configured to be an area corresponding to a paste operation for the second table; The method is configured to determine the same items in the first cell data set and the second cell data set, determine the column in the second table where the same items are located as a condition column, and determine the column in the first table where the same items are located as a search area.

[0027] In some embodiments, the condition data determination subunit comprises: When the first cell area and the second cell area are both involved in N rows, where N is a natural number greater than 1, for each row involved in the first cell area: determining a third cell data set corresponding to said row; determining a row in the second cell region corresponding to the row; and determining a fourth cell data set corresponding to the corresponding row; determining the same itemsets in the third cell data set and the fourth cell data set; determining the same items of the same itemset corresponding to each row of the first cell area, determining the column in the second table in which the same items are located as a condition column, and determining the column in the first table in which the same items are located as a search area; The second cell area is an area corresponding to a paste operation on the second table.

[0028] In some embodiments, the copy region determination module: determining a first set of column headings corresponding to said first table and a second set of column headings corresponding to said second table; determining associated column headings in the first set of column headings and the second set of column headings; The method is configured to determine, as a copy target area, an area consisting of cells corresponding to the associated column header in a row related to the first cell area, and the first cell area is a cell area corresponding to the copy operation.

[0029] In some embodiments, the paste cell determination module comprises: a paste area determination unit configured to determine a paste target area in the second table, the paste target area including at least two cells in the same row in the second table; For each copy cell in the copy target area, determining a paste target cell from the paste target region that satisfies a set condition, the set condition corresponding to a column header to which the paste cell and the copy cell are associated; determining the paste target cell as a paste cell corresponding to the copy cell; a paste area determination unit.

[0030] In some embodiments, the paste area determination unit comprises: The method is configured to determine, as a paste target area, an area consisting of cells corresponding to the associated column header in a row related to the second cell area, and the second cell area is an area corresponding to a paste operation for the second table.

[0031] In some embodiments, the data fill module: For each paste cell: creating a data fill formula based on the corresponding copied cells; Filling the paste cell with the data fill formula, The data fill expression indicates that the cell data in the corresponding copy cell is to be displayed in the paste cell.

[0032] In a third aspect, the present disclosure provides a method for manufacturing a semiconductor device comprising: a processor and a memory, The processor executes a table data filling program stored in the memory to implement the table data filling method described in the present disclosure, thereby providing an electronic device.

[0033] In a fourth aspect, the present disclosure provides a method for manufacturing a semiconductor device comprising: A storage medium is provided having one or more programs stored thereon that, when executed by one or more processors, implement the table data filling method described in this disclosure.

[0034] In some embodiments, in response to a copy operation on the first table, a copy target area is determined in the first table, paste cells corresponding to each copy cell in the copy target area are determined in the second table, and the cell data in each copy cell is filled into the corresponding paste cell, thereby determining multiple pairs of corresponding copy cells and paste cells in the source table containing the data to be copied and the filled table, and further enabling copying and pasting of multiple pieces of data between the source table and the filled table, thereby improving the efficiency of data migration between the two tables. In the prior art, copying and pasting multiple pieces of data between two tables relies entirely on repeated manual copy and paste operations, which results in low data migration efficiency. This solves the technical problem and effectively reduces operational errors associated with repeated manual work. [Brief explanation of the drawings]

[0035] [Figure 1] 1 is a flowchart of an example of a table data filling method according to an embodiment of the present disclosure. [Figure 2] FIG. 1 is a schematic diagram of an application scenario according to an embodiment of the present disclosure. [Figure 3] FIG. 10 is a schematic diagram of another application scenario according to an embodiment of the present disclosure. [Figure 4] FIG. 10 is a schematic diagram of yet another application scenario according to an embodiment of the present disclosure. [Figure 5] 10 is a flowchart of another example of a method for filling table data in accordance with an embodiment of the present disclosure. [Figure 6] 10 is a flowchart of yet another example method for filling table data in accordance with an embodiment of the present disclosure. [Figure 7] 10 is a flowchart of yet another example method for filling table data in accordance with an embodiment of the present disclosure. [Figure 8] 10 is a flowchart of yet another example method for filling table data in accordance with an embodiment of the present disclosure. [Figure 9]FIG. 2 is a block diagram of an embodiment of a table data filling device according to an embodiment of the present disclosure. [Figure 10] 1 is a structural schematic diagram of an electronic device according to an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE INVENTION

[0036] In order to clarify the objectives, technical solutions and advantages of the embodiments of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described with reference to the accompanying drawings in the embodiments of the present disclosure, and it should be understood that the described embodiments are not all the embodiments but are a part of the embodiments of the present disclosure. Based on the embodiments of the present disclosure, all other embodiments that a person skilled in the art can make without creative ingenuity belong to the scope of the present disclosure.

[0037] The table data filling method according to the present disclosure will be further described below with reference to the drawings and specific examples, which should not be construed as limiting the present invention.

[0038] 1 is a flowchart of an embodiment of a table data filling method according to an embodiment of the present disclosure. As shown in FIG. 1, in response to a copy operation on the first table, step 101 determines a copy target area in the first table; Step 102: determining a paste cell corresponding to each copy cell in the copy target area in Table 2; and step 103 of filling the cell data in each copy cell into the corresponding paste cell.

[0039] The first table above refers to a table containing source data, and may be a sheet or an area in a sheet, and is not specifically limited here.

[0040] The copy operation on Table 1 may be a copy operation on one or more selected cells in Table 1. When there are multiple selected cells, the multiple selected cells may be cells in the same row (including when an entire row is selected), cells in the same column (including when an entire column is selected), or cells spanning multiple rows and columns, and are not specifically limited here.

[0041] In some embodiments, the user can control the mouse to select one or more cells in Table 1. In some embodiments, the user first controls the mouse to select a cell, and then holds down the left mouse button and drags the mouse, causing any cells the cursor passes over to become selected cells until the user releases the left mouse button.

[0042] In some embodiments, a user can select one or more cells in Table 1 by specifying a row / column number, which includes a row number and a column number. In some embodiments, if the row / column number specified by the user is A5, the cell in column A, row 5 is determined as the selected cell. In some embodiments, if the row / column number specified by the user is A5:B6, the four cells in column A, row 5, column A, row 6, column B, row 5, and column B, row 6 are determined as the selected cells.

[0043] The copy target area is made up of a plurality of cells in Table 1. In this way, the technical means according to the embodiment of the present disclosure can achieve copying and pasting of cell data in a single operation.

[0044] In some embodiments, when a copy operation on Table 1 is detected, a copy target area is determined in Table 1. Typically, the copy target area may include other cells in addition to the selected cells, i.e., the cell area corresponding to the copy operation (hereinafter, for convenience of explanation, referred to as the first cell area).

[0045] In some embodiments, the area to be copied includes an area consisting of each column involved in the first cell area, i.e., an implementation of determining the area to be copied in the first table may include determining an area consisting of each column involved in the first cell area as the area to be copied.

[0046] For ease of understanding, in the following description of step 102, a specific example of this embodiment will be given in combination with the second table to be filled, but will not be described in detail here.

[0047] In some embodiments, the region to be copied includes the first cell region and a region of cells in a row related to the first cell region that satisfy a certain condition.

[0048] For ease of understanding, in the following description of step 102, a specific example of this embodiment will be given in combination with the second table to be filled, but will not be described in detail here.

[0049] In this way, the technical means of the embodiments of the present disclosure, unlike the conventional technology in which the copy area is entirely dependent on the user's selection operation, realizes automatic expansion of the copy area, thereby enabling auto-filling into tables and reducing user operations.

[0050] In some embodiments, whether to expand the copy area is selected based on a user operation. For example, a notification message indicating the expansion of the copy area is output via a user interface (e.g., a pop-up notification message). If the user responds to the notification message by triggering an instruction operation to allow the expansion of the copy area, the copy area is expanded. Conversely, if the user responds to the notification message by triggering an instruction operation to reject the expansion of the copy area, the copy area is not expanded, and only the cell area selected by the user through the copy operation is determined as the copy area. This process can avoid a situation contrary to the user's intention, i.e., a situation in which the user unnecessarily copies and pastes other cell areas even though he or she only wants to copy and paste the selected cell area.

[0051] The second table refers to the table to be filled, and may be a sheet or a region on a sheet, and is not specifically limited thereto. In some embodiments, the first table and the second table may be on different sheets, different regions on the same sheet, or regions on different sheets, and is not specifically limited thereto.

[0052] In some embodiments, a user may perform a copy operation on a first table, and then continue to perform a paste operation on another table, determining the table corresponding to the paste operation as the second table.

[0053] The paste operation may be a paste operation on one or more selected cells in Table 2. When there are multiple selected cells, the multiple selected cells may be cells in the same row (including when an entire row is selected), cells in the same column (including when an entire column is selected), or cells spanning multiple rows and columns, and are not specifically limited here.

[0054] The paste cell refers to a cell to be filled in Table 2, and here, it is not specifically limited whether the paste cell is empty or not. In other words, even if the paste cell originally contains cell data, the technical means according to the embodiment of the present disclosure can be applied to replace (or overwrite) the cell data originally in the paste cell.

[0055] In some embodiments, the paste cell may include a cell corresponding to the paste operation, or may not include a cell corresponding to the paste operation, and this is not specifically limited. In this way, when the paste cell does not include a cell corresponding to the paste operation, by applying the technical means according to the embodiments of the present disclosure, the paste cell can be automatically determined from the second table without relying on user operation, thereby reducing the requirement for user operation and improving the user experience.

[0056] In addition, in the embodiment of the present disclosure, the area consisting of all paste cells is called a paste target area.

[0057] In some embodiments, the paste target area can be determined in Table 2 first, and then the paste cells corresponding to each copy cell in the copy target area can be determined in the paste target area. In this way, the paste cells in the paste target area and the copy cells in the copy target area correspond one-to-one.

[0058] In any of the above embodiments, the copy cell and the corresponding paste cell have at least one associated target parameter.

[0059] Here, the target parameter may represent a specific meaning corresponding to the data filled in the cell, and may be expressed by a row header and / or a column header corresponding to the cell. That is, the target parameter may include a row header and / or a column header. For example, the table data "13800000000" shown in FIG. 2 represents the mobile phone number of Zhang San. Since the copy cell and the corresponding paste cell have at least one associated target parameter, the data filled in the copy cell and the corresponding paste cell are associated with each other.

[0060] In some embodiments, the target parameters may be displayed in a table, such as specific column or row headings included in the tabular data shown in FIG.

[0061] In some embodiments, the target parameters may not be displayed (or hidden) in the table. In this case, a hidden column heading for a column may be automatically determined based on data filled in the column, or a hidden row heading for a row may be automatically determined based on data filled in the row. In this embodiment, as one selectable implementation form, a hidden column heading for a column containing data or a hidden row heading for a row containing data may be intelligently identified based on parameters such as the data type, data format, data rules, and data semantics of the data. For example, based on the data "13800000000," the hidden column heading for a column containing data or the hidden row heading for a row containing data may be identified as "mobile phone number," and based on the data "2023-11-12," the hidden column heading for a column containing data or the hidden row heading for a row containing data may be identified as "date."

[0062] In some embodiments, the associations refer to the same thing.

[0063] In some embodiments, the relatedness refers to semantic similarity. For example, two column or row headings, "Mobile Phone Number" and "Phone," may be considered related because they are similar in meaning but written differently.

[0064] In some embodiments, if the area to be copied includes an area consisting of each column of the first cell area, the area to be pasted may include at least one column in the second table. If the area to be copied includes the first cell area and an area consisting of cells that satisfy a certain condition in a row of the first cell area, the area to be pasted may include at least two cells in the same row of the second table.

[0065] In some embodiments, if the area to be copied includes an area consisting of rows related to the first cell area, the area to be pasted may include at least one row in the second table. If the area to be copied includes the first cell area and an area consisting of cells in a column related to the first cell area that satisfy a certain condition, the area to be pasted may include at least two cells in the same column in the second table.

[0066] 2 is a schematic diagram of an application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 2, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cell in column D, row 3 in Table 1 and performs a copy operation on the cell, and also selects the cell in column C, row 2 in Table 2 and performs a paste operation on the cell.

[0067] Then, in the above application scenario, by applying the technical means related to the embodiments of the present disclosure, the area consisting of the cells in column D in Table 2 is determined as the copy target area, and the area consisting of the cells in column C in Table 1 is determined as the paste target area, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0068] In some embodiments, the cell in column C, row 3 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 5 in Table 2, and the cell data in the copy cell in column D, row 5 in Table 2 is filled into the paste cell in column C, row 3 in Table 1.

[0069] In some embodiments, the cell in column C, row 4 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 4 in Table 2, and the cell data in the copy cell in column D, row 4 in Table 2 is filled into the paste cell in column C, row 4 in Table 1.

[0070] By analogy, the user can simply copy the mobile phone numbers in Table 2 into Table 1, thereby achieving accurate correspondence between mobile phone numbers and users. This significantly reduces the number of user operations compared to the prior art.

[0071] Specifically, a method for determining the copy target area in Table 1 and the paste target area in Table 2 will be described below using a specific example, but will not be described in detail here.

[0072] 3 is a schematic diagram of another application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 3, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cells in column B, row 2, column C, row 3, column B, and row 3 in Table 1 and performs a copy operation on these cells, and also selects the cells in column B, row 2, column C, row 2, column B, and row 3, column C, in Table 2 and performs a paste operation on these cells.

[0073] Then, in the above application scenario, by applying the technical means related to the embodiments of the present disclosure, the area consisting of cells in columns B and C in Table 2 is determined as the copy target area, and the area consisting of cells in columns B and C in Table 1 is determined as the paste target area, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0074] In some embodiments, the cell in column B, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column B, row 2 in Table 2, and the cell data in the copy cell in column B, row 2 in Table 2 is filled into the paste cell in column B, row 2 in Table 1.

[0075] In some embodiments, the cell in column C, row 3 in Table 1 is determined as the paste cell corresponding to the copy cell in column C, row 3 in Table 2, and the cell data in the copy cell in column C, row 3 in Table 2 is filled into the paste cell in column C, row 3 in Table 1.

[0076] By analogy, the user can simply copy the phone number and gender in Table 2 once to Table 1, thereby achieving accurate correspondence between the phone number, gender, and user. This significantly reduces the user's operations compared to the prior art.

[0077] Specifically, a method for determining the copy target area in Table 1 and the paste target area in Table 2 will be described below using a specific example, but will not be described in detail here.

[0078] 4 is a schematic diagram of another application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 4, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cell in column D, row 2 in Table 1 and performs a copy operation on the cell, and also assumes that a user selects the cell in column B, row 2 in Table 2 and performs a paste operation on the cell.

[0079] Then, in the above application scenario, by applying the technical means related to the embodiment of the present disclosure, the area consisting of the cell in the second row of column B, the cell in the second row of column D, and the cell in the second row of column E in Table 2 is determined as the area to be copied, and the area consisting of the cell in the second row of column B, the cell in the second row of column C, and the cell in the second row of column F in Table 1 is determined as the area to be pasted, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0080] In some embodiments, the cell in column B, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 2 in Table 2, and the cell data in the copy cell in column D, row 2 in Table 2 is filled into the paste cell in column B, row 2 in Table 1.

[0081] In some embodiments, the cell in column D, row 2 of Table 1 is determined as the paste cell corresponding to the copy cell in column E, row 2 of Table 2, and the cell data in the copy cell in column E, row 2 of Table 2 is filled into the paste cell in column D, row 2 of Table 1.

[0082] In some embodiments, the cell in column C, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column B, row 2 in Table 2, and the cell data in the copy cell in column B, row 2 in Table 2 is filled into the paste cell in column C, row 2 in Table 1.

[0083] This allows the user to fill Zhang San's age, mobile phone number, and email address in Table 2 into Table 1 with just one copy operation, significantly reducing the number of user operations compared to conventional technology.

[0084] Specifically, the method of determining the copy target area in Table 1 and the paste target area in Table 2 will be described below with different examples, but will not be described in detail here.

[0085] According to the technical means of the embodiment of the present disclosure, in response to a copy operation on the first table, a copy target area is determined in the first table, paste cells corresponding to each copy cell in the copy target area are determined in the second table, and the cell data in each copy cell is filled into the corresponding paste cell, thereby determining multiple pairs of corresponding copy cells and paste cells in the source table containing the data to be copied and the filled table, and further, copying and pasting multiple pieces of data between the source table and the filled table is possible, thereby improving the efficiency of data migration between the two tables. In the prior art, copying and pasting multiple pieces of data between two tables relies entirely on repeated manual copy and paste operations, which results in low data migration efficiency. This solves the technical problem and effectively reduces operational errors associated with repeated manual operations.

[0086] 5 is a flowchart of another example of a table data filling method according to an embodiment of the present disclosure. As shown in FIG. 5, the method includes: determining a copy target area in the first table in response to a copy operation on the first table in step 501; Step 502: determining, by text recognition, paste cells in the second table corresponding to each copy cell in the copy target area; Step 503 of filling the cell data in each copy cell into the corresponding paste cell.

[0087] The first table above refers to a table containing source data, and may be a sheet or an area in a sheet, and is not specifically limited here.

[0088] The copy operation on Table 1 may be a copy operation on one or more selected cells in Table 1. When there are multiple selected cells, the multiple selected cells may be cells in the same row (including when an entire row is selected), cells in the same column (including when an entire column is selected), or cells spanning multiple rows and columns, and are not specifically limited here.

[0089] In some embodiments, the user can control the mouse to select one or more cells in Table 1. In some embodiments, the user first controls the mouse to select a cell, and then holds down the left mouse button and drags the mouse, causing any cells the cursor passes over to become selected cells until the user releases the left mouse button.

[0090] In some embodiments, a user can select one or more cells in Table 1 by specifying a row / column number, which includes a row number and a column number. In some embodiments, if the row / column number specified by the user is A5, the cell in column A, row 5 is determined as the selected cell. In some embodiments, if the row / column number specified by the user is A5:B6, the four cells in column A, row 5, column A, row 6, column B, row 5, and column B, row 6 are determined as the selected cells.

[0091] The copy target area is made up of a plurality of cells in Table 1. In this way, the technical means according to the embodiment of the present disclosure can achieve copying and pasting of cell data in a single operation.

[0092] In some embodiments, when a copy operation on Table 1 is detected, a copy target area is determined in Table 1. Typically, the copy target area may include other cells in addition to the selected cells, i.e., the cell area corresponding to the copy operation (hereinafter, for convenience of explanation, referred to as the first cell area).

[0093] In some embodiments, the area to be copied includes an area consisting of each column involved in the first cell area, i.e., an implementation of determining the area to be copied in the first table may include determining an area consisting of each column involved in the first cell area as the area to be copied.

[0094] For ease of understanding, in the following description of step 102, a specific example of this embodiment will be given in combination with the second table to be filled, but will not be described in detail here.

[0095] In some embodiments, the region to be copied includes the first cell region and a region of cells in a row related to the first cell region that satisfy a certain condition.

[0096] For ease of understanding, in the following description of step 102, a specific example of this embodiment will be given in combination with the second table to be filled, but will not be described in detail here.

[0097] In this way, the technical means of the embodiments of the present disclosure, unlike the conventional technology in which the copy area is entirely dependent on the user's selection operation, realizes automatic expansion of the copy area, thereby enabling auto-filling into tables and reducing user operations.

[0098] In some embodiments, whether to expand the copy area is selected based on a user operation. For example, a notification message indicating the expansion of the copy area is output via a user interface (e.g., a pop-up notification message). If the user responds to the notification message by triggering an instruction operation to allow the expansion of the copy area, the copy area is expanded. Conversely, if the user responds to the notification message by triggering an instruction operation to reject the expansion of the copy area, the copy area is not expanded, and only the cell area selected by the user through the copy operation is determined as the copy area. This process can avoid a situation contrary to the user's intention, i.e., a situation in which the user unnecessarily copies and pastes other cell areas even though he or she only wants to copy and paste the selected cell area.

[0099] The second table refers to the table to be filled, and may be a sheet or a region on a sheet, and is not specifically limited thereto. In some embodiments, the first table and the second table may be on different sheets, different regions on the same sheet, or regions on different sheets, and is not specifically limited thereto.

[0100] In some embodiments, a user may perform a copy operation on a first table, and then continue to perform a paste operation on another table, determining the table corresponding to the paste operation as the second table.

[0101] The paste operation may be a paste operation on one or more selected cells in Table 2. When there are multiple selected cells, the multiple selected cells may be cells in the same row (including when an entire row is selected), cells in the same column (including when an entire column is selected), or cells spanning multiple rows and columns, and are not specifically limited here.

[0102] The paste cell refers to a cell to be filled in Table 2, and here, it is not specifically limited whether the paste cell is empty or not. In other words, even if the paste cell originally contains cell data, the technical means according to the embodiment of the present disclosure can be applied to replace (or overwrite) the cell data originally in the paste cell.

[0103] In some embodiments, the paste cell may include a cell corresponding to the paste operation, or may not include a cell corresponding to the paste operation, and this is not specifically limited. In this way, when the paste cell does not include a cell corresponding to the paste operation, by applying the technical means according to the embodiments of the present disclosure, the paste cell can be automatically determined from the second table without relying on user operation, thereby reducing the requirement for user operation and improving the user experience.

[0104] In addition, in the embodiment of the present disclosure, the area consisting of all paste cells is called a paste target area.

[0105] In some embodiments, the paste target area can be determined in Table 2 first, and then the paste cells corresponding to each copy cell in the copy target area can be determined in the paste target area. In this way, the paste cells in the paste target area and the copy cells in the copy target area correspond one-to-one.

[0106] The step of determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area through text recognition refers to performing text recognition on the column headers and / or row headers in the copy target area and the second table, recognizing specific text content and semantics, and determining the correspondence between the copy cells and the paste cells based on the recognized text content and semantics. Specifically, a method of determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area through text recognition will be described below with reference to specific examples shown in Figures 6 and 7, but will not be described in detail here.

[0107] In some embodiments, if the area to be copied includes an area consisting of each column of the first cell area, the area to be pasted may include at least one column in the second table. If the area to be copied includes the first cell area and an area consisting of cells that satisfy a certain condition in a row of the first cell area, the area to be pasted may include at least two cells in the same row of the second table.

[0108] In some embodiments, if the area to be copied includes an area consisting of rows related to the first cell area, the area to be pasted may include at least one row in the second table. If the area to be copied includes the first cell area and an area consisting of cells in a column related to the first cell area that satisfy a certain condition, the area to be pasted may include at least two cells in the same column in the second table.

[0109] 2 is a schematic diagram of an application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 2, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cell in column D, row 3 in Table 1 and performs a copy operation on the cell, and also selects the cell in column C, row 2 in Table 2 and performs a paste operation on the cell.

[0110] Then, in the above application scenario, by applying the technical means related to the embodiments of the present disclosure, the area consisting of the cells in column D in Table 2 is determined as the copy target area, and the area consisting of the cells in column C in Table 1 is determined as the paste target area, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0111] In some embodiments, the cell in column C, row 3 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 5 in Table 2, and the cell data in the copy cell in column D, row 5 in Table 2 is filled into the paste cell in column C, row 3 in Table 1.

[0112] In some embodiments, the cell in column C, row 4 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 4 in Table 2, and the cell data in the copy cell in column D, row 4 in Table 2 is filled into the paste cell in column C, row 4 in Table 1.

[0113] By analogy, the user can simply copy the mobile phone numbers in Table 2 into Table 1, thereby achieving accurate correspondence between mobile phone numbers and users. This significantly reduces the number of user operations compared to the prior art.

[0114] Specifically, a method for determining the copy target area in Table 1 and the paste target area in Table 2 will be described below using a specific example, but will not be described in detail here.

[0115] 3 is a schematic diagram of another application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 3, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cells in column B, row 2, column C, row 3, column B, and row 3 in Table 1 and performs a copy operation on these cells, and also selects the cells in column B, row 2, column C, row 2, column B, and row 3, column C, in Table 2 and performs a paste operation on these cells.

[0116] Then, in the above application scenario, by applying the technical means related to the embodiments of the present disclosure, the area consisting of cells in columns B and C in Table 2 is determined as the copy target area, and the area consisting of cells in columns B and C in Table 1 is determined as the paste target area, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0117] In some embodiments, the cell in column B, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column B, row 2 in Table 2, and the cell data in the copy cell in column B, row 2 in Table 2 is filled into the paste cell in column B, row 2 in Table 1.

[0118] In some embodiments, the cell in column C, row 3 in Table 1 is determined as the paste cell corresponding to the copy cell in column C, row 3 in Table 2, and the cell data in the copy cell in column C, row 3 in Table 2 is filled into the paste cell in column C, row 3 in Table 1.

[0119] By analogy, the user can simply copy the phone number and gender in Table 2 once to Table 1, thereby achieving accurate correspondence between the phone number, gender, and user. This significantly reduces the user's operations compared to the prior art.

[0120] Specifically, a method for determining the copy target area in Table 1 and the paste target area in Table 2 will be described below using a specific example, but will not be described in detail here.

[0121] 4 is a schematic diagram of another application scenario according to an embodiment of the present disclosure. In the application scenario shown in FIG. 4, Table 1 is Table 2, Table 2 is Table 1, and it is assumed that a user selects the cell in column D, row 2 in Table 1 and performs a copy operation on the cell, and also assumes that a user selects the cell in column B, row 2 in Table 2 and performs a paste operation on the cell.

[0122] Then, in the above application scenario, by applying the technical means related to the embodiment of the present disclosure, the area consisting of the cell in the second row of column B, the cell in the second row of column D, and the cell in the second row of column E in Table 2 is determined as the area to be copied, and the area consisting of the cell in the second row of column B, the cell in the second row of column C, and the cell in the second row of column F in Table 1 is determined as the area to be pasted, and then, in the paste target area, paste cells corresponding to each copy cell in the copy target area are determined, and further, the cell data in each copy cell is filled into the corresponding paste cell.

[0123] In some embodiments, the cell in column B, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column D, row 2 in Table 2, and the cell data in the copy cell in column D, row 2 in Table 2 is filled into the paste cell in column B, row 2 in Table 1.

[0124] In some embodiments, the cell in column D, row 2 of Table 1 is determined as the paste cell corresponding to the copy cell in column E, row 2 of Table 2, and the cell data in the copy cell in column E, row 2 of Table 2 is filled into the paste cell in column D, row 2 of Table 1.

[0125] In some embodiments, the cell in column C, row 2 in Table 1 is determined as the paste cell corresponding to the copy cell in column B, row 2 in Table 2, and the cell data in the copy cell in column B, row 2 in Table 2 is filled into the paste cell in column C, row 2 in Table 1.

[0126] This allows the user to fill Zhang San's age, mobile phone number, and email address in Table 2 into Table 1 with just one copy operation, significantly reducing the number of user operations compared to conventional technology.

[0127] Specifically, the method of determining the copy target area in Table 1 and the paste target area in Table 2 will be described below with different examples, but will not be described in detail here.

[0128] According to the technical means of the embodiment of the present disclosure, in response to a copy operation on the first table, a copy target area is determined in the first table, paste cells corresponding to each copy cell in the copy target area are determined in the second table, and the cell data in each copy cell is filled into the corresponding paste cell, thereby determining multiple pairs of corresponding copy cells and paste cells in the source table containing the data to be copied and the filled table, and further, copying and pasting multiple pieces of data between the source table and the filled table is possible, thereby improving the efficiency of data migration between the two tables. In the prior art, copying and pasting multiple pieces of data between two tables relies entirely on repeated manual copy and paste operations, which results in low data migration efficiency. This solves the technical problem and effectively reduces operational errors associated with repeated manual operations.

[0129] 6 is a flowchart of yet another example of a table data filling method according to an embodiment of the present disclosure. The flow shown in FIG. 6 is based on the above flow shown in FIG. 1 or FIG. 5, Step 601: In response to a copy operation on the first table, a region consisting of each column related to the first cell region is determined as a region to be copied, where the first cell region is the cell region corresponding to the copy operation; determining a paste target area in a second table, step 602, where the paste target area includes at least one column in the second table; Step 603 of determining a condition string in Table 2 and a search area in Table 1; Step 604: determining paste cells in the paste target area corresponding to each copy cell in the copy target area based on the condition string and the search area; and step 605 of filling the cell data in each copy cell into the corresponding paste cell.

[0130] In some embodiments, referring to the application scenario illustrated in FIG. 2, the first cell region is the cell in column D, row 3 in Table 2, and the region to be copied is the region consisting of the cells in column D in Table 2.

[0131] In some embodiments, referring to the application scenario illustrated in FIG. 3, the first cell area is the area consisting of the cell in column B, row 2, the cell in column C, row 2, the cell in column B, row 3, and the cell in column C, row 3 in Table 2, and the area to be copied is the area consisting of the cells in columns B and C in Table 2.

[0132] For other explanations of step 601, please refer to the relevant explanations in the above embodiment shown in FIG. 1 or FIG. 5, and therefore the explanation will be omitted here.

[0133] Since the area to be copied includes at least one column in the first table, the area to be pasted accordingly also includes at least one column in the second table.

[0134] In some embodiments, when the second cell region and the first cell region have the same number of rows and columns, the region consisting of a certain column of the second cell region is determined as the paste target region, where the second cell region corresponds to the paste operation on the second table.

[0135] In some embodiments, referring to the application scenario illustrated in Fig. 2, the first cell region is the region consisting of the cell in row 3 of column D in Table 2, and the number of rows and columns is both 1, and the second cell region is the region consisting of the cell in row 2 of column C in Table 1, and the number of rows and columns is both 1. According to the above explanation, if the number of rows and columns of the second cell region and the first cell region are the same, the region consisting of a column in which the second cell region is located, i.e., the region consisting of column C in Table 1, is determined as the paste target region.

[0136] 3 , the first cell region is the region consisting of the cells in column B, row 2, column C, row 2, column B, row 3, and column C, row 3, in Table 2, and the number of rows and columns is 2, while the second cell region is the region consisting of the cells in column B, row 2, column C, row 3, column B, and row C, row 3, in Table 1, and the number of rows and columns is 2. According to the above description, when the number of rows and columns of the second cell region and the number of columns are the same, the region consisting of a column in which the second cell region is located, i.e., the region consisting of columns B and C in Table 1, is determined as the paste target region.

[0137] In some embodiments, the implementation of determining the paste target area in the second table includes performing the following process for each column involved in the first cell area: determining a column header for the column, and if it is determined that a target column header that matches the column header exists in the row headers of the second table, determining the area consisting of the column corresponding to the target column header as the paste target area.

[0138] In some embodiments, the matching may refer to exact matches or to semantic similarity of the text. For example, two column headings, Mobile Number and Phone, may be considered to match because they are different but have semantic similarity of the text.

[0139] In some embodiments, referring to Figure 4, assuming that the first cell area is the area consisting of the cell in the second row of column D and the cell in the second row of column E in Table 2, in accordance with the above explanation, for column D in Table 2, the column heading of that column is determined to be specifically "mobile phone number", and the target column heading in the row headings of Table 1 that matches that column heading is determined to be specifically "mobile phone number", and a process is performed to determine the area in Table 1 whose column heading is "mobile phone number", i.e., the area consisting of column B, as the paste target area; and for column E in Table 2, the column heading of that column is determined to be specifically "email address", and the target column heading in the row headings of Table 1 that matches that column heading is determined to be specifically "email address", and a process is performed to determine the area in Table 1 whose column heading is "email address", i.e., the area consisting of column D, as the paste target area.

[0140] As can be seen from the above example, the user does not need to perform selection and paste operations on cells in the second table, and the user operation can be simplified by applying the technical means related to the embodiments of the present disclosure to determine the paste target area in the second table.

[0141] In some embodiments, even when the first cell area involves at least two discontinuous columns, the technical means of the above embodiment can be applied to determine the paste target area in the second table, thereby reducing restrictions on user operations and improving the user experience.

[0142] Although the embodiments of the present disclosure describe technical solutions for a vertically arranged table (i.e., a table in which each row corresponds to one object and each column corresponds to one field), those skilled in the art will readily conceive of adapting the technical solutions to a horizontally arranged table based on the embodiments of the present disclosure. In some embodiments, for a horizontally arranged table (i.e., a table in which each column corresponds to one object and each row corresponds to one field), an area consisting of each row related to a first cell area can be determined as a copy target area. Accordingly, the paste target area includes at least one row in the second table, and the column headers are changed to row headers accordingly. The embodiments of the present disclosure do not specifically limit the table arrangement method to be applied.

[0143] In some embodiments, when the first cell region and the second cell region each involve only one row, the implementation of determining the condition column in the second table and determining the search area in the first table includes determining the condition column in the second table and determining the search area in the first table through text recognition. Specifically, the implementation uses text recognition to determine a first cell dataset corresponding to the row in which the first cell region is located and a second cell dataset corresponding to the row in which the second cell region is located, and then determines identical items in the first cell dataset and the second cell dataset, and determines the column in the second table where the identical item is located as the condition column and the column in the first table where the identical item is located as the search area. Here, the identical items refer to two data items with exactly the same content.

[0144] 2, the first cell region and the second cell region each include only one row, the first cell data set corresponding to the row in the first cell region is {Name=Li Si, Age=29, Gender=Male, Mobile Phone Number=138000001, Email Address=ls@**.com}, and the second cell data set corresponding to the row in the second cell region is {Name=Li Si, Event=Bicycle}. From this comparison, it can be seen that the same item in the first cell data set and the second cell data set is "Name=Li Si." Furthermore, column A in Table 1 where "Name=Li Si" is located is determined as the condition column, and column A in Table 2 where "Name=Li Si" is located is determined as the search region.

[0145] In some embodiments, when determining whether two data items in the first cell data set and the second cell data set are the same item, the determination may be made by referring to the column headers of the columns in which the two data items are located. In some embodiments, if two data items are the same and their corresponding column headers also match, the two data items are determined to be the same item. This processing can improve accuracy.

[0146] In some embodiments, when the first cell region and the second cell region both involve N rows (N is a natural number greater than 1), the implementation of determining the condition column in the second table and determining the search area in the first table includes performing the following processes for each row in the first cell region: determining a third cell dataset corresponding to the row, determining a row in the second cell region corresponding to the row, and determining a fourth cell dataset corresponding to the corresponding row. Then, determining the same itemsets of the third cell dataset and the fourth cell dataset. Finally, determining a common header for the same itemsets corresponding to each row in the first cell region, determining the column in the second table with the common header as the condition column, and determining the column in the first table with the common header as the search area. Here, the row in the second cell region corresponding to the row in the first cell region refers to a row in the second cell region whose relative row number is the same as the relative row number in the first cell region of the row in the first cell region. In some embodiments, the row in the second cell region that corresponds to the first row in the first cell region (i.e., the second row in Table 2) is the first row in the second cell region (i.e., the second row in Table 1).

[0147] In some embodiments, referring to the application scenario illustrated in Figure 3, the first cell region and the second cell region each include two rows, and the following process is performed for the first row of the first cell region: determine the third cell dataset corresponding to the row as {Name=A, Phone=111, Gender=Male, Years of Service=3}, determine the row corresponding to the row in the second cell region, and determine the fourth cell dataset corresponding to the corresponding row as {Name=A, Years of Service=1}, and determine that the same itemset in the third cell dataset and the fourth cell dataset is {Name=A}.

[0148] This includes performing the following process for the second row related to the first cell region: determining that the third cell dataset corresponding to that row is {Name=B, Phone=222, Gender=Female, Years of Service=2}, determining the row corresponding to that row in the second cell region, and determining that the fourth cell dataset corresponding to that corresponding row is {Name=B, Years of Service=2}, and determining that the same item set in the third cell dataset and the fourth cell dataset is {Name=B, Years of Service=2}.

[0149] Finally, the common heading for the two same item sets is determined to be "Name." Following the above explanation, column A in Table 1 where "Name" is located is determined to be the condition column, and the column in Table 2 where "Name" is located is determined to be the search area.

[0150] In some embodiments, an implementation of determining a paste cell in the paste target area corresponding to each copied cell in the copy target area based on the condition column and the search area includes determining each row in the paste target area as a target row, and performing the following process for each target row: determining cell data in the target row in the condition column as condition data, determining the condition data in the search area, determining the row containing the condition data as a target row, and determining an area consisting of copied cells in the target row in the copy target area as a sub-copy target area corresponding to the target row. Then, performing the following process for each copy cell in the sub-copy target area: determining a paste target cell from the target row that satisfies a set condition, where the set condition means that the paste cell and the copy cell have the same relative position, and the relative position represents the position of the paste cell in the target row or the position of the copy cell in the sub-copy target area, and determining the paste target cell as the paste cell corresponding to the copy cell.

[0151] In some embodiments, referring to the application scenario illustrated in FIG. 2, assuming that the second row of Table 1 is the target row, the cell data in the second row of column A, which is the condition column, is "Li Si," and "Li Si" is determined as the condition data. Next, in column A of Table 2, which is the search area, the condition data "Li Si" is determined, and the row containing the condition data "Li Si," i.e., row 3, is determined as the target row. Then, in column D of Table 2, which is the copy area, the copy cell in row 3, i.e., the area consisting of the cell in column D, row 3, is determined as the target row (the sub-copy area corresponding to row 2 of Table 1).

[0152] Then, for the copy cell in the sub-copy target area, i.e., the cell in column D, row 3, if there is only one paste cell in the processing target row at this time, only one paste cell in the processing target row can be determined as the paste cell corresponding to the copy cell.

[0153] In some embodiments, referring to the application scenario illustrated in FIG. 3, if the second row of Table 1 is taken as the processing target row, the cell data in the second row of column A as the condition column is "A," and "A" is determined as the condition data. Next, in column A of Table 2 as the search area, the condition data "A" is determined, and the row containing the condition data "A," i.e., the second row of Table 2, is determined as the target row. Then, in columns B and C of Table 2 as the copy target area, the area consisting of the copy cell in the second row, i.e., the cell in the second row of column B and the cell in the second row of column C, is determined as the processing target row (the sub-copy target area corresponding to the second row of Table 1).

[0154] At this time, if there are two copy cells in the sub-copy target area and two paste cells in the processing target row, it is necessary to further determine the correspondence between the two copy cells and the two paste cells.

[0155] In some embodiments, for the copy cell in the second row of column B in Table 2, the copy cell is the first cell from the left in the sub-copy target area, that is, the copy cell is the first cell from the left in the sub-copy target area. According to the above description, the first cell from the left in the processing target row, that is, the paste cell in the second row of column B in Table 1, is determined as the paste cell corresponding to the copy cell.

[0156] Similarly, for the copy cell in the second row of column C in Table 2, the copy cell is the second cell from the left in the sub-copy target area, that is, the copy cell is the second cell from the left in its relative position in the sub-copy target area. According to the above explanation, the second cell from the left in the processing target row, that is, the paste cell in the second row of column C in Table 1, is determined as the paste cell corresponding to the copy cell.

[0157] As can be seen from the above example, the technical means according to the embodiment of the present disclosure is not limited to auto-filling data of multiple rows and one column, but can also automatically fill data of multiple rows and multiple columns.

[0158] According to the flow shown in Figure 6, multiple rows of data can be automatically filled into a table without the user having to perform repeated copy and paste operations multiple times, improving the efficiency of data transfer between two tables and effectively reducing operational errors associated with repeated manual work.

[0159] It should be noted that the flow shown in Figure 6 describes the technical means for a table arranged vertically, and a person skilled in the art can easily think of adaptively changing the technical means for a table arranged horizontally based on the flow shown in Figure 6. In some embodiments, for a table arranged horizontally, the condition column may be changed to a condition row, and similarly, the search area is changed to an area consisting of cells in a row. Specifically, Figure 7 is a flowchart of yet another example of a table data filling method according to an embodiment of the present disclosure, Step 701: In response to a copy operation on the first table, a region consisting of each row related to the first cell region is determined as a region to be copied, where the first cell region is the cell region corresponding to the copy operation; determining a paste target area in the second table, step 702, where the paste target area includes at least one row in the second table; Step 703 of determining the condition row in the second table and the search area in the first table; Step 704: determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area based on the condition line and the search area; and step 705 of filling the cell data in each copy cell into the corresponding paste cell.

[0160] In some embodiments, the implementation of determining the paste target area in the second table includes performing the following process for each row related to the first cell area: determining the row header of the row, and if it is determined that a target row header that matches the row header exists in the column headers of the second table, determining the area consisting of the row corresponding to the target row header as the paste target area.

[0161] A detailed explanation of steps 701 to 705 can be easily derived by a person skilled in the art by referring to the relevant explanation of the embodiment shown in Figure 6 and making reasonable modifications, so the explanation of steps 701 to 705 will be omitted here.

[0162] The flow shown in FIG. 7 is a variation of the flow shown in FIG. 6 for horizontally arranged tables, allowing the user to automatically fill multiple columns of data in a table without having to perform multiple repetitive copy and paste operations.

[0163] 8 is a flowchart of yet another example of a table data filling method according to an embodiment of the present disclosure. The flow shown in FIG. 8 is based on the above flow shown in FIG. 1, a step 801 of determining a first set of column headings corresponding to the first table and determining a second set of column headings corresponding to the second table in response to a copy operation on the first table; determining 802 related column headings in the first and second sets of column headings; a step 803 of determining as a copy target area a region of cells corresponding to the associated column header in a row of the first cell area, the first cell area being the cell area corresponding to the copy operation; Step 804: determining a region of cells corresponding to the associated column header in the row of the second cell region as a paste target region, where the second cell region is the region corresponding to the paste operation for the second table; Step 805: for each copy cell in the copy target area, determine a paste target cell from the paste target area that satisfies a set condition, and determine the paste target cell as a paste cell corresponding to the copy cell, where the set condition means that the paste cell and the copy cell correspond to a related column header; and step 806 of filling the cell data in each copy cell into a corresponding paste cell.

[0164] Taking the application scenario shown in Figure 4 as an example, Table 2 is Table 1, Table 1 is Table 2, the first column heading set corresponding to Table 1 is {name, age, gender, mobile phone number, email address}, and the second column heading set corresponding to Table 2 is {name, mobile phone number, age, email address, whether or not the person has a local family register, place of origin}.

[0165] In some embodiments, the related column headings refer to column headings that are exactly the same or have semantically similar text. In some embodiments, two column headings, Mobile Number and Phone, can be considered related column headings because they are different but have semantically similar text.

[0166] In the example of step 801 above, the relevant column headings in the first and second column heading sets include name, age, mobile phone number, and email address.

[0167] In the example of step 801 above, the area consisting of the cell in column B, row 2, the cell in column C, row 2, the cell in column D, row 2, and the cell in column E, row 2 in Table 2 shown in FIG. 4 is determined as the area to be copied.

[0168] In the example of step 801 above, the area consisting of the cell in column B, row 2, the cell in column C, row 2, and the cell in column D, row 2 in Table 1 shown in FIG. 4 is determined as the paste target area.

[0169] In the example of the above steps, the cell in column B, row 2 of Table 1 is determined as the paste cell corresponding to the copied cell in column D, row 2 of Table 2, the cell in column C, row 2 of Table 1 is determined as the paste cell corresponding to the copied cell in column B, row 2 of Table 2, and the cell in column D, row 2 of Table 1 is determined as the paste cell corresponding to the copied cell in column E, row 2 of Table 2.

[0170] In the example of the above step, Zhang San's age "35" in Table 2 is filled into the cell in column C, row 2 of Table 1, Zhang San's mobile phone number "138000000" in Table 2 is filled into the cell in column B, row 2 of Table 1, and Zhang San's email address "zs@**.com" in Table 2 is filled into the cell in column D, row 2 of Table 1.

[0171] According to the flow shown in FIG. 7, multiple columns of data can be automatically filled into a table without the user having to perform repeated copy and paste operations multiple times, and the multiple columns can be discontinuous, thereby improving the efficiency of data transfer between two tables and effectively reducing operational errors associated with repeated manual work.

[0172] Note that the flow shown in FIG. 8 also describes technical means for a table arranged vertically, and a person skilled in the art can easily think of adaptively changing the technical means for a table arranged horizontally based on the flow shown in FIG. 8. In some embodiments, for a table arranged horizontally, the column headers can be changed to row headers. Specifically, FIG. 9 is a flowchart of yet another example of a table data filling method according to an embodiment of the present disclosure, a step 901 of determining a first set of row headings corresponding to the first table and determining a second set of row headings corresponding to the second table in response to a copy operation on the first table; determining associated row headings in the first and second row heading sets in step 902; a step 903 of determining a region of cells corresponding to the associated row header in the column of the first cell region as a region to be copied, the first cell region being the cell region corresponding to the copy operation; Step 904: determining a region of cells corresponding to the associated row header in the column of the second cell region as a paste target region, where the second cell region is the region corresponding to the paste operation for the second table; Step 905: for each copy cell in the copy target area, determine a paste target cell from the paste target area that satisfies a set condition, and determine the paste target cell as a paste cell corresponding to the copy cell, where the set condition means that the paste cell and the copy cell correspond to a related row header; and step 906 of filling the cell data in each copy cell into a corresponding paste cell.

[0173] A detailed explanation of steps 901 to 906 can be easily derived by a person skilled in the art by referring to the relevant explanation of the embodiment shown in Figure 8 and making reasonable modifications, so the explanation of steps 901 to 906 will be omitted here.

[0174] The flow shown in FIG. 9 is a variation of the flow shown in FIG. 8 for horizontally arranged tables, allowing the user to automatically fill multiple rows of data into the table without having to perform multiple repetitive copy and paste operations.

[0175] 10 is a flowchart of yet another example of a table data filling method according to an embodiment of the present disclosure. The flow shown in FIG. 10 illustrates a method for filling cell data in each copy cell into a corresponding paste cell based on any of the above flows. The flow includes: Step 1001 of creating a data fill formula for the paste cell based on the corresponding copy cell; and step 1002 of filling the paste cell with the data fill formula.

[0176] The above data fill formula indicates that the cell data in the corresponding copy cell should be displayed in the paste cell.

[0177] In some embodiments, referring to the application scenario illustrated in FIG. 2 , if the cell in row 3 of column C of Table 1 is a paste cell corresponding to the copy cell in row 5 of column D of Table 2, the following data fill formula can be created for the paste cell in row 3 of column C of Table 1: XLOOKUP(A2, Table 2!A:A, Table 2!D:D).

[0178] In the above data fill formula, A2 indicates that the data in the second row of column A of Table 1 is the condition data, Table2!A:A indicates that the search area is column A of Table 2, and Table2!D:D indicates that the return area is column D of Table 2.

[0179] In some embodiments, the above data fill expression indicates that the condition data "Li Si" is searched for in column A of Table 2, and the cell data corresponding to "Li Si" in column D of Table 2 is displayed in the paste cell. In this way, the mobile phone number of Li Si in Table 2 can be filled into the information corresponding to Li Si in Table 1.

[0180] Continuing, referring to the application scenario illustrated in FIG. 2, if the cell in column C, row 4 of Table 1 is a paste cell corresponding to the copy cell in column D, row 4 of Table 2, the following data fill formula can be created for the paste cell in column C, row 4 of Table 1: XLOOKUP(A4, Table 2!A:A, Table 2!D:D).

[0181] The above data fill formula indicates that the condition data "Wang Wu" is searched for in column A of Table 2, and the cell data corresponding to "Wang Wu" in column D of Table 2 is displayed in the paste cell. In this way, the mobile phone number of Wang Wu in Table 2 can be filled into the information corresponding to Wang Wu in Table 1.

[0182] In some embodiments, referring to the application scenario illustrated in FIG. 4 , if the cell in column B, row 2 of Table 1 is a paste cell corresponding to the copy cell in column D, row 2 of Table 2, the following data fill formula can be created for the paste cell in column B, row 2 of Table 1: YLOOKUP(B1, Table2!1:1, Table2!2:2).

[0183] In the above data fill formula, B1 indicates that the data in the first row of column B of Table 1 is the condition column header, Table2!1:1 indicates that the search area is the row header of Table 2, and Table2!2:2 indicates that the return area is the second row of Table 2.

[0184] In some embodiments, the above data fill expression indicates that the cell in the second row of Table 2 whose corresponding header matches the condition column header "Mobile Phone Number" is searched for, and the cell data in that cell is displayed in the paste cell. In this way, Zhang San's mobile phone number in Table 2 can be filled with the information corresponding to Zhang San in Table 1.

[0185] Continuing, referring to the application scenario illustrated in FIG. 4, if the cell in column C, row 2 of Table 1 is a paste cell corresponding to the copy cell in column B, row 2 of Table 2, the following data fill formula can be created for the paste cell in column C, row 2 of Table 1: YLOOKUP(C1, Table2!1:1, Table2!2:2).

[0186] In some embodiments, the above data fill expression indicates that the cell in the second row of Table 2 whose corresponding header matches the condition column header "Age" is searched for, and the cell data in that cell is displayed in the paste cell. In this way, Zhang San's age in Table 2 can be filled with the information corresponding to Zhang San in Table 1.

[0187] In some embodiments, the flow shown in FIG. 5 can be used in combination with the flow shown in FIG. 6 to autofill multiple rows and columns of data into a table simultaneously, further improving the efficiency of data migration between the two tables.

[0188] 11 is a block diagram of an embodiment of a table data filling device according to an embodiment of the present disclosure. As shown in FIG. 11, the device includes: a copy area determination module 111 configured to determine an area to be copied in the first table in response to a copy operation on the first table; a paste cell determination module 112 configured to determine a paste cell corresponding to each copy cell in the copy target region in table 2, wherein the copy cell and the corresponding paste cell have at least one associated target parameter; a data fill module 113 configured to fill cell data in each of the copy cells into the corresponding paste cells.

[0189] In some embodiments, the paste cell determination module 112: The text recognition is configured to determine paste cells in the second table that correspond to each copy cell in the copy target area.

[0190] In some embodiments, the copy region determination module 111: The method is configured to determine an area consisting of each column related to a first cell area as a copy target area, and the first cell area is a cell area corresponding to the copy operation.

[0191] In some embodiments, the paste cell determination module 112: a paste area determination unit configured to determine a paste target area in a second table, the paste area determination unit comprising at least one column in the second table; a condition determination unit configured to determine a condition string in the second table and to determine a search area in the first table; a cell determination unit configured to determine, in the paste target area, paste cells corresponding to each copy cell in the copy target area, based on the condition string and the search area.

[0192] In some embodiments, the cell determination unit: a condition data determination subunit configured to execute a process of determining each row related to the paste target area as one processing target row, and determining, for each processing target row, cell data in the processing target row in the condition column as condition data; a target row determination subunit configured to determine the condition data in the search area and determine a row in which the condition data is located as a target row; a sub-copy target area determination subunit configured to determine an area consisting of copy cells in the target row in the copy target area as a sub-copy target area corresponding to the processing target row; For each copy cell in the sub-copy target area, determining a paste target cell from the processing target row that satisfies a set condition, the set condition indicating that the paste cell and the copy cell have the same relative position, the relative position representing the position of the paste cell in the processing target row or the position of the copy cell in the sub-copy target area; and a paste target cell determination subunit configured to perform the process of determining the paste target cell as a paste cell corresponding to the copy cell.

[0193] In some embodiments, the paste area determination unit comprises: When the number of rows and columns of the second cell area and the first cell area are the same, the area consisting of a certain column of the second cell area is determined as the paste target area, and the second cell area is the area corresponding to the paste operation on the second table.

[0194] In some embodiments, the paste area determination unit comprises: For each column of the first cell region: determining column headings for said columns; When it is determined that a target column heading that matches the column heading exists in the row headings of the second table, an area consisting of the column corresponding to the target column heading is determined as a paste target area.

[0195] In some embodiments, the condition data determination subunit comprises: When the first cell area and the second cell area each relate to only one row, the first cell area is configured to determine a first cell data set corresponding to a row, and the second cell area is configured to determine a second cell data set corresponding to a row, and the second cell area is configured to be an area corresponding to a paste operation for the second table; The method is configured to determine the same items in the first cell data set and the second cell data set, determine the column in the second table where the same items are located as a condition column, and determine the column in the first table where the same items are located as a search area.

[0196] In some embodiments, the condition data determination subunit comprises: When the first cell area and the second cell area are both involved in N rows, where N is a natural number greater than 1, for each row involved in the first cell area: determining a third cell data set corresponding to said row; determining a row in the second cell region corresponding to the row; and determining a fourth cell data set corresponding to the corresponding row; determining the same itemsets in the third cell data set and the fourth cell data set; determining the same items of the same itemset corresponding to each row of the first cell area, determining the column in the second table in which the same items are located as a condition column, and determining the column in the first table in which the same items are located as a search area; The second cell area is an area corresponding to a paste operation on the second table.

[0197] In some embodiments, the copy region determination module 111: determining a first set of column headings corresponding to said first table and a second set of column headings corresponding to said second table; determining associated column headings in the first set of column headings and the second set of column headings; The method is configured to determine, as a copy target area, an area consisting of cells corresponding to the associated column header in a row related to the first cell area, and the first cell area is a cell area corresponding to the copy operation.

[0198] In some embodiments, the paste cell determination module 112 comprises: a paste area determination unit configured to determine a paste target area in the second table, the paste target area including at least two cells in the same row in the second table; For each copy cell in the copy target area, determining a paste target cell from the paste target region that satisfies a set condition, the set condition corresponding to a column header to which the paste cell and the copy cell are associated; determining the paste target cell as a paste cell corresponding to the copy cell; a paste area determination unit.

[0199] In some embodiments, the paste area determination unit comprises: The method is configured to determine, as a paste target area, an area consisting of cells corresponding to the associated column header in a row related to the second cell area, and the second cell area is an area corresponding to a paste operation for the second table.

[0200] In some embodiments, the data fill module 113: For each paste cell: creating a data fill formula based on the corresponding copied cells; Filling the paste cell with the data fill formula, The data fill expression indicates that the cell data in the corresponding copy cell is to be displayed in the paste cell.

[0201] FIG. 12 is a structural schematic diagram of an electronic device according to one embodiment of the present disclosure. The electronic device 1200 shown in FIG. 12 includes at least one processor 1201, a memory 1202, at least one network interface 1204, and another user interface 1203. The components in the electronic device 1200 are coupled together via a bus system 1205. It should be understood that the bus system 1205 provides communication between these components. In addition to a data bus, the bus system 1205 also includes a power bus, a control bus, and a status signal bus. However, for clarity, all of the various buses in FIG. 12 will be referred to as the bus system 1205.

[0202] In some embodiments, the user interface 1203 may include a display, a keyboard or clicking device (eg, a mouse, a trackball), a touchpad or touchscreen, or the like.

[0203] It should be appreciated that memory 1202 in embodiments of the present disclosure may be volatile or nonvolatile memory, or may include both volatile and nonvolatile memory. Nonvolatile memory may be read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), or flash memory. Volatile memory may be random access memory (RAM) used as an external cache. By way of example and not limitation, many forms of RAM can be used, such as static random access memory (Static RAM, SRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (Synchronous DRAM, SDRAM), double data rate synchronous dynamic random access memory (DDRSDRAM), enhanced synchronous dynamic random access memory (Enhanced SDRAM, ESDRAM), synch link dynamic random access memory (SLDRAM), and direct Rambus random access memory (DRRAM). Memory 1202 as described herein includes, but is not limited to, these and any other suitable types of memory.

[0204] In some embodiments, memory 1202 stores the following elements: executable modules or data structures, or a proper subset or extension thereof, for example, an operating system 12021 and application programs 12022.

[0205] The operating system 12021 includes various system programs, such as a framework layer, a core library layer, and a driver layer, for implementing various basic services and processing hardware-based services. The application programs 12022 include various application programs, such as a media player and a browser, for implementing various application services. A program for implementing a method according to an embodiment of the present disclosure may be included in the application programs 12022.

[0206] In the embodiments of the present disclosure, the steps of the method for the processor 1201 to execute each method embodiment by calling a program or instruction stored in the memory 1202, specifically, a program or instruction stored in the application program 12022, are as follows: determining a copy target area in the first table in response to a copy operation on the first table; determining a paste cell corresponding to each copy cell in the copy target region in a second table, the copy cell and the corresponding paste cell having at least one associated target parameter; and filling the cell data in each copy cell into a corresponding paste cell.

[0207] The methods disclosed in the embodiments of the present disclosure may be applied to or implemented by the processor 1201. The processor 1201 may be an integrated circuit chip having signal processing capabilities. In the implementation process, each step of the above method may be completed by a hardware integrated logic circuit in the processor 1201 or a command in the form of software. The processor 1201 may be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic device, a discrete gate or transistor logic device, or a discrete hardware component. Each method, step, and logical block diagram according to the embodiments of the present disclosure may be realized or executed. The general-purpose processor may be a microprocessor, any conventional processor, etc. The steps of the methods disclosed with reference to the embodiments of the present disclosure may be directly embodied as being executed and completed by a hardware decoding processor or by being executed and completed by a combination of hardware and software units in the decoding processor. The software unit may be located in a storage medium mature in the art, such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The storage medium is located in the memory 1202, and the processor 1201 reads the information in the memory 1202 and completes the steps of the above method in combination with its hardware.

[0208] As can be appreciated, the embodiments described herein can be implemented by hardware, software, firmware, middleware, microcode, or a combination thereof. In the case of a hardware implementation, the processing unit can be implemented in one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processing (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field-Programmable Gate Arrays (FPGAs), general-purpose processors, controllers, microcontrollers, microprocessors, other electronic elements, or a combination thereof, for performing the functions of the present disclosure.

[0209] In the case of a software implementation, the techniques described herein can be implemented by units that perform the functions described herein. The software code can be stored in a memory and executed by a processor. The memory may be implemented within the processor or external to the processor.

[0210] The electronic device of this embodiment may be the electronic device shown in FIG. 12, which can perform all the steps of the table data filling method in the above embodiment and further achieve the technical effects of the table data filling method in the above embodiment. For details, please refer to the relevant description of the above embodiment, and for the sake of brevity, the description will be omitted here.

[0211] An embodiment of the present disclosure further provides a computer-readable storage medium, in which one or more programs are stored. The storage medium may include volatile memory such as random access memory, non-volatile memory such as read-only memory, flash memory, hard disk, or solid-state drive, or a combination of the above types of memory.

[0212] When one or more programs stored in the storage medium are executed by one or more processors, the table data filling method executed on the electronic device side is realized.

[0213] The processor executes a table data filling program stored in the memory to realize the following steps of a table data filling method executed on the electronic device side, the steps including: determining a copy target area in the first table in response to a copy operation on the first table; determining a paste cell corresponding to each copy cell in the copy target region in a second table, the copy cell and the corresponding paste cell having at least one associated target parameter; and filling the cell data in each copy cell into a corresponding paste cell.

[0214] As can be understood by those skilled in the art, the units and algorithm steps of each example described in the embodiments disclosed herein can be realized by electronic hardware, computer software, or a combination of both. In order to clearly explain the compatibility between hardware and software, the configurations and steps of each example are generally described according to their functions in the above description. Whether these functions are implemented in the form of hardware or software depends on the specific application and design constraints of the technical means. Those skilled in the art may implement the described functions in different ways for each specific application, but such implementation should not be considered to go beyond the scope of the present disclosure.

[0215] The steps of a method or algorithm described in the embodiments disclosed herein may be embodied in hardware, in software modules executed by a processor, or in a combination of both. The software modules may be located in random access memory (RAM), memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, removable disk, CD-ROM, or any other form of storage medium known in the art.

[0216] The above specific embodiments further explain the objectives, technical means, and beneficial effects of the present disclosure, but it should be understood that the above are merely specific embodiments of the present disclosure and do not limit the protection scope of the present disclosure, and any edits, equivalent substitutions, improvements, etc. made without departing from the spirit of the present disclosure should all be included within the protection scope of the present disclosure.

Claims

1. 1. A table data filling method, comprising: determining a copy target area in the first table in response to a copy operation on the first table; determining a paste cell corresponding to each copy cell in the copy target region in a second table, the copy cell and the corresponding paste cell having at least one associated target parameter; and filling the cell data in each copy cell into a corresponding paste cell, respectively.

2. Determining paste cells in the second table corresponding to each copy cell in the copy target area includes:

2. The method of claim 1, further comprising determining, by text recognition, paste cells in the second table that correspond to each copy cell in the region to be copied.

3. Determining the area to be copied in the first table includes: The method of claim 1 , further comprising determining an area of ​​each column of a first cell area as an area to be copied, the first cell area being the cell area corresponding to the copy operation.

4. Determining paste cells in the second table corresponding to each copy cell in the copy target area includes: determining a paste target area in a second table, the paste target area including at least one column in the second table; determining a condition string in the second table and a search area in the first table; 4. The method according to claim 1, further comprising determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area, based on the condition string and the search area.

5. determining, in the paste target area, paste cells corresponding to each copy cell in the copy target area based on the condition string and the search area; Each line related to the paste target area is determined as a processing target line, and for each processing target line: determining cell data in the processing target row in the condition column as condition data; determining the condition data in the search area, and determining a row in which the condition data is present as a target row; determining an area consisting of copy cells in the target row in the copy target area as a sub-copy target area corresponding to the processing target row; For each copy cell in the sub-copy target area, determining a paste target cell from the processing target row that satisfies a set condition, the set condition indicating that the paste cell and the copy cell have the same relative position, the relative position representing the position of the paste cell in the processing target row or the position of the copy cell in the sub-copy target area; determining the paste target cell as a paste cell corresponding to the copy cell; The method of claim 4, comprising:

6. Determining the paste target area in the second table includes:

5. The method of claim 4, further comprising: when the number of rows and the number of columns of the second cell area and the first cell area are the same, determining an area consisting of a column of the second cell area as the paste target area, wherein the second cell area is an area corresponding to a paste operation on the second table.

7. Determining the paste target area in the second table includes: For each column of the first cell region: determining column headings for said columns; When it is determined that a target column heading exists in the row headings of the second table that matches the column heading, an area consisting of a column corresponding to the target column heading is determined as a paste target area; The method of claim 4, comprising:

8. determining a condition string in the second table and a search area in the first table; If the first cell area and the second cell area each relate to only one row, determining a first cell data set corresponding to the row in which the first cell area is located and determining a second cell data set corresponding to the row in which the second cell area is located, the second cell area being an area corresponding to a paste operation on the second table; determining the same items between the first cell data set and the second cell data set, determining a column in the second table in which the same items exist as a condition column, and determining a column in the first table in which the same items exist as a search area; The method of claim 4, comprising:

9. determining a condition string in the second table and a search area in the first table; When the first cell region and the second cell region each involve N rows, where N is a natural number greater than 1, for each row of the first cell region: determining a third data set of cells corresponding to the row; determining a row in the second cell region corresponding to the row; and determining a fourth cell data set corresponding to the corresponding row; determining the same itemsets in the third cell data set and the fourth cell data set; determining the same items of the same itemset corresponding to each row of the first cell area, determining a column in the second table in which the same items are present as a condition column, and determining a column in the first table in which the same items are present as a search area; wherein the second cell area is an area corresponding to a paste operation on the second table; The method of claim 4, comprising:

10. Determining the area to be copied in the first table includes: determining a first set of column headings corresponding to the first table and a second set of column headings corresponding to a second table; determining associated column headings in the first set of column headings and the second set of column headings; determining a region of cells corresponding to the associated column header in a row related to the first cell region as a region to be copied, the first cell region being a cell region corresponding to the copy operation; The method of claim 1 , comprising:

11. Determining paste cells in the second table corresponding to each copy cell in the copy target area includes: determining a paste target area in the second table, the paste target area including at least two cells in the same row in the second table; For each copy cell in the copy target area, determining a paste target cell from the paste target region that satisfies a set condition, the set condition corresponding to a column header to which the paste cell and the copy cell are associated; determining the paste target cell as a paste cell corresponding to the copy cell; The method of claim 10, comprising:

12. Determining the paste target area in the second table includes: determining a region of cells corresponding to the associated column header in a row related to a second cell region as a paste target region, wherein the second cell region is a region corresponding to a paste operation on the second table; The method of claim 11 , comprising:

13. Filling the cell data in each of the copy cells into the corresponding paste cells includes: For each paste cell: creating a data fill formula based on the corresponding copied cells; Filling the paste cell with the data fill formula, the data fill expression indicates that cell data in the corresponding copy cell is to be displayed in the paste cell; The method of claim 1 , comprising:

14. a copy area determination module configured to determine an area to be copied in the first table in response to a copy operation on the first table; a paste cell determination module configured to determine a paste cell corresponding to each copy cell in the copy target region in a second table, the copy cell and the corresponding paste cell having at least one associated target parameter; a data fill module configured to fill cell data in each copy cell into a corresponding paste cell, respectively; A table data fill device including:

15. a processor and a memory, The electronic device, wherein the processor executes a table data filling program stored in the memory to implement the table data filling method according to any one of claims 1 to 13.

16. A storage medium on which one or more programs are stored and which, when executed by one or more processors, implement the table data filling method according to any one of claims 1 to 13.

Images