CN111209800A - Form content change recognition method and device, storage medium and electronic equipment - Google Patents
Form content change recognition method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN111209800A CN111209800A CN201911340773.3A CN201911340773A CN111209800A CN 111209800 A CN111209800 A CN 111209800A CN 201911340773 A CN201911340773 A CN 201911340773A CN 111209800 A CN111209800 A CN 111209800A
- Authority
- CN
- China
- Prior art keywords
- cell
- cell identifier
- picture
- change
- identifier
- 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.)
- Granted
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
Abstract
The disclosure relates to a table content change identification method and device, a storage medium and an electronic device. 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 a 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 or not according to the first cell identifier, wherein the first table is one of a table before change and a table after change, and the second table is the other of the table before change and the table after change; and if the second cell identifier exists, determining the change attribute of the target picture according to the associated information of the second cell identifier. Therefore, manual comparison is not needed, the labor cost is saved, and meanwhile, the change attribute of the target picture in the first form relative to the second form can be accurately determined.
Description
Technical Field
The present disclosure relates to the field of data processing, and in particular, to a method and an apparatus for identifying a change in table content, a storage medium, and an electronic device.
Background
The table can clearly show and record information. In a table, some pictures are usually inserted, which can serve as markers and improve the visibility of the table. When editing a table, typically the contents of the table are adjusted, e.g., rows are deleted, columns are deleted, rows are added, columns are added, etc. The pictures in the table may also change with the adjustment of the table content, such as the addition and deletion of pictures, etc. At present, generally, a manual identification mode is used for determining which changes occur in a picture in a form before change and a form after change, so that the efficiency is low, and accurate identification cannot be guaranteed.
Disclosure of Invention
The invention aims to provide a form content change identification method, a form content change identification device, a storage medium and electronic equipment, which can accurately determine the change attribute of pictures before and after form change.
In order to achieve the above object, in a first aspect, there is provided a form content change identification method, including: 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 a 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 table before change and a table after change, and the second table is the other of the table before change and the table after change; and if the second cell identifier exists, determining the change attribute of the target picture according to the associated information of the second cell identifier.
Optionally, the determining the change attribute of the target picture according to the associated information of the second cell identifier includes: in the case that the second cell identification has associated 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 associated information of the second cell identifier includes: in the event that the second cell identification does not have picture information associated therewith: if the first form is a form before change, determining that the change attribute of the target picture is deletion; and if the first form is a changed form, determining that the change attribute of the target picture is newly increased.
Optionally, the method further comprises: if the second cell identifier does not exist, then: if the first table is a table before change, determining the change attribute of the cell corresponding to the first cell identifier as deletion; and if the first table is a changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly increased.
Optionally, the cell identifier corresponding to the picture in the table is: and identifying the cell of the cell where the center coordinate of the picture is located.
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 or not 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 the change attribute of the target cell filling value according to the cell filling value corresponding to the fourth cell identifier includes: comparing the target cell fill value with a cell fill value corresponding to the fourth cell identification; if the comparison result indicates that the target cell filling value is different from the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is replacement; and if the comparison result indicates that the target cell filling value is the same as the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is unchanged.
In a second aspect, there is provided a table content change recognition apparatus, the apparatus including: the first obtaining module is used for obtaining 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 a cell is located and a title identifier of a column where the cell is located; the first determining module is used for 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 table before change and a table after change, and the second table is the other of the table before change and the table after change; and the second determining module is used for determining the change attribute of the target picture according to the associated information of the second cell identifier if the second cell identifier exists.
Optionally, the second determining module is configured to, in a case that the second 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 that the second cell identifier does not have associated picture information: if the first form is a form before change, determining that the change attribute of the target picture is deletion; and if the first form is a changed form, determining that the change attribute of the target picture is newly increased.
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 change, determining the change attribute of the cell corresponding to the first cell identifier as deletion; and if the first table is a changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly increased.
Optionally, the apparatus further comprises: the second obtaining module is used for obtaining 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 matching the third cell identifier exists in the second table; and a fifth determining module, configured to determine, if the fourth cell identifier exists, a change attribute of the target cell filling value according to the 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 target cell filling value is different from the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is replacement; and if the comparison result indicates that the target cell filling value is the same as the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is unchanged.
In a third aspect, a computer readable storage medium is provided, on which a computer program is stored, which program, when being executed by a processor, carries out the steps of the method provided by the first aspect of the disclosure.
In a fourth aspect, an electronic device is provided, 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.
According to the technical scheme, the association relationship 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 having the association relationship with the target picture. If a second cell identifier matching the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the associated information of the second cell identifier. Therefore, manual comparison is not needed, the labor cost is saved, and meanwhile, the change attribute of the target picture in the first form relative to the second form can be accurately determined. And the cell mark is defined according to the title mark of the row where the cell is located and the title mark of the column where the cell is located, so that the cell mark 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 mark 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 subsequently judging whether the cell content is changed.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure without limiting the disclosure. In the drawings:
fig. 1 is a flowchart illustrating a table content change identification method according to an example embodiment.
Fig. 2 shows a schematic diagram of a table.
Fig. 3 is a schematic diagram illustrating 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 is a schematic diagram illustrating a correspondence relationship between cell identifiers and pictures in the table shown in fig. 4.
Fig. 6 is a block diagram illustrating a form content change identifying apparatus according to an exemplary embodiment.
FIG. 7 is a block diagram illustrating an electronic device in accordance with an example embodiment.
FIG. 8 is a block diagram illustrating an electronic device in accordance with another example embodiment.
Detailed Description
The following detailed description of specific embodiments of the present disclosure is provided in connection with the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating the present disclosure, are given by way of illustration and explanation only, not limitation.
Fig. 1 is a flowchart illustrating a table content change identification method according to an example embodiment. The method can be applied to electronic equipment with processing capacity, such as a server, a terminal and the like. The server may be, for example, a cloud server, a table management server, or the like. The terminal can be, for example, a smart phone, a tablet computer, a notebook computer, and the like. 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 like, and the table only shows examples in which the filling values are letters, but does not constitute a limitation to the embodiments of the present disclosure. The table shown in fig. 2 also includes a picture 201, a picture 202, a picture 203, a picture 204, and a 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 and 205.
Each cell in the table has a respective cell identification. The table comprises row titles of at least one row and column titles of at least one column, and the heading identification of the row and the heading identification of the column 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, (Xm, Yn) may be used to represent the cell identifier, where Xm may represent the header identifier of the mth column where the cell is located, and Yn may represent the header identifier of the nth row where the cell is located. Illustratively, in the table shown in FIG. 2, the cell of the cell 206 is identified as (X3, Y4).
For each picture in the table, an association relationship between the picture and the cell can be established. For example, the association relationship between the picture and the cell may be established through the cell in which the center coordinate of the picture is located, and the cell identifier corresponding to the picture is the cell identifier of the cell in which 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 of the cell 206 (X3, Y4).
Thus, the table shown in fig. 2 can be converted into the form shown in fig. 3 according to the defined cell identifiers and the association relationship between the pictures and the cells. Thus, according to the corresponding relationship between the picture and the cell identifier in fig. 3, the first cell identifier corresponding to the target picture can be obtained. For example, the first cell id corresponding to the picture 201 is (X1, Y2), and the first cell id corresponding to the picture 202 is (X2, Y7).
In S102, it is determined whether a second cell id matching the first cell id exists in the second table according to the first cell id.
Fig. 4 shows a schematic diagram of another table, wherein the table in fig. 4 is obtained by performing a change operation on the table in fig. 2. As can be seen from comparison between fig. 2 and fig. 4, the modification operation includes other modification operations such as deleting the column corresponding to X2 and the row corresponding to Y6, adding a new column corresponding to X5 and a new row corresponding to Y8, adjusting the positions of the column corresponding to X3 and the column corresponding to X4, and updating some pictures and cell filling values. 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 can be converted into the form shown in fig. 5 by the way of defining the cell identifier and the way of establishing the association relationship between the picture and the cell described in S101.
For example, the table in fig. 2 is used as the first table, and the table in fig. 4 is used as the second table. In this step, for example, with the picture 203 in fig. 2 as a target picture to be recognized, a first cell identifier corresponding to the picture 203 is (X3, Y4), and according to this first cell identifier, it may be determined whether a second cell identifier matching with the first cell identifier exists in the table shown in fig. 4.
In S103, if the second cell identifier exists, the change attribute of the target picture is determined according to the associated information of the second cell identifier.
Following the example in S102, if there is a second cell id matching the first cell id (X3, Y4) in the table shown in fig. 4, the change attribute of the picture 203 may be determined according to the associated information of the second cell id.
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, or the like.
According to the technical scheme, the association relationship 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 having the association relationship with the target picture. If a second cell identifier matching the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the associated information of the second cell identifier. Therefore, manual comparison is not needed, the labor cost is saved, and meanwhile, the change attribute of the target picture in the first form relative to the second form can be accurately determined. And the cell mark is defined according to the title mark of the row where the cell is located and the title mark of the column where the cell is located, so that the cell mark 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 mark 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 subsequently judging whether the cell content is changed.
When the change attribute of the target picture is determined in S103, in one embodiment, if the picture information is associated with the second cell identifier, the picture information of the target picture may be compared with the picture information associated with the second cell identifier. The picture information may refer to the picture itself, or may refer to information capable of uniquely identifying the picture, for example, a hash value corresponding to the picture.
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, the changed attribute of the target picture may be determined to be replacement. By way of example, taking the table in fig. 2 as a first table, the table in fig. 4 as a second table, taking the picture 201 as a target picture to be recognized, and taking the first cell identifier corresponding to the picture 201 as (X1, Y2), according to the first cell identifier, it may be determined that a second cell identifier matching the first cell identifier exists in the table shown in fig. 4, the second cell identifier is associated with the picture 402, and the picture 201 is different from the picture 402 in picture information, it may be determined that the change attribute of the target picture 201 is replacement, and the picture 201 is replaced by the picture 402.
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. For example, taking the picture 203 as a target picture to be recognized, the first cell identifier corresponding to the picture 203 is (X3, Y4), according to the first cell identifier, it may be determined that a second cell identifier matching the first cell identifier exists in the table shown in fig. 4, the second cell identifier is associated with the picture 403, the picture 203 and the picture 403 have the same picture information, and it may be determined that the changed attribute of the target picture 203 is unchanged. Further, for example, if the picture 205 is taken as a target picture to be recognized, the corresponding first cell id of the picture 205 is (X4, Y1), a second cell id matching the first cell id exists in the table shown in fig. 4, the second cell id is associated with the picture 404, and the picture information of the picture 205 is the same as that of the picture 404, it is determined that the changed attribute of the target picture 205 is unchanged.
In another embodiment, when the second cell identifier is not associated with picture information, if the first table is a table before change, the change attribute of the target picture can be determined to be deleted; and if the first form is the changed form, determining that the change attribute of the target picture is newly increased.
Illustratively, the table before modification shown in fig. 2 is taken as the first table, and the table after modification shown in fig. 4 is taken as the second table. With the picture 204 as a target picture to be recognized, the first cell id corresponding to the picture 204 is (X3, Y5), and according to the first cell id, it can be determined that a second cell id matching the first cell id exists in the table shown in fig. 4, and no picture information is associated with the second cell id, it can be determined that the picture 204 is deleted, that is, the change attribute of the target picture 204 is deleted.
For example, the table after the change shown in fig. 4 is taken as the first table, and the table before the change shown in fig. 2 is taken as the second table. With the picture 401 as a target picture to be recognized, the first cell identifier corresponding to the picture 401 is (X1, Y1), and according to the first cell identifier, it is determined that a second cell identifier matching the first cell identifier exists in the table shown in fig. 2, and the second cell identifier is not associated with picture information, it is determined that the picture 401 is a newly added picture, that is, the change attribute of the target picture 401 is newly added.
In the present disclosure, in the case where there is no second cell identifier matching the first cell identifier, if the first table is a table before change, the change attribute of the cell corresponding to the first cell identifier is determined to be deleted; and if the first table is the changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly increased.
Illustratively, the table before modification shown in fig. 2 is taken as the first table, and the table after modification shown in fig. 4 is taken as the second table. With the picture 202 as the target picture to be recognized, the first cell id corresponding to the picture 202 is (X2, Y7), and according to the first cell id, it can be determined that there is no second cell id matching with the first cell id in the table shown in fig. 4, and then it can be determined that the cell corresponding to the first cell id is deleted, that is, the change attribute of the cell is deletion, and the picture 202 associated with the cell is also deleted.
For example, the table after the change shown in fig. 4 is taken as the first table, and the table before the change shown in fig. 2 is taken as the second table. Taking the picture 405 as a target picture to be recognized, the 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 matching 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 new, and the picture 405 associated with the cell is also a new picture.
According to the correspondence shown in fig. 3 and 5, in addition to the change attribute of the picture in the table, the change attribute of the cell filling value in the table can be determined. Therefore, the form 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 the first table; determining whether a fourth cell identifier matched with the third cell identifier exists in the second table or not 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 of the cells in the first table. For example, taking the table in fig. 2 as a first table, the table in fig. 4 as a second table, the cell 207 in fig. 2 as a target cell, the target cell fill value is D, the corresponding third cell identifier is (X1, Y4), and according to the third cell identifier, it is determined that a fourth cell identifier matching with the third cell identifier exists in the table shown in fig. 4, and then the change attribute of the cell 207 fill value can be determined according to the fill 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 has been changed, and if the cell filling value has been changed, the change attribute may also indicate a type of change of the cell filling value, such as deletion, replacement, addition, and the like.
In the present disclosure, an embodiment of determining a change attribute of a 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 target cell filling value is different from the cell filling value corresponding to the fourth cell identifier, the change attribute of the target cell filling value can be determined to be replacement; if the comparison result indicates that the target cell filling value is the same as the cell filling value corresponding to the fourth cell identifier, it may be determined that the modified property of the target cell filling value is not modified.
Following the above example of using 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 thus, the changed attribute of the filling value of the target cell 207 may be determined as replacement, and the cell filling value is replaced from D to G.
For example, in fig. 2, the cell 208 is taken as a target cell, the target cell fill value is C, the corresponding third cell identifier is (X1, Y3), and according to the third cell identifier, it can be determined that a fourth cell identifier matching the third cell identifier exists in the table shown in fig. 4, and the fill value of the cell 407 corresponding to the fourth cell identifier is also C, so that the changed attribute of the cell 208 fill value can be determined as unchanged.
It should be noted that the third cell id may be the same as or different from the first cell id in S101, and if the third cell id is the same as the first cell id, the padding value in the cell and the picture associated with the cell may be simultaneously compared during comparison, so that the change attribute of the picture and the change attribute of the cell padding value may be simultaneously determined.
If the first table is a table before change, it is determined that the change attribute of the cell corresponding to the third cell id is deleted; if the first table is a changed table, the changed attribute of the cell corresponding to the third cell identifier can be determined to be new.
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 is taken as the target cell to be recognized, the target cell filling value is G, the corresponding third cell identifier is (X2, Y6), and according to the third cell identifier, it is determined that there is no fourth cell identifier matching with the third cell identifier in the table shown in fig. 4, and it is determined that the cell 209 is deleted, that is, the modification attribute of the cell 209 is deleted.
For example, the table after the change shown in fig. 4 is taken as the first table, and the table before the change shown in fig. 2 is taken as the second table. The cell 408 is used as a target cell to be recognized, the filling value of the target cell is J, the corresponding third cell identifier is (X5, Y8), and according to the third cell identifier, it is determined that a fourth cell identifier matching with the third cell identifier does not exist in the table shown in fig. 2, and then it is 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 form content change recognition device. Fig. 6 is a block diagram illustrating a form content change identifying 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 matching the first cell identifier exists in a second table, where the first table is one of a table before change and a table after change, and the second table is the other of the table before change and the table after change; a second determining module 603, configured to determine, if the second cell identifier exists, a change attribute of the target picture according to the associated information of the second cell identifier.
By adopting the device, the association relationship 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 having the association relationship with the target picture. If a second cell identifier matching the first cell identifier exists in the second table, the change attribute of the target picture can be determined according to the associated information of the second cell identifier. Therefore, manual comparison is not needed, the labor cost is saved, and meanwhile, the change attribute of the target picture in the first form relative to the second form can be accurately determined. And the cell identifier in the table is defined according to the title identifier of the row where the cell is located and the title identifier of the column where the cell is located, so that the cell identifier 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 identifier 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 subsequently judging whether the cell content is changed.
Optionally, the second determining module 603 may be configured to, in a case that the second 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 603 may be configured to, in a case that the second cell identifier does not have picture information associated therewith: if the first form is a form before change, determining that the change attribute of the target picture is deletion; and if the first form is a changed form, determining that the change attribute of the target picture is newly increased.
Optionally, the apparatus 600 may further include a third determining module, configured to, if the second cell identifier does not exist: if the first table is a table before change, determining the change attribute of the cell corresponding to the first cell identifier as deletion; and if the first table is a changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly increased.
Optionally, the apparatus 600 may further include: the second obtaining module is used for obtaining 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 matching the third cell identifier exists in the second table; and a fifth determining module, configured to determine, if the fourth cell identifier exists, a change attribute of the target cell filling value according to the cell filling value corresponding to the fourth cell identifier.
Optionally, the fifth determining module may be configured to compare the target cell fill value with a cell fill value corresponding to the fourth cell identifier; if the comparison result indicates that the target cell filling value is different from the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is replacement; and if the comparison result indicates that the target cell filling value is the same as the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is unchanged.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
Fig. 7 is a block diagram illustrating an electronic device 700 in accordance with an example embodiment. As shown in fig. 7, the electronic device 700 may include: a processor 701 and 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, so as to complete all or part of the steps in the above-mentioned form content change identification method. The memory 702 is used to store various types of data to support operation at the electronic device 700, such as instructions for any application or method operating on the electronic device 700 and application-related data, such as contact data, transmitted and received messages, pictures, audio, video, and the like. The Memory 702 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk, or optical disk. The multimedia components 703 may include screen and audio components. Wherein the screen may be, for example, a touch screen and the audio component is used for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signal may further be stored in the memory 702 or transmitted through the communication component 705. The audio assembly also includes at least one speaker for outputting audio signals. The I/O interface 704 provides an interface between the processor 701 and other interface modules, such as a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 705 is used for wired or wireless communication between the electronic device 700 and other devices. Wireless communication, such as Wi-Fi, bluetooth, Near Field Communication (NFC), 2G, 3G, 4G, NB-IOT, eMTC, or other 5G, etc., or a combination of one or more of them, which is not limited herein. The corresponding communication component 705 may thus include: 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 (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components, for performing the above table content alteration identification method.
In another exemplary embodiment, a computer readable storage medium is also provided, which includes program instructions, which when executed by a processor, implement the steps of the above-described table content change identification method. For example, the computer readable storage medium may be the memory 702 comprising program instructions executable by the processor 701 of the electronic device 700 to perform the above-described table content change identification method.
Fig. 8 is a block diagram illustrating an electronic device 800 in accordance with another example embodiment. For example, the electronic device 800 may be provided as a server. Referring to fig. 8, an 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 programs stored in memory 832 may include one or more modules that each correspond to a set of instructions. Further, the processor 822 may be configured to execute the computer program to perform the above-described table content change identification method.
Additionally, the electronic device 800 may also include a power component 826 and a communication component 850, the power 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, e.g., wired or wireless communication, of the electronic device 800. The electronic device 800 may also include input/output (I/O) interfaces 858. The electronic device 800 may operate based on an operating system stored in the memory 832, such as Windows Server, Mac OSXTM, UnixTM, LinuxTM, and the like.
In another exemplary embodiment, a computer readable storage medium is also provided, which includes program instructions, which when executed by a processor, implement the steps of the above-described table content change identification method. For example, the computer readable storage medium may be the memory 832 including program instructions executable by the processor 822 of the electronic device 800 to perform the form content change identification method described above.
In another exemplary embodiment, a computer program product is also provided, which comprises a computer program executable by a programmable apparatus, the computer program having code portions for performing the above-mentioned table content alteration identification method when executed by the programmable apparatus.
The preferred embodiments of the present disclosure are described in detail with reference to the accompanying drawings, however, the present disclosure is not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solution of the present disclosure within the technical idea of the present disclosure, and these simple modifications all belong to the protection scope of the present disclosure.
It should be noted that, in the foregoing embodiments, various features described in the above embodiments may be combined in any suitable manner, and in order to avoid unnecessary repetition, various combinations that are possible in the present disclosure are not described again.
In addition, any combination of various embodiments of the present disclosure may be made, and the same should be considered as the disclosure of the present disclosure, as long as it does not depart from the spirit of the present disclosure.
Claims (10)
1. A method for identifying changes to 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 a 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 table before change and a table after change, and the second table is the other of the table before change and the table after change;
and if the second cell identifier exists, determining the change attribute of the target picture according to the associated information of the second cell identifier.
2. The method according to claim 1, wherein the determining the change attribute of the target picture according to the associated information of the second cell identifier comprises:
in the case that the second cell identification has associated 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 according to claim 1, wherein the determining the change attribute of the target picture according to the associated information of the second cell identifier comprises:
in the event that the second cell identification does not have picture information associated therewith:
if the first form is a form before change, determining that the change attribute of the target picture is deletion;
and if the first form is a changed form, determining that the change attribute of the target picture is newly increased.
4. The method of claim 1, further comprising:
if the second cell identifier does not exist, then:
if the first table is a table before change, determining the change attribute of the cell corresponding to the first cell identifier as deletion;
and if the first table is a changed table, determining that the changed attribute of the cell corresponding to the first cell identifier is newly increased.
5. The method of claim 1, wherein the cell identifier corresponding to the picture in the table is: and identifying the cell of the cell where the center coordinate of the picture is located.
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 or not 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 according to claim 6, wherein said determining the change property of the target cell fill value according to the cell fill value corresponding to the fourth cell id comprises:
comparing the target cell fill value with a cell fill value corresponding to the fourth cell identification;
if the comparison result indicates that the target cell filling value is different from the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is replacement;
and if the comparison result indicates that the target cell filling value is the same as the cell filling value corresponding to the fourth cell identifier, determining that the change attribute of the target cell filling value is unchanged.
8. A form content change recognition apparatus, comprising:
the first obtaining module is used for obtaining 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 a cell is located and a title identifier of a column where the cell is located;
the first determining module is used for 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 table before change and a table after change, and the second table is the other of the table before change and the table after change;
and the second determining module is used for determining the change attribute of the target picture according to the associated information of the second cell identifier if the second cell identifier exists.
9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 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 carry out the steps of the method of any one of claims 1 to 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 true CN111209800A (en) | 2020-05-29 |
| CN111209800B 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 (7)
| 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 |
| US20180217972A1 (en) * | 2014-05-08 | 2018-08-02 | 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 |
| 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 |
-
2019
- 2019-12-23 CN CN201911340773.3A patent/CN111209800B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180217972A1 (en) * | 2014-05-08 | 2018-08-02 | Google Llc | Populating values in a spreadsheet using semantic cues |
| CN106407883A (en) * | 2016-08-10 | 2017-02-15 | 北京工业大学 | Complex table and method for identifying handwritten numbers in complex table |
| US20180225270A1 (en) * | 2017-02-06 | 2018-08-09 | International Business Machines Corporation | Processing user action in data integration tools |
| 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 |
|---|---|
| CN111209800B (en) | 2023-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20130244627A1 (en) | Method for providing phone book service and associated electronic device thereof | |
| CN110875871A (en) | Management method of instant messaging application and electronic equipment | |
| CN111158597A (en) | Metadata reading method and device, electronic equipment and storage medium | |
| CN114579561A (en) | Data processing method and device, and storage medium | |
| US11582173B2 (en) | Message processing method and electronic device supporting the same | |
| CN105468606B (en) | Webpage saving method and device | |
| CN113132906B (en) | Virtual positioning identification method and device, storage medium and electronic equipment | |
| US20150363372A1 (en) | Method and device for updating user data | |
| CN109672608B (en) | Method for transmitting messages according to time | |
| CN111209800B (en) | Table content change identification method and device, storage medium and electronic equipment | |
| CN113301203B (en) | Method and device for updating historical information data based on address book | |
| CN115563377A (en) | Enterprise determination method and device, storage medium and electronic equipment | |
| CN109684437B (en) | Content alignment method, device, storage medium and equipment for file comparison | |
| JP6178119B2 (en) | Data migration system and data migration method | |
| CN108009057B (en) | Test method and device for password input, storage medium and electronic equipment | |
| CN109766526B (en) | Form preservation method and device, storage medium and electronic equipment | |
| CN105429931A (en) | Method and system for account number information interaction between application platform and third-party platform | |
| CN110874444B (en) | URL conversion model building method and device and electronic equipment | |
| CN116303103B (en) | Evaluation set generation method, device and equipment of automatic driving scene library | |
| CN110955653A (en) | Data page processing method, device, equipment and computer system | |
| CN110309159B (en) | Data modification method and system and electronic equipment | |
| CN113626409B (en) | Test data processing method, device, equipment and storage medium | |
| CN110457506B (en) | Page positioning method and device, storage medium and electronic equipment | |
| CN113157704B (en) | Hierarchical relationship analysis method, device, equipment and computer readable storage medium | |
| CN114564206A (en) | Data non-empty checking method, device, equipment and readable 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 |