Recommendation Method, Device, Storage Medium and Processor for Region Information

Abstract

The present application discloses a method, apparatus, storage medium, and processor for recommending area information. The method includes: obtaining a target operation of a target object on a target product and data information of the target product; identifying product structure information of the target product according to the data information; determining a plurality of target information of the target product based on the product structure information; and determining a list of areas recommended for the target object based on the plurality of target information and the target operation. Through the present application, the problem in the related art that it is difficult to recommend a table area that meets the user's operation intention to the user, thereby reducing the efficiency of the user in processing information, is solved.

Description

Technical Field

[0001] The present application relates to the field of information processing, and in particular, to a method, device, storage medium, and processor for recommending regional information. Background Art

[0002] During the process of a user operating a spreadsheet software, there may be a situation where a worksheet includes multiple sheets. In the related art, some preset rules are used. For example, by moving up, down, left, or right to find blank rows and columns, determining the largest blank area, and then using Ctrl+A to obtain this area. This method is relatively single and difficult to identify the user's intention. Therefore, it is impossible to judge the actual operation intention of the user, resulting in difficulty in recommending a table area that meets the user's operation intention to the user, and reducing the efficiency of the user in processing information.

[0003] Regarding the problem in the related art that it is difficult to recommend a table area that meets the user's operation intention to the user, reducing the efficiency of the user in processing information, no effective solution has been proposed yet. Summary of the Invention

[0004] The main purpose of the present application is to provide a method, device, storage medium, and processor for recommending regional information, so as to solve the problem in the related art that it is difficult to recommend a table area that meets the user's operation intention to the user, reducing the efficiency of the user in processing information.

[0005] To achieve the above object, according to one aspect of the present application, a method for recommending regional information is provided. The method includes: obtaining a target operation of a target object on a target product and data information of the target product; identifying product structure information of the target product according to the data information; determining a plurality of target information of the target product based on the product structure information; and determining a list of regions recommended for the target object based on the plurality of target information and the target operation.

[0006] Further, the target product is a spreadsheet. Identifying the product structure information of the target product according to the data information includes: determining the type of each table row in the spreadsheet; and determining the product structure information of the target product based on the type of each table row.

[0007] Further, determining a plurality of target information of the target product based on the product structure information includes: using blank columns to cut the entire area of the spreadsheet to obtain at least one non-blank column area; using a big title to cut each non-blank column area to obtain a first list of big title table areas; and using the first list of big title table areas and the entire area of the spreadsheet as the target information.

[0008] Further, after identifying the product structure information of the target product according to the data information, the method further includes: determining a list of cell ranges selected by the target object on the target product according to the target operation; determining the largest range of the coordinate positions where the selected list of cell ranges is located to obtain a merged selection area; using the merged selection area as the target information.

[0009] Further, determining multiple pieces of target information of the target product according to the product structure information includes: using a big title to cut the non-empty column areas in the determined merged selection area to obtain a list of big title table areas two; determining the largest big title table area of the merged selection area according to the list of big title table areas two; using the list of big title table areas two and the largest big title table area as the target information.

[0010] Further, determining multiple pieces of target information of the target product according to the product structure information includes: determining the largest non-empty area in the merged selection area; using the largest non-empty area as the target information.

[0011] Further, determining a list of areas recommended for the target object according to the multiple pieces of target information and the target operation includes: determining a target condition that the target operation meets; determining a recommendation scheme according to the target condition and the multiple pieces of target information, where the recommendation scheme includes one or more pieces of information among the multiple pieces of target information; determining a list of areas recommended for the target object according to the recommendation scheme.

[0012] Further, determining a list of areas recommended for the target object according to the multiple pieces of target information and the target operation includes: if the target condition is a first condition, where the first condition is that the cell range selected by the target object on the target product is empty or the target object has not selected a cell range on the target product; determining a first recommendation scheme according to the multiple pieces of target information, where the first recommendation scheme at least includes the following content in order: the entire area of the spreadsheet, the list of big title table areas one; determining a list of areas recommended for the target object according to the first recommendation scheme.

[0013] Further, determining the list of regions recommended for the target object based on the multiple target information and the target operation includes: If the target condition is the second condition, where the second condition is that there is only one cell in the cell region selected by the target object on the target product, and the number of rows in the largest major title table region to which the cell belongs is greater than the number of rows in the continuous region; determining Recommendation Plan 2 based on the multiple target information, where at least the following content is included in Recommendation Plan 2 in the following order: the largest major title table region, the first list of major title table regions, the largest non-empty region, the entire region of the spreadsheet, and the merged selection; determining the list of regions recommended for the target object based on Recommendation Plan 2.

[0014] Further, determining the list of regions recommended for the target object based on the multiple target information and the target operation includes: If the target condition meets the third condition, where the third condition is that the number of cells in the cell region selected by the target object on the target product is multiple; determining Recommendation Plan 3 based on the multiple target information, where at least the following content is included in Recommendation Plan 3 in the following order: the largest non-empty region, the largest major title table region, the first list of major title table regions, the merged selection, the entire region of the spreadsheet, the list of sub-tables of the spreadsheet; determining the list of regions recommended for the target object based on Recommendation Plan 3.

[0015] Further, determining the list of regions recommended for the target object based on the multiple target information and the target operation includes: If the target condition meets the fourth condition, where the fourth condition is that there is only one cell in the cell region selected by the target object on the target product; determining Recommendation Plan 4 based on the multiple target information, where at least the following is included in Recommendation Plan 4: the largest non-empty region, the largest major title table region, the first list of major title table regions, the entire region of the spreadsheet, the merged selection; determining the list of regions recommended for the target object based on Recommendation Plan 4.

[0016] Further, determining the list of regions recommended for the target object based on the recommendation plan includes: If there are duplicate regions in the recommendation plan, deleting the duplicate regions in the recommendation plan; using the remaining selected regions after deleting the duplicate regions in the recommendation plan as the list of regions recommended for the target object.

[0017] To achieve the above object, according to one aspect of the present application, there is provided a device for recommending regional information, including: a first acquisition unit configured to acquire a target operation of a target object on a target product and data information of the target product; a first recognition unit configured to recognize product structure information of the target product according to the data information; a first determination unit configured to determine a plurality of target information of the target product based on the product structure information; and a second determination unit configured to determine a list of regions recommended for the target object based on the plurality of target information and the target operation.

[0018] Further, the target product is a spreadsheet, and the first recognition unit further includes: a first determination subunit configured to determine the type of each table row in the spreadsheet; and a first determination subunit configured to determine the product structure information of the target product based on the type of each table row.

[0019] Further, the first determination unit includes: a first cutting subunit configured to cut the entire area of the spreadsheet using blank columns to obtain at least one non-blank column area; a second cutting subunit configured to cut each non-blank column area using a header to obtain a first list of header table areas; and a second determination subunit configured to use the first list of header table areas and the entire area of the spreadsheet as the target information.

[0020] Further, the device further includes: a third determination unit configured to, after recognizing the product structure information of the target product according to the data information, determine a list of cell areas selected by the target object on the target product according to the target operation; a fourth determination unit configured to determine the largest area of the coordinate positions where the list of selected cell areas is located to obtain a merged selection area; and a fifth determination unit configured to use the merged selection area as the target information.

[0021] Further, the first determination unit includes: a third determination subunit configured to cut the non-blank column areas in the determined merged selection area using headers to obtain a second list of header table areas; a fourth determination subunit configured to determine the largest header table area of the merged selection area based on the second list of header table areas; and a fifth determination subunit configured to use the second list of header table areas and the largest header table area as the target information.

[0022] Further, the first determination unit includes: a sixth determination subunit configured to determine the largest non-empty area in the merged selection area; and a seventh determination subunit configured to use the largest non-empty area as the target information.

[0023] Further, the second determination unit includes: an eighth determination subunit, configured to determine a target condition that the target operation meets; a ninth determination subunit, configured to determine a recommendation plan according to the target condition and a plurality of target information, where the recommendation plan includes one or more pieces of information among the plurality of target information; a tenth determination subunit, configured to determine a list of areas recommended for the target object according to the recommendation plan.

[0024] Further, the second determination unit includes: an eleventh determination subunit, configured to, if the target condition is a first condition, determine a first recommendation plan according to the plurality of target information, where the first condition is that the cell area selected by the target object on the target product is empty or the target object does not select a cell area on the target product, and the first recommendation plan includes at least the following in sequence: the entire area of the spreadsheet, the first list of big title table areas; a twelfth determination subunit, configured to determine a list of areas recommended for the target object according to the first recommendation plan.

[0025] Further, the second determination unit includes: a thirteenth determination subunit, configured to, if the target condition is a second condition, determine a second recommendation plan according to the plurality of target information, where the second condition is that the cell area selected by the target object on the target product has only one cell, and the number of rows of the largest big title table area to which the cell belongs is greater than the number of rows of the continuous area, and the second recommendation plan includes at least the following in sequence: the largest big title table area, the first list of big title table areas, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area; a fourteenth determination subunit, configured to determine a list of areas recommended for the target object according to the second recommendation plan.

[0026] Further, the second determination unit includes: a fifteenth determination subunit, configured to, if the target condition meets a third condition, determine a third recommendation plan according to the plurality of target information, where the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple, and the third recommendation plan includes at least the following in sequence: the largest non-empty area, the largest big title table area, the first list of big title table areas, the merged selection area, the entire area of the spreadsheet, the list of sub-tables of the spreadsheet; a sixteenth determination subunit, configured to determine a list of areas recommended for the target object according to the third recommendation plan.

[0027] Further, the second determination unit includes: a seventeenth determination subunit, configured to determine Recommendation Plan Four based on the multiple target information if the target condition meets the fourth condition, where the fourth condition is that there is only one cell in the cell range selected by the target object on the target product, and Recommendation Plan Four at least includes: the largest non-empty area, the largest title table area, the first list of title table areas, the entire area of the spreadsheet, and the merged selection area; an eighteenth determination subunit, configured to determine the area list recommended for the target object based on Recommendation Plan Four.

[0028] Further, the tenth determination subunit includes: a deletion module, configured to delete the duplicate areas in the recommendation plan if there are duplicate areas in the recommendation plan; a determination module, configured to use the remaining selected areas after deleting the duplicate areas in the recommendation plan as the area list recommended for the target object.

[0029] To achieve the above object, according to one aspect of the present application, there is provided a computer-readable storage medium, where the storage medium includes a stored program, and the program executes the area information recommendation method described in any one of the above.

[0030] To achieve the above object, according to one aspect of the present application, there is provided a processor, where the processor is used to run a program, and when the program runs, it executes the area information recommendation method described in any one of the above.

[0031] By means of the present application, the following steps are adopted: obtaining the target operation of the target object on the target product and the data information of the target product; identifying the product structure information of the target product according to the data information; determining multiple target information of the target product according to the product structure information; determining the area list recommended for the target object according to the multiple target information and the target operation, which solves the problem in the related art that it is difficult to recommend a table area that meets the user's operation intention to the user, and reduces the efficiency of the user in processing information. By the target operation of the target object on the target product, the user's operation intention can be understood, and the area list recommended for the target object is determined in combination with the target information of the target product, which greatly improves the accuracy of the recommendation and further improves the efficiency of the user in processing information. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] The drawings constituting a part of the present application are used to provide a further understanding of the present application. The schematic embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation to the present application. In the drawings:

[0033] Figure 1 is a schematic diagram of the cell range and the merged selection area selected by the user according to the embodiment of the present application;

[0034] Figure 2 is a schematic diagram of the largest non - empty area provided according to an embodiment of the present application;

[0035] Figure 3 is a schematic diagram of the cell area selected by the user provided according to an embodiment of the present application;

[0036] Figure 4 is a schematic diagram of the largest heading table area provided according to an embodiment of the present application;

[0037] Figure 5 is a flowchart of a method for recommending area information provided according to an embodiment of the present application;

[0038] Figure 6 is a schematic diagram of a worksheet provided according to an embodiment of the present application;

[0039] Figure 7 is a schematic diagram of the structural information of a worksheet provided according to an embodiment of the present application;

[0040] Figure 8 is a schematic diagram of a recommended area list provided according to an embodiment of the present application;

[0041] Figure 9 is a schematic diagram of a list of heading table areas of merged selected areas provided according to an embodiment of the present application;

[0042] Figure 10 is a schematic diagram of a table under the first condition provided according to an embodiment of the present application;

[0043] Figure 11 is a schematic diagram of a table under the second condition provided according to an embodiment of the present application;

[0044] Figure 12 is a schematic diagram of a table under the third condition provided according to an embodiment of the present application;

[0045] Figure 13 is a schematic diagram of a table under the fourth condition provided according to an embodiment of the present application;

[0046] Figure 14 is a schematic diagram of a method for recommending optional area information provided according to an embodiment of the present application;

[0047] Figure 15 is a schematic diagram of a device for recommending area information provided according to an embodiment of the present application. Detailed implementation manners

[0048] It should be noted that, without conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.

[0049] In order to enable those skilled in the art to better understand the solution of this application, the technical solutions in the embodiments of this application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of this application. Obviously, the described embodiments are only a part of the embodiments of this application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of this application.

[0050] It should be noted that the terms "first", "second", etc. in the specification and claims of this application and the above-mentioned drawings are used to distinguish similar objects, and do not have to be used to describe a specific order or sequence. It should be understood that such data can be interchanged under appropriate circumstances so as to implement the embodiments of this application described here. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, system, product or device that includes a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but may include other steps or units not clearly listed or inherent to these processes, methods, products or devices.

[0051] For the convenience of description, some nouns or terms related to the embodiments of this application are explained below:

[0052] Coordinates of the area: [row number of the upper left cell, row number of the lower right cell, column number of the upper left cell, column number of the lower right cell].

[0053] Cell area selected by the user: Coordinates of the positions of the cells selected by the user.

[0054] Merged selection area: The largest area at the coordinate position where the list of the cell areas selected by the user is located. For example, Figure 1 as shown, the thick black frame is the three cell areas selected by the user, and the merged selection area of the three cell areas selected by the user is the area shown by the thick dashed frame in Figure 1 The setting of the merged selection area is based on the cell areas clearly selected by the user to determine the selection area, which conforms to the user's operation intention.

[0055] Largest non-empty area: Since users usually use blank rows or columns to divide the entire table area to clarify the operable area, therefore, taking the current merged selection area as the center, search for blank rows upward and downward, and search for blank columns left and right. The area found is the largest non-empty area of the current merged selection area. For example, the merged selection area is the area shown by the thick dashed frame in Figure 1 and its corresponding largest non-empty area is the area shown by the thick dashed frame in Figure 2 .

[0056] List of table areas with main headings: Since users use main headings to distinguish table areas, for all tables in the entire table area, first cut the area with blank columns to obtain a list of non-blank column areas. For each non-blank column area, use the main heading to cut and obtain a list of [main heading, row heading, content, others]. All are summarized to obtain the list of table areas with main headings. Take Figure 2 as an example, Figure 2 the list of table areas with main headings in

[0057] is Table 1, Table 2, Table 3 and Table 4. Figure 3 as shown. The list of table areas with main headings for the entire table includes Table 1, Table 2, Table 3 and Table 4. The merged selection area is the largest area at the coordinate positions of Table 1 and Table 3. The list of table areas with main headings that intersect the merged selection area is Figure 4 Table 1 and Table 3 in the dashed box in

[0058] Since users often misselect the entire table area, by determining the list of table areas with main headings in the merged selection area, it is convenient for users to more clearly identify the list of tables for operation. Figure 4 The largest table area with main headings: The largest area at the position of the list of table areas with main headings in the merged selection area. For example, the list of table areas with main headings that intersect the merged selection area is Table 1 and Table 3.

[0059] The entire table area: All areas of the entire table area.

[0060] The present invention will be described below in conjunction with preferred implementation steps. Figure 5 is a flowchart of a method for recommending area information provided according to an embodiment of the present application. As Figure 5 shown, the method includes the following steps:

[0061] Step S101, obtain the target operation of the target object on the target product and the data information of the target product.

[0062] The above-mentioned target product can be a spreadsheet, and the target operation can be that the target object does not select a cell range or the selected cell range contains nothing, or the cell range selected by the target object has only one cell and the number of rows in the largest main title table area to which the cell belongs is greater than the continuous area, or the number of cells in the area selected by the user is greater than 1, or there is only 1 cell in the area selected by the user. The data information of the target product is all the information included in the table. The data information of the target product is all the data information in the spreadsheet.

[0063] Step S102, identify the product structure information of the target product according to the data information.

[0064] For example, from the data information in the target product, as Figure 6 shown, identify the structure information in the table as Figure 7 shown. The structure information includes: worksheet sub-region, identification type, and region coordinates. Among them, the identification type includes: main title, row title, content, and blank row.

[0065] Step S103, determine multiple target information of the target product according to the product structure information.

[0066] For example, divide the information in Figure 6 using the main title to obtain the list of main title table areas, as Figure 7 shown, and [1, 34, 1, 10], [10, 29, 13, 20], and the worksheet area is [1, 34, 1, 20]. The merged selected area obtained according to the selected cell range list [14, 14, 7, 7] is [14, 14, 7, 7], and the list of sub-regions covered by the merged selected area is [1, 34, 1, 10]. The list of main title table areas obtained is [1, 34, 1, 10], and the largest main title table area is [1, 34, 1, 10]. The largest non-empty area is [1, 24, 1, 10].

[0067] Step S104, determine the recommended area list for the target object according to the multiple target information and the target operation.

[0068] If there is only 1 cell in the cell range selected by the user in the current scenario, then the recommended selected area list is: the largest non-empty area, the largest main title table area, the list of main title table areas, the entire table area, the merged selected area, and the recommended area list, as Figure 8 shown.

[0069] Through the above steps, by combining the target operations of the target object on the target product and the target information of the target product, the recommended area list for the target object is determined, greatly improving the accuracy of the recommendation. The user can then intuitively view the recommended area list and thus quickly select the table they want to operate on for processing, improving the efficiency of the user in processing information.

[0070] Optionally, in the method for recommending area information provided in the embodiments of the present application, when the target product is a spreadsheet, identifying the product structure information of the target product based on the data information includes: determining the type of each table row in the spreadsheet, where the type includes one of the following: big title, row title, table content, others; and determining the product structure information of the target product based on the type of each table row.

[0071] For example, as Figure 6 shown, determine Figure 6 the types of each table row in Figure 7 . After determining the types of each table row, the worksheet sub-regions, identification types, and region coordinates can be determined, and then the structure information of the table can be determined, as

[0072] shown.

[0073] Optionally, in the method for recommending area information provided in the embodiments of the present application, based on the product structure information, determining multiple target information of the target product includes: using blank columns to cut the entire area of the spreadsheet to obtain at least one non-blank column area; using big titles to cut each non-blank column area to obtain a list of big title table areas one; and taking the list of big title table areas one and the entire area of the spreadsheet as the target information.

[0074] As shown in Spreadsheet 1 below,

[0075] Spreadsheet 1

[0076]

[0077] Use blank columns to cut the entire area of Spreadsheet 1 to obtain non-blank column areas including Table 1 and Table 2. Then, use big titles (for example, Table 1 and Table 2) to cut the non-blank column areas to obtain a list of big title table areas one (for example, Table 1 and Table 2). Finally, take the list of big title table areas one and the entire area of the spreadsheet as the target information.

[0078] Through the above solution, the list of big title table areas one can be quickly obtained, and the list of big title table areas one and the entire area of the spreadsheet can be taken as the target information.

[0079] Optionally, in the method for recommending area information provided in the embodiments of the present application, after identifying the product structure information of the target product according to the data information, the method further includes: determining a list of cell areas selected by the target object on the target product according to the target operation; determining the largest area of the coordinate positions where the selected list of cell areas is located to obtain a merged selection area; and using the merged selection area as the target information.

[0080] For example, if the list of cell areas selected is [[0, 1, 6, 7], [3, 4, 6, 7]], the merged selection area obtained is [0, 4, 6, 7], and the merged selection area is used as the target information. Through the above solution, the merged selection area can be obtained quickly and used as the target information.

[0081] Optionally, in the method for recommending area information provided in the embodiments of the present application, determining multiple pieces of target information of the target product according to the product structure information includes: using a big title to cut the non-blank column areas in the determined merged selection area to obtain a second list of big title table areas; determining the largest big title table area of the merged selection area according to the second list of big title table areas; and using the second list of big title table areas and the largest big title table area as the target information.

[0082] For example, using a big title to cut the non-blank column areas in the determined merged selection area to obtain a list of big title table areas of the merged selection area, that is, the second list of big title table areas (Table 1 and Table 2), and determining the largest area where Table 1 and Table 2 are located according to Table 1 and Table 2. For example, the largest big title table area is as Figure 9 shown. Through the above solution, the second list of big title table areas and the largest big title table area can be obtained quickly, and the second list of big title table areas and the largest big title table area are used as the target information.

[0083] Optionally, in the method for recommending area information provided in the embodiments of the present application, determining multiple pieces of target information of the target product according to the product structure information includes: determining the largest non-empty area in the merged selection area; and using the largest non-empty area as the target information.

[0084] The largest non-empty area in the above-mentioned merged selection area is the largest non-empty area obtained by finding blank rows upward and downward and blank columns left and right in the current merged selection area. Through this, the largest non-empty area can be obtained quickly and used as the target information.

[0085] Optionally, in the method for recommending area information provided in the embodiments of the present application, determining the area list recommended for the target object based on multiple target information and a target operation includes: determining the target condition that the target operation meets; determining a recommendation plan based on the target condition and multiple target information, where the recommendation plan includes one or more pieces of information among the multiple target information; and determining the area list recommended for the target object based on the recommendation plan.

[0086] For example, the target operation may be that the target object does not select a cell area or the selected cell area does not contain any content, or the cell area selected by the target object has only one cell and the number of rows in the largest major title table area to which the cell belongs is greater than the continuous area, or the number of cells in the area selected by the user is greater than 1, or there is only 1 cell in the area selected by the user. The data information of the target product is all the information included in the table. Taking the target object not selecting a cell area or the selected cell area not containing any content as condition 1, if the target operation indicates that the target object does not select a cell area or the selected cell area does not contain any content, it is considered that the target operation meets condition 1, and thus, based on condition 1 and multiple target information, the area list recommended for the target object is determined. If there is only 1 cell in the area selected by the user, it is determined that the area list recommended for the user is: the largest non-empty area, the largest major title table area, the list of major title table areas, the entire table area, and the merged selection area.

[0087] Through the above solution, based on the target operation of the target object combined with multiple target information, the area list recommended for the target object can be quickly determined, greatly improving the accuracy of the recommendation. So that the user can intuitively see the area list recommended for him, and thus quickly select the table he wants to operate for processing, improving the efficiency of the user in processing information.

[0088] Optionally, in the method for recommending area information provided in the embodiments of the present application, determining the area list recommended for the target object based on multiple target information and a target operation includes: if the target condition is the first condition, where the first condition is that the cell area selected by the target object on the target product is empty or the target object does not select a cell area on the target product; determining a first recommendation plan based on multiple target information, where the first recommendation plan at least includes the following in order: the entire area of the spreadsheet, the first list of major title table areas; and determining the area list recommended for the target object based on the first recommendation plan.

[0089] In the above solution, it is specifically defined that the first condition is that the cell area selected by the target object on the target product is empty or the target object does not select a cell area on the target product, such as Figure 10As shown. During the user operation, if no area is selected, what should be recommended to the user should be the entire table area, and the list of the big title area will be more in line with the user's expectations. Therefore, the recommended solution determined for the user in the scenario of the first condition is: the entire area of the spreadsheet, the list of the big title table area one; determine the list of areas recommended for the target object according to the recommended solution one, and recommend it to the user.

[0090] Through the above solution, further limit the recommended solution specifically recommended to the user in the scenario of the first condition in combination with the user's intention, so as to ensure the accuracy of the list of areas recommended for the target object. The list of areas recommended to the user is more in line with the user's intention, enabling the user to make selections more simply and quickly when using the table. In the experimental test, the click selection rate of the list of areas recommended by the user reaches more than 95%.

[0091] Optionally, in the area information recommendation method provided in the embodiment of the present application, determining the list of areas recommended for the target object according to multiple target information and target operations includes: if the target condition is the second condition, where the second condition is that the cell area selected by the target object on the target product has only one cell, and the number of rows of the largest big title table area to which the cell belongs is greater than the number of rows of the continuous area; determine the recommended solution two according to multiple target information, where the recommended solution two at least includes the following content in order: the largest big title table area, the list of the big title table area one, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area; determine the list of areas recommended for the target object according to the recommended solution two.

[0092] In the above solution, it is specifically limited that the second condition is that the cell area selected by the target object on the target product has only one cell, and the number of rows of the largest big title table area to which the cell belongs is greater than the number of rows of the continuous area, as Figure 11 shown. Since the largest big title area is larger and of greater value to the user, the recommended solution determined for the user in the scenario of the second condition is: the largest big title table area, the list of the big title table area one, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area, and recommend it to the user.

[0093] Through the above solution, further limit the recommended solution specifically recommended to the user in the scenario of the second condition in combination with the user's intention, so as to ensure the accuracy of the list of areas recommended for the target object. The list of areas recommended to the user is more in line with the user's intention, enabling the user to make selections more simply and quickly when using the table. In the experimental test, the click selection rate of the list of areas recommended by the user reaches more than 95%.

[0094] Optionally, in the method for recommending regional information provided in the embodiments of the present application, determining the list of regions recommended for the target object based on multiple target information and target operations includes: if the target condition meets the third condition, where the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple; determining Recommendation Plan Three based on multiple target information, where Recommendation Plan Three at least includes the following in order: the largest non-empty area, the largest big title table area, the first list of big title table areas, the merged selection area, the entire area of the spreadsheet, and the list of sub-tables of the spreadsheet; determining the list of regions recommended for the target object according to Recommendation Plan Three.

[0095] In the above solution, it is specifically defined that the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple, as Figure 12 shown. Since blank rows are often used to divide table areas in general scenarios, the largest non-empty area is recommended first. Therefore, the recommendation plan determined for the user in the scenario of the third condition is: the largest non-empty area, the largest big title table area, the first list of big title table areas, the merged selection area, the entire area of the spreadsheet, and the list of sub-tables of the spreadsheet, and recommend it to the user.

[0096] Through the above solution, it further defines the recommendation plan specifically recommended for the user in the scenario of the third condition in combination with the user's intention, thereby ensuring the accuracy of the list of regions recommended for the target object. The list of regions recommended for the user is more in line with the user's intention, enabling the user to make selections more simply and quickly when using the table. In experimental tests, the click selection rate of the list of regions recommended by the user reaches more than 95%.

[0097] Optionally, in the method for recommending regional information provided in the embodiments of the present application, determining the list of regions recommended for the target object based on multiple target information and target operations includes: if the target condition meets the fourth condition, where the fourth condition is that there is only one cell in the cell area selected by the target object on the target product; determining Recommendation Plan Four based on multiple target information, where Recommendation Plan Four at least includes: the largest non-empty area, the largest big title table area, the first list of big title table areas, the entire area of the spreadsheet, and the merged selection area; determining the list of regions recommended for the target object according to Recommendation Plan Four.

[0098] In the above solution, it is specifically defined that the fourth condition is that there is only one cell in the cell area selected by the target object on the target product, as Figure 13As shown. Since blank lines are often used to divide table areas in general scenarios, the largest non-empty area is preferably recommended. Also, since there is only one cell in the selected cell area, merging the selected area is recommended to be at the end. Therefore, the recommended solution determined for the user in the scenario of the fourth condition is: the largest non-empty area, the largest main title table area, the first list of main title table areas, the entire area of the spreadsheet, and the merged selected area, and recommend them to the user.

[0099] Through the above solution, the recommended solution specifically recommended to the user in the scenario of the fourth condition is further defined in combination with the user's intention, thereby ensuring the accuracy of the list of areas recommended for the target object. The list of areas recommended to the user is more in line with the user's intention, enabling the user to make selections more simply and quickly when using the table. In experimental tests, the click selection rate of the user for the recommended list of areas reached more than 95%.

[0100] Optionally, in the recommended method for area information provided in the embodiments of the present application, determining the list of areas recommended for the target object according to the recommended solution includes: if there are duplicate areas in the recommended solution, deleting the duplicate areas in the recommended solution; using the remaining selected areas after deleting the duplicate areas in the recommended solution as the list of areas recommended for the target object.

[0101] For example, if the largest non-empty area and the largest main title table area are the same area, then delete the duplicate selected areas in the area list to obtain the final list of areas recommended for the user.

[0102] Through the above solution, the duplicate selected areas in the area list are deleted, and only one of the same areas is retained, ensuring that the areas recommended for the user are all different, thereby improving the efficiency of the user in selecting the area to be operated on.

[0103] Based on the scenarios of the four conditions described above, in the present application, the information of the user's selected cell area, the areas already obtained by the user, and 5 features can be used as training sample data to train a decision tree to obtain an area recommendation model. Among them, the 5 features are specifically: 1. Whether there is a selected cell area; 2. Whether the selected cell area contains content; 3. Whether the selected cell area is one cell; 4. Whether the largest main title area is larger than the largest blank area; 5. Whether the selected cell area is larger than one cell.

[0104] After generating the area recommendation model, when detecting the user's currently selected cell area, the area recommendation model can automatically extract the features that the user's operation conforms to and automatically recommend areas that meet the user's intention to the user, improving the efficiency of recommending the operation area.

[0105] Such as Figure 14As shown, determine the cell area selected by the user and the table data in the worksheet. Get the table structure information of the worksheet, that is, the recognition result of the table structure. According to the table structure information, determine the type of each table row, where the types include: large title, row title, content, and others. Use blank columns to divide the worksheet to obtain a list of worksheet sub-areas. Get the list of the entire table area and the large title table area. For all tables in the entire table area, first use blank columns to cut the area to obtain a list of non-blank column areas. For each non-blank column area, use large titles to cut to obtain a list of [large titles, row titles, content, and others]. All are summarized to obtain a list of large title table areas. Then get the merged selection based on the cell area list selected by the user.

[0106] Based on the obtained large title table area list and the merged selection, the large title table area list of the merged selection, the maximum large title table area of ​​the merged selection, and the maximum non-empty area are obtained.

[0107] According to the selected cell area of ​​the current user and the current table area (the entire table area, the large title table area list, the merged selection, the large title table area list of the merged selection, the largest large title table area of ​​the merged selection, and the largest non-empty area), four conditions are summarized (condition 1, no cell area is selected or the selected cell area does not contain any content; condition 2, the cell area selected by the target object has only one cell and the number of rows of the largest large title table area to which the cell belongs is greater than the continuous area; condition 3, the number of cells in the area selected by the user is greater than 1; condition 4, there is only 1 cell in the area selected by the user) and the recommended area list under each condition. The duplicate selections in the recommended area list are deleted, and only one of the same area is retained, which ensures that the areas recommended to the user are different, and finally the recommended user area list is obtained. Through the above method, the target operation of the target object on the target product and the target information of the target product are combined to determine the recommended area list for the target object, which greatly improves the accuracy of the recommendation and thus improves the efficiency of user information processing.

[0108] In addition, it should be noted that in electronic spreadsheets, for situations where the table is too long, the table is not connected, or the table is not displayed completely, the method for recommending regional information provided in the embodiment of the present application can still recommend a list of regions that meet the user's operating intentions to the user, thereby improving the user's efficiency in processing information.

[0109] The recommended method for area information provided by the embodiments of this application obtains the target operation of the target object on the target product and the data information of the target product; identifies the product structure information of the target product according to the data information; determines multiple target information of the target product based on the product structure information; and determines the recommended area list for the target object based on the multiple target information and the target operation, solving the problem in the related art that it is difficult to recommend table areas that meet the user's operation intention to the user, and reducing the efficiency of the user in processing information. By the target operation of the target object on the target product, the user's operation intention can be understood, and the recommended area list for the target object is determined in combination with the target information of the target product, greatly improving the accuracy of the recommendation and further improving the efficiency of the user in processing information.

[0110] It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although the logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in a different order than here.

[0111] The embodiments of this application also provide a recommended device for area information. It should be noted that the recommended device for area information in the embodiments of this application can be used to execute the recommended method for area information provided by the embodiments of this application. The following introduces the recommended device for area information provided by the embodiments of this application.

[0112] Figure 15 is a schematic diagram of the recommended device for area information according to the embodiments of this application. As Figure 15 shown, the device includes: a first acquisition unit 1101, a first identification unit 1102, a first determination unit 1103, and a second determination unit 1104.

[0113] Specifically, the first acquisition unit 1101 is used to acquire the target operation of the target object on the target product and the data information of the target product;

[0114] The first identification unit 1102 is used to identify the product structure information of the target product according to the data information;

[0115] The first determination unit 1103 is used to determine multiple target information of the target product based on the product structure information;

[0116] The second determination unit 1104 is used to determine the recommended area list for the target object based on the multiple target information and the target operation.

[0117] The recommended device for regional information provided by the embodiments of the present application obtains the target operation of the target object on the target product and the data information of the target product through the first acquisition unit 1101; the first recognition unit 1102 recognizes the product structure information of the target product according to the data information; the first determination unit 1103 determines multiple target information of the target product based on the product structure information; the second determination unit 1104 determines the list of regions recommended for the target object based on the multiple target information and the target operation. This solves the problem in the related art that it is difficult to recommend table regions that meet the user's operation intention to the user, reducing the efficiency of the user in processing information. By the target operation of the target object on the target product, the user's operation intention can be understood, and the list of regions recommended for the target object is determined by combining the target information of the target product, greatly improving the accuracy of the recommendation and further improving the efficiency of the user in processing information.

[0118] Optionally, in the recommended device for regional information provided by the embodiments of the present application, the target product is a spreadsheet, and the first recognition unit further includes: a first determination subunit, configured to determine the type of each table row in the spreadsheet; a first determination subunit, configured to determine the product structure information of the target product based on the type of each table row.

[0119] Optionally, in the recommended device for regional information provided by the embodiments of the present application, the first determination unit includes: a first cutting subunit, configured to cut the entire area of the spreadsheet using blank columns to obtain at least one non-blank column area; a second cutting subunit, configured to cut each non-blank column area using a header to obtain a first list of header table areas; a second determination subunit, configured to use the first list of header table areas and the entire area of the spreadsheet as the target information.

[0120] Optionally, in the recommended device for regional information provided by the embodiments of the present application, the device further includes: a third determination unit, configured to determine the list of cell areas selected by the target object on the target product according to the target operation after recognizing the product structure information of the target product according to the data information; a fourth determination unit, configured to determine the largest area at the coordinate position of the selected list of cell areas to obtain a merged selection area; a fifth determination unit, configured to use the merged selection area as the target information.

[0121] Optionally, in the recommended device for regional information provided by the embodiments of the present application, the first determination unit includes: a third determination subunit, configured to cut the non-blank column areas in the determined merged selection area using a header to obtain a second list of header table areas; a fourth determination subunit, configured to determine the largest header table area of the merged selection area based on the second list of header table areas; a fifth determination subunit, configured to use the second list of header table areas and the largest header table area as the target information.

[0122] Optionally, in the region information recommendation device provided in the embodiments of the present application, the first determination unit includes: a sixth determination subunit, configured to determine the largest non-empty region in the merged selection area; a seventh determination subunit, configured to use the largest non-empty region as the target information.

[0123] Optionally, in the region information recommendation device provided in the embodiments of the present application, the second determination unit includes: an eighth determination subunit, configured to determine the target condition that the target operation meets; a ninth determination subunit, configured to determine a recommendation scheme according to the target condition and multiple target information, where the recommendation scheme includes one or more pieces of information among the multiple target information; a tenth determination subunit, configured to determine a region list recommended for the target object according to the recommendation scheme.

[0124] Optionally, in the region information recommendation device provided in the embodiments of the present application, the second determination unit includes: an eleventh determination subunit, configured to, if the target condition is the first condition, determine a first recommendation scheme according to multiple target information, where the first condition is that the cell area selected by the target object on the target product is empty or the target object does not select a cell area on the target product, and the first recommendation scheme includes at least the following in order: the entire area of the spreadsheet, the list of large title table areas one; a twelfth determination subunit, configured to determine a region list recommended for the target object according to the first recommendation scheme.

[0125] Optionally, in the region information recommendation device provided in the embodiments of the present application, the second determination unit includes: a thirteenth determination subunit, configured to, if the target condition is the second condition, determine a second recommendation scheme according to multiple target information, where the second condition is that the cell area selected by the target object on the target product has only one cell, and the number of rows of the largest large title table area to which the cell belongs is greater than the number of rows of the continuous area, and the second recommendation scheme includes at least the following in order: the largest large title table area, the list of large title table areas one, the largest non-empty region, the entire area of the spreadsheet, and the merged selection area; a fourteenth determination subunit, configured to determine a region list recommended for the target object according to the second recommendation scheme.

[0126] Optionally, in the region information recommendation device provided in the embodiments of the present application, the second determination unit includes: a fifteenth determination subunit, configured to, if the target condition meets the third condition, determine a third recommendation scheme according to multiple target information, where the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple, and the third recommendation scheme includes at least the following in order: the largest non-empty region, the largest large title table area, the list of large title table areas one, the merged selection area, the entire area of the spreadsheet, and the list of sub-tables of the spreadsheet; a sixteenth determination subunit, configured to determine a region list recommended for the target object according to the third recommendation scheme.

[0127] Optionally, in the recommendation device for regional information provided in the embodiments of the present application, the second determination unit includes: a seventeenth determination subunit, configured to determine Recommendation Plan Four based on multiple target information if the target condition meets the fourth condition, where the fourth condition is that there is only one cell in the cell area selected by the target object on the target product, and Recommendation Plan Four includes at least: the largest non-empty area, the largest header table area, the first list of header table areas, the entire area of the spreadsheet, and the merged selection area; an eighteenth determination subunit, configured to determine the list of areas recommended to the target object based on Recommendation Plan Four.

[0128] Optionally, in the recommendation device for regional information provided in the embodiments of the present application, the tenth determination unit includes: a deletion module, configured to delete the duplicate areas in the recommendation plan if there are duplicate areas in the recommendation plan; a determination module, configured to use the remaining selected areas after deleting the duplicate areas in the recommendation plan as the list of areas recommended to the target object.

[0129] The recommendation device for regional information includes a processor and a memory. The above-mentioned first acquisition unit 1101, first recognition unit 1102, first determination unit 1103, second determination unit 1104, etc. are all stored in the memory as program units, and the processor executes the above program units stored in the memory to implement corresponding functions.

[0130] The processor contains a kernel, and the kernel retrieves the corresponding program unit from the memory. One or more kernels can be set, and the regional information can be recommended by adjusting the kernel parameters.

[0131] The memory may include non-permanent memory in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of, for example, read-only memory (ROM) or flash memory (flash RAM), and the memory includes at least one storage chip.

[0132] The embodiments of the present invention provide a computer-readable storage medium, on which a program is stored, and when the program is executed by a processor, the recommendation method for regional information is implemented.

[0133] The embodiments of the present invention provide a processor, and the processor is used to run a program, where the program executes the recommendation method for regional information when running.

[0134] An embodiment of the present invention provides a device, which includes a processor, a memory, and a program stored on the memory and executable on the processor. When the processor executes the program, the following steps are implemented: obtaining a target operation of a target object on a target product and data information of the target product; identifying product structure information of the target product according to the data information; determining multiple target information of the target product based on the product structure information; and determining a recommended area list for the target object based on the multiple target information and the target operation.

[0135] When the processor executes the program, the following steps are further implemented: when the target product is a spreadsheet, identifying the product structure information of the target product according to the data information includes: determining the type of each table row in the spreadsheet; and determining the product structure information of the target product based on the type of each table row.

[0136] When the processor executes the program, the following steps are further implemented: determining multiple target information of the target product based on the product structure information includes: using blank columns to cut the entire area of the spreadsheet to obtain at least one non-blank column area; using headings to cut each non-blank column area to obtain a first list of heading table areas; and using the first list of heading table areas and the entire area of the spreadsheet as the target information.

[0137] When the processor executes the program, the following steps are further implemented: after identifying the product structure information of the target product according to the data information, the method further includes: determining a list of cell areas selected by the target object on the target product according to the target operation; determining the largest area of the coordinate positions where the selected list of cell areas is located to obtain a merged selection area; and using the merged selection area as the target information.

[0138] When the processor executes the program, the following steps are further implemented: determining multiple target information of the target product based on the product structure information includes: using headings to cut the non-blank column areas in the determined merged selection area to obtain a second list of heading table areas; determining the largest heading table area of the merged selection area based on the second list of heading table areas; and using the second list of heading table areas and the largest heading table area as the target information.

[0139] When the processor executes the program, the following steps are further implemented: determining multiple target information of the target product based on the product structure information includes: determining the largest non-empty area in the merged selection area; and using the largest non-empty area as the target information.

[0140] When the processor executes the program, the following steps are also implemented: Based on the multiple target information and the target operation, determining the recommended area list for the target object includes: determining the target condition that the target operation meets; determining a recommendation plan based on the target condition and the multiple target information, where one or more pieces of information in the multiple target information are included in the recommendation plan; determining the recommended area list for the target object based on the recommendation plan.

[0141] When the processor executes the program, the following steps are also implemented: Based on the multiple target information and the target operation, determining the recommended area list for the target object includes: if the target condition is the first condition, where the first condition is that the cell area selected by the target object on the target product is empty or the target object has not selected a cell area on the target product; determining a first recommendation plan based on the multiple target information, where the first recommendation plan at least includes the following in order: the entire area of the spreadsheet, the first list of large title table areas; determining the recommended area list for the target object based on the first recommendation plan.

[0142] When the processor executes the program, the following steps are also implemented: Based on the multiple target information and the target operation, determining the recommended area list for the target object includes: if the target condition is the second condition, where the second condition is that there is only one cell in the cell area selected by the target object on the target product, and the number of rows of the largest large title table area to which the cell belongs is greater than the number of rows of the continuous area; determining a second recommendation plan based on the multiple target information, where the second recommendation plan at least includes the following in order: the largest large title table area, the first list of large title table areas, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area; determining the recommended area list for the target object based on the second recommendation plan.

[0143] When the processor executes the program, the following steps are also implemented: Based on the multiple target information and the target operation, determining the recommended area list for the target object includes: if the target condition meets the third condition, where the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple; determining a third recommendation plan based on the multiple target information, where the third recommendation plan at least includes the following in order: the largest non-empty area, the largest large title table area, the first list of large title table areas, the merged selection area, the entire area of the spreadsheet, and the sub-table list of the spreadsheet; determining the recommended area list for the target object based on the third recommendation plan.

[0144] When the processor executes the program, the following steps are also implemented: According to the multiple target information and the target operation, determining that the area list recommended for the target object includes: If the target condition meets the fourth condition, where the fourth condition is that there is only one cell in the cell area selected by the target object on the target product; determining recommendation plan four according to the multiple target information, where at least the following are included in the recommendation plan four: the largest non-empty area, the largest big title table area, the first list of big title table areas, the entire area of the spreadsheet, and the merged selection area; determining the area list recommended for the target object according to the recommendation plan four.

[0145] When the processor executes the program, the following steps are also implemented: According to the recommendation plan, determining that the area list recommended for the target object includes: If there are duplicate areas in the recommendation plan, deleting the duplicate areas in the recommendation plan; using the remaining selected areas after deleting the duplicate areas in the recommendation plan as the area list recommended for the target object. The device in this article can be a server, a PC, a PAD, a mobile phone, etc.

[0146] This application also provides a computer program product, which when executed on a data processing device is adapted to execute a program initialized with the following method steps: obtaining the target operation of the target object on the target product and the data information of the target product; identifying the product structure information of the target product according to the data information; determining multiple target information of the target product according to the product structure information; determining the area list recommended for the target object according to the multiple target information and the target operation.

[0147] When executed on a data processing device, it is also adapted to execute a program initialized with the following method steps: The target product is a spreadsheet, and identifying the product structure information of the target product according to the data information includes: determining the type of each table row in the spreadsheet; determining the product structure information of the target product according to the type of each table row.

[0148] When executed on a data processing device, it is also adapted to execute a program initialized with the following method steps: Determining the multiple target information of the target product according to the product structure information includes: using blank columns to cut the entire area of the spreadsheet to obtain at least one non-blank column area; using big titles to cut each non-blank column area to obtain the first list of big title table areas; using the first list of big title table areas and the entire area of the spreadsheet as the target information.

[0149] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: After identifying the product structure information of the target product according to the data information, the method further includes: determining a list of cell area selections made by the target object on the target product according to the target operation; determining the maximum area of the coordinate positions where the selected list of cell areas is located to obtain a merged selection area; and using the merged selection area as the target information.

[0150] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: According to the product structure information, determining multiple target information of the target product includes: using a big title to cut the non-blank column areas in the determined merged selection area to obtain a list of big title table areas two; according to the list of big title table areas two, determining the largest big title table area of the merged selection area; and using the list of big title table areas two and the largest big title table area as the target information.

[0151] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: According to the product structure information, determining multiple target information of the target product includes: determining the largest non-empty area in the merged selection area; and using the largest non-empty area as the target information.

[0152] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: According to the multiple target information and the target operation, determining a list of areas recommended for the target object includes: determining a target condition that the target operation meets; determining a recommendation scheme according to the target condition and the multiple target information, where the recommendation scheme includes one or more pieces of information in the multiple target information; and determining a list of areas recommended for the target object according to the recommendation scheme.

[0153] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: According to the multiple target information and the target operation, determining a list of areas recommended for the target object includes: if the target condition is a first condition, where the first condition is that the cell area selected by the target object on the target product is empty or the target object has not selected a cell area on the target product; determining a first recommendation scheme according to the multiple target information, where the first recommendation scheme at least includes the following in order: the entire area of the spreadsheet, the list of big title table areas one; and determining a list of areas recommended for the target object according to the first recommendation scheme.

[0154] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: Based on the multiple target information and the target operation, determining the list of regions recommended for the target object includes: If the target condition is the second condition, where the second condition is that the cell range selected by the target object on the target product has only one cell, and the number of rows in the largest major heading table area to which the cell belongs is greater than the number of rows in the continuous area; determining recommendation scheme two based on the multiple target information, where at least the following content is included in recommendation scheme two in the following order: the largest major heading table area, the first list of major heading table areas, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area; determining the list of regions recommended for the target object based on recommendation scheme two.

[0155] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: Based on the multiple target information and the target operation, determining the list of regions recommended for the target object includes: If the target condition meets the third condition, where the third condition is that the number of cells in the cell range selected by the target object on the target product is multiple; determining recommendation scheme three based on the multiple target information, where at least the following content is included in recommendation scheme three in the following order: the largest non-empty area, the largest major heading table area, the first list of major heading table areas, the merged selection area, the entire area of the spreadsheet, and the list of sub-tables of the spreadsheet; determining the list of regions recommended for the target object based on recommendation scheme three.

[0156] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: Based on the multiple target information and the target operation, determining the list of regions recommended for the target object includes: If the target condition meets the fourth condition, where the fourth condition is that the cell range selected by the target object on the target product has only one cell; determining recommendation scheme four based on the multiple target information, where at least the following is included in recommendation scheme four: the largest non-empty area, the largest major heading table area, the first list of major heading table areas, the entire area of the spreadsheet, and the merged selection area; determining the list of regions recommended for the target object based on recommendation scheme four.

[0157] When executed on a data processing device, it is also suitable for executing a program initialized with the following method steps: Based on the recommendation scheme, determining the list of regions recommended for the target object includes: If there are duplicate regions in the recommendation scheme, deleting the duplicate regions in the recommendation scheme; using the remaining selected areas after deleting the duplicate regions in the recommendation scheme as the list of regions recommended for the target object.

[0158] Those skilled in the art will understand that the embodiments of the present application can be provided as a method, a system, or a computer program product. Therefore, the present application can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present application can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code.

[0159] The present application is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to the embodiments of the present application. It should be understood that each flow and / or block in the flowchart and / or block diagram can be implemented by computer program instructions, as well as the combination of flows and / or blocks in the flowchart and / or block diagram. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing devices generate means for implementing the functions specified in Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0160] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory generate a manufactured article including instruction means that implement the functions specified in Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0161] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are performed on the computer or other programmable device to generate a computer-implemented process, so that the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0162] In a typical configuration, a computing device includes one or more processors (CPUs), an input / output interface, a network interface, and memory.

[0163] The memory may include non-permanent memory in the computer-readable medium, in the form of random access memory (RAM) and / or non-volatile memory, such as read-only memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.

[0164] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include temporary computer readable media (transitory media), such as modulated data signals and carrier waves.

[0165] It should also be noted that the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, commodity or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, commodity or device. In the absence of more restrictions, the elements defined by the sentence "comprises a ..." do not exclude the existence of other identical elements in the process, method, commodity or device including the elements.

[0166] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems or computer program products. Therefore, the present application may take the form of a complete hardware embodiment, a complete software embodiment or an embodiment combining software and hardware. Moreover, the present application may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.

[0167] The above are only embodiments of the present application and are not intended to limit the present application. For those skilled in the art, the present application may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included within the scope of the claims of the present application.

Claims

1. A method for recommending area information, characterized in that, Including: Obtaining a target operation of a target object on a target product and data information of the target product; Identifying product structure information of the target product according to the data information, where the product structure information includes at least one of the following: worksheet sub-region, identification type, region coordinates, and the identification type includes at least one of the following: big title, row title, content, blank row, blank column; Determining multiple target information of the target product according to the product structure information; Determining a list of recommended regions for the target object according to the multiple target information and the target operation; Wherein, the target product is a spreadsheet, and the types of table rows in the spreadsheet include: big title, row title, table content, blank row; determining multiple target information of the target product according to the product structure information in the spreadsheet includes: Cutting the entire region of the spreadsheet using blank columns to obtain at least one non-blank column region; Using big titles to cut each non-blank column region to obtain a first list of big title table regions; Taking the first list of big title table regions and the entire region of the spreadsheet as the target information; After identifying the product structure information of the target product according to the data information, the method further includes: Determining a list of cell regions selected by the target object on the target product according to the target operation; Determining the largest region of the coordinate positions where the selected list of cell regions is located to obtain a merged selection area; Taking the merged selection area as the target information.

2. The method according to claim 1, wherein Identifying the product structure information of the target product according to the data information includes: Determining the type of each table row in the spreadsheet; Determining the product structure information of the target product according to the type of each table row.

3. The method according to claim 1, wherein Determining multiple target information of the target product according to the product structure information includes: Using big titles to cut the non-blank column regions in the determined merged selection area to obtain a second list of big title table regions; Determining the largest big title table region of the merged selection area according to the second list of big title table regions; Taking the second list of big title table regions and the largest big title table region as the target information.

4. The method according to claim 3, wherein Determining multiple target information of the target product according to the product structure information includes: Determining the largest non-empty region in the merged selection area; Taking the largest non-empty region as the target information.

5. The method according to claim 4, wherein Determining a list of recommended regions for the target object according to the multiple target information and the target operation includes: Determining target conditions that the target operation meets; Determining a recommendation scheme according to the target conditions and multiple target information, where the recommendation scheme includes one or more pieces of information in the multiple target information; Determining a list of recommended regions for the target object according to the recommendation scheme.

6. The method according to claim 5, characterized in that Determining a list of recommended regions for the target object according to the multiple target information and the target operation includes: If the target condition is the first condition, where the first condition is that the cell area selected by the target object on the target product is empty or the target object does not select a cell area on the target product; Determine the first recommended solution based on the multiple target information, where the first recommended solution at least includes the following in sequence: the entire area of the spreadsheet, the first list of big title table areas; Determine the list of areas recommended for the target object based on the first recommended solution.

7. The method according to claim 5, wherein Determine the list of areas recommended for the target object based on the multiple target information and the target operation, including: If the target condition is the second condition, where the second condition is that the cell area selected by the target object on the target product has only one cell, and the number of rows of the largest big title table area to which the cell belongs is greater than the number of rows of the continuous area; Determine the second recommended solution based on the multiple target information, where the second recommended solution at least includes the following in sequence: the largest big title table area, the first list of big title table areas, the largest non-empty area, the entire area of the spreadsheet, and the merged selection area; Determine the list of areas recommended for the target object based on the second recommended solution.

8. The method according to claim 5, wherein Determine the list of areas recommended for the target object based on the multiple target information and the target operation, including: If the target condition meets the third condition, where the third condition is that the number of cells in the cell area selected by the target object on the target product is multiple; Determine the third recommended solution based on the multiple target information, where the third recommended solution at least includes the following in sequence: the largest non-empty area, the largest big title table area, the first list of big title table areas, the merged selection area, the entire area of the spreadsheet, the list of sub-tables of the spreadsheet; Determine the list of areas recommended for the target object based on the third recommended solution.

9. The method according to claim 5, characterized in that, Determine the list of areas recommended for the target object based on the multiple target information and the target operation, including: If the target condition meets the fourth condition, where the fourth condition is that the cell area selected by the target object on the target product has only one cell; Determine the fourth recommended solution based on the multiple target information, where the fourth recommended solution at least includes: the largest non-empty area, the largest big title table area, the first list of big title table areas, the entire area of the spreadsheet, the merged selection area; Determine the list of areas recommended for the target object based on the fourth recommended solution.

10. The method according to claim 5, characterized in that, Determine the list of areas recommended for the target object based on the recommended solution, including: If there are duplicate areas in the recommended solution, delete the duplicate areas in the recommended solution; Use the remaining selected areas after deleting the duplicate areas in the recommended solution as the list of areas recommended for the target object.

11. A recommendation device for regional information, characterized in that, Including: The first acquisition unit is used to acquire the target operation of the target object on the target product and the data information of the target product; A first recognition unit, configured to recognize product structure information of the target product according to the data information, where the product structure information includes at least one of the following: worksheet sub-regions, recognition types, and regional coordinates, and the recognition types include at least one of the following: big titles, row titles, content, blank rows, and blank columns; A first determination unit, configured to determine multiple target information of the target product according to the product structure information; A second determination unit, configured to determine a list of regions recommended for the target object according to the multiple target information and the target operation; Wherein, the target product is a spreadsheet, and the types of table rows in the spreadsheet include: big titles, row titles, table content, and blank rows; determining the multiple target information of the target product according to the product structure information in the spreadsheet includes: Cutting the entire region of the spreadsheet using blank columns to obtain at least one non-blank column region; Using big titles to cut each non-blank column region to obtain a first list of big title table regions; Regarding the first list of big title table regions and the entire region of the spreadsheet as the target information; The apparatus further includes: A third determination unit, configured to, after recognizing the product structure information of the target product according to the data information, determine a list of cell regions selected by the target object on the target product according to the target operation; A fourth determination unit, configured to determine the largest region of the coordinate positions where the list of selected cell regions is located to obtain a merged selection area; A fifth determination unit, configured to regard the merged selection area as the target information.

12. A computer-readable storage medium, characterized in that, The storage medium includes a stored program, where the program executes the region information recommendation method according to any one of claims 1 to 10.

13. A processor, characterized in that, The processor is configured to run a program, where when the program runs, it executes the region information recommendation method according to any one of claims 1 to 10.

Images