CN113536750B - Form marking method and device, electronic equipment and storage medium - Google Patents

Abstract

Embodiments of the present application provide a table marking method, device, electronic device and storage medium, which relate to the technical field of file processing and include: determining unit items to be skipped in the table as target unit items, wherein the unit items Including unit rows and/or unit columns; determining first identifiers of other unit items; marking the identifiers of other unit items as the first identifier. It can be seen that by applying the solution provided by the embodiment of the present application, the number of unit items used to display specific content in the table can be conveniently counted.

Description

A form marking method, device, electronic equipment and storage medium

Technical field

The present application relates to the field of document processing technology, and in particular to a form marking method, device, electronic equipment and storage medium.

Background technique

With the rapid development of document processing technology, tables are used more and more widely. Usually, the cell items in the table are marked. The above-mentioned unit items can be unit rows or unit columns. Based on the marked information, the number of unit items in the table can be counted.

Take Figure 1 as an example. Figure 1 is a schematic diagram of the enterprise employee table. In Figure 1, "XX" represents the employee's name. The left column of the table has a numerical row label, and the upper row has a column label with letters. Based on the unit item label When the information counts the number of unit items, if a title or table header appears, the mark in the prior art can only count all rows and columns, and cannot count the number of unit items used to display specific content in the table.

Contents of the invention

The purpose of the embodiments of the present application is to provide a table marking method, device, electronic equipment and storage medium to solve the problem that if a title or header appears, the existing technology markers can only count all the rows and columns, and cannot conveniently view the tables. Technical issue of counting the number of unit items used to display specific content. The specific technical solutions are as follows:

In a first aspect, an embodiment of the present invention provides a table marking method, which method includes:

Determine the unit item to be skipped in the table as the target unit item, wherein the unit item includes a unit row and/or a unit column;

Determine the first identification of other unit items, wherein the other unit items are: unit items in each unit item of the table except the target unit item;

Mark the identifiers of the other unit items as the first identifier.

In one embodiment of the present invention, the above-mentioned determination of the first identification of other unit items includes: determining the first identification of each other unit item according to the order in which the other unit items are arranged in the table.

In one embodiment of the present invention, determining the first identifier of each other unit item according to the arrangement order of the other unit items in the table includes: determining the first identifier of each first unit item according to the arrangement order of the other unit items in the table. The first identification of each first unit item, wherein the first unit item is: each unit item in the opposite direction represented by the type of the target unit item; according to the arrangement of each second unit item in the table In order, according to the first identification of each first unit item, the first identification of each second unit item is determined, wherein the second unit item is: each unit item in the forward direction represented by the type of the target unit item. unit item.

In one embodiment of the present invention, determining the first identifier of each other unit item according to the arrangement order of the other unit items in the table includes: determining the first identifier of each first unit item according to the arrangement order of the other unit items in the table. The first identifier of each first unit item, wherein the first unit item is: each unit item in the opposite direction represented by the type of the target unit item; according to the arrangement of each second unit item in the table In order, the first identification of each second unit item is determined, wherein the second unit item is: each unit item in the forward direction represented by the type of the target unit item.

In one embodiment of the present invention, the above method further includes:

Determine the re-marked unit items in the marked table as reference unit items;

In the case where the reference unit item is located before the target unit item, the reference unit item and the third unit item of each third unit item are determined according to the order in which the reference unit item and each third unit item are arranged in the table. two identifiers, and mark the identifiers of the reference unit item and each third unit item as the second identifier, wherein the third unit item is: the link between the reference unit item and the target unit item. unit item;

When the reference unit item is located after the target unit item, the reference unit item and the fourth unit item are determined according to the order in which the reference unit item and each fourth unit item are arranged in the table. Three identifiers, and mark the identifiers of the reference unit item and each fourth unit item as the third identifier, where the fourth unit item is: the unit item after the reference unit item.

In one embodiment of the present invention, the above method further includes: upon receiving an identification recovery operation triggered by the user in the user interface, determining the preset identification of each unit item in the table, and updating the identification of each unit item. is the default logo.

In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of units and/or at least two rows of continuous unit columns.

In one embodiment of the present invention, the above-mentioned determination of unit items to be skipped in the table includes: traversing unit items within a preset range in the table, finding unit items that meet the preset skip mark conditions, and using them as target unit items. , wherein the skip mark condition includes at least one of the following conditions: blank rows, blank columns, unit rows for displaying titles, and unit columns for displaying titles.

In a second aspect, an embodiment of the present invention provides a form marking device. The device includes:

The first unit item determination module is used to determine the unit item to be skipped in the table as the target unit item, where the unit item includes a unit row and/or a unit column;

The first identification determination module is used to determine the first identification of other unit items, wherein the other unit items are: unit items in each unit item of the table except the target unit item;

An identification marking module, configured to mark the identifications of the other unit items as the first identification.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each other unit item according to the order in which the other unit items are arranged in the table.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each first unit item according to the order in which the first unit items are arranged in the table, wherein the first The unit items are: each unit item in the opposite direction represented by the type of the target unit item; according to the order of arrangement of each second unit item in the table, and according to the first identification of each first unit item, determine The first identifier of each second unit item, wherein the second unit item is: each unit item in the forward direction represented by the type of the target unit item.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each first unit item according to the order in which the first unit items are arranged in the table, wherein the first The unit items are: each unit item in the opposite direction represented by the type of the target unit item; according to the order of arrangement of the second unit items in the table, the first identification of each second unit item is determined, wherein, The second unit item is: each unit item in the positive direction represented by the type of the target unit item.

In one embodiment of the present invention, the above device further includes:

The second unit item determination module is used to determine the re-marked unit items in the marked table as reference unit items;

The second identification determination module is used to determine the reference unit item according to the arrangement order of the reference unit item and each third unit item in the table when the reference unit item is located before the target unit item. and the second identification of each third unit item, and the identification of the reference unit item and each third unit item is marked as the second identification, wherein the third unit item is: the reference unit item and The unit items between the target unit items;

A third identification determination module, configured to determine the reference unit item according to the order in which the reference unit item and each fourth unit item are arranged in the table when the reference unit item is located after the target unit item. and the third identification of each fourth unit item, and mark the identification of the reference unit item and each fourth unit item as the third identification, wherein the fourth unit item is: after the reference unit item unit item.

In one embodiment of the present invention, the above device further includes: an identification update module, configured to determine the preset identification of each unit item in the table when receiving an identification recovery operation triggered by the user in the user interface, and update the The identification of each unit item is updated to the default identification.

In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of units and/or at least two rows of continuous unit columns.

In one embodiment of the present invention, the above-mentioned first unit item determination module is specifically used to traverse the unit items within a preset range in the table and find the unit item that meets the preset skip mark condition as the target unit item, where, The skip mark condition includes at least one of the following conditions: blank rows, blank columns, unit rows for displaying titles, and unit columns for displaying titles.

In a third aspect, embodiments of the present application provide an electronic device, including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory complete communication with each other through the communication bus;

The memory is used to store computer programs; the processor is used to implement any of the method steps described in the first aspect when executing the program stored in the memory.

In a fourth aspect, embodiments of the present application provide a computer-readable storage medium. A computer program is stored in the computer-readable storage medium. When the computer program is executed by a processor, any one of the methods described in the first aspect is implemented. Method steps.

When applying the solution provided by the embodiment of the present application for table marking, first determine the unit item to be skipped in the table as the target unit item, where the unit item includes unit rows and/or unit columns, and then divide the units in a preset order. The unit item of the target unit item is marked. In this way, when marking the table, you can skip marking the cell rows and/or cell columns that are not expected to be marked, instead of marking all the unit rows and/or cell columns. Based on the marked information, the table can be conveniently marked. Count the number of unit items used to display specific content.

Description of drawings

In order to explain the embodiments of the present application or the technical solutions in the prior art more clearly, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings in the following description are only These are some embodiments of the present application. For those of ordinary skill in the art, other embodiments can be obtained based on these drawings without exerting creative efforts.

Figure 1 is a schematic diagram of table marking in the prior art;

Figure 2 is a schematic flow chart of the first form marking method provided by the embodiment of the present application;

Figure 3 is a schematic diagram of a menu item provided by an embodiment of the present application;

Figure 4a is a schematic diagram of the first form provided by the embodiment of the present application;

Figure 4b is a schematic diagram of the second form provided by the embodiment of the present application;

Figure 5a is a schematic diagram of the third form provided by the embodiment of the present application;

Figure 5b is a schematic diagram of the fourth form provided by the embodiment of the present application;

Figure 6 is a schematic flow chart of the second form marking method provided by the embodiment of the present application;

Figure 7 is a schematic diagram of another menu item provided by an embodiment of the present application;

Figure 8a is a schematic diagram of the fifth form provided by the embodiment of the present application;

Figure 8b is a schematic diagram of the sixth form provided by the embodiment of the present application;

Figure 8c is a schematic diagram of the seventh form provided by the embodiment of the present application;

Figure 8d is a schematic diagram of the eighth form provided by the embodiment of the present application;

Figure 9a is a schematic diagram of the ninth form provided by the embodiment of the present application;

Figure 9b is a schematic diagram of the tenth form provided by the embodiment of the present application;

Figure 10 is a schematic structural diagram of the first form marking device provided by the embodiment of the present application;

Figure 11 is a schematic structural diagram of the second form marking device provided by the embodiment of the present application;

Figure 12 is a schematic structural diagram of an electronic device provided by an embodiment of the present application.

Detailed ways

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative efforts fall within the scope of protection of this application.

In order to count the number of specific unit items in the table, embodiments of the present application provide a table marking method, device, electronic device and storage medium, which are described in detail below.

First, the application scenarios of the embodiments of the present invention are described.

The embodiment of the present invention is applied to the application scenario of counting unit items used to display specific content in a table.

Since in the prior art, unit items are usually marked in order from top to bottom, in the above application scenario, the number of counted unit items cannot statistically display the actual specific content of the unit items in a table. The actual number, the statistical results always include the number of rows or columns in the title or header.

Taking Figure 1 as an example, assuming that the unit items used to display specific content in Figure 1 are: unit items marked as "3", "4" and "5", according to the marking method of the prior art, the counted number of unit items is 5, but the actual number of unit items used to display specific content is 3, so the accuracy of the counted quantity is low.

Refer to Figure 2, which is a schematic flow chart of the first form marking method provided by an embodiment of the present application. This method can be applied to electronic devices such as electronic computers, mobile phones, and tablet computers, and can also be applied to office software such as WPS Office and Microsoft Office. The above table marking method includes the following steps 201 to 203.

Step 201: Determine the unit item to be skipped in the table as the target unit item.

Among them, the unit items include unit rows and/or unit columns.

The above target unit item refers to the unit item to be skipped, that is, the target unit item is a unit item that does not need to be marked. The target unit item may include a target unit row and/or a target unit column. The target unit row is: the unit row of the mark to be skipped, and the target unit column is: the unit column of the mark to be skipped.

In some cases, there are cell rows and/or cell columns in the table that are marked to be skipped. For example: you can skip markers for blank rows and columns in the table; you can skip markers for cell rows and column columns that are used to display titles in the table; you can skip markers for cell rows and column columns that do not display specific content in the table. Pass mark. The above-mentioned cell rows and/or cell columns marked to be skipped can be used as target cell items.

The number of the above target unit items can be one or multiple. When there are multiple target unit items, in one embodiment of the present invention, the target unit items may include: at least two consecutive rows of unit rows and/or at least two rows of continuous unit columns. Of course, the target unit item may also be: at least two discontinuous unit rows and/or at least two discontinuous unit columns.

Specifically, when the target unit item is a unit row and/or unit column used to display a title, it may need to occupy continuous unit rows and/or unit columns. Therefore, when the target unit item includes at least two consecutive rows of unit rows and / Or at least two consecutive rows of cell columns when the full title can be displayed.

The above-mentioned target unit item may be a unit item selected by the user to be marked as skipped. In one implementation, the user can move the cursor to the position of the unit item in the table on the user interface by moving the mouse, and trigger a click operation indicating that the unit item is a unit item to be marked to be skipped. When the client detects the user's click operation, it determines the unit item clicked by the user as the target unit item.

Specifically, the user can select and click the unit item to be skipped in the table, and a preset menu item will pop up. The menu item includes an option button indicating that the selected unit item needs to be skipped. After clicking the option button, it can be determined that the unit item selected by the user is the target unit item to be skipped.

Take Figure 3 as an example. Figure 3 is a schematic diagram of a menu item provided by an embodiment of the present application. As shown in Figure 3, the menu items include option buttons such as "Copy", "Cut", and "Paste". The option button "Skip the current number of rows" indicates that the currently selected unit row needs to be skipped. When the user After selecting a unit row, and then selecting the option button of "Skip the current number of rows" in the above menu item, it can be considered that the user needs the electronic device to skip mark the selected unit row, so the selected unit row can be used as Target unit item.

In another implementation, the user can also input the location of the unit item in the table on the user interface as the unit item to be marked to be skipped. Based on the position input by the user, the client determines the unit item corresponding to the above position in the table, and uses the determined unit item as the target unit item.

Step 202: Determine the first identifiers of other unit items.

The above-mentioned other unit items are: unit items in each unit item of the table except the target unit item. The target unit item is the unit item to be skipped, then the other unit items mentioned above refer to the unit items to be marked.

The above-mentioned first identifier refers to the value of the identifier parameter item of other unit items, that is, the value of the identifier of other unit items. The above-mentioned first identification can be in the form of numerical numbers "1, 2, 3...", so that according to the mark, the number of rows of units other than the target unit row can be directly determined. In addition, the first identification can also be in the form of letters " A, B, C..." form.

In order to improve the efficiency and accuracy of identification determination, in one embodiment of the present invention, the first identification of each other unit item may be determined according to the order in which the other unit items are arranged in the table.

The order in which the above-mentioned other unit items are arranged in the table includes top-to-bottom order and left-to-right order.

Take Figure 4a as an example. In the table shown in Figure 4a, the dark color area is used to display the logo. In the cell rows except the dark color area, the unit behavior located in the third row is: target unit item; located in the first and second rows. The cell behavior of the row, fourth row, and fifth row is: other unit items; among them, the order of other unit items in the table is: first row unit row, second row unit row, fourth row unit row, fifth row unit OK.

In the table shown in Figure 4a, the cell columns located in the third column among the cell columns except the dark color area are: target unit items; the cell columns located in the first, second, fourth and fifth columns : Other unit items; among them, the order of other unit columns in the table is: first column unit column, second column unit column, fourth column unit column, fifth column unit column.

Specifically, when determining the first identifier of each other unit item, the first identifier of each other unit item may be determined sequentially according to the order in which the other unit items are arranged from top to bottom or from left to right in the table.

For example: Taking Figure 4a as an example, when the arrangement order of other unit items in the table is: the first row of unit rows, the second row of unit rows, the fourth row of unit rows, and the fifth row of unit rows, you can follow the above arrangement order, Determine that the identifier of the first row of unit rows is "1", the identifier of the second row of unit rows is "2", the identifier of the fourth row of unit rows is "3", and the identifier of the fifth row of unit rows is "4";

When other unit items are arranged in the table in the following order: the first unit column, the second unit column, the fourth unit column, and the fifth unit column, the unit columns of the first column can be determined according to the above arrangement order. The identifier is "1", the identifier of the second column unit column is "2", the identifier of the fourth column unit column is "3", and the identifier of the fifth column unit column is "4".

In one implementation, when determining the first identification of each other unit item, the identification of the unit item located in the first row/first column among each other unit item may be first determined, based on the determined first row/first column The identifier of the unit item of the column and the arrangement order of each other unit item in the table determine the identifier of each other unit item as the first identifier.

When determining the identity of the unit item located in the first row/first column, the identity input by the user may be used as the identity of the unit item located in the first row/first column. For example: assuming that the identity input by the user is "3 ”, you can use “3” as the identifier of the cell item located in the first row/first column. It is also possible to use the preset identification as the identification of the unit item located in the first row/first column. The above-mentioned preset identification can be set by the staff based on experience. For example, the above-mentioned preset identification can be "1" or "A" .

After determining the identification of the unit item located in the first row/first column, determine the identification of each other unit item in turn according to the order in which the other unit items are arranged in the table.

Following Figure 4a, the identifier of the unit item in the first row is "1". According to the order of arrangement of the other unit items in the table, "2, 3, 4" are used as the identifiers of each other unit item respectively. Among them, the second The identification of the unit row of the row is: "2", the identification of the unit row of the fourth row is: "3", the identification of the unit row of the fifth row is: "4", and the marked table is shown in Figure 4b.

In another embodiment, the preset identification of each unit item before the target unit item can also be used as the first identification of each unit item; and based on the preset identification of the target unit item, each unit after the target unit item is determined. The first identifier of the item.

By default, all cell rows have corresponding preset identifiers, and all unit columns have corresponding preset identifiers.

The target unit item is the unit item to be skipped. The default identification of each unit item after the target unit item needs to be changed, but the default identification of each unit item before the target unit item does not need to be changed. .

Based on this, the preset identification of each unit item before the target unit item can be directly determined as the first identification of each of the above-mentioned unit items.

When determining the identification of each unit item located after the target unit item, the preset identification of the target unit item can be used as the identification of the adjacent unit item located after the target unit item, and then the identification of each unit item located after the target unit item is determined. logo.

For example: Assume that the third row of unit rows is the target unit item, and the default identification of the above-mentioned target unit item is "3". The unit items located after the target unit item include: the fourth row of unit rows, the fifth row of unit rows, the sixth row of unit rows, Then the unit row,..., among which, the fourth row unit row: the adjacent unit item located after the target unit item, so "3" can be determined as the identifier of the fourth row unit row, and then the fifth row unit row can be determined The identifier is: "4", the identifier of the sixth row unit row is: "5",... In this way, according to the arrangement order of each other unit item in the table, the first identification of each other unit item can be quickly determined, which improves the efficiency of identification determination.

Step 203: Mark the identifiers of other unit items as the first identifier.

The identification of the unit item refers to the identification parameter item of the unit item.

Marking the identifiers of other unit items as the first identifier means: marking the values of the identifier parameter items of other unit items in the user interface as the first identifier.

Specifically, the following two situations can be included when marking:

In the first case, the identifiers of each unit item in the table have initial values. In this case, when marking the identifiers of other unit items, the initial values of the identifiers of other unit items in the user interface are updated to First logo.

For example: Assume that the initial value of the identifier of unit item 1 in the table is 1, the initial value of the identifier of unit item 2 is 2, the initial value of the identifier of unit item 3 is 3, and the initial value of the identifier of unit item 4 is 3. is 4, the initial value of the identifier of unit item 5 is 5;

Assume that unit item 2 is the target unit item, then the first identifiers of other unit items after redetermination are: the first identifier of unit item 1 is 1, the first identifier of unit item 3 is 2, and the first identifier of unit item 4 is The identifier is 3, and the first identifier of unit item 5 is 4. According to the first identifier, the initial value of the identifier of each other unit item in the user interface is updated to implement the process of marking the identifiers of other unit items.

In the second case, the value of the identifier of each unit item in the table does not have an initial value. In this case, when marking the identifiers of other unit items, the identifiers of other unit items in the user interface are marked. The value is determined directly as the first identifier.

For example: Assume that the table includes unit item 1, unit item 2, unit item 3, unit item 4, and unit item 5. Among them, unit item 2 is the target unit item, and the first identifiers of the other unit items after redetermination are: The first identifier of unit item 1 is 1, the first identifier of unit item 3 is 2, the first identifier of unit item 4 is 3, the first identifier of unit item 5 is 4, and the other unit items in the table in the user interface are The value of the identifier is marked as the first identifier to realize the process of marking the identifiers of other unit items.

Specifically, when marking other cell rows, you can mark in the leftmost cell in other cell rows; when marking other cell columns, you can mark in the topmost cell in other cell columns. .

Taking Figure 4b as an example, the unit row in the third row in Figure 4b is the target unit row, and the other unit rows are: unit rows except the target unit row. As can be seen from Figure 4b, the first row of unit rows is marked: " 1", the second row of unit rows is marked as: "2", the fourth row of unit rows is marked as: "3", and the fifth row of unit rows is marked as: "4".

Based on the marked first identifier, the number of cell items in the table can be conveniently counted. As shown in Figure 4b, the number of unit items used to display specific content in the table can be directly determined to be 10.

The above target unit item may be a unit row/unit column used to display the title, and the target unit item is a unit item to be skipped. That is, when the solution provided in this embodiment is used for marking, the unit item used to display the title is not marked. The cell rows/columns are marked so that the number of cell items used to display specific content can be easily counted.

It can be seen from the above that when applying the solution provided by this embodiment for table marking, the unit rows and/or unit columns that are not expected to be marked can be skipped and marked instead of marking all unit rows and/or unit columns. Based on the The marked information can conveniently count the number of unit items used to display specific content in the table.

In one embodiment of the present invention, the determination of the first identifier in the above step 202 can also be implemented in the following two ways.

The first way is to determine the first identification of each first unit item according to the arrangement order of each first unit item in the table, and to determine the first identification of each second unit item according to the arrangement order of each second unit item in the table. The first identifier of the two-unit item.

The second method: determine the first identifier of each first unit item according to the order in which the first unit items are arranged in the table; determine the first identifier of each second unit item in accordance with the order in which the second unit items are arranged in the table. A logo.

The above-mentioned first unit items are: each unit item in the reverse direction represented by the type of the target unit item. The above-mentioned second unit items are: each unit item in the positive direction represented by the type of the target unit item.

The types of target unit items include unit rows and unit columns.

When the type of the target unit item is a unit row, the direction represented by the type of the target unit item may be: the vertical direction starting from the target unit item. Furthermore, since the unit item identifiers of the table usually increase sequentially from top to bottom. Therefore, the positive direction represented by the type of the target unit item is: the vertical downward direction starting from the target unit item, and the second unit item is: each unit row in the vertical downward direction starting from the target unit item; the target unit The reverse direction represented by the type of item is: starting from the target unit item in the vertical upward direction, and the first unit item is: starting from the target unit item in the vertical upward direction to each unit row.

Take Figure 5a as an example. In Figure 5a, the unit item marked as empty is the target unit item. The direction of the vertical downward arrow is the vertical downward direction starting from the target unit item, so the direction of the vertical downward arrow is the target. The positive direction of the direction represented by the type of unit item. The second unit item is: each unit row in the vertical downward direction starting from the target unit item;

The direction of the vertical upward arrow is the vertical upward direction starting from the target unit item, so the direction of the vertical upward arrow is the reverse of the direction represented by the type of the target unit item. The first unit item is: starting from the target unit item Go straight up each row of cells.

When the type of the target unit item is a unit column, the direction represented by the type of the target unit item may be: the horizontal direction starting from the target unit item. Furthermore, since the unit item identifiers of the table usually increase sequentially from left to right. Therefore, the positive direction represented by the type of the target unit item is: starting from the target unit item in the horizontal direction to the right, and the second unit item is: starting from the target unit item in the horizontal direction to the right direction of each unit column; the target unit item The reverse direction represented by the type is: starting from the target unit item in the horizontal direction to the left, and the first unit item is: starting from the target unit item in the horizontal direction to the left direction of each unit column.

Take Figure 5b as an example. In Figure 5b, the unit item marked empty is the target unit item. The direction of the horizontal right arrow is from the target unit item to the horizontal right direction, so the direction of the horizontal right arrow is the target unit item. The forward direction of the direction represented by the type, the second unit item is: each unit column in the horizontal right direction starting from the target unit item;

The direction of the horizontal left arrow is the horizontal left direction starting from the target unit item, so the direction of the horizontal left arrow is the reverse of the direction represented by the type of the target unit item. The first unit item is: starting horizontally from the target unit item Column of cells in the left direction.

The specific process of determining the first identifier is different in the above-mentioned first way and the second way, and will be described respectively below.

When using the above first method to determine the first identifier, first, determine the first identifier of each first unit item according to the order in which the first unit items are arranged in the table. , when determining the first identifier of each second unit item, the unit item located in the first row/column of the second unit item can be determined based on the first identifier of the unit item located in the last row/column of each first unit item. The first identifier is then determined according to the order in which the second unit items are arranged in the table.

For example: Assume that the first unit item includes: the first row of unit rows, the second row of unit rows, and the third row of unit rows, and the second unit item includes: the fifth row of unit rows, the sixth row of unit rows, and the seventh row of unit rows. When determining the first identifier of the first unit item, according to the arrangement order of each first unit item in the table, it can be determined that the identifier of the first unit row is "1" and the identifier of the second unit row is "2" , The identifier of the third row unit row is "3";

When determining the first identifier of the second unit item, since the unit behavior of the third row: the unit item in the last row of the first unit item is identified as "3", the unit behavior of the fifth row: the unit item of the second unit item is located at the For a row of unit items, according to the identification of the third unit row, the identification of the fifth unit row can be determined to be "4", and then the identification of the sixth unit row can be determined to be "5", and the identification of the seventh unit row can be determined is "6".

In this way, since the identifier of the second unit item is determined based on the identifier of the first unit item, that is, the identifiers of the first unit item and the second unit item are related, which can satisfy the application that requires overall statistics of the number of data in the table. scenarios to better meet the actual needs of users.

When the second method above is used to determine the first identifier, the first identifier of each first unit item is determined according to the order in which the first unit items are arranged in the table; and according to the order in which the second unit items are arranged in the table , determine the first identifier of each second unit item.

For example: Following the above example, when determining the first identifier of the first unit item, according to the order of arrangement of each first unit item in the table, the identifier of the first row of unit rows can be determined to be "1", and the identifier of the second row of unit rows can be determined as "1". The identifier of the unit row is "2", and the identifier of the third unit row is "3"; when determining the first identifier of the second unit item, the fifth unit row can be determined according to the order in which the second unit items are arranged in the table. The identifier of the unit row is "1", the identifier of the sixth unit row is "2", and the identifier of the seventh unit row is "3".

In this case, it can be understood that the table contains multiple sub-tables. Since the target unit item is not identified, and the first identification of the first unit item and the second unit item is determined separately, it is possible to conveniently identify the first unit item and the second unit item. The number of unit items is counted.

Referring to Figure 6, Figure 6 is a schematic flowchart of the second form marking method provided by the embodiment of the present application. After the above step 203, the following steps 204-206 may also be included.

Step 204: Determine the re-marked unit item in the marked table as the reference unit item.

In some cases, the labels marked in the table cannot meet the user's needs, or there are errors in the labels, etc. The user can select the unit items that need to be relabeled in the marked table.

In one implementation, the user can move the cursor to the location of the unit item in the table on the user interface by moving the mouse, and trigger a click operation to indicate that the unit item is a relabeled unit item. When the client detects the user's click operation, it determines the unit item clicked by the user as a reference unit item.

Specifically, the user can select and click on the re-marked unit item in the table, and a preset menu item will pop up. The menu item contains option buttons indicating that the selected unit item needs to be re-marked. After detecting that the user has clicked on the above option button After the click operation, it can be determined that the unit item selected by the user is the relabeled reference unit item.

Taking FIG. 7 as an example, FIG. 7 is a schematic diagram of another menu item provided by an embodiment of the present application. As shown in Figure 7, the menu items include option buttons such as "Copy", "Cut", and "Paste", among which the option button "Start identifying from the current row" indicates that the currently selected unit row needs to be re-identified. When the user selects the unit row and then selects the option button of "Start labeling from the current row" in the above menu item, it can be considered that the user needs the electronic device to re-label the selected unit row, so the current fifth row can be used as Reference unit item.

In another implementation, the user can input the location of the unit item in the table on the user interface as the relabeled unit item.

In this case, when determining the above-mentioned reference unit item, based on the location of the unit item in the table input by the user, the unit item corresponding to the above-mentioned position can be determined in the table, and the determined unit item can be used as the reference unit item. .

Step 205: When the reference unit item is located before the target unit item, determine the second identifier of the reference unit item and each third unit item according to the order in which the reference unit item and each third unit item are arranged in the table, and set The identifiers of the reference unit item and each third unit item are marked as second identifiers.

The above-mentioned third unit item is: the unit item between the reference unit item and the target unit item.

Take Figure 8a as an example. The unit item marked empty in Figure 8a is the target unit item, and the unit item marked 3 is the reference unit item. It can be seen that the reference unit item is located before the target unit item, and the reference unit item and the target unit item are Each unit item in between is the third unit item.

When determining the identification of the reference unit item and each third unit item, the second identification of the reference unit item may be determined first, based on the determined identification of the reference unit item and the positions of the reference unit item and each third unit item in the table. Arrange the order, determine the identifier of each third unit item, and use the determined identifier of the reference unit item and the identifier of the third unit item as the second identifier. .

When determining the identifier of the reference unit item, the identifier input by the user may be used as the identifier of the reference unit item. For example, assuming that the identifier input by the user is "3", "3" may be used as the identifier of the reference unit item. It is also possible to use a preset identifier as the identifier of the reference unit item. The above-mentioned preset identifier can be set by the staff based on experience. For example, the above-mentioned preset identifier can be "1" or "A".

After determining the identification of the reference unit item, according to the arrangement order of the reference unit item and each third unit item in the table, the number of unit item intervals between each third unit item and the reference unit item can be determined, based on the reference unit item The identification of each third unit item and the number of unit item intervals corresponding to each third unit item can determine the identification of each third unit item.

Following Figure 8a, the reference unit item is the third unit row, the target unit item is the seventh unit row, and the third unit items are: the fourth unit row, the fifth unit row, and the sixth unit row. Assume The identifier of the redetermined reference unit item is "1", and the number of unit row intervals between the fourth row of unit rows and the third row of unit rows is 1, so the identifier of the fourth row of unit rows can be calculated as: 1+1 =2, that is, "2". According to this method, it can be calculated that the identifier of the fifth row of unit rows is: "3", and the identifier of the sixth row of unit rows is "4".

After the second identifiers of the reference unit item and each third unit item are determined, the identifiers of the reference unit item and each third unit item are marked as the above-mentioned second identifiers.

Specifically, the identification of the unit item before the reference unit item can be determined based on the actual needs of the user. When the user triggers a clearing operation on the identification of the unit item before the reference unit item in the user interface, the identification of the unit item before the reference unit item can be determined. Clear the identifiers of each unit item before the reference unit item.

Moreover, the identification of the unit items after the target unit item can keep the marked identification unchanged; the identification of each unit item after the target unit item can also be calculated based on the identification of the adjacent unit items before the target unit item, and the identification of each unit item after the target unit item can be calculated. The computed identity of the identity relabeling of each cell item after the target cell item.

For example: assuming that the identifier of the adjacent unit item before the target unit item is 4, it can be calculated that the identifiers of each unit item after the target unit item are: 5, 6, 7, 8, 9... in order.

Taking Figure 8b as an example, Figure 8b is a schematic diagram of a table obtained by marking the identification of the reference unit item and each third unit item in Figure 8a as the third identification. From Figure 8b, it can be seen that the unit items before the reference unit item are The logo has been cleared.

Comparing Figure 8b and Figure 8a, the identification of the reference unit item is marked as "1", the identification of each third unit item is marked as "2", "3", and "4" in order, and the unit item before the reference unit item is are all empty, and the unit items after the target unit item are marked "5" and "6".

Of course, if the user does not trigger the above clearing operation, the identifier of the unit item located before the reference unit item can be kept unchanged.

Step 206: When the reference unit item is located after the target unit item, determine the identification of the reference unit item and each fourth unit item according to the order in which the reference unit item and each fourth unit item are arranged in the table, and assign the reference unit item to The identifier of the item and each fourth unit item is marked as a third identifier.

The above-mentioned fourth unit item is: the unit item after the reference unit item.

Take Figure 8c as an example. The unit item marked empty in the rectangular box in Figure 8c is the target unit item, and the unit item marked 4 is the reference unit item. You can see that the reference unit item is located after the target unit item and after the reference unit item. Each unit item of is the fourth unit item.

When determining the identification of the reference unit item and each fourth unit item, the identification of the reference unit item may be determined first, based on the determined identification of the reference unit item and the arrangement order of the reference unit item and each fourth unit item in the table. , determine the identification of each fourth unit item, and use the identification of the reference unit item and the identification of the fourth unit item as the third identification.

For a specific method of determining the identification of the reference unit item, please refer to the method of determining the identification of the reference unit item in step 204.

After determining the identification of the reference unit item, according to the arrangement order of the reference unit item and each fourth unit item in the table, the number of unit item intervals between each fourth unit item and the reference unit item can be determined, based on the reference unit item The identification of each fourth unit item and the number of unit item intervals corresponding to each fourth unit item can be determined.

Following Figure 8c, the reference unit item is the fifth unit row, the target unit item is the third unit row, and the fourth unit items are: the sixth unit row, the seventh unit row, and the eighth unit row. Assume The identifier of the redetermined reference unit item is "1", and the number of unit row intervals between the sixth unit row and the fifth row unit row is 1, so the identifier of the sixth unit row can be calculated as: 1+1＝ 2, that is, "2". According to this method, the identifier of the seventh unit row can be calculated as: "3", and the identifier of the eighth unit row is "4".

After the third identifiers of the reference unit item and each fourth unit item are determined, the identifiers of the reference unit item and each fourth unit item are marked as the above-mentioned third identifiers.

Specifically, the identification of the unit items located between the target unit item and the reference unit item can be determined based on the actual needs of the user. When the user triggers the identification of the unit item between the target unit item and the reference unit item in the user interface, In the case of the clearing operation of the identifier, the identifier of the unit item between the target unit item and the reference unit item can be cleared.

Of course, if the user does not trigger the above clearing operation, the identifier of the unit item located between the target unit item and the reference unit item can be left unchanged.

Taking Figure 8d as an example, Figure 8d is a schematic diagram of a table obtained by marking the identification of the reference unit item and each fourth unit item in Figure 8c as the third identification. From Figure 8d, it can be seen that the reference unit item and the target unit item are The identifiers of the unit items between have been cleared.

Comparing Figure 8d and Figure 8c, the identification of the reference unit item is marked as "1", the identification of each fourth unit item is marked as "2", "3", "4", and "5" in order, and the reference unit item The identifier of the cell item between the target cell item and the target cell item is empty.

In this way, when the unit item in the table needs to be re-marked, the reference unit item that needs to be re-marked is determined, thereby re-determining the second unit item after the reference unit item, or the first unit item between the reference unit item and the target unit item. The first identifier of the unit item to meet the need to re-label the unit items in the table.

In one embodiment of the present invention, upon receiving the identification recovery operation triggered by the user in the user interface, the preset identification of each unit item in the table can also be determined, and the identification of each unit item can be updated to the preset identification.

Under normal circumstances, the identification of each cell item in the table has a preset identification. When the user needs to restore the identification of each unit item in the table, the user can trigger the above identification restoration operation. The above identification restoration operation is used to instruct the restoration of the identification of each unit item in the table.

Specifically, a logo recovery button can be set in the user interface, and by detecting the user's click operation that triggers the logo recovery button, it is determined that the user needs to restore the logo of each unit item of the table. In this case, the preset identification of each unit item may be determined, and the identification of each unit item may be updated to the preset identification.

Take Figure 9a and Figure 9b as an example. In Figure 9a, the fifth row of unit rows is the target unit row. The identification of each unit row except the fifth row of unit rows is from top to bottom: "1,2,3,4,5, 6,7,8,9", the identification of each unit item shown in Figure 9b is: the identification of each unit item after restoration on the basis of Figure 9a, the identification of each unit row from top to bottom is: "1,2 ,3,4,5,6,7,8,9,10”.

In this way, the identification of each unit item in the marked table can be restored, which meets the need to restore the identification of the unit item.

In one embodiment of the present application, when determining the above target unit item, the unit items within a preset range in the table may be traversed to find unit items that meet the preset skip mark conditions as the target unit item.

The skip mark condition includes at least one of the following conditions: blank rows, blank columns, cell rows for displaying titles, and cell columns for displaying titles.

There are no characters in all cells in blank rows and columns;

There are cells in the cell row used to display the title and the cell column used to display the title used to display the title content.

Specifically, for blank rows, blank columns, cell rows used to display titles, cell columns used to display titles, etc., the marking can be skipped, that is, no marking is performed. Therefore, the unit item that meets the above conditions can be found in the table, and the found unit item is used as the target unit item to be skipped.

In one embodiment of the present application, the above-mentioned skip marking condition may be a preset condition, or may be a user-defined skip marking condition.

Specifically, the electronic device can provide a condition input box and obtain the user's input of the condition in the condition input box as the skip mark condition. You can also provide multiple candidate conditions, obtain one or more conditions selected by the user from multiple candidate conditions, and combine them to obtain the skip mark condition.

Referring to Figure 10, Figure 10 is a schematic structural diagram of a first form marking device provided by an embodiment of the present application. The device includes the following modules 1001-1003:

The first unit item determination module 1001 is used to determine the unit item to be skipped in the table as the target unit item, where the unit item includes a unit row and/or a unit column;

The first identification determination module 1002 is used to determine the first identification of other unit items, where the other unit items are: unit items in each unit item of the table except the target unit item;

The identification marking module 1003 is used to mark the identifications of the other unit items as the first identification.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each other unit item according to the order in which the other unit items are arranged in the table.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each first unit item according to the order in which the first unit items are arranged in the table, wherein the first The unit items are: each unit item in the opposite direction represented by the type of the target unit item; according to the order of arrangement of each second unit item in the table, and according to the first identification of each first unit item, determine The first identifier of each second unit item, wherein the second unit item is: each unit item in the forward direction represented by the type of the target unit item.

In one embodiment of the present invention, the above-mentioned first identification determining module is specifically used to determine the first identification of each first unit item according to the order in which the first unit items are arranged in the table, wherein the first The unit items are: each unit item in the opposite direction represented by the type of the target unit item; according to the order of arrangement of the second unit items in the table, the first identification of each second unit item is determined, wherein, The second unit item is: each unit item in the positive direction represented by the type of the target unit item.

Referring to Figure 11, Figure 11 is a schematic structural diagram of a second form marking device provided by an embodiment of the present application. The above device also includes the following modules 1004-1006.

The second unit item determination module 1004 is used to determine the re-marked unit items in the marked table as reference unit items;

The second identification determination module 1005 is used to determine the reference unit according to the order in which the reference unit item and each third unit item are arranged in the table when the reference unit item is located before the target unit item. item and the second identifier of each third unit item, and mark the identifier of the reference unit item and each third unit item as the second identifier, wherein the third unit item is: the reference unit item The unit item between the target unit item;

The third identification determination module 1006 is configured to determine the reference unit according to the order in which the reference unit item and each fourth unit item are arranged in the table when the reference unit item is located after the target unit item. item and the third identifier of each fourth unit item, and mark the identifier of the reference unit item and each fourth unit item as the third identifier, wherein the fourth unit item is: the reference unit item subsequent unit items.

In one embodiment of the present invention, the above device further includes:

The identification update module is configured to determine the preset identification of each unit item in the table and update the identification of each unit item to the preset identification when receiving an identification recovery operation triggered by the user in the user interface.

In one embodiment of the present invention, the target unit item includes: at least two consecutive rows of units and/or at least two rows of continuous unit columns.

In one embodiment of the present invention, the above-mentioned first unit item determination module is specifically used to traverse the unit items within a preset range in the table and find the unit item that meets the preset skip mark condition as the target unit item, where, The skip mark condition includes at least one of the following conditions: blank rows, blank columns, unit rows for displaying titles, and unit columns for displaying titles.

The embodiment of the present application also provides an electronic device, as shown in Figure 12, including a processor 1201, a communication interface 1202, a memory 1203, and a communication bus 1204. The processor 1201, the communication interface 1202, and the memory 1203 communicate through the communication bus 1204. complete mutual communication,

Memory 1203, used to store computer programs;

The processor 1201 is used to implement the steps of the table marking method when executing the program stored in the memory 1203.

The communication bus mentioned in the above-mentioned electronic equipment may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The communication bus can be divided into address bus, data bus, control bus, etc. For ease of presentation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus.

The communication interface is used for communication between the above-mentioned electronic devices and other devices.

The memory may include random access memory (Random Access Memory, RAM) or non-volatile memory (Non-Volatile Memory, NVM), such as at least one disk memory. Optionally, the memory may also be at least one storage device located far away from the aforementioned processor.

The above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (Network Processor, NP), etc.; it can also be a digital signal processor (Digital SignalProcessing, DSP), an application-specific integrated circuit (Application Specific Integrated Circuit, ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, and discrete hardware components.

In yet another embodiment provided by this application, a computer-readable storage medium is also provided. A computer program is stored in the computer-readable storage medium. When the computer program is executed by a processor, any of the above table marking methods is implemented. A step of.

In yet another embodiment provided by this application, a computer program product containing instructions is also provided, which when run on a computer causes the computer to execute any of the table marking methods in the above embodiments.

In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented using software, it may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the processes or functions described in the embodiments of the present application are generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, e.g., the computer instructions may be transferred from a website, computer, server, or data center Transmission to another website, computer, server or data center by wired (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (such as infrared, wireless, microwave, etc.) means. The computer-readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains one or more available media integrated. The available media may be magnetic media (eg, floppy disk, hard disk, magnetic tape), optical media (eg, DVD), or semiconductor media (eg, Solid State Disk (SSD)), etc.

It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that these entities or operations are mutually exclusive. any such actual relationship or sequence exists between them. Furthermore, the terms "comprises," "comprises," or any other variations thereof are intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus that includes a list of elements includes not only those elements, but also those not expressly listed other elements, or elements inherent to the process, method, article or equipment. Without further limitation, an element defined by the statement "comprises a..." does not exclude the presence of additional identical elements in a process, method, article, or apparatus that includes the stated element.

Each embodiment in this specification is described in a related manner. The same and similar parts between the various embodiments can be referred to each other. Each embodiment focuses on its differences from other embodiments. In particular, for the device embodiments, electronic equipment embodiments, computer-readable storage medium embodiments, and computer program product embodiments, since they are basically similar to the method embodiments, the descriptions are relatively simple. For relevant details, please refer to the method embodiments. Partial description is enough.

The above descriptions are only preferred embodiments of the present application and are not intended to limit the protection scope of the present application. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of this application are included in the protection scope of this application.

Claims (10)

1. A table marking method, characterized in that the method includes: Determine the target unit item to be skipped in the table, where the unit item includes a unit row and/or a unit column; Determine the first identification of other unit items, wherein the other unit items are: unit items in each unit item of the table except the target unit item; Mark the identifiers of the other unit items as the first identifier; The method also includes: Determine the re-marked unit items in the marked table as reference unit items; In the case where the reference unit item is located before the target unit item, the reference unit item and the third unit item of each third unit item are determined according to the order in which the reference unit item and each third unit item are arranged in the table. two identifiers, and mark the identifiers of the reference unit item and each third unit item as the second identifier, wherein the third unit item is: the link between the reference unit item and the target unit item. unit item; When the reference unit item is located after the target unit item, the reference unit item and the fourth unit item are determined according to the order in which the reference unit item and each fourth unit item are arranged in the table. Three identifiers, and mark the identifiers of the reference unit item and each fourth unit item as the third identifier, where the fourth unit item is: the unit item after the reference unit item. 2. The method according to claim 1, characterized in that determining the first identification of other unit items includes: The first identifier of each other unit item is determined according to the order in which the other unit items are arranged in the table. 3. The method according to claim 2, wherein determining the first identifier of each other unit item according to the order in which the other unit items are arranged in the table includes: According to the arrangement order of each first unit item in the table, the first identifier of each first unit item is determined, wherein the first unit item is: each unit item in the opposite direction represented by the type of the target unit item. unit item; According to the arrangement order of each second unit item in the table, and according to the first identification of each first unit item, the first identifier of each second unit item is determined, wherein the second unit item is: Each unit item in the positive direction represented by the type of the target unit item. 4. The method according to claim 2, wherein determining the first identifier of each other unit item according to the order in which the other unit items are arranged in the table includes: According to the arrangement order of each first unit item in the table, the first identifier of each first unit item is determined, wherein the first unit item is: each unit item in the opposite direction represented by the type of the target unit item. unit item; According to the arrangement order of each second unit item in the table, the first identifier of each second unit item is determined, wherein the second unit item is: each direction in the forward direction represented by the type of the target unit item. unit item. 5. The method according to any one of claims 1-4, characterized in that the method further includes: When receiving the identification recovery operation triggered by the user in the user interface, the preset identification of each unit item in the table is determined, and the identification of each unit item is updated to the preset identification. 6. The method according to any one of claims 1 to 4, characterized in that the target unit item includes: at least two consecutive rows of units and/or at least two consecutive rows of unit columns. 7. The method according to any one of claims 1-4, characterized in that the determination of the unit items to be skipped in the table includes: Traverse the unit items within the preset range in the table and find the unit item that satisfies the preset skip mark condition as the target unit item, wherein the skip mark condition includes at least one of the following conditions: blank row, blank line Column, row of cells for displaying titles, column of cells for displaying titles. 8. A form marking device, characterized in that the device includes: The first unit item determination module is used to determine the unit item to be skipped in the table as the target unit item, where the unit item includes a unit row and/or a unit column; The first identification determination module is used to determine the first identification of other unit items, wherein the other unit items are: unit items in each unit item of the table except the target unit item; An identification marking module, used to mark the identification of the other unit items as the first identification; The device also includes: The second unit item determination module is used to determine the re-marked unit items in the marked table as reference unit items; The second identification determination module is used to determine the reference unit item according to the arrangement order of the reference unit item and each third unit item in the table when the reference unit item is located before the target unit item. and the second identification of each third unit item, and the identification of the reference unit item and each third unit item is marked as the second identification, wherein the third unit item is: the reference unit item and The unit items between the target unit items; A third identification determination module, configured to determine the reference unit item according to the order in which the reference unit item and each fourth unit item are arranged in the table when the reference unit item is located after the target unit item. and the third identification of each fourth unit item, and mark the identification of the reference unit item and each fourth unit item as the third identification, wherein the fourth unit item is: after the reference unit item unit item. 9. An electronic device, characterized in that it includes a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory complete communication with each other through the communication bus; Memory, used to store computer programs; The processor is used to implement the method steps described in any one of claims 1-7 when executing a program stored in the memory. 10. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, and when the computer program is executed by a processor, the method steps of any one of claims 1-7 are implemented. .