Report positioning method and review opinion processing method and device
By obtaining and analyzing unstructured review opinions for reports and generating key-value pairs, the problem of difficult to locate unstructured review opinions in reports is solved, and the efficiency of report revision and review is improved.
Patent Information
- Application Number
- CN202411203085.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-29
- Publication Date
- 2024-11-29
AI Technical Summary
In reporting systems, there is a large amount of data and unstructured review opinions are difficult to locate, making it difficult for report staff to quickly find key data areas for revision, which affects efficiency.
By obtaining the target report and its associated review opinion table, using statement segmentation and semantic analysis to determine feature vocabulary, generate key-value pairs, respond to user positioning requests, quickly locate and display review opinions, and simplify the revision process.
It has achieved rapid positioning and revision of key data areas, improved the revision and review efficiency of report staff, and reduced report complexity.
Smart Images

Figure CN119047444A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a report positioning method, a review opinion processing method and a device. Background Art
[0002] At present, for reporting systems, such as financial and tax reporting systems, in the process of online data review, due to the large amount of data, it is difficult for reporting staff to quickly obtain the focus. In the relevant technology, the report is usually added in the form of general unstructured language or annotations to indicate the review opinions. However, because there are many systematic report review opinions and the distribution is complex, it is difficult to retrieve and locate the review focus of the corresponding indicator by only adding unstructured review opinions and pointing out report data problems in the form of text descriptions. Or, by adding numerous annotations, it is difficult to deal with complexly distributed review data, making it difficult for reporting staff to locate the data area to be reviewed and modify the data, and it is not convenient for reporting staff to revise the report based on the review opinions, which affects the efficiency of reporting staff in revising and reviewing the report. Summary of the invention
[0003] The present application aims to solve one of the technical problems in the related art at least to some extent.
[0004] To this end, the first purpose of this application is to propose a report positioning method to quickly locate the area where the data that the user focuses on is located, thereby facilitating the report staff to revise the data based on the review opinions annotated in the area where the data is located, thereby improving the efficiency of the report staff in revising and reviewing the report.
[0005] The second purpose of this application is to propose a method for processing review opinions, which associates the review opinion form with the report. The review opinions can be displayed through the review opinion form without repeatedly annotating the report, or adding general unstructured language to the report to make the report more complicated and cumbersome, making it difficult to locate the review opinions annotated in the area where the data of focus is located.
[0006] The third objective of the present application is to provide a report positioning device.
[0007] The fourth objective of this application is to provide a device for processing review comments.
[0008] A fifth objective of the present application is to provide an electronic device.
[0009] A sixth object of the present application is to provide a computer-readable storage medium.
[0010] A seventh object of the present application is to provide a computer program product.
[0011] To achieve the above-mentioned purpose, the first aspect of the present application proposes a report positioning method, including: obtaining a target report, and obtaining a review opinion table associated with the target report; wherein the review opinion table is obtained by sentence segmentation of an unstructured review text, and at least one feature word semantically associated with the review opinion is determined, and the identification information of the target cell corresponding to the feature word is used as a key name, and the review opinion is generated as a key value; in response to a target user's positioning request instruction for the target report, the key name of each cell in the target report is determined according to the identification information of each cell in the target report; based on the key name of each cell, the correspondence between the key name and the review opinion in the review opinion table is queried to obtain the key name corresponding to the review opinion; based on the key name corresponding to the review opinion, the target cell annotated with the review opinion and the review opinion annotated on the target cell are determined; the target cell and the review opinion annotated on the target cell are displayed to the target user in a set form.
[0012] To achieve the above-mentioned purpose, the second aspect of the present application proposes a method for processing review comments, including: obtaining an unstructured review text added to a target report; performing sentence segmentation on the unstructured review text to obtain review comments; performing semantic analysis on the review comments to determine at least one feature word semantically associated with the review comments; determining the identification information of the cell corresponding to the feature word from a preset comparison table, and determining the target cell in the target report based on the identification information of the cell; wherein the comparison table stores the correspondence between the feature words and the identification information of the cell; using the review comments associated with the target cell as a key value and the identification information of the target cell as a key name to generate the review comment table; associating the review comment table with the target report for storage, wherein when the stored review comment table is used for displaying the associated target report, the target cell of the target report is annotated with the corresponding review comments based on the review comment table.
[0013] To achieve the above-mentioned purpose, the third aspect of the present application proposes a report positioning device, including: a first acquisition module, which acquires a target report, and acquires a review opinion table associated with the target report; wherein the review opinion table is obtained by sentence segmentation of an unstructured review text, and at least one feature word semantically associated with the review opinion is determined, and the identification information of the target cell corresponding to the feature word is used as a key name, and the review opinion is generated as a key value; a first determination module is used to respond to a target user's location request instruction for the target report, according to the target report The invention relates to a method for determining a target cell annotated with the review opinion and the review opinion annotated on the target cell based on the identification information of each cell in the target report; a second determination module is used to query the correspondence between the key name and the review opinion in the review opinion table based on the key name of each cell, and obtain the key name corresponding to the review opinion; a third determination module is used to determine the target cell annotated with the review opinion and the review opinion annotated on the target cell based on the key name corresponding to the review opinion; a display module is used to display the target cell and the review opinion annotated on the target cell to the target user in a set form.
[0014] To achieve the above-mentioned purpose, the fourth aspect of the present application proposes a review opinion processing device, comprising: a second acquisition module, used to acquire an unstructured review text added to the target report; a fourth determination module, used to perform sentence segmentation on the unstructured review text to obtain the review opinion; an analysis module, used to perform semantic analysis on the review opinion and determine at least one feature word semantically associated with the review opinion; a fifth determination module, used to determine the identification information of the cell corresponding to the feature word from a preset comparison table, and determine the target cell in the target report according to the identification information of the cell; wherein the comparison table stores the correspondence between the feature word and the identification information of the cell; a generation module, used to use the review opinion associated with the target cell as a key value and the identification information of the target cell as a key name to generate the review opinion table; a storage module, used to associate and store the review opinion table with the target report, wherein when the stored review opinion table is used to display the associated target report, the target cell of the target report is annotated with the corresponding review opinion based on the review opinion table.
[0015] To achieve the above-mentioned purpose, the fifth aspect embodiment of the present application proposes an electronic device, comprising: a processor; a memory for storing instructions executable by the processor; wherein the processor is configured to execute the instructions to implement the report positioning method and the review opinion processing method as described in the above-mentioned embodiments of the present application.
[0016] To achieve the above-mentioned purpose, the sixth aspect embodiment of the present application proposes a computer-readable storage medium. When the instructions in the computer-readable storage medium are executed by the processor of an electronic device, the electronic device can execute the report positioning method and the review opinion processing method as described in the above-mentioned embodiments of the present application.
[0017] To achieve the above objectives, the seventh aspect of the present application proposes a computer program product, a computer program, which, when executed by a processor, implements the report positioning method and the review opinion processing method as described in the above embodiments of the present application.
[0018] The report positioning method, review opinion processing method and device provided by the present application obtain a target report and a review opinion table associated with the target report; in response to a target user's request instruction for positioning the target report, determine the key name of each cell in the target report according to the identification information of each cell in the target report; based on the key name of each cell, query the corresponding relationship between the key name and the review opinion in the review opinion table to obtain the key name corresponding to the review opinion; based on the key name corresponding to the review opinion, determine the target cell annotated with the review opinion and the review opinion annotated on the target cell; The cells and the review comments annotated on the target cells are displayed to the target users in a set form. Therefore, the correspondence between the key names in the review comment table and the review comments can be used to determine whether the key names of each cell are consistent with the key names in the review comment table, thereby quickly determining the target cells annotated with review comments, so as to quickly locate the area where the data that the user focuses on is located, thereby making it convenient for report staff to revise the data contained in the target cells based on the review comments annotated on the target cells, thereby improving the efficiency of report staff in revising and reviewing reports.
[0019] Additional aspects and advantages of the present application will be given in part in the description below, and in part will become apparent from the description below, or will be learned through the practice of the present application. BRIEF DESCRIPTION OF THE DRAWINGS
[0020] The above and / or additional aspects and advantages of the present application will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:
[0021] Figure 1 A flowchart of a report location method provided in an embodiment of the present application;
[0022] Figure 2 A flowchart of another report location method provided in an embodiment of the present application;
[0023] Figure 3 A flowchart of a method for processing review comments provided in an embodiment of the present application;
[0024] Figure 4 It is a structural schematic diagram of a report positioning device provided in an embodiment of the present application;
[0025] Figure 5 It is a structural schematic diagram of a review opinion processing device provided in an embodiment of the present application;
[0026] Figure 6 It is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0027] Embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present application, and should not be construed as limiting the present application.
[0028] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this application are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards.
[0029] Among them, it should be noted that the acquisition, transmission, storage, use, and processing of data in the technical solution of this application comply with the relevant provisions of relevant laws and regulations. In the embodiments of this application, certain software, components, models, and other existing solutions in the industry may be mentioned. They should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of this application, but it does not mean that the applicant has or will necessarily use the solution.
[0030] The report positioning method, review opinion processing method and device according to the embodiments of the present application are described below with reference to the accompanying drawings.
[0031] Figure 1 A flow chart of a report location method provided in an embodiment of the present application
[0032] To address this problem, the present application provides a report positioning method, such as Figure 1 As shown, the report positioning method includes the following steps:
[0033] Step 101, obtaining a target report and obtaining a review opinion form associated with the target report.
[0034] It should be noted that the report positioning method provided in the embodiment of the present application can be executed by a report positioning device (also referred to as a report locator), wherein the report positioning device can be implemented by software and / or hardware. The report positioning device can be an electronic device, or can be configured in an electronic device to implement the report positioning function. The embodiment of the present application is described by taking the report positioning method configured in an electronic device as an example.
[0035] Among them, the electronic device can be any device with computing capabilities, such as a personal computer, a mobile terminal, a server, etc. The mobile terminal can be, for example, a vehicle-mounted device, a mobile phone, a tablet computer, a personal digital assistant, a wearable device, and other hardware devices with various operating systems, touch screens and / or display screens.
[0036] It is understandable that the target report may be any type of report, which is not specifically limited in this embodiment, for example, a financial report or a tax report.
[0037] In addition, it should be noted that for different types of reports, the corresponding review opinion forms are also different.
[0038] In addition, it should be noted that the review opinion table is generated by performing sentence segmentation on the unstructured review text to obtain the review opinions, and determining at least one feature word semantically associated with the review opinions, using the identification information of the target cell corresponding to the feature word as the key name, and using the review opinions as the key value.
[0039] It is understandable that the unstructured review text is used to be added to the target report.
[0040] Step 102 : in response to a target user's request for locating a target report, determine a key name of each cell in the target report according to identification information of each cell in the target report.
[0041] It should be noted that the identification information of a cell includes a row identification and a column identification of the cell.
[0042] As an example, the row identifier and column identifier of each cell in the target report are combined with a set separator to obtain a key name of the corresponding cell.
[0043] In order to accurately obtain the corresponding identification information of each cell in the target report, before determining the identification information of each cell in the target report, as a possible implementation method, the identification information of each cell in the target report is determined based on the row identification set and the column identification set of the target report.
[0044] As an example, obtain the row identifier set and column identifier set of the target report; for each cell, determine the row position and column position of the cell in the target report; based on the row position of the cell in the target report, take the row position element from the row identifier set to determine the row identifier of the cell; based on the column position of the cell in the target report, take the column position element from the column identifier set to determine the column identifier of the cell; determine the identification information of the cell based on the row identifier and column identifier of the cell.
[0045] For example, if the target report has 4 rows and 5 columns of cells, assume that the row identifier set is ["1", "2", "Zhang San", "4"] and the column identifier set is ["1", "2", "3", "Li Si", "5"]. When the row or column changes, the row identifier set or column identifier set changes accordingly. For example, if you insert a row before the second row, the row identifier set is ["1", "5", "2", "Zhang San", "4"], and if you insert a column before the third column, the column identifier set is ["1", "2", "6", "3", "Li Si", "5"]; if you delete the third row, the row identifier set is ["1", "5", "Zhang San", "4"], and if you delete the fourth column, the column identifier set is ["1", "2", "6", "Li Si", "5"].
[0046] For example, for the cell in the 2nd row and 4th column of the target report, take the 2nd element from the row identifier set (["1", "5", "Zhang San", "4"]), then the row identifier of the cell in the 2nd row and 4th column is "5", and take the 4th element from the column identifier set (["1", "2", "6", "Li Si", "5"]), then the column identifier of the cell in the 2nd row and 4th column is "Li Si", that is, the row identifier is "5" and the column identifier is "Li Si", which is the identification information of the cell in the 2nd row and 4th column.
[0047] It should be noted that the specific symbol of the set separator can be determined according to actual needs and is not specifically limited in this embodiment, for example, a row identifier or a column identifier.
[0048] In order to accurately determine the target report, as a possible implementation method, the target report is determined based on the target report identifier carried by the positioning request instruction.
[0049] As an example, the target report identifier carried by the positioning request instruction is obtained; and according to the target report identifier carried by the positioning request instruction, each report is searched to obtain the target report.
[0050] In addition, it should be noted that each report includes a unique pre-set report identifier.
[0051] Step 103: Based on the key name of each cell, query the corresponding relationship between the key name and the review opinion in the review opinion table to obtain the key name corresponding to the review opinion.
[0052] It is important to understand that determining whether a cell is annotated with review comments and then obtaining the target cell is done by determining whether the key name of the cell is consistent with the key name in the review comment table. Therefore, in order to quickly locate the area where the data that the user focuses on is located, based on the key name of each cell, the key name that is consistent with the key name in the review comment table is queried, and then based on the correspondence between the key name and the review opinion in the review comment table, the target cell annotated with review comments is determined.
[0053] In addition, it should be noted that there is at least one set of key-value pairs in the review comment table, in which the key-value pair uses the identification information of the target cell as the key name and the review comments annotated on the target cell as the key value, that is, the key names in the review comment table all have corresponding review comments.
[0054] Step 104 , based on the key name corresponding to the review comment, determine the target cell annotated with the review comment and the review comment annotated on the target cell.
[0055] In addition, it should be noted that the cell associated with the key name in the review opinion table is the target cell.
[0056] In order to accurately determine the target cells annotated with review comments and the review comments annotated on the target cells, as a possible implementation method, based on the key names corresponding to the review comments and the review comment table, the target cells annotated with review comments and the review comments annotated on the target cells are determined.
[0057] As an example, characters are split according to the separator contained in the key name corresponding to the review comments to obtain the row identifier and column identifier separated by the separator; the target cell for annotating the review opinions in the target report is determined according to the row identifier and column identifier separated by the separator; the key value associated with the key name is used as the review opinion annotated on the target cell.
[0058] Step 105 , displaying the target cell and the review comments annotated on the target cell to the target user in a set format.
[0059] It should be noted that the specific setting form of the setting form can be preset according to actual needs, and this embodiment does not make any specific limitation.
[0060] For example, the target cell and the review comments annotated on the target cell may be displayed to the target user in a highlighted form, or the target cell and the review comments annotated on the target cell may be combined into a table and displayed to the target user in the form of a table.
[0061] It should be understood that after the target cell and the review comments annotated on the target cell are displayed to the target user in a set form, the target user can revise the target cell based on the review comments. The revised target cell no longer needs to be focused on. In order to instantly update the status of the review comment form, the review comment form is updated after receiving the instruction information to revise the target cell.
[0062] As an example, if an instruction message is received to revise a target cell; when the instruction message indicates that the corresponding target cell has been revised, the key-value pair consisting of the identification information of the corresponding target cell as the key name and the review comments annotated on the corresponding target cell as the key value is deleted from the review comment table to complete the update of the review comment table.
[0063] The report positioning method provided by the present application obtains a target report and a review opinion table associated with the target report; in response to a target user's positioning request instruction for the target report, determines the key name of each cell in the target report according to the identification information of each cell in the target report; based on the key name of each cell, queries the correspondence between the key name and the review opinion in the review opinion table to obtain the key name corresponding to the review opinion; based on the key name corresponding to the review opinion, determines the target cell annotated with the review opinion and the review opinion annotated on the target cell; displays the target cell and the review opinion annotated on the target cell in a set form to the target user, thereby, through the correspondence between the key name and the review opinion in the review opinion table, it can be judged whether the key name of each cell is consistent with the key name in the review opinion table, and then quickly determines the target cell annotated with the review opinion, so as to quickly locate the area where the data focused by the user is located, and then facilitates the report staff to revise the data contained in the target cell based on the review opinion annotated on the target cell, thereby improving the efficiency of the report staff in revising and reviewing the report.
[0064] In the embodiment of the present application, in order to clearly understand how to query the corresponding relationship between the key name and the review opinion in the review opinion table based on the key name of each cell, obtain the key name corresponding to the review opinion, and the review opinion annotated on the target cell, the following is combined with Figure 2 An exemplary description is given of a possible implementation method of querying the correspondence between key names and review opinions in the review opinion table based on the key names of each cell, obtaining the key names corresponding to the review opinions, and the review opinions annotated on the target cells. Figure 2 A flowchart of another report positioning method is provided for an embodiment of the present application, and this embodiment further refines the report positioning method.
[0065] like Figure 2 As shown, the report positioning method may include the following steps:
[0066] Step 201, obtaining a target report and obtaining a review opinion form associated with the target report.
[0067] Step 202: In response to a target user's request for locating a target report, determine the key name of each cell in the target report according to identification information of each cell in the target report.
[0068] Step 203: Determine, according to the review opinion table, the key name of at least one set of key-value pairs in the review opinion table, and use the key value associated with the key name in the review opinion table as the corresponding review opinion.
[0069] For example, assuming that there is a set of key-value pairs in the review comment table ("4, 5" = "the data format is incorrect"), there is a corresponding relationship between the key name ("4, 5") and the review comment ("the data format is incorrect"), and the key value ("the data format is incorrect") associated with the key name ("4, 5") serves as the corresponding review comment.
[0070] Step 204: search the review opinion table for the key name of each cell to obtain the key name existing in the review opinion table.
[0071] Step 205: Use the key name existing in the review opinion table as the key name corresponding to the review opinion.
[0072] Step 206 , based on the key name corresponding to the review comment, determine the target cell annotated with the review comment and the review comment annotated on the target cell.
[0073] For example, assuming that the key name of the cell in the 4th row and 3rd column in the target report is ("4, 5"), then the key name of the cell in the 4th row and 3rd column is consistent with the key name ("4, 5") in the review comment table, that is, the cell in the 4th row and 3rd column in the target report is the target cell, and the review comment is "Incorrect data format."
[0074] Step 207 : Display the target cell and the review comments annotated on the target cell to the target user in a set format.
[0075] It should be noted that the execution process of steps 201, 202, 206 and 207 can be implemented in any way in the embodiments of the present application, and the embodiments of the present application do not limit this and will not be repeated.
[0076] Figure 3 A flowchart of a method for processing review comments provided in an embodiment of the present application.
[0077] To address this problem, the present application provides a report positioning method, such as Figure 3 As shown, the report positioning method includes the following steps:
[0078] Step 301: Obtain the unstructured review text added to the target report.
[0079] In order to quickly add unstructured review text to a target report, as a possible implementation, in response to a trigger operation on the target report, an input control for adding unstructured review text is displayed, and unstructured review text input by a user interacting with the input control is received.
[0080] As an example, in response to a trigger operation on a target report, an input control for adding unstructured review text is displayed; the input control of the target report collects the unstructured review text.
[0081] For example, the input control may be displayed in the form of a text box, which is not limited in this embodiment.
[0082] It is important to understand that there are numerous systematic review opinions on reports. If you repeatedly annotate the report, or add general, unstructured language to the target report, it will not only make the target report more complicated and cumbersome, but also make it difficult to locate the review opinions annotated on the area where the key data is located. Therefore, a review opinion table can be constructed to associate the review opinions with the target report without the need for a complex query process. When the target report is displayed, the review opinions annotated on the target cells associated with the target report can be directly displayed to the user based on the review opinion table.
[0083] Step 302, segment the unstructured review text into sentences to obtain review opinions.
[0084] In addition, it should be noted that the unstructured review text contains at least one review sentence, and the unstructured review text is segmented to obtain at least one review sentence, that is, the review sentence is the review opinion.
[0085] For example, assuming that the unstructured review text is "The bank's annual interest rate data is incorrect, and the service object's name is semantically unclear", the unstructured review text (The bank's annual interest rate data is incorrect, and the service object's name is semantically unclear) is segmented and two review opinions are obtained, namely "The bank's annual interest rate data is incorrect", and "The service object's name is semantically unclear".
[0086] Step 303: perform semantic analysis on the review comments to determine at least one characteristic word semantically associated with the review comments.
[0087] In order to accurately determine at least one feature word semantically associated with the review comments, as a possible implementation method, the multiple words obtained by segmenting the review comments are classified, the words belonging to the target vocabulary category are determined, and it is judged whether the words belonging to the target vocabulary category are consistent with the feature words in a preset feature vocabulary table, so as to determine the feature words semantically associated with the review comments.
[0088] As an example, the review comments are segmented to determine multiple words associated with the review comments; for each word, the words associated with the review comments are classified to determine the vocabulary category to which the word belongs; based on the vocabulary category to which the word belongs, the words belonging to the target vocabulary category are determined; it is judged whether the words belonging to the target vocabulary category are consistent with the feature words in a preset feature vocabulary table; when there is a word that is consistent with the feature words in the feature vocabulary table, the word is used as the feature word semantically associated with the corresponding review comment.
[0089] In addition, it should be noted that the feature vocabulary table contains at least one feature vocabulary.
[0090] In addition, it should be noted that vocabulary categories include but are not limited to nouns, pronouns, and adjectives.
[0091] For example, the target vocabulary category may be a noun category, which is not specifically limited in this embodiment.
[0092] For example, the feature vocabulary is shown in Table 1. Assuming that the target vocabulary category is noun, the feature vocabulary are "annual interest rate", "credit limit", and "transfer limit".
[0093] Table 1 Feature vocabulary
[0094]
[0095]
[0096] In order to completely determine the feature vocabulary, as a possible implementation method, text is extracted from the cells in the first row and the first column of the target report; when the number of cells contained in the first row is less than the number of cells contained in the last row, text is extracted from the cells in the second to the i-th row of the target report; when the number of cells contained in the first column is less than the number of cells contained in the last column, text is extracted from the cells in the second to the j-th column of the target report; and a feature vocabulary is generated based on the extracted text.
[0097] Among them, the i-th row is the row number whose cells are equal to the cells contained in the last row and has the smallest value.
[0098] Among them, the jth column is the column number whose cells are equal to the cells contained in the last column and has the smallest value.
[0099] In addition, it should be noted that if the number of cells included in the first row is greater than the number of cells included in the last row, that is, there are subordinate cells in the first row of the target report.
[0100] In addition, it should be noted that if the number of cells included in the first column is less than the number of cells included in the last column, that is, there are subordinate cells in the first column of the target report.
[0101] For example, assuming a target report with 4 rows and 5 columns, the cells included in the first row of the target report exist in subordinate tables, while the cells included in the last row do not exist in subordinate tables, then the number of cells included in the first row of the target report is greater than the number of cells included in the last row; the cells included in the first column of the target report exist in subordinate tables, while the cells included in the last column do not exist in subordinate tables, then the number of cells included in the first column of the target report is greater than the number of cells included in the last column.
[0102] Step 304, determining the identification information of the cell corresponding to the characteristic word from a preset comparison table, and determining the target cell in the target report according to the identification information of the cell; wherein the comparison table stores the correspondence between the characteristic word and the identification information of the cell.
[0103] For example, the comparison table is shown in Table 2. Assuming that the characteristic words are "annual interest rate", "credit limit", and "transfer limit", the identification information of the cell corresponding to "annual interest rate" is (2, 6), the identification information of the cell corresponding to "credit limit" is (1, Li Si), and the identification information of the cell corresponding to "annual interest rate" is (5, 6).
[0104] Table 2 Comparison table
[0105] Feature vocabulary Cell identification information Annual Interest Rate (2,6) Credit Line (1, Li Si) Transfer Limit (5,6)
[0106] It can be understood that the identification information of the cell includes the row identification and the column identification of the cell.
[0107] Step 305: Use the review comments associated with the target cell as a key value and the identification information of the target cell as a key name to generate a review comment table.
[0108] In addition, it should be noted that the row identifier and column identifier of the target cell are combined with a set separator to obtain the key name of the target cell.
[0109] In addition, it should be noted that the specific symbol of the set separator can be determined according to actual needs and is not specifically limited in this embodiment, for example, a row identifier or a column identifier.
[0110] For example, the row identifier of the target cell is "5" and the column identifier is "Li Si", then the key name of the target cell can be expressed as 5, Li Si.
[0111] For example, if the target report has 4 rows and 5 columns of cells, assuming that the cell in the 2nd row and 4th column in the target report is the target cell, the row identifier of the target cell in the 2nd row and 4th column is "5", and the column identifier is "Li Si", and the review opinion associated with the target cell in the 2nd row and 4th column is "The bank's annual interest rate data is wrong", then the target cell's identification information (5, Li Si) is used as the key name, and the review opinion annotated on the target cell ("The bank's annual interest rate data is wrong") is used as the key value to form a key-value pair ("5, Li Si" = "The bank's annual interest rate data is wrong").
[0112] Step 306 , the review opinion form is associated with the target report and stored, wherein when the stored review opinion form is used for displaying the associated target report, the target cell of the target report is annotated with the corresponding review opinion based on the review opinion form.
[0113] In order to facilitate displaying the review opinions to the user, as an example, when displaying the target report, based on the review opinion table associated with the target report, the corresponding review opinions can be annotated on the target cells of the target report.
[0114] The method for processing review comments provided in the present application obtains an unstructured review text added to a target report; performs sentence segmentation on the unstructured review text to obtain review comments; performs semantic analysis on the review comments to determine at least one feature word semantically associated with the review comments; determines identification information of a cell corresponding to the feature word from a preset comparison table, and determines a target cell in the target report based on the identification information of the cell; wherein the comparison table stores the correspondence between the feature word and the identification information of the cell; uses the review comment associated with the target cell as a key value, and converts the identification information of the target cell into a key value. The target report is associated with the target report and stored in association with the review opinion table. When the stored review opinion table is used for displaying the associated target report, the target cells of the target report are annotated with the corresponding review opinions based on the review opinion table. Thus, the review opinion table and the target report are associated with each other, and the review opinions are displayed through the review opinion table. There is no need to repeatedly annotate the report, or to add general unstructured language to the target report, which makes the target report more complicated and cumbersome, making it difficult to locate the review opinions annotated in the area where the data of focus is located, thereby simplifying the review process.
[0115] In order to implement the above embodiment, the present application also proposes a report positioning device.
[0116] Figure 4 A structural schematic diagram of a report positioning device provided in an embodiment of the present application.
[0117] like Figure 4 As shown, the report locating device 400 includes: a first acquiring module 401 , a first determining module 402 , a second determining module 403 , a third determining module 404 and a display module 405 .
[0118] The first acquisition module 401 acquires a target report and a review opinion table associated with the target report; wherein the review opinion table is generated by performing sentence segmentation on an unstructured review text to obtain review opinions, and determining at least one feature word semantically associated with the review opinions, using identification information of a target cell corresponding to the feature word as a key name, and using the review opinions as key values;
[0119] A first determination module 402 is used to determine the key name of each cell in the target report according to the identification information of each cell in the target report in response to the target user's location request instruction for the target report;
[0120] The second determination module 403 is used to query the corresponding relationship between the key name and the review opinion in the review opinion table based on the key name of each cell, and obtain the key name corresponding to the review opinion;
[0121] The third determining module 404 is used to determine the target cell annotated with the review comment and the review comment annotated on the target cell based on the key name corresponding to the review comment;
[0122] The display module 405 is used to display the target cell and the review comments annotated on the target cell to the target user in a set form.
[0123] In one embodiment of the present application, the identification information includes a row identification and a column identification, and the first determination module 402 is specifically configured to:
[0124] Combine the row identifier and column identifier of each cell in the target report with the set separator to obtain the key name of the corresponding cell.
[0125] In one embodiment of the present application, the first determining module 402 is further specifically configured to:
[0126] Get the row identifier set and column identifier set of the target report;
[0127] For each cell, determine the row position and column position of the cell in the target report;
[0128] Based on the row position of the cell in the target report, take the row position element from the row identifier set to obtain the row identifier of the cell;
[0129] Based on the column position of the cell in the target report, taking the column position element from the column identifier set to obtain the column identifier of the cell;
[0130] Determine the identification information of the cell according to the row identification and column identification of the cell.
[0131] In one embodiment of the present application, the first determining module 402 is specifically configured to:
[0132] Get the target report ID carried by the positioning request instruction;
[0133] According to the target report identifier carried in the positioning request instruction, a search is performed in each report to obtain the target report, wherein each report includes a preset unique report identifier.
[0134] In one embodiment of the present application, the second determining module 403 is specifically configured to:
[0135] According to the review opinion table, determine the key name of at least one set of key-value pairs in the review opinion table, and use the key value associated with the key name in the review opinion table as the corresponding review opinion;
[0136] For the key name of each cell, query the review opinion table to obtain the key name existing in the review opinion table;
[0137] The key name existing in the review comment table is used as the key name corresponding to the review comment.
[0138] In one embodiment of the present application, the third determining module 404 is specifically configured to:
[0139] Perform character splitting according to the separator contained in the key name corresponding to the review comments, and obtain the row identifier and column identifier separated by the separator;
[0140] According to the row identifier and column identifier separated by the separator, the target cell for annotating the review opinion in the target report is determined;
[0141] Use the key value associated with the key name as the review comment annotated on the target cell.
[0142] In one embodiment of the present application, the device further includes a revision module, specifically configured to:
[0143] If an instruction to revise the target cell is received;
[0144] When the corresponding target cell indicated by the indication information has been revised, the key-value pair consisting of the identification information of the corresponding target cell as the key name and the review comment annotated on the corresponding target cell as the key value is deleted from the review comment table.
[0145] It should be noted that the above explanations of the report positioning method embodiment are also applicable to the report positioning device of this embodiment, and will not be repeated here.
[0146] The report positioning device provided by the present application obtains a target report and a review opinion table associated with the target report; wherein each cell in the target report has corresponding identification information; in response to a target user's request instruction for positioning the target report, the key name of each cell in the target report is determined according to the identification information of each cell in the target report; based on the key name of each cell, the corresponding relationship between the key name and the review opinion in the review opinion table is queried to obtain the key name corresponding to the review opinion; based on the key name corresponding to the review opinion, the target cell annotated with the review opinion and the review opinion annotated on the target cell are determined ; The target cell and the review comments annotated on the target cell are displayed to the target user in a set form. Therefore, the correspondence between the key name in the review comment table and the review comments can be used to determine whether the key name of each cell is consistent with the key name in the review comment table, and then the target cell annotated with the review comments can be quickly determined to quickly locate the area where the data that the user focuses on is located, and then it is convenient for the report staff to revise the data contained in the target cell based on the review comments annotated on the target cell, thereby improving the efficiency of the report staff in revising and reviewing the report.
[0147] In order to implement the above embodiment, the present application also proposes a device for processing review opinions.
[0148] Figure 5 A schematic diagram of the structure of a review opinion processing device provided in an embodiment of the present application.
[0149] like Figure 5 As shown, the review opinion processing device 500 includes: a second acquisition module 501 , a fourth determination module 502 , an analysis module 503 , a fifth determination module 504 , a generation module 505 and a storage module 506 .
[0150] The second acquisition module 501 is used to acquire the unstructured review text added to the target report;
[0151] The fourth determination module 502 is used to segment the unstructured review text into sentences to obtain review opinions;
[0152] An analysis module 503 is used to perform semantic analysis on the review comments and determine at least one characteristic word semantically associated with the review comments;
[0153] The fifth determination module 504 is used to determine the identification information of the cell corresponding to the characteristic word from the preset comparison table, and determine the target cell in the target report according to the identification information of the cell; wherein the comparison table stores the correspondence between the characteristic word and the identification information of the cell;
[0154] A generating module 505, for generating a review opinion table by using the review opinion associated with the target cell as a key value and the identification information of the target cell as a key name;
[0155] The storage module 506 is used to associate and store the review opinion form with the target report, wherein when the stored review opinion form is used to display the associated target report, the corresponding review opinion is annotated in the target cell of the target report based on the review opinion form.
[0156] In one embodiment of the present application, the analysis module 503 is specifically used to:
[0157] Segment the review comments to determine multiple words associated with the review comments;
[0158] For each word, classify the words associated with the review comments to determine the word category to which the word belongs;
[0159] Determine the words that belong to the target vocabulary category based on the vocabulary category to which the words belong;
[0160] Determining whether the vocabulary belonging to the target vocabulary category is consistent with the characteristic vocabulary in a preset characteristic vocabulary list; wherein the characteristic vocabulary list contains at least one characteristic vocabulary;
[0161] When the existing word is consistent with the feature word in the feature word list, the word is used as the feature word of the corresponding review opinion semantic association.
[0162] In one embodiment of the present application, before judging whether the words belonging to the target vocabulary category are consistent with the feature words in the preset feature vocabulary table, the analysis module 503 is further specifically used to:
[0163] Extract text from cells in the first row and first column of the target report;
[0164] When the number of cells in the first row is less than the number of cells in the last row, extract text from the cells in the second to the i-th row of the target report, where the i-th row is the row with the smallest value and the same number of cells as the cells in the last row;
[0165] When the number of cells in the first column is less than the number of cells in the last column, extract text from the cells in the second to jth columns of the target report, where the jth column is the column number that contains the same number of cells as the last column and has the smallest value;
[0166] Generate a feature vocabulary based on the extracted text.
[0167] It should be noted that the above explanation of the embodiment of the method for processing review opinions is also applicable to the apparatus for processing review opinions of this embodiment, and will not be repeated here.
[0168] The review opinion processing device provided by the present application obtains an unstructured review text added to a target report; performs sentence segmentation on the unstructured review text to obtain review opinions; performs semantic analysis on the review opinions to determine at least one feature word semantically associated with the review opinions; determines identification information of a cell corresponding to the feature word from a preset comparison table, and determines a target cell in the target report based on the identification information of the cell; wherein the comparison table stores the correspondence between the feature word and the identification information of the cell; uses the review opinion associated with the target cell as a key value, and converts the identification information of the target cell into a key value. The target report is associated with the target report and stored in association with the review opinion table. When the stored review opinion table is used for displaying the associated target report, the target cells of the target report are annotated with the corresponding review opinions based on the review opinion table. Thus, the review opinion table and the target report are associated with each other, and the review opinions are displayed through the review opinion table. There is no need to repeatedly annotate the report, or to add general unstructured language to the target report, which makes the target report more complicated and cumbersome, making it difficult to locate the review opinions annotated in the area where the data of focus is located, thereby simplifying the review process.
[0169] In an exemplary embodiment, an electronic device is also provided.
[0170] Among them, electronic equipment includes:
[0171] processor;
[0172] a memory for storing processor-executable instructions;
[0173] The processor is configured to execute instructions to implement the report positioning method proposed in any of the aforementioned embodiments.
[0174] As an example, Figure 6 is a schematic diagram of the structure of an electronic device 600 shown in an exemplary embodiment of the present application. Figure 6 As shown, the electronic device 600 may further include:
[0175] The memory 610 and the processor 620, a bus 630 connecting different components (including the memory 610 and the processor 620), the memory 610 stores a computer program, and when the processor 620 executes the program, the report positioning method described in the embodiment of the present application is implemented.
[0176] Bus 630 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.
[0177] The electronic device 600 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by the electronic device 600, including volatile and non-volatile media, removable and non-removable media.
[0178] The memory 610 may also include computer system readable media in the form of volatile memory, such as random access memory (RAM) 640 and / or cache memory 650. The server 600 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 660 may be used to read and write non-removable, non-volatile magnetic media ( Figure 6 not shown, often referred to as a "hard drive packager"). Although Figure 6 Not shown, a disk driver package for reading and writing a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk driver package for reading and writing a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical medium) may be provided. In these cases, each driver package can be connected to bus 630 via one or more data medium interfaces. Memory 610 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of each embodiment of the present application.
[0179] A program / utility 680 having a set (at least one) of program modules 670 may be stored, for example, in the memory 610, such program modules 670 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 670 generally perform the functions and / or methods of the embodiments described herein.
[0180] The electronic device 600 may also communicate with one or more external devices 660 (e.g., keyboard, pointing device, display 691, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 600, and / or communicate with any device that enables the electronic device 600 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed via an input / output (I / O) interface 692. In addition, the electronic device 600 may also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN) and / or public network, such as the Internet) via a network adapter 693. As shown, the network adapter 693 communicates with other modules of the electronic device 600 via a bus 630. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device driver package, redundant processing unit, external disk driver package array, RAID system, tape driver package, and data backup storage system, etc.
[0181] The processor 620 executes various functional applications and data processing by running the programs stored in the memory 610 .
[0182] It should be noted that the implementation process and technical principles of the electronic device of this embodiment refer to the explanation of the method provided in the above-mentioned embodiment, which will not be repeated here.
[0183] In an exemplary embodiment, a computer-readable storage medium including instructions is also provided, such as a memory including instructions, and the above instructions can be executed by a processor of an electronic device to complete the method provided in the above embodiments. Optionally, the computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.
[0184] In an exemplary embodiment, a computer program product is also provided, including a computer program / instruction, wherein the computer program / instruction implements the method provided in the above embodiment when executed by a processor.
[0185] The collection, storage, access, processing, transmission, provision and application of user personal information involved in this application are in compliance with relevant laws and regulations and do not violate public order and good morals.
[0186] It should be noted that personal information from users should be collected for legitimate and reasonable purposes and not shared or sold outside of these legitimate accesses. In addition, such collection / sharing should be carried out after receiving the user's informed consent, including but not limited to notifying the user to read the user agreement / user notice before the user accesses the function, and signing the agreement / authorization including authorization of relevant user information. In addition, any necessary steps should be taken to protect and safeguard access to such personal information data and ensure that others who have access to personal information data comply with its privacy policy and procedures.
[0187] This application is expected to provide an implementation scheme for users to selectively block access to or access to personal information data. That is, this application is expected to provide hardware and / or software to prevent or block access to such personal information data. Once the personal information data is no longer needed, risks can be minimized by limiting data collection and deleting data. In addition, when applicable, personal identifiers are removed from such personal information to protect the privacy of users.
[0188] In the description of the aforementioned embodiments, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.
[0189] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of this application, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.
[0190] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, fragment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present application belong.
[0191] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.
[0192] In addition, each functional unit in each embodiment of the present application may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or accessed as an independent product, it may also be stored in a computer-readable storage medium.
[0193] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limiting the present application. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present application.
Claims
1. A report positioning method, It is characterized in that The following steps are involved: Obtaining a target report, and obtaining a review opinion table associated with the target report; wherein the review opinion table is generated by performing sentence segmentation on an unstructured review text to obtain review opinions, and determining at least one feature word semantically associated with the review opinions, using identification information of a target cell corresponding to the feature word as a key name, and using the review opinions as a key value; In response to a target user's request for locating the target report, determining a key name of each cell in the target report according to identification information of each cell in the target report; Based on the key name of each cell, query the corresponding relationship between the key name and the review opinion in the review opinion table to obtain the key name corresponding to the review opinion; Based on the key name corresponding to the review opinion, determining the target cell annotated with the review opinion and the review opinion annotated on the target cell; The target cell and the review opinion annotated on the target cell are displayed to the target user in a set form.
2. The method according to claim 1, It is characterized in that The identification information includes a row identification and a column identification; and determining the key name of each cell in the target report according to the identification information of each cell in the target report includes: The row identifier and the column identifier of each cell in the target report are combined with a set separator to obtain a key name of the corresponding cell.
3. The method according to claim 2, It is characterized in that Before the identification information of each cell in the target report is obtained, the method includes: Obtaining a row identifier set and a column identifier set of the target report; For each of the cells, determining the row position and column position of the cell in the target report; Based on the row position of the cell in the target report, taking the row position-th element from the row identifier set to determine the row identifier of the cell; Based on the column position of the cell in the target report, taking the column position-th element from the column identifier set to determine the column identifier of the cell; The identification information of the cell is determined according to the row identification and the column identification of the cell.
4. The method according to claim 1, It is characterized in that The step of responding to the target user's request for positioning the target report includes: Obtaining the target report identifier carried by the positioning request instruction; According to the target report identifier carried in the positioning request instruction, a search is performed in each report to obtain the target report, wherein each report includes a preset unique report identifier.
5. The method according to claim 1, It is characterized in that Based on the key name of each cell, querying the corresponding relationship between the key name and the review opinion in the review opinion table to obtain the key name corresponding to the review opinion includes: According to the review opinion table, determining a key name of at least one set of key-value pairs in the review opinion table, and using a key value associated with a key name in the review opinion table as the corresponding review opinion; Searching the review opinion table for the key name of each cell to obtain the key name existing in the review opinion table; The key name existing in the review opinion table is used as the key name corresponding to the review opinion.
6. The method according to claim 1, It is characterized in that The step of determining the target cell annotated with the review opinion and the review opinion annotated on the target cell based on the key name corresponding to the review opinion includes: Perform character splitting according to the separator contained in the key name corresponding to the review opinion to obtain the row identifier and column identifier separated by the separator; Determining the target cell in the target report for annotating the review opinion according to the row identifier and the column identifier separated by the separator; The key value associated with the key name is used as the review opinion annotated on the target cell.
7. The method according to any one of claims 1 to 6, It is characterized in that After the target cell and the review comments annotated on the target cell are displayed to the target user in a set form, the method includes: If instruction information for revising the target cell is received; When the corresponding target cell indicated by the indication information has been revised, the key-value pair consisting of the identification information of the corresponding target cell as the key name and the review comment annotated on the corresponding target cell as the key value is deleted from the review comment table.
8. A method for handling review comments. It is characterized in that include: Get the unstructured review text added to the target report; Segmenting the unstructured review text to obtain review opinions; Performing semantic analysis on the review opinion to determine at least one characteristic word semantically associated with the review opinion; Determine the identification information of the cell corresponding to the characteristic vocabulary from a preset comparison table, and determine the target cell in the target report according to the identification information of the cell; wherein the comparison table stores the correspondence between the characteristic vocabulary and the identification information of the cell; Using the review opinion associated with the target cell as a key value and the identification information of the target cell as a key name, generating the review opinion table; The review opinion form is associated with the target report and stored, wherein when the stored review opinion form is used for displaying the associated target report, the corresponding review opinion is annotated in the target cell of the target report based on the review opinion form.
9. The method according to claim 8, It is characterized in that The performing semantic analysis on the review opinion to determine at least one characteristic word semantically associated with the review opinion includes: Segmenting the review comments to determine a plurality of words associated with the review comments; For each of the words, classify the words associated with the review opinion to determine the vocabulary category to which the words belong; Determining the vocabulary belonging to the target vocabulary category according to the vocabulary category to which the vocabulary belongs; Determining whether the vocabulary belonging to the target vocabulary category is consistent with a feature vocabulary in a preset feature vocabulary list; wherein the feature vocabulary list contains at least one feature vocabulary; In the case where the word is consistent with a feature word in the feature word table, the word is used as the feature word semantically associated with the corresponding review opinion.
10. The method according to claim 9, It is characterized in that Before judging whether the vocabulary belonging to the target vocabulary category is consistent with the feature vocabulary in the preset feature vocabulary table, the method further includes: Extracting text from cells in the first row and first column of the target report; When the number of cells contained in the first row is less than the number of cells contained in the last row, extract text from the cells located in the second row to the i-th row of the target report, wherein the i-th row is the row number containing cells equal to the cells contained in the last row and having the smallest value; When the number of cells contained in the first column is less than the number of cells contained in the last column, extract text from the cells located in the second column to the jth column of the target report, wherein the jth column is the column number containing the same number of cells as the cells contained in the last column and having the smallest value; The feature vocabulary is generated based on the extracted text.
11. A report positioning device, It is characterized in that include: A first acquisition module is used to acquire a target report and a review opinion table associated with the target report; wherein the review opinion table is generated by performing sentence segmentation on an unstructured review text to obtain review opinions, and determining at least one feature word semantically associated with the review opinion, using identification information of a target cell corresponding to the feature word as a key name, and using the review opinion as a key value; A first determination module is used to determine the key name of each cell in the target report according to the identification information of each cell in the target report in response to the target user's location request instruction for the target report; A second determination module is used to query the corresponding relationship between the key name and the review opinion in the review opinion table based on the key name of each cell, and obtain the key name corresponding to the review opinion; A third determination module is used to determine the target cell annotated with the review opinion and the review opinion annotated on the target cell based on the key name corresponding to the review opinion; A display module is used to display the target cell and the review comments annotated on the target cell to the target user in a set form.
12. A device for processing review comments, It is characterized in that include: A second acquisition module is used to acquire the unstructured review text added to the target report; A fourth determination module is used to perform sentence segmentation on the unstructured review text to obtain review opinions; An analysis module, configured to perform semantic analysis on the review opinion and determine at least one characteristic word semantically associated with the review opinion; A fifth determination module, used to determine the identification information of the cell corresponding to the characteristic vocabulary from a preset comparison table, and determine the target cell in the target report according to the identification information of the cell; wherein the comparison table stores the correspondence between the characteristic vocabulary and the identification information of the cell; A generating module, configured to use the review opinion associated with the target cell as a key value and the identification information of the target cell as a key name to generate the review opinion table; A storage module is used to associate and store the review opinion form with the target report, wherein when the stored review opinion form is used to display the associated target report, the corresponding review opinion is annotated in the target cell of the target report based on the review opinion form.
13. An electronic device, It is characterized in that include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 7, or the method according to any one of claims 8 to 10.
14. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, they are used to implement the method according to any one of claims 1 to 7, or the method according to any one of claims 8 to 10.
15. A computer program product, It is characterized in that The invention comprises a computer program, which, when executed by a processor, implements the method according to any one of claims 1 to 7, or the method according to any one of claims 8 to 10.
