CN111209800B - Table content change identification method and device, storage medium and electronic equipment - Google Patents
Table content change identification method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN111209800B CN111209800B CN201911340773.3A CN201911340773A CN111209800B CN 111209800 B CN111209800 B CN 111209800B CN 201911340773 A CN201911340773 A CN 201911340773A CN 111209800 B CN111209800 B CN 111209800B
- Authority
- CN
- China
- Prior art keywords
- cell
- cell identifier
- picture
- change
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06V—IMAGE OR VIDEO RECOGNITION OR UNDERSTANDING
- G06V30/00—Character recognition; Recognising digital ink; Document-oriented image-based pattern recognition
- G06V30/40—Document-oriented image-based pattern recognition
Landscapes
- Engineering & Computer Science (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Artificial Intelligence (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Multimedia (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosure relates to a table content change identification method, a table content change identification device, a storage medium and electronic equipment. The method comprises the following steps: acquiring a first cell identifier corresponding to a target picture to be identified in a first table, wherein the cell identifier comprises a title identifier of a row where the cell is located and a title identifier of a column where the cell is located; determining whether a second cell identifier matched with the first cell identifier exists in a second table according to the first cell identifier, wherein the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table; and if the second cell identifier exists, determining the change attribute of the target picture according to the association information of the second cell identifier. Therefore, the comparison is not needed manually, the labor cost is saved, and the change attribute of the target picture in the first table relative to the second table can be accurately determined.
Description
Technical Field
The disclosure relates to the field of data processing, and in particular relates to a table content change identification method, a table content change identification device, a storage medium and electronic equipment.
Background
The form can clearly show and record information. In the form, pictures are typically inserted, which can be used as markers and improve the visibility of the form. When editing a table, the contents of the table are typically adjusted, such as deleting rows, deleting columns, adding rows, adding columns, etc. The pictures in the table can also change along with the adjustment of the table content, such as adding and deleting pictures and the like. At present, a manual identification mode is generally adopted to determine which changes occur in the images in the pre-change form and the post-change form, so that the efficiency is low, and accurate identification cannot be ensured.
Disclosure of Invention
The invention aims to provide a table content change identification method, a table content change identification device, a storage medium and electronic equipment, and change attributes of pictures before and after table change can be accurately determined.
To achieve the above object, in a first aspect, there is provided a table content change identification method, the method comprising: acquiring a first cell identifier corresponding to a target picture to be identified in a first table, wherein the cell identifier comprises a title identifier of a row where the cell is located and a title identifier of a column where the cell is located; determining whether a second cell identifier matched with the first cell identifier exists in a second table according to the first cell identifier, wherein the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table; and if the second cell identifier exists, determining the change attribute of the target picture according to the association information of the second cell identifier.
Optionally, the determining the change attribute of the target picture according to the association information of the second cell identifier includes: in the case that the second unit cell identification is associated with picture information: comparing the picture information of the target picture with the picture information associated with the second cell identifier; if the comparison result indicates that the picture information of the target picture is different from the picture information associated with the second cell identifier, determining that the change attribute of the target picture is replacement; and if the comparison result indicates that the picture information of the target picture is the same as the picture information associated with the second cell identifier, determining that the change attribute of the target picture is unchanged.
Optionally, the determining the change attribute of the target picture according to the association information of the second cell identifier includes: in the case that the second cell identification is not associated with picture information: if the first table is a pre-change table, determining that the change attribute of the target picture is deletion; and if the first table is the changed table, determining that the change attribute of the target picture is newly added.
Optionally, the method further comprises: if the second cell identifier does not exist, then: if the first table is a table before changing, determining that the changing attribute of the cell corresponding to the first cell identifier is deleting; and if the first table is the changed table, determining that the change attribute of the cell corresponding to the first cell identifier is newly added.
Optionally, the cell identifier corresponding to the picture in the table is: and the center coordinates of the picture are marked by the cells of the cells.
Optionally, the method further comprises: acquiring a third cell identifier corresponding to a target cell filling value to be identified in the first table; determining whether a fourth cell identifier matched with the third cell identifier exists in the second table according to the third cell identifier; and if the fourth cell identifier exists, determining the change attribute of the target cell filling value according to the cell filling value corresponding to the fourth cell identifier.
Optionally, the determining, according to the cell filling value corresponding to the fourth cell identifier, the change attribute of the target cell filling value includes: comparing the target cell filling value with a cell filling value corresponding to the fourth cell identifier; if the comparison result indicates that the filling value of the target cell is different from the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is replacement; and if the comparison result indicates that the filling value of the target cell is the same as the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is unchanged.
In a second aspect, there is provided a table content change identification apparatus, the apparatus including: the first acquisition module is used for acquiring a first cell identifier corresponding to a target picture to be identified in the first table, wherein the cell identifier comprises a title identifier of a row where the cell is located and a title identifier of a column where the cell is located; a first determining module, configured to determine, according to the first cell identifier, whether a second cell identifier that matches the first cell identifier exists in a second table, where the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table; and the second determining module is used for determining the change attribute of the target picture according to the association information of the second cell identifier if the second cell identifier exists.
Optionally, the second determining module is configured to, in a case where the second unit cell identifier is associated with picture information: comparing the picture information of the target picture with the picture information associated with the second cell identifier; if the comparison result indicates that the picture information of the target picture is different from the picture information associated with the second cell identifier, determining that the change attribute of the target picture is replacement; and if the comparison result indicates that the picture information of the target picture is the same as the picture information associated with the second cell identifier, determining that the change attribute of the target picture is unchanged.
Optionally, the second determining module is configured to, in a case where the second cell identifier is not associated with picture information: if the first table is a pre-change table, determining that the change attribute of the target picture is deletion; and if the first table is the changed table, determining that the change attribute of the target picture is newly added.
Optionally, the apparatus further includes a third determining module, configured to, if the second cell identifier does not exist: if the first table is a table before changing, determining that the changing attribute of the cell corresponding to the first cell identifier is deleting; and if the first table is the changed table, determining that the change attribute of the cell corresponding to the first cell identifier is newly added.
Optionally, the apparatus further comprises: the second acquisition module is used for acquiring a third cell identifier corresponding to a target cell filling value to be identified in the first table; a fourth determining module, configured to determine, according to the third cell identifier, whether a fourth cell identifier that matches the third cell identifier exists in the second table; and a fifth determining module, configured to determine, if the fourth cell identifier exists, a modification attribute of the target cell filling value according to a cell filling value corresponding to the fourth cell identifier.
Optionally, the fifth determining module is configured to compare the target cell filling value with a cell filling value corresponding to the fourth cell identifier; if the comparison result indicates that the filling value of the target cell is different from the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is replacement; and if the comparison result indicates that the filling value of the target cell is the same as the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is unchanged.
In a third aspect, there is provided a computer readable storage medium having stored thereon a computer program which when executed by a processor implements the steps of the method provided by the first aspect of the present disclosure.
In a fourth aspect, there is provided an electronic device comprising: a memory having a computer program stored thereon; a processor for executing the computer program in the memory to implement the steps of the method provided by the first aspect of the present disclosure.
Through the technical scheme, the association relation between the pictures in the table and the cells in the table is established, and the first cell identifier corresponding to the target picture in the first table is the identifier of the cell with the association relation with the target picture. If a second cell identifier matched with the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the association information of the second cell identifier. Therefore, the comparison is not needed manually, the labor cost is saved, and the change attribute of the target picture in the first table relative to the second table can be accurately determined. And the cell identification is defined according to the title identification of the row where the cell is located and the title identification of the column where the cell is located, so that the cell identification can uniquely and accurately represent the meaning of the content in the cell, and the corresponding cell content can be accurately positioned through the cell identification no matter how the position of the row and the column in the table is adjusted, thereby providing a reliable and accurate index basis for the follow-up judgment of whether the cell content is changed or not.
Additional features and advantages of the present disclosure will be set forth in the detailed description which follows.
Drawings
The accompanying drawings are included to provide a further understanding of the disclosure, and are incorporated in and constitute a part of this specification, illustrate the disclosure and together with the description serve to explain, but do not limit the disclosure. In the drawings:
FIG. 1 is a flow chart illustrating a method of identifying changes to table contents according to an exemplary embodiment.
Fig. 2 shows a schematic diagram of a table.
Fig. 3 is a schematic diagram showing a correspondence relationship between cell identifiers and pictures in the table shown in fig. 2.
Fig. 4 shows a schematic diagram of another table.
Fig. 5 shows a schematic diagram of the correspondence between cell identifiers and pictures in the table shown in fig. 4.
Fig. 6 is a block diagram illustrating a table content change identification apparatus according to an exemplary embodiment.
Fig. 7 is a block diagram of an electronic device, according to an example embodiment.
Fig. 8 is a block diagram of an electronic device, according to another example embodiment.
Detailed Description
Specific embodiments of the present disclosure are described in detail below with reference to the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating and illustrating the disclosure, are not intended to limit the disclosure.
FIG. 1 is a flow chart illustrating a method of identifying changes to table contents according to an exemplary embodiment. The method can be applied to electronic equipment with processing capability, such as a server, a terminal and the like. The server may be, for example, a cloud server, a form management server, or the like. The terminal can be, for example, a smart phone, a tablet computer, a notebook computer and other devices. As shown in fig. 1, the method may include S101-S103.
In S101, a first cell identifier corresponding to a target picture to be identified in a first table is obtained.
Fig. 2 shows a schematic diagram of a table, as shown in fig. 2, in which letters a-J may be used as fill values in a cell. It should be noted that, the filling values in the cells may also be in the form of numbers, character strings, chinese characters, or combinations thereof, and the table only shows examples in which the filling values are letters, but does not limit the embodiments of the present disclosure. Also included in the table shown in fig. 2 are picture 201, picture 202, picture 203, picture 204, and picture 205. If the table in fig. 2 is used as the first table, the target picture to be identified may be any one of the pictures 201-205.
Each cell in the table has a respective cell identification. Wherein the table includes row headers of at least one row and column headers of at least one column, and the header identifications of the rows and the header identifications of the columns in the table have uniqueness. In the present disclosure, when defining the cell identifier, the cell identifier may include a header identifier of a row where the cell is located and a header identifier of a column where the cell is located, for example, the cell identifier may be represented by (Xm, yn), where Xm may represent a header identifier of an mth column where the cell is located, and Yn may represent a header identifier of an nth row where the cell is located. Illustratively, in the table shown in FIG. 2, the cell of cell 206 is identified as (X3, Y4).
For each picture in the table, an association relationship between the picture and the cell may be established. For example, the association relationship between the picture and the cell can be established through the cell where the center coordinate of the picture is located, and the cell identifier corresponding to the picture is the cell identifier of the cell where the center coordinate of the picture is located. For example, if the center coordinate of the picture 203 falls in the cell 206, the picture 203 may establish an association relationship with the cell 206, and the first cell identifier corresponding to the picture 203 is the cell identifier (X3, Y4) of the cell 206.
Thus, the table shown in fig. 2 can be converted into the form shown in fig. 3 according to the defined cell identification and the association relationship between the picture and the cell. Thus, according to the correspondence between the pictures and the cell identifiers in fig. 3, the first cell identifier corresponding to the target picture can be obtained. For example, the first cell corresponding to the picture 201 is identified as (X1, Y2), and the first cell corresponding to the picture 202 is identified as (X2, Y7).
In S102, it is determined whether there is a second cell identifier in the second table that matches the first cell identifier according to the first cell identifier.
Fig. 4 shows a schematic diagram of another table, in which the table in fig. 4 is obtained by performing a change operation on the table in fig. 2. As can be seen from comparison of fig. 2 and fig. 4, the changing operation includes deleting the column corresponding to X2 and the row corresponding to Y6, adding the column corresponding to X5 and the row corresponding to Y8, adjusting the position of the column corresponding to X3 and the position of the column corresponding to X4, and updating some other changing operations such as the picture and the cell filling value. As shown in fig. 4, the table includes a picture 401, a picture 402, a picture 403, a picture 404, and a picture 405. The table in fig. 4 may be converted into the form shown in fig. 5 by defining the cell identifier and establishing the association relationship between the picture and the cell as described in S101.
For example, the table in fig. 2 is used as a first table, and the table in fig. 4 is used as a second table. In this step, for example, with the picture 203 in fig. 2 as the target picture to be identified, the first cell identifier corresponding to the picture 203 is (X3, Y4), and according to the first cell identifier, it may be determined whether there is a second cell identifier matching the first cell identifier in the table shown in fig. 4.
In S103, if the second cell identifier exists, the modification attribute of the target picture is determined according to the association information of the second cell identifier.
Following the example in S102, if there is a second cell identifier matching the first cell identifier (X3, Y4) in the table shown in fig. 4, the modification attribute of the picture 203 may be determined according to the association information of the second cell identifier.
The association information may indicate whether the second cell identifier is associated with picture information, and information such as a cell filling value corresponding to the second cell identifier. The change attribute of the target picture may be used to indicate whether the target picture is changed, and if the target picture is changed, the change attribute may also indicate a picture change type, for example, deletion, replacement, addition, and the like.
Through the technical scheme, the association relation between the pictures in the table and the cells in the table is established, and the first cell identifier corresponding to the target picture in the first table is the identifier of the cell with the association relation with the target picture. If a second cell identifier matched with the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the association information of the second cell identifier. Therefore, the comparison is not needed manually, the labor cost is saved, and the change attribute of the target picture in the first table relative to the second table can be accurately determined. And the cell identification is defined according to the title identification of the row where the cell is located and the title identification of the column where the cell is located, so that the cell identification can uniquely and accurately represent the meaning of the content in the cell, and the corresponding cell content can be accurately positioned through the cell identification no matter how the position of the row and the column in the table is adjusted, thereby providing a reliable and accurate index basis for the follow-up judgment of whether the cell content is changed or not.
When the modification attribute of the target picture is determined in S103, in one embodiment, when the picture information is associated with the second unit cell identifier, the picture information of the target picture may be compared with the picture information associated with the second unit cell identifier. The picture information may refer to a picture itself, or may refer to information capable of uniquely identifying the picture, for example, a hash value corresponding to the picture, etc.
In this embodiment, if the comparison result indicates that the picture information of the target picture is different from the picture information associated with the second cell identifier, it may be determined that the modification attribute of the target picture is replacement. For example, taking the table in fig. 2 as the first table, taking the table in fig. 4 as the second table, taking the picture 201 as the target picture to be identified, identifying the first cell identifier corresponding to the picture 201 as (X1, Y2), determining that there is a second cell identifier matched with the first cell identifier in the table shown in fig. 4 according to the first cell identifier, where the second cell identifier is associated with the picture 402, and the picture 201 is different from the picture 402, and determining that the change attribute of the target picture 201 is replaced and that the picture 201 is replaced by the picture 402.
If the comparison result indicates that the picture information of the target picture is the same as the picture information associated with the second cell identifier, the change attribute of the target picture can be determined to be unchanged. For example, with the picture 203 as the target picture to be identified, the first cell identifier corresponding to the picture 203 is (X3, Y4), according to the first cell identifier, it may be determined that there is a second cell identifier matching the first cell identifier in the table shown in fig. 4, where the second cell identifier is associated with the picture 403, and the picture 203 is the same as the picture information of the picture 403, and it may be determined that the modification attribute of the target picture 203 is unchanged. As another example, with the picture 205 as the target picture to be identified, the corresponding first cell identifier of the picture 205 is (X4, Y1), and in the table shown in fig. 4, there is a second cell identifier matching the first cell identifier, and the second cell identifier is associated with the picture 404, where the picture 205 is the same as the picture information of the picture 404, it may be determined that the modification attribute of the target picture 205 is unchanged.
In another embodiment, if the second cell identifier is not associated with the picture information, if the first table is a pre-change table, it may be determined that the change attribute of the target picture is deletion; and if the first table is the changed table, determining that the change attribute of the target picture is newly added.
Illustratively, the pre-change table shown in fig. 2 is taken as a first table, and the post-change table shown in fig. 4 is taken as a second table. Taking the picture 204 as a target picture to be identified, wherein a first cell identifier corresponding to the picture 204 is (X3, Y5), according to the first cell identifier, it can be determined that a second cell identifier matched with the first cell identifier exists in the table shown in fig. 4, and the second cell identifier is not associated with picture information, and then it can be determined that the picture 204 is deleted, that is, the change attribute of the target picture 204 is deletion.
Illustratively, the post-change table shown in fig. 4 is taken as a first table, and the pre-change table shown in fig. 2 is taken as a second table. Taking the picture 401 as a target picture to be identified, wherein a first cell identifier corresponding to the picture 401 is (X1, Y1), and according to the first cell identifier, it can be determined that a second cell identifier matched with the first cell identifier exists in the table shown in fig. 2, and the second cell identifier is not associated with picture information, and then it can be determined that the picture 401 is a newly added picture, that is, that the change attribute of the target picture 401 is newly added.
In the present disclosure, if a first table is a pre-change table in the case where there is no second cell identifier that matches the first cell identifier, determining that a change attribute of a cell corresponding to the first cell identifier is deletion; if the first table is the changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly added.
Illustratively, the pre-change table shown in fig. 2 is taken as a first table, and the post-change table shown in fig. 4 is taken as a second table. Taking the picture 202 as a target picture to be identified, a first cell identifier corresponding to the picture 202 is (X2, Y7), and according to the first cell identifier, it can be determined that a second cell identifier matched with the first cell identifier does not exist in the table shown in fig. 4, and then it can be determined that the cell corresponding to the first cell identifier is deleted, that is, the change attribute of the cell is deletion, and the picture 202 associated with the cell is also deleted.
Illustratively, the post-change table shown in fig. 4 is taken as a first table, and the pre-change table shown in fig. 2 is taken as a second table. Taking the picture 405 as a target picture to be identified, a first cell identifier corresponding to the picture 405 is (X4, Y8), and according to the first cell identifier, it can be determined that a second cell identifier matched with the first cell identifier does not exist in the table shown in fig. 2, and then it can be determined that the cell corresponding to the first cell identifier is newly added, that is, the change attribute of the cell is newly added, and the picture 405 associated with the cell is also the newly added picture.
According to the correspondence relationships shown in fig. 3 and 5, the change attribute of the cell filling value in the table may be determined in addition to the change attribute of the picture in the table. Therefore, the table content change identification method provided by the present disclosure may further include:
acquiring a third cell identifier corresponding to a target cell filling value to be identified in a first table; determining whether a fourth cell identifier matched with the third cell identifier exists in the second table according to the third cell identifier; if the fourth cell identifier exists, the change attribute of the target cell filling value can be determined according to the cell filling value corresponding to the fourth cell identifier.
The target cell to be identified may be any one cell in the first table. For example, taking the table in fig. 2 as the first table, the table in fig. 4 as the second table, taking the cell 207 in fig. 2 as the target cell, the filling value of the target cell is D, the corresponding third cell identifier is (X1, Y4), and if the fourth cell identifier matching the third cell identifier is determined to exist in the table shown in fig. 4 according to the third cell identifier, the modification attribute of the filling value of the cell 207 may be determined according to the filling value of the cell 406 corresponding to the fourth cell identifier. The change attribute of the cell filling value may be used to indicate whether the cell filling value is changed, and if the cell filling value is changed, the change attribute may also indicate a change type of the cell filling value, for example, deletion, replacement, addition, and the like.
In the present disclosure, an embodiment of determining the change attribute of the target cell fill value may be:
comparing the target cell filling value with a cell filling value corresponding to a fourth cell identifier; if the comparison result indicates that the filling value of the target cell is different from the filling value of the cell corresponding to the fourth cell identifier, the change attribute of the filling value of the target cell can be determined to be replacement; if the comparison result indicates that the cell filling value of the target cell is the same as the cell filling value corresponding to the fourth cell identifier, the change attribute of the target cell filling value can be determined to be unchanged.
Along with the above example of taking the cell 207 as the target cell, the filling value of the cell 406 in the table shown in fig. 4 is G, which is different from the filling value D of the target cell 207, and therefore, it can be determined that the change attribute of the filling value of the target cell 207 is replacement, and the cell filling value is replaced from D to G.
For example, regarding the cell 208 in fig. 2 as the target cell, the filling value of the target cell is C, the corresponding third cell identifier is (X1, Y3), and according to the third cell identifier, it can be determined that the fourth cell identifier matching the third cell identifier exists in the table shown in fig. 4, and the filling value of the cell 407 corresponding to the fourth cell identifier is also C, so that it can be determined that the modification attribute of the filling value of the cell 208 is unchanged.
It should be noted that, the third cell identifier may be the same as or different from the first cell identifier in S101, and if they are the same, the filling value in the cell and the picture associated with the cell may be compared at the same time during the comparison, so that the changing attribute of the picture and the changing attribute of the filling value of the cell may be determined at the same time.
In addition, when the fourth cell identifier matched with the third cell identifier does not exist in the second table, if the first table is a table before modification, the modification attribute of the cell corresponding to the third cell identifier can be determined to be deleted; if the first table is a changed table, the change attribute of the cell corresponding to the third cell identifier can be determined to be newly added.
For example, with the table before modification shown in fig. 2 as the first table, the table after modification shown in fig. 4 as the second table, the cell 209 as the target cell to be identified, the target cell filling value is G, the corresponding third cell identifier is (X2, Y6), and according to the third cell identifier, it may be determined that the cell 209 is deleted, that is, the modification attribute of the cell 209 is deleted if it is determined that there is no fourth cell identifier matching the third cell identifier in the table shown in fig. 4.
Illustratively, the post-change table shown in fig. 4 is taken as a first table, and the pre-change table shown in fig. 2 is taken as a second table. Taking the cell 408 as a target cell to be identified, the filling value of the target cell is J, the corresponding third cell identifier is (X5, Y8), and if it is determined that, according to the third cell identifier, there is no fourth cell identifier matching the third cell identifier in the table shown in fig. 2, it can be determined that the cell 408 is a newly added cell, that is, the change attribute of the cell 408 is newly added.
Based on the same inventive concept, the disclosure also provides a table content change identification device. Fig. 6 is a block diagram illustrating a table content change identification apparatus according to an exemplary embodiment. As shown in fig. 6, the apparatus 600 may include: a first obtaining module 601, configured to obtain a first cell identifier corresponding to a target picture to be identified in a first table, where the cell identifier includes a header identifier of a row where a cell is located and a header identifier of a column where the cell is located; a first determining module 602, configured to determine, according to the first cell identifier, whether a second cell identifier that matches the first cell identifier exists in a second table, where the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table; and a second determining module 603, configured to determine, if the second cell identifier exists, a modification attribute of the target picture according to association information of the second cell identifier.
By adopting the device, the pictures in the table and the cells in the table are established with an association relationship, and the first cell identifier corresponding to the target picture in the first table is the identifier of the cell with the association relationship with the target picture. If a second cell identifier matched with the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the association information of the second cell identifier. Therefore, the comparison is not needed manually, the labor cost is saved, and the change attribute of the target picture in the first table relative to the second table can be accurately determined. And the cell identification in the table is defined according to the title identification of the row where the cell is located and the title identification of the column where the cell is located, so that the cell identification can uniquely and accurately represent the meaning of the content in the cell, and the corresponding cell content can be accurately positioned through the cell identification no matter how the row and the column in the table are subjected to position adjustment, thereby providing a reliable and accurate index basis for subsequently judging whether the cell content is changed or not.
Optionally, the second determining module 603 may be configured to, in case the second unit cell identification is associated with picture information: comparing the picture information of the target picture with the picture information associated with the second cell identifier; if the comparison result indicates that the picture information of the target picture is different from the picture information associated with the second cell identifier, determining that the change attribute of the target picture is replacement; and if the comparison result indicates that the picture information of the target picture is the same as the picture information associated with the second cell identifier, determining that the change attribute of the target picture is unchanged.
Optionally, the second determining module 603 may be configured to, in a case where the second cell identifier is not associated with picture information: if the first table is a pre-change table, determining that the change attribute of the target picture is deletion; and if the first table is the changed table, determining that the change attribute of the target picture is newly added.
Optionally, the apparatus 600 may further include a third determining module configured to, if the second cell identifier is not present: if the first table is a table before changing, determining that the changing attribute of the cell corresponding to the first cell identifier is deleting; and if the first table is the changed table, determining that the change attribute of the cell corresponding to the first cell identifier is newly added.
Optionally, the apparatus 600 may further include: the second acquisition module is used for acquiring a third cell identifier corresponding to a target cell filling value to be identified in the first table; a fourth determining module, configured to determine, according to the third cell identifier, whether a fourth cell identifier that matches the third cell identifier exists in the second table; and a fifth determining module, configured to determine, if the fourth cell identifier exists, a modification attribute of the target cell filling value according to a cell filling value corresponding to the fourth cell identifier.
Optionally, the fifth determining module may be configured to compare the target cell filling value with a cell filling value corresponding to the fourth cell identifier; if the comparison result indicates that the filling value of the target cell is different from the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is replacement; and if the comparison result indicates that the filling value of the target cell is the same as the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is unchanged.
The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.
Fig. 7 is a block diagram of an electronic device 700, according to an example embodiment. As shown in fig. 7, the electronic device 700 may include: a processor 701, a memory 702. The electronic device 700 may also include one or more of a multimedia component 703, an input/output (I/O) interface 704, and a communication component 705.
The processor 701 is configured to control the overall operation of the electronic device 700 to complete all or part of the steps in the table content modification and identification method. The memory 702 is used to store various types of data to support operation on the electronic device 700, which may include, for example, instructions for any application or method operating on the electronic device 700, as well as application-related data, such as contact data, messages sent and received, pictures, audio, video, and so forth. The Memory 702 may be implemented by any type or combination of volatile or non-volatile Memory devices, such as static random access Memory (Static Random Access Memory, SRAM for short), electrically erasable programmable Read-Only Memory (Electrically Erasable Programmable Read-Only Memory, EEPROM for short), erasable programmable Read-Only Memory (Erasable Programmable Read-Only Memory, EPROM for short), programmable Read-Only Memory (Programmable Read-Only Memory, PROM for short), read-Only Memory (ROM for short), magnetic Memory, flash Memory, magnetic disk, or optical disk. The multimedia component 703 can include a screen and an audio component. Wherein the screen may be, for example, a touch screen, the audio component being for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signals may be further stored in the memory 702 or transmitted through the communication component 705. The audio assembly further comprises at least one speaker for outputting audio signals. The I/O interface 704 provides an interface between the processor 701 and other interface modules, which may be a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 705 is for wired or wireless communication between the electronic device 700 and other devices. Wireless communication, such as Wi-Fi, bluetooth, near field communication (Near Field Communication, NFC for short), 2G, 3G, 4G, NB-IOT, eMTC, or other 5G, etc., or one or a combination of more of them, is not limited herein. The corresponding communication component 705 may thus comprise: wi-Fi module, bluetooth module, NFC module, etc.
In an exemplary embodiment, the electronic device 700 may be implemented by one or more application specific integrated circuits (Application Specific Integrated Circuit, abbreviated ASIC), digital signal processor (Digital Signal Processor, abbreviated DSP), digital signal processing device (Digital Signal Processing Device, abbreviated DSPD), programmable logic device (Programmable Logic Device, abbreviated PLD), field programmable gate array (Field Programmable Gate Array, abbreviated FPGA), controller, microcontroller, microprocessor, or other electronic components for performing the table content change identification method described above.
In another exemplary embodiment, a computer readable storage medium is also provided, comprising program instructions which, when executed by a processor, implement the steps of the table content change identification method described above. For example, the computer readable storage medium may be the memory 702 including program instructions described above that are executable by the processor 701 of the electronic device 700 to perform the table content change identification method described above.
Fig. 8 is a block diagram of an electronic device 800, shown in accordance with another exemplary embodiment. For example, the electronic device 800 may be provided as a server. Referring to fig. 8, the electronic device 800 includes a processor 822, which may be one or more in number, and a memory 832 for storing computer programs executable by the processor 822. The computer program stored in memory 832 may include one or more modules each corresponding to a set of instructions. Further, the processor 822 may be configured to execute the computer program to perform the table content change identification method described above.
In addition, the electronic device 800 may further include a power supply component 826 and a communication component 850, the power supply component 826 may be configured to perform power management of the electronic device 800, and the communication component 850 may be configured to enable communication of the electronic device 800, such as wired or wireless communication. In addition, the electronic device 800 may also include an input/output (I/O) interface 858. The electronic device 800 may operate based on an operating system stored in the memory 832, such as Windows Server, mac OS XTM, unixTM, linuxTM, etc.
In another exemplary embodiment, a computer readable storage medium is also provided, comprising program instructions which, when executed by a processor, implement the steps of the table content change identification method described above. For example, the computer readable storage medium may be the memory 832 including program instructions described above that are executable by the processor 822 of the electronic device 800 to perform the table content change identification method described above.
In another exemplary embodiment, a computer program product is also provided, comprising a computer program executable by a programmable apparatus, the computer program having code portions for performing the above-described table content change identification method when executed by the programmable apparatus.
The preferred embodiments of the present disclosure have been described in detail above with reference to the accompanying drawings, but the present disclosure is not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solutions of the present disclosure within the scope of the technical concept of the present disclosure, and all the simple modifications belong to the protection scope of the present disclosure.
In addition, the specific features described in the foregoing embodiments may be combined in any suitable manner, and in order to avoid unnecessary repetition, the present disclosure does not further describe various possible combinations.
Moreover, any combination between the various embodiments of the present disclosure is possible as long as it does not depart from the spirit of the present disclosure, which should also be construed as the disclosure of the present disclosure.
Claims (10)
1. A method for identifying changes in table contents, the method comprising:
acquiring a first cell identifier corresponding to a target picture to be identified in a first table, wherein the cell identifier comprises a title identifier of a row where the cell is located and a title identifier of a column where the cell is located;
determining whether a second cell identifier matched with the first cell identifier exists in a second table according to the first cell identifier, wherein the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table;
if the second cell identifier exists, determining a change attribute of the target picture according to the association information of the second cell identifier, wherein the association information is used for indicating whether the second cell identifier is associated with picture information, and the change attribute of the target picture is used for indicating whether the target picture is changed.
2. The method of claim 1, wherein the determining the change attribute of the target picture according to the association information of the second cell identifier comprises:
in the case that the second unit cell identification is associated with picture information:
comparing the picture information of the target picture with the picture information associated with the second cell identifier;
if the comparison result indicates that the picture information of the target picture is different from the picture information associated with the second cell identifier, determining that the change attribute of the target picture is replacement;
and if the comparison result indicates that the picture information of the target picture is the same as the picture information associated with the second cell identifier, determining that the change attribute of the target picture is unchanged.
3. The method of claim 1, wherein the determining the change attribute of the target picture according to the association information of the second cell identifier comprises:
in the case that the second cell identification is not associated with picture information:
if the first table is a pre-change table, determining that the change attribute of the target picture is deletion;
and if the first table is the changed table, determining that the change attribute of the target picture is newly added.
4. The method according to claim 1, wherein the method further comprises:
if the second cell identifier does not exist, then:
if the first table is a table before changing, determining that the changing attribute of the cell corresponding to the first cell identifier is deleting;
and if the first table is the changed table, determining that the change attribute of the cell corresponding to the first cell identifier is newly added.
5. The method of claim 1, wherein the cell identifier corresponding to the picture in the table is: and the center coordinates of the picture are marked by the cells of the cells.
6. The method according to any one of claims 1-5, further comprising:
acquiring a third cell identifier corresponding to a target cell filling value to be identified in the first table;
determining whether a fourth cell identifier matched with the third cell identifier exists in the second table according to the third cell identifier;
and if the fourth cell identifier exists, determining the change attribute of the target cell filling value according to the cell filling value corresponding to the fourth cell identifier.
7. The method of claim 6, wherein the determining the change attribute of the target cell fill value according to the cell fill value corresponding to the fourth cell identifier comprises:
comparing the target cell filling value with a cell filling value corresponding to the fourth cell identifier;
if the comparison result indicates that the filling value of the target cell is different from the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is replacement;
and if the comparison result indicates that the filling value of the target cell is the same as the filling value of the cell corresponding to the fourth cell identifier, determining that the change attribute of the filling value of the target cell is unchanged.
8. A form content change identification apparatus, the apparatus comprising:
the first acquisition module is used for acquiring a first cell identifier corresponding to a target picture to be identified in the first table, wherein the cell identifier comprises a title identifier of a row where the cell is located and a title identifier of a column where the cell is located;
a first determining module, configured to determine, according to the first cell identifier, whether a second cell identifier that matches the first cell identifier exists in a second table, where the first table is one of a pre-change table and a post-change table, and the second table is the other of the pre-change table and the post-change table;
and the second determining module is used for determining the change attribute of the target picture according to the association information of the second cell identifier if the second cell identifier exists, wherein the association information is used for indicating whether the second cell identifier is associated with picture information, and the change attribute of the target picture is used for indicating whether the target picture is changed.
9. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the steps of the method according to any one of claims 1-7.
10. An electronic device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to implement the steps of the method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911340773.3A CN111209800B (en) | 2019-12-23 | 2019-12-23 | Table content change identification method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911340773.3A CN111209800B (en) | 2019-12-23 | 2019-12-23 | Table content change identification method and device, storage medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111209800A CN111209800A (en) | 2020-05-29 |
| CN111209800B true CN111209800B (en) | 2023-04-28 |
Family
ID=70786373
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911340773.3A Active CN111209800B (en) | 2019-12-23 | 2019-12-23 | Table content change identification method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111209800B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407883A (en) * | 2016-08-10 | 2017-02-15 | 北京工业大学 | Complex table and method for identifying handwritten numbers in complex table |
| CN107133319A (en) * | 2017-05-03 | 2017-09-05 | 努比亚技术有限公司 | A kind of method, device and the computer-readable recording medium of efficient adjustment order |
| CN109446199A (en) * | 2018-10-19 | 2019-03-08 | 天津字节跳动科技有限公司 | Cell data processing method and device |
| CN109445677A (en) * | 2018-09-12 | 2019-03-08 | 天津字节跳动科技有限公司 | Method, apparatus, medium and the electronic equipment that content in document is edited |
| CN109522816A (en) * | 2018-10-26 | 2019-03-26 | 北京慧流科技有限公司 | Table recognition method and device, computer storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9959265B1 (en) * | 2014-05-08 | 2018-05-01 | Google Llc | Populating values in a spreadsheet using semantic cues |
| US20180225270A1 (en) * | 2017-02-06 | 2018-08-09 | International Business Machines Corporation | Processing user action in data integration tools |
-
2019
- 2019-12-23 CN CN201911340773.3A patent/CN111209800B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407883A (en) * | 2016-08-10 | 2017-02-15 | 北京工业大学 | Complex table and method for identifying handwritten numbers in complex table |
| CN107133319A (en) * | 2017-05-03 | 2017-09-05 | 努比亚技术有限公司 | A kind of method, device and the computer-readable recording medium of efficient adjustment order |
| CN109445677A (en) * | 2018-09-12 | 2019-03-08 | 天津字节跳动科技有限公司 | Method, apparatus, medium and the electronic equipment that content in document is edited |
| CN109446199A (en) * | 2018-10-19 | 2019-03-08 | 天津字节跳动科技有限公司 | Cell data processing method and device |
| CN109522816A (en) * | 2018-10-26 | 2019-03-26 | 北京慧流科技有限公司 | Table recognition method and device, computer storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111209800A (en) | 2020-05-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107688664B (en) | Chart generation method and device, computer equipment and storage medium | |
| CN108647317B (en) | Incremental file generation method and device, storage medium and electronic equipment | |
| CN109672608B (en) | Method for transmitting messages according to time | |
| US10205813B2 (en) | Method and system for detecting abnormal contact information and server | |
| CN104808991A (en) | Terminal processing method | |
| US11281761B2 (en) | Method and system for using a plurality of accounts in an instant messaging application | |
| CN110096413A (en) | A kind of disk localization method, system and electronic equipment and storage medium | |
| CN112860953A (en) | Data importing method, device, equipment and storage medium of graph database | |
| CN111694703B (en) | Cache region management method and device and computer equipment | |
| US11582173B2 (en) | Message processing method and electronic device supporting the same | |
| CN111209800B (en) | Table content change identification method and device, storage medium and electronic equipment | |
| CN113132906B (en) | Virtual positioning identification method and device, storage medium and electronic equipment | |
| CN104809049A (en) | Terminal | |
| CN108255486B (en) | View conversion method and device for form design and electronic equipment | |
| CN109766526B (en) | Form preservation method and device, storage medium and electronic equipment | |
| CN115544981A (en) | Document processing method, document processing device, electronic device, storage medium, and program product | |
| CN110580200B (en) | Data synchronization method and device | |
| CN113132241A (en) | ACL template dynamic configuration method and device | |
| CN105187633A (en) | Mobile phone number display method and device | |
| CN110348552B (en) | Jumper addressing method and device, scanner and storage medium | |
| CN105429931A (en) | Method and system for account number information interaction between application platform and third-party platform | |
| CN110457506B (en) | Page positioning method and device, storage medium and electronic equipment | |
| CN116303103B (en) | Evaluation set generation method, device and equipment of automatic driving scene library | |
| US20230305038A1 (en) | Method, system, and non-transitory computer readable medium for detecting time difference | |
| CN111078718B (en) | Frequency control method, device, equipment and computer storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |