A method for extracting and processing table content for online quick sharing

Abstract

The present invention provides a method for extracting and processing table content for online quick sharing, belonging to the technical field of online sharing. The table includes content cells and contact cells; each contact cell corresponds to multiple content cells. The method includes the following steps: S1: Obtaining multiple table content selection operations of a user; S2: Based on the multiple content selection operations of the user, screening out multiple table contents to be shared and multiple table contacts; S3: Sharing each table content to be shared with the corresponding contact to be shared; the contact to be shared is an online contact determined after activating at least one sharing software based on the table contact. The present invention also discloses a human-computer interaction terminal and a computer-readable storage medium for implementing the method. The present invention can intelligently identify the association between table contacts and table content, permissions and contact persons of triggered sharing software, so as to realize distributed sending and sharing of table content at different levels and with different permissions.

Description

Technical Field

[0001] The present invention belongs to the technical field of online sharing, and particularly relates to a method for extracting and processing table content for online fast sharing, a human-computer interaction terminal for implementing the method, and a computer-readable storage medium. Background Art

[0002] Microsoft Excel is a spreadsheet software developed by Microsoft for computers using Windows and Apple Macintosh operating systems. Its intuitive interface, excellent calculation functions and chart tools, combined with successful marketing, have made Excel the most popular personal computer data processing software. With the further enrichment of function development, spreadsheet software can achieve a variety of complex content editing and statistics, and the content that can be input into the table is diverse, including text, pictures and even multimedia data.

[0003] In an office scenario, spreadsheet software is needed to count various data, including employee information, employee salaries, etc. Among them, employee information involves personal privacy information such as text and pictures, and employee salaries need to be sent to each employee separately. Usually, after the user uses the table software to count all employees' employee information or employee salary information, they send it to the corresponding contacts one by one through other means.

[0004] However, it is found in actual applications that due to the different contact information of different employees and different receiving channels for information, users usually need to copy the information one by one and then select the corresponding sending channels; in addition, the levels of different employees are also different, and the security of sending information also varies. The process of manually selecting the sending channels and selecting the information to be sent for security processing is very inefficient. When the number of employees exceeds a certain number, the table software itself needs to have frequent data interactions with other information sending channels, which in turn affects the performance of the table software itself and further reduces the office efficiency. Summary of the Invention

[0005] To solve the above technical problems, the present invention proposes a method for extracting and processing table content for online fast sharing, a human-computer interaction terminal for implementing the method, and a computer-readable storage medium.

[0006] In the present invention, the table includes content cells and contact cells;

[0007] Each content cell corresponds to at least one contact cell; each contact cell corresponds to multiple content cells, and different contacts have different sharing levels (table content viewing permissions) and sharing trigger methods (activating different sharing software).

[0008] Based on the above application scenarios, in the first aspect of the present invention, a method for extracting and processing table content for online quick sharing is provided. The method includes steps S1 - S3, and the specific implementation of each step is as follows:

[0009] S1: Obtain multiple table content selection operations of the user;

[0010] S2: Based on the multiple content selection operations of the user, screen out multiple table contents to be shared and multiple table contacts;

[0011] S3: Share each table content to be shared with the corresponding contact to be shared;

[0012] Among them, the contact to be shared is an online contact determined after activating at least one sharing software based on the table contact.

[0013] In the present invention, a table permission personnel database that can be updated is established in advance. The table permission personnel database stores the viewing permissions of table content for each contact, and the sharing level is related to the viewing permissions of the table content.

[0014] Different sharing levels correspond to different sharing software; the type of sharing software to be activated can be determined based on the sharing level of the table contact, and the sharing software includes social software.

[0015] In the above method, before the step S1, the method further includes the following steps:

[0016] S100: Open the target table;

[0017] S110: Identify the contact cells included in the target table;

[0018] S120: Match the content of the contact cells with the table permission personnel database to determine the sharing level of each table contact and the number of contacts to be shared;

[0019] S130: Establish a circular stack based on the sharing level and the number of contacts to be shared;

[0020] The step S2 includes: storing the multiple table contents to be shared and the multiple table contacts corresponding to each other into the circular stack.

[0021] More specifically, the circular stack includes an inner - ring storage stack and an outer - ring storage stack;

[0022] The inner - ring storage stack contains a first number of inner - ring stack storage units, and the outer - ring storage stack includes a second number of outer - ring stack storage units;

[0023] The first number is the same as the number of contacts to be shared;

[0024] The second quantity is the same as the number of levels of the sharing level.

[0025] When the outer ring stack storage unit of the outer ring storage stack is full, share the content of the to-be-shared form corresponding to the full outer ring stack storage unit to the corresponding to-be-shared contact.

[0026] To implement the above method steps, in the second aspect of the present invention, a human-computer interaction terminal is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the above steps are implemented.

[0027] In the fourth aspect of the present invention, a data storage medium is provided, for example, a computer-readable storage medium. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above steps are implemented.

[0028] The present invention can intelligently identify the association between the form contacts and the form content, and the permissions and the sharing software contacts triggered, so as to realize the distributed sending and sharing of the form content at different levels and with different permissions.

[0029] The further advantages of the present invention will be further detailed in the specific embodiment part in combination with the accompanying drawings of the specification. Description of the Drawings

[0030] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required to be used in the embodiments. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0031] Figure 1 It is a main step flowchart of a method for extracting and processing form content for online quick sharing according to an embodiment of the present invention;

[0032] Figure 2 It is a schematic diagram of a to-be-shared form involved in each embodiment of the present invention;

[0033] Figure 3 Shows Figure 1 A schematic diagram of the circular stack used in the embodiment;

[0034] Figures 4 - 5 Based on Figure 3 A further preferred embodiment schematic diagram of the circular stack;

[0035] Figure 6It is a schematic diagram showing the effect of realizing the distributed sending and sharing of table content at different levels and with different permissions;

[0036] Figure 7 It is a schematic diagram of the structure of an electronic device for implementing the technical solution of the present invention. Detailed implementation manners

[0037] Next, with reference to the accompanying drawings and specific implementation manners, the invention will be further described.

[0038] Refer to Figure 1 , which is a main step flowchart of a method for extracting and processing table content for online quick sharing according to an embodiment of the present invention. Figure 1 It shows that the steps include steps S1 - S3, and each step is specifically implemented as follows:

[0039] S1: Obtain multiple table content selection operations of the user;

[0040] S2: Based on the multiple content selection operations of the user, screen out multiple table contents to be shared and multiple table contacts;

[0041] S3: Share each table content to be shared with the corresponding contact to be shared;

[0042] Among them, the contact to be shared is an online contact determined after activating at least one sharing software based on the table contact.

[0043] Figure 2 It shows a schematic diagram of the table to be shared involved in various embodiments of the present invention.

[0044] In Figure 2 , the table includes content cells and contact cells; each content cell corresponds to at least one contact cell; each contact cell corresponds to multiple content cells.

[0045] Taking Figure 2 as an example, the contact cells include rows "Name 1", "Name 2", "Name 3",..., and the content cells include columns "Item 1", "Item 2", "Item 3",...; among them, each name represents a contact, and the content of "Item 1", "Item 2", "Item 3",... corresponding to the name row represents the information belonging to the name, such as the "name", "monthly salary", "employee number", "punch fingerprint pattern", etc. of employee Zhang San.

[0046] Among them, different contacts have different sharing levels (table content viewing permissions) and sharing triggering methods (activating different sharing software).

[0047] Accordingly, a table permission personnel database that can be updated is established in advance. The table permission personnel database stores the table content viewing permissions of each contact, and the sharing level is related to the table content viewing permissions. Different sharing levels correspond to different sharing software; the type of sharing software to be activated can be determined based on the sharing level of the table contacts.

[0048] Wherein, before the step S1, the method further includes the following steps:

[0049] S100: Open the target table;

[0050] S110: Identify the contact cells included in the target table;

[0051] S120: Match the content of the contact cells with the table permission personnel database to determine the sharing level of each table contact and the number of contacts to be shared;

[0052] S130: Establish a circular stack based on the sharing level and the number of contacts to be shared;

[0053] Then, execute step S1: Obtain multiple table content selection operations of the user;

[0054] More specifically, obtain the table content selection operations of the user one by one.

[0055] When the user selects a certain name cell, after automatically identifying the table content viewing permission of the contact included in the name cell, perform display level processing on the content of at least some content cells in the table corresponding to the name cell;

[0056] The level of the table content viewing permission represents the range of table content that the current contact can view.

[0057] The sharing level of the user represents the way to send the table content that the current contact can view to the current contact.

[0058] Take Figure 2 as an example. Suppose after the user selects the cell of "Name 1", it is determined that the table content viewing permission of the contact in the current cell does not include "Item 1", then the display level processing of the content of at least some content cells in the table corresponding to the name cell is: mask the content of the "Item 1" content cell corresponding to "Name 1", for example, display a mosaic;

[0059] Assume that after the user selects the cell of "Name 2", it is determined that the viewing permission of the table content of the contact in the current cell does not include "Item 2", then the display level processing of the content of at least some of the content cells corresponding to the name cell in the table is as follows: the content of the "Item 2" content cell corresponding to "Name 2" is blocked, for example, a mosaic is displayed;

[0060] Similarly, the display level processing of the content of at least some of the content cells corresponding to the name cell in the table also includes displaying a thumbnail of the original content. For example, the originally stored high-definition "punch fingerprint map" in the cell is processed so that when the user selects the cell of "Name 3", only the "thumbnail" is displayed.

[0061] Meanwhile, when the user selects a name cell, the sharing level of the table content of the contact included in the name cell is automatically recognized.

[0062] The sharing level is related to the viewing permission of the table content. Different sharing levels correspond to different sharing software; the type of sharing software to be activated can be determined based on the sharing level of the table contact.

[0063] The sharing level is related to the viewing permission of the table content. The greater the viewing permission of the table content, the higher the sharing level, and the more secure sharing channels should be selected; the highest sharing method is to share the table content through an encrypted channel

[0064] As an example, the sharing level can be divided into levels 1-10, where level 1 has the highest sharing level and level 10 has the lowest. The viewing permission of the table content can be divided into five levels: "low - medium - relatively high - high - highest".

[0065] When the viewing permission of the table content is "low", the sharing level is 1-2; when the viewing permission of the table content is "medium", the sharing level is 3-4; when the viewing permission of the table content is "relatively high", the sharing level is 5-6; when the viewing permission of the table content is "high", the sharing level is 7-8; when the viewing permission of the table content is "low", the sharing level is 9-10.

[0066] Preferably, each viewing permission of the table content corresponds to multiple sharing levels.

[0067] On this basis, step S2 includes: storing the multiple pieces of table content to be shared screened out and multiple table contacts in the circular stack correspondingly.

[0068] As an example, when the user selects the cell of "Name 1", the multiple tables to be shared include multiple entries in the row where "Name 1" is located ("Entry 1", "Entry 2", "Entry 3",..., where "Entry 1" is in mosaic form), and the corresponding contact person for the tables to be shared is "Name 1".

[0069] Next Figure 3 shows the specific storage structure of the circular stack used in each embodiment of the present invention. The circular stack includes an inner ring storage stack and an outer ring storage stack;

[0070] The inner ring storage stack contains a first number of inner ring stack storage units, and the outer ring storage stack includes a second number of outer ring stack storage units;

[0071] The first number is the same as the number of contacts to be shared; the second number is the same as the number of levels of the sharing level.

[0072] Further, as a preference, each inner ring stack storage unit is associated with multiple outer ring stack storage units, that is, the second number is an integer multiple of the first number.

[0073] It can be understood that the above-mentioned preferred improvement is an overall one associated with multiple sharing levels corresponding to the viewing permissions of the foregoing table content. After the table contacts are stored in the inner ring storage stack, the table contacts have a determined viewing permission for the table content. Since each viewing permission for the table content corresponds to multiple sharing levels, therefore, the tables to be shared need to be stored in the outer ring storage stack, and the number of outer ring storage stacks needs to be greater than that of the inner ring storage stacks, so as to achieve hierarchical and permission-based data storage and reading.

[0074] Therefore, as a further embodiment, refer to Figure 4 , step S2 includes: storing the multiple tables to be shared screened out into the outer ring storage stack; storing the multiple table contacts screened out into the inner ring storage stack.

[0075] Next refer to Figure 5 , as a further improvement,

[0076] When the outer ring stack storage units of the outer ring storage stack are full, share the tables to be shared corresponding to the full outer ring stack storage units to the corresponding contacts to be shared.

[0077] Combined with Figures 4 - 5 , several key improvements adopted in the above embodiments are introduced in detail:

[0078] (1) The storage structure of the stack, especially the storage structure of the circular stack

[0079] The storage feature of the stack is last-in-first-out. Therefore, it can ensure that the data finally selected by the current user can be taken out of the stack first, thus achieving fast sharing. According to practical experience, the data finally selected is often the data finally confirmed by the user, with relatively high accuracy. This cannot be achieved if conventional array or queue structures are used, which will affect the user experience;

[0080] The further adopted circular stack can avoid "overflow".

[0081] When the user operates on table data, generally, the user does not realize how much data has been selected currently. And when using the method of the present invention, it is necessary to store the multiple table contents to be shared and the multiple table contacts corresponding to them in the stack each time. If a linear stack or ordinary data is used, due to the limited storage space, data overflow may occur quickly.

[0082] Although the space of the stack is also limited, by using a circular stack, the data stored last can automatically eliminate the data stored earliest, avoiding the "overflow" phenomenon.

[0083] (2)Sharing when the stack is full

[0084] If the user sends sharing in real time every time one is selected, it will lead to frequent data interaction between the table processing software and the external sharing channels, thus affecting the performance of the table processing software itself;

[0085] Therefore, in the embodiments of the present invention, when the outer ring stack storage unit of the outer ring storage stack is full, the table content to be shared corresponding to the full outer ring stack storage unit is shared with the corresponding contact to be shared.

[0086] Combined with the above-mentioned last-in-first-out feature of the stack, it can also ensure that the quantity of each sharing is within a reasonable range, and ensure that it is the latest data finally confirmed by the user, reducing the data interaction between the table processing software and the external sharing channels, and ensuring the user performance.

[0087] As a further preference, the storage space size of the outer ring stack of the circular stack is adjustable.

[0088] Finally, refer to Figure 6 . In Figure 6 shows a schematic diagram of the effect of realizing distributed sending and sharing of table contents with different levels and permissions.

[0089] It should be noted that in the sharing schematic diagram of Figure 6 , the sharing for Name 1 and Name 3 may be simultaneous or sequential.

[0090] This is because Name 1 and Name 3 are stored in different inner ring storage stacks, which respectively correspond to outer ring storage stacks of different sizes. And the times when different outer ring storage stacks are full are different.

[0091] In Figure 6 for Name 1, since its sharing level is relatively high, encrypted emails are used; for Name 3, since its sharing level is relatively low, ordinary methods such as WeChat or text messages are used.

[0092] Based on the technical solution of the present invention, the above process has been automatically determined when the user selects the contact cell, that is, by matching the content of the contact cell with the table permission personnel database, the sharing level of each table contact and the number of contacts to be shared are determined.

[0093] The table permission personnel database stores the viewing permissions of the table content for each contact, and the sharing level is related to the viewing permissions of the table content.

[0094] Then, when the corresponding outer ring storage stack is full, the corresponding sharing software is activated to start sharing the table content.

[0095] Therefore, the present invention can intelligently identify the association between table contacts and table content, the permissions and the contacts of the sharing software triggered, so as to achieve distributed sending and sharing of table content at different levels and with different permissions, and at the same time avoid the low performance of the table processing software or data overflow caused by frequent data interaction.

[0096] The steps, methods or processes described in the foregoing embodiments can all be automatically implemented by computer program instructions. Therefore, referring to Figure 7 there is provided an electronic device, which can be a human-computer interaction terminal, including a processor, a memory and a bus. The memory is used to store a table processing program, and the table processing program includes program instructions. The processor is used to execute the program instructions stored in the computer storage medium, so as to implement the method steps.

[0097] In another embodiment, the present invention further provides a data storage medium, such as a computer-readable storage medium (Memory). The computer-readable storage medium is a memory power secondary device in the terminal power secondary device and is used to store programs and data. It can be understood that the computer-readable storage medium here can include both the built-in storage medium in the terminal power secondary device and, of course, the extended storage medium supported by the terminal power secondary device. The computer-readable storage medium provides a storage space, and the operating system of the terminal is stored in this storage space. Moreover, one or more instructions suitable for being loaded and executed by the processor are stored in this storage space. These instructions can be one or more computer programs (including program codes). It should be noted that the computer-readable storage medium here can be a high-speed RAM memory or a non-volatile memory, such as at least one disk memory.

[0098] Those skilled in the art should 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 memories, CD-ROMs, optical memories, etc.) containing computer-usable program codes.

[0099] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications or equivalent replacements can still be made to the specific implementation manners of the present invention. Any modification or equivalent replacement that does not depart from the spirit and scope of the present invention shall be covered by the protection scope of the claims of the present invention.

[0100] For the part of the module structure not specifically defined in the present invention, the content recorded in the prior art shall prevail. The prior art mentioned in the foregoing background art section of the present invention can be used as a part of the present invention to understand the meaning of some technical features or parameters. The protection scope of the present invention shall be subject to the content actually recorded in the claims.

Claims

1. An online fast-sharing method for extracting and processing table content, characterized in that, The method includes the following steps: S1: Obtain multiple table content selection operations of the user; S2: Based on the multiple content selection operations of the user, filter out multiple table contents to be shared and multiple table contacts; S3: Share each table content to be shared with the corresponding contact to be shared; Wherein, the contact to be shared is an online contact determined after activating at least one sharing software based on the table contact; Before the step S1, the method further includes the following steps: S100: Open the target table; S110: Identify the contact cells included in the target table; S120: Match the content of the contact cells with the table permission personnel database to determine the sharing level of each table contact and the number of contacts to be shared; the table permission personnel database stores the viewing permissions of table content for each contact, the sharing level is related to the viewing permissions of table content; the greater the viewing permissions of table content, the higher the sharing level, and a more secure sharing channel should be selected; the highest sharing level sharing method is to share the table content through an encrypted channel; S130: Establish a circular stack based on the sharing level and the number of contacts to be shared; The step S2 includes: Correspondingly store the multiple table contents to be shared and the multiple table contacts screened out into the circular stack; The circular stack includes an inner ring storage stack and an outer ring storage stack; The inner ring storage stack contains a first number of inner ring stack storage units, and the outer ring storage stack includes a second number of outer ring stack storage units; The first number is the same as the number of contacts to be shared; The second number is the same as the number of levels of the sharing level; Each inner ring stack storage unit is associated with multiple outer ring stack storage units, that is, the second number is an integer multiple of the first number; The step S2 includes: Store the multiple table contents to be shared screened out into the outer ring storage stack; Store the multiple table contacts screened out into the inner ring storage stack; The step S3 includes: When the outer ring stack storage unit of the outer ring storage stack is full, share the table content to be shared corresponding to the full outer ring stack storage unit with the corresponding contact to be shared.

2. An online fast-sharing table content extraction and processing method according to claim 1, characterized in that: The table includes content cells and contact cells; Each content cell corresponds to at least one contact cell; Each contact cell corresponds to multiple content cells.

3. An online fast-sharing table content extraction and processing method according to claim 1, characterized in that: Different sharing levels correspond to different sharing software; Based on the sharing level of the table contact, determine the type of sharing software to be activated.

4. A human-computer interaction terminal, the human-computer interaction terminal includes a memory and a processor, the memory stores a table processing program, and by executing the table processing program through the processor, it is used to implement the steps of an online fast-sharing table content extraction and processing method according to any one of claims 1-3.

5. A computer-readable storage medium storing one or more computer programs which, when executed, are configured to implement the method according to any one of claims 1-3.

Images