Interaction method and apparatus for table document, electronic device, and storage medium

Abstract

Embodiments of the present disclosure provide an interaction method and apparatus for a table document, an electronic device, and a storage medium. The method comprises: displaying a wide table document in an interaction interface, the wide table document being provided with at least two data columns, and at least one data column among the at least two data columns being unable to be completely displayed in a current view page of the interaction interface; on the basis of document content of the wide table document, displaying at least one data label corresponding to a data column in the interaction interface; and in response to a trigger operation for a target data label, controlling the interaction interface to move to a target view page, the target view page being used for positioning and displaying a target data column corresponding to the target data label. By displaying the data label corresponding to the data column, and moving the target data label to the corresponding target view page in response to the trigger operation for the target data label, the rapid positioning of the target data column is achieved in the interaction scene for the wide table document comprising multiple data columns, and the interaction efficiency for wide tables is improved.

Description

[0001]This application claims priority to Chinese Patent Application No. 202311747223.X, filed on December 18, 2023. The disclosure of the aforementioned Chinese Patent Application is hereby incorporated by reference in its entirety as a part of this application. Technical Field: Embodiments of the present disclosure relate to a method, apparatus, electronic device, and storage medium for interacting with tabular documents. Background: Tabular documents are a common document format that records data in rows and columns, enabling intuitive and efficient information display and processing. Tabular documents typically record a data object in a row and the corresponding object content in a column. During the interactive process of viewing and editing such tabular documents, users often need to manually locate the edited content, resulting in low interaction efficiency. SUMMARY: Embodiments of the present disclosure provide a method, apparatus, electronic device, and storage medium for interacting with tabular documents to overcome this low efficiency. In a first aspect, an embodiment of the present disclosure provides an interactive method for a table document, comprising: displaying a wide table document in an interactive interface, the wide table document having at least two data columns, at least one of the at least two data columns being unable to be fully displayed in a current view page of the interactive interface; displaying at least one data tag corresponding to the data column in the interactive interface based on document content of the wide table document; and controlling the interactive interface to display a positioning view page in response to a triggering operation on the target data tag, the positioning view page being used to position and display the data column corresponding to the target data tag. In a second aspect, embodiments of the present disclosure provide an interactive device for a table document, comprising: a display module configured to display a wide table document within an interactive interface, the wide table document having at least two data columns, at least one of the at least two data columns being incompletely displayed within a current view page of the interactive interface; a processing module configured to display at least one data tag corresponding to the data column within the interactive interface based on the document content of the wide table document; and a control module configured to control the interactive interface to display a positioning view page in response to a triggering operation for a target data tag, the positioning view page being configured to position and display the data column corresponding to the target data tag. In a third aspect, embodiments of the present disclosure provide an electronic device, comprising: a processor and a memory; the memory storing computer-executable instructions; the processor executing the computer-executable instructions stored in the memory, causing the at least one processor to perform the interactive method for a table document as described in the first aspect and various possible designs of the first aspect.In a fourth aspect, embodiments of the present disclosure provide a computer-readable storage medium storing computer-executable instructions. When a processor executes the computer-executable instructions, the method for interacting with a table document as described in the first aspect and various possible designs of the first aspect is implemented. In a fifth aspect, embodiments of the present disclosure provide a computer program product comprising a computer program. When executed by a processor, the computer program implements the method for interacting with a table document as described in the first aspect and various possible designs of the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS In order to more clearly illustrate the embodiments of the present disclosure or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the prior art descriptions. Obviously, the drawings described below are some embodiments of the present disclosure. For those skilled in the art, other drawings can be obtained based on these drawings without inventive work. FIG. 1 is an application scenario diagram of the interactive method for a table document provided in an embodiment of the present disclosure; FIG. 2 is a flowchart of the interactive method for a table document provided in an embodiment of the present disclosure; FIG. 3 is a schematic diagram of a data tag provided in an embodiment of the present disclosure; FIG. 4 is a flowchart of a specific implementation of step S102 in the embodiment shown in FIG. 2; FIG. 5 is a flowchart of a specific implementation of step S1021 in the embodiment shown in FIG. 4; FIG. 6 is a schematic diagram of a process for locating a target data column provided in an embodiment of the present disclosure; FIG. 7 is a flowchart of a second flowchart of the interactive method for a table document provided in an embodiment of the present disclosure; FIG. 8 is a flowchart of a specific implementation of step S204 in the embodiment shown in FIG. 7; FIG. 9 is a schematic diagram of highlighting a data tag provided in an embodiment of the present disclosure; FIG. 10 is a flowchart of a specific implementation of step S206 in the embodiment shown in FIG. Figure 11 is a block diagram of an interactive device for table documents provided in an embodiment of the present disclosure; Figure 12 is a schematic diagram of the structure of an electronic device provided in an embodiment of the present disclosure; and Figure 13 is a schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS To further clarify the objectives, technical solutions, and advantages of the embodiments of the present disclosure, the technical solutions in the embodiments of the present disclosure will be described clearly and completely below in conjunction with the accompanying drawings. It should be understood that the described embodiments are only a portion of the embodiments of the present disclosure, and are not exhaustive. All other embodiments derived by persons of ordinary skill in the art based on the embodiments of the present disclosure without inventive effort are intended to fall within the scope of protection of the present disclosure.It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this disclosure are all information and data authorized by the user or fully authorized by all parties. The collection, use, and processing of relevant data must comply with the relevant laws, regulations, and standards of relevant countries and regions, and corresponding operation portals are provided for users to choose to authorize or refuse. The application scenarios of the embodiments of the present disclosure are explained below: Figure 1 is an application scenario diagram of the interactive method for table documents provided by the embodiments of the present disclosure. The interactive method for table documents provided by the embodiments of the present disclosure can be applied to applications with the function of displaying table documents. More specifically, it can be applied to application scenarios for displaying and editing wide table documents. The execution entity of this embodiment can be a terminal device running the above-mentioned application with the function of displaying table documents, or a server deploying the server corresponding to the above-mentioned application, or other electronic devices that perform similar functions. Referring to FIG. 1 , taking a terminal device as an example, after running the aforementioned application program (specifically, spreadsheet software) capable of displaying and editing spreadsheet documents, the terminal device loads the spreadsheet document online or offline and displays it within the application's interactive interface. The user can then view and further edit the spreadsheet document through the interactive interface. As shown in FIG. 1 , a spreadsheet document typically includes multiple rows and columns of data. Each row corresponds to a data object, and each column records the object content corresponding to the data object. During interaction with such a spreadsheet document, if the spreadsheet document contains too many rows of data to be fully displayed on a single view page, the user is required to flip the page up or down (e.g., by dragging the scroll bar) to switch the current view page of the interactive interface to display data objects outside the current view page. If the spreadsheet document contains too many columns of data to be fully displayed on a single view page, the user is required to flip the page left or right to switch the current view page of the interactive interface to display object content outside the current view page. However, in actual applications, data rows are usually arranged based on a content dimension, such as "user name" or "object ID." Therefore, even when there are a large number of data rows, locating the data rows is relatively easy. Data columns usually correspond to an independent data content dimension, such as data column #1 recording the object content of "time" and data column #2 recording the object content of "location."Each data column is independent and related, with no sequential relationship. Locating a data column in a wide table document requires the user to manually navigate the interactive interface multiple times, moving the view horizontally and observing the content. Because the content dimensions corresponding to the data columns in a wide table document are independent, and multiple data columns cannot be displayed on the same view page, a complex "operation-observation" process is required to locate the target data column of interest. This results in low interaction efficiency for wide table documents. The present embodiment provides an interactive method for table documents to address the aforementioned issues. Referring to FIG. 2 , FIG. 2 is a first flow diagram of the interactive method for table documents provided by the present embodiment. The method of this embodiment can be applied in a terminal device. The interactive method for table documents includes: Step S101: Displaying a wide table document in an interactive interface, wherein the wide table document has at least two data columns, at least one of which cannot be fully displayed within the current view page of the interactive interface. Step S102: Displaying at least one data label corresponding to the data column in the interactive interface based on the document content of the wide table document. Exemplarily, referring to the application scenario diagram shown in FIG1 , after a terminal device runs an application program (such as spreadsheet software) capable of displaying a table document, the wide table document is displayed through the interactive interface of the application program. Specifically, first, through the document loading interface of the application program, a table file stored locally on the terminal device or in the cloud is selected and loaded into the terminal device. The terminal device parses the data in the table file and generates a wide table document based on table style parameters or a table template, and displays the document in the interactive interface. The table style parameters or the table template may be preset in the terminal device (application program). Based on the table style parameters or the table template, the appearance style of the wide table document may be set, for example, table line width, row height, column width, etc. The specific implementation method may be set as needed and will not be described in detail here. Further, as described in the previous section, a wide table document is a table document with a special table structure. A wide table document has multiple columns for recording the object content of the data object corresponding to a data row within an independent content dimension. For example, the data object corresponding to a data row is "user ID," and the data column corresponding to each "user ID" is used to record the object content within the independent content dimension corresponding to that "user ID." Object content includes, for example, "creation time," "request content," and "authorization level." These object contents, such as "creation time," "request content," and "authorization level," correspond to independent content dimensions.At the same time, at least one of the at least two data columns cannot be fully displayed within the current view page of the interactive interface. For such wide table documents, the view page must be moved horizontally to view the content. Subsequently, the terminal device displays the data labels corresponding to the data columns based on the document content of the wide table document. In one possible implementation, after the table document content is displayed, the terminal device may display the data labels corresponding to the data columns in response to a user trigger instruction, such as clicking a specific trigger button. In another possible implementation, the terminal device may synchronously display the data labels corresponding to the data columns after the table document content is displayed. The specific configuration can be set based on needs. The correspondence between data labels and data columns can be achieved by aligning the data labels with the column headers. That is, visually, after displaying the wide table document, the terminal device displays the column headers of each data column in the wide table document in the interactive interface, enabling quick location of each data column. More specifically, the column headers can be the titles corresponding to each data column, or they can be attribute information bound to the data column, recorded in a wide table document and retrieved when the wide table document is loaded. Figure 3 is a schematic diagram of a data label provided by an embodiment of the present disclosure. As shown in Figure 3, a wide table document data_1 containing N data columns is displayed in the first area of ​​the interactive interface of a terminal device. Simultaneously, after loading the table document data_1, the terminal device displays N data labels (labeled Label #1, Label #2, through Label #N in the figure) in the second area of ​​the interactive interface. Each data label corresponds to a data column, and the label content of each data label can be the column title of the data column. Furthermore, in one possible implementation, the data labels are implemented using a label control group. The label control group is placed in a designated location of the interactive interface, such as the second area in the embodiment shown in Figure 3. The label control group can be a control set that aggregates multiple trigger controls, or a control container that hosts trigger controls. The label control group can be used to set the display status of the trigger control integrated within the label control group, specifically, for example, showing or hiding the trigger control, display position, and display style. Accordingly, in one possible implementation, as shown in FIG4 , the specific implementation of step S102 includes: Step S1021: Obtaining the column headers corresponding to each data column. Step S1022: Determining the target control object within the label control group based on the column headers. Step S1023: Configuring the label control group based on the target control object to display the data labels within the label control group.For example, in one possible implementation, after loading a wide table document, the terminal device directly obtains the preconfigured column headers corresponding to each data column. The column headers are static information pre-stored in the wide table document, and the implementation will not be further described. Subsequently, the terminal device determines the target control object within the label control group based on the column headers. Specifically, for example, a corresponding number of trigger control objects are created based on the number of column headers, and each trigger control object is mapped to a corresponding data column to generate a target control object. Furthermore, a corresponding positioning anchor point can be set for the data column within the interactive interface. The target control object and the positioning anchor point are then associated. When the target control object is triggered, the view page of the interactive interface is horizontally moved to the position of the positioning anchor point, thereby achieving data column positioning. The control name of each target control object is set to the corresponding column header, so that it is displayed as a data label. Finally, the generated target control object is used to configure a label control group, thereby displaying the target control object within the label control group. The control name of the target control object is set to column title, thereby displaying the data labels (column titles) corresponding to each data column. Furthermore, in another possible implementation, when the wide table document does not include pre-configured column titles, column titles are dynamically generated based on the data content of each data column, and data labels are then generated for display. For example, as shown in FIG5 , the specific implementation of step S1021 includes: Step S1021A: Obtaining the object content of at least one data object under the data column. Step S1021B: Processing the object content based on the language model to generate summarized content corresponding to the data column. Step S1021C: Generating column titles based on the summarized content. Exemplarily, after loading a wide table document, the terminal device first obtains the object content of at least one data object under each data column. Specifically, data objects are recorded based on data rows. Therefore, for example, the terminal device obtains the data of the first three rows of the loaded wide table document, i.e., three data objects. The terminal device then performs content extraction on each data column of the three data objects to obtain the object content. For example, data column A corresponds to three object contents (of data objects): content A_1, content A_2, and content A_3. The terminal device then utilizes the content understanding and summarization capabilities of the Large Language Model (LLM) to generate corresponding summary content A_summary. This summary content A_summary is then used as the column heading of data column A.Similarly, data column B also corresponds to three columns. Based on the large language model and the three object contents corresponding to data column B, a column title for data column B, namely, the summary content B summary, can be obtained. Further description is omitted. Furthermore, in the process of generating the summary content (step S1021B), the object contents corresponding to each data column can be grouped into content groups (for example, in the previous embodiment, content A_1, content A_2, and content A_3 constitute a content group). These content groups are then simultaneously fed into the language model for processing. Accordingly, the language model processes the content groups corresponding to each data column to generate summary content corresponding to each data column. In this embodiment, by feeding the content groups into the language model for processing, the language model can refer to the content-related characteristics of each content group, thereby more accurately understanding the meaning of the object content recorded in each data column and generating more accurate column titles, thereby improving the efficiency of subsequently locating the target data column. Step S103: In response to a trigger operation on the target data tag, the interactive interface is controlled to move to a positioning view page, which is used to locate and display the target data column corresponding to the target data tag. Exemplarily, after the data tag corresponding to the data column is displayed in the interactive interface, a content-location mapping association is established between the data tag and the corresponding data column. Subsequently, when the user triggers the target data tag, the terminal device controls the interactive interface to move horizontally to the positioning view page corresponding to the target data tag, thereby locating the target data column corresponding to the target data tag. Specifically, for example, a positioning anchor point of the target data column corresponding to the target data tag is obtained; the interactive interface is controlled to move to the positioning anchor point to display the positioning view page. Specifically, for example, the first leftmost or rightmost instance of the positioning view page is the target data column. Therefore, after the interactive interface moves to the positioning view page, the positioning view page can be used to locate the target data column. FIG6 is a schematic diagram of a process for locating a target data column according to an embodiment of the present disclosure. Referring to FIG6 , illustratively, initially, a wide table document containing multiple data columns is displayed in an interactive interface of a terminal device. The wide table document includes a plurality of data columns, and a portion of the data columns are fully displayed in the current view page of the interactive interface. For example, as shown in the figure, the column headings of the data columns displayed in the current view page are: Data Column A, Data Column B, and Data Column C. Subsequently, the user clicks data label #1 in the interactive interface. The label name of data label #1 is "Task Completion Status."Afterward, the terminal device controls the translation of the interactive interface's view page based on the triggering of data tag #1. As shown in the figure, after the interactive interface's view page translates to the positioning view page, the first left column in the positioning view page becomes the target data column corresponding to data tag #1. The column heading for this target data column is "Task Completion Status." The content of each row in this target data column is data related to "Task Completion Status." Simultaneously, based on the original positional relationship between the data columns in the wide table text, two additional pages following the target data column are displayed in the positioning view page. Their column headings are "Data Column C" and "Data Column D," respectively. In this embodiment, a wide table document is displayed in an interactive interface. The wide table document has at least two data columns, at least one of which cannot be fully displayed within the current view page of the interactive interface. Based on the document content of the wide table document, data labels corresponding to the data columns are displayed in the interactive interface. In response to a trigger operation on a target data label, the interactive interface is controlled to move to a positioning view page, which is used to locate and display the target data column corresponding to the target data label. By displaying data labels corresponding to the data columns based on the document content while displaying the wide table document, data columns are marked. In response to a trigger operation on the target data label, the interface moves to the corresponding positioning view page to locate the target data column corresponding to the target data label. This allows for rapid location of the target data column in interactive scenarios involving wide table documents containing multiple data columns, improving interaction efficiency with wide tables. Referring to FIG. 7 , FIG. 7 is a second flow diagram of an interactive method for table documents provided in an embodiment of the present disclosure. Based on the embodiment shown in FIG. 2 , this embodiment further refines step S103. The steps of interacting with a user are described in this interactive method for a table document, including: Step S201: Displaying a wide table document within an interactive interface. The wide table document has at least two data columns, at least one of which cannot be fully displayed within the current view page of the interactive interface. Step S202: Displaying data labels corresponding to the data columns within the interactive interface based on the document content of the wide table document. Step S203: Receiving a sliding operation within the interactive interface, wherein the sliding operation is used to adjust the current view page of the interactive interface.Step S204: In response to the sliding operation, the data label is set to a target display mode, where the target display mode is determined based on the data column displayed on the current view page. Exemplarily, after displaying the data label in the interactive interface, the terminal device may further receive a sliding operation input by the user, where the sliding operation refers to an operation used to adjust the current view page of the interactive interface, such as sliding horizontally on the touch screen of the terminal device, thereby causing the current view page of the interactive interface to move horizontally. Afterwards, when the sliding operation changes the current view page of the interactive interface, the terminal device will further adjust the data label based on the content displayed in the changed current view page, that is, change the display mode of the data label. In one possible implementation, as shown in FIG8 , the specific implementation of step S204 includes: Step S2041: In response to the sliding operation, obtain a target column title of the data column displayed at the target position of the current view page. Step S2042: Determine a corresponding target data label based on the target column title, and highlight the target data label. Exemplarily, When the terminal device responds to a sliding operation and moves the current view page of the interactive interface, it uses the updated target position of the current view page as an indicator to determine the target data column. For example, the leftmost preset area of ​​the current view page is the target position, and the data column within this preset area is the target data column. Accordingly, the column title of the target data column is the target column title. Subsequently, based on the target column title indicated by the target position of the current view page determined after the dynamic sliding, the corresponding data label, i.e., the target data label, is determined. The target data label is then highlighted, for example, by underlining, bolding, or adding a shadow, thereby achieving a reverse effect of the user operation on the data label. Furthermore, based on the previous steps, the target position of the current view page can be implemented in other ways. For example, the target position of the current view page can be the entire area of ​​the current view page. In this implementation, the target column titles determined by the target position of the current view page are the column titles of all data columns displayed on the current view page. Therefore, it is possible to use data tags to quickly display the content (column headers) in the current view page, and then use data tags to quickly locate the target data column, thereby improving the overall efficiency of data column positioning. Especially when the amount of data in the current view page is large, it can effectively improve the operating efficiency of the table document.FIG9 is a schematic diagram of highlighting data labels according to an embodiment of the present disclosure. As shown in FIG9 , after loading a wide table document, a terminal device displays data labels corresponding to each data column of the wide table document within a label control group on an interactive interface, such as labels #1 through #9 within the label control group in the figure. Subsequently, a preset target location is the entire area of ​​the current view page. When the interactive interface is on a first view page, labels #1 and #9 are highlighted based on the data columns (e.g., data columns A and B) displayed within the target location on the first view page. Subsequently, in response to a user's sliding operation, the terminal device moves the current view page (the first view page) to a second view page. When the interactive interface is on the second view page, labels #2 and #4 are highlighted based on the data columns (e.g., data columns C and D) displayed within the target location on the second view page. In this embodiment, by examining the content at the target location of the current view page, mapping it to the corresponding target data tag, and highlighting the target data tag, the purpose of quickly identifying and displaying the content in the current view page using the data tag is achieved. This facilitates the subsequent rapid location of the target data column using the data tag, thereby improving the overall efficiency of data column location. In another possible implementation, the specific implementation of step S204 includes: Step S2043: In response to the sliding operation, obtaining the column title of the target data column displayed in the current view page. Step S2044: Based on the column title of the target data column, updating the data tag displayed in the interactive interface. For example, in another possible implementation, in response to the sliding operation, the terminal device controls the current view page of the interactive interface to move, thereby displaying the updated current view page. As the current view page changes, the content displayed in the corresponding schematic diagram, i.e., the data column, also changes accordingly. This specific process is described in detail in the previous embodiment and will not be repeated here. The terminal device then determines the corresponding target data column, i.e., all data columns displayed in the current view page, based on the content displayed in the current view page updated in response to the sliding operation. The data label displayed in the interactive interface is then dynamically updated based on the column title of the target data column.Specifically, for example, when the interactive interface is on the first view page, corresponding data labels A, B, and C are displayed based on all data columns displayed in the first view page, such as data column #1, data column #2, and data column #3. When the terminal device responds to a sliding operation and positions the interactive interface on the second view page, corresponding data labels D and E are displayed based on all data columns displayed in the second view page, such as data column #4 and data column #5. In this embodiment, dynamic display of data labels is achieved by mapping data columns displayed in the current view page to corresponding data labels, thereby achieving data filtering within a small range (within a view page). This can further improve operational efficiency and human-computer interaction efficiency for wide table documents. Step S205: Determine at least one candidate data column based on the target data label corresponding to the triggering operation. Step S206: Sort the at least one candidate data column to determine the target data column. For example, for wide table data, if there are too many data columns and the column headers share common identifiers, a single data label can be mapped to multiple data columns, thereby improving positioning efficiency. For example, if a wide table document includes 1,000 data columns, it would be impossible to assign a separate data label to each data column, or it would be impossible to fully display all data labels in the interactive interface, resulting in a loss of operational efficiency. In this case, multiple different column headers with a common identifier can be mapped to the same data label based on the column headers. For example, a wide table document includes three data columns with column headings Infb_1, Infb_2, and Infb_3. Their shared identifier "Info" is mapped to a data label. Accordingly, when the data label is displayed in the interactive interface, the shared identifier "Infb" is displayed as the data label. The data label corresponds to three candidate data columns, namely, Infb_1, Infb_2, and Infb_3 mentioned above. Based on the above process of generating data labels, when the terminal device triggers the target data label based on the shared identifier in response to a triggering operation, at least one candidate data column is determined (e.g., Infb_1, Info_2, and Infb_3 mentioned above). The candidate data columns are then sorted to determine a target data column. In one possible implementation, for example, the candidate data columns are sorted based on their positioning anchor points. The candidate data column corresponding to the anchor point closest to the current view page is determined as the target data column, and positioning is then performed on the target data column.In one possible implementation, as shown in FIG10 , step S206 includes the following: Step S2061: Obtaining the access frequency of the candidate data columns within the target time period. Step S2062: Arranging the candidate data columns from highest to lowest access frequency, and determining at least one of the largest candidate data columns as the target data column. For example, after determining the candidate data columns, obtaining the access frequency of each candidate data column within the target time period. Furthermore, each time the terminal device receives a trigger operation for a target data tag and obtains a candidate data column, it generates an access frequency corresponding to the candidate data column based on further user access to the candidate data column. Such access includes, but is not limited to, viewing, saving, copying, and modifying the data column. The access frequency is stored in the wide table document, and the terminal device obtains the access frequency during the loading of the wide table document. The target time period is a preset value, such as one week or one hour, and can be set as needed. The terminal device then sorts the candidate data columns from highest to lowest based on access frequency, and determines the largest or largest candidate data columns as target data columns. This achieves data column sorting based on historical access frequency, allowing frequently accessed data columns to be selected first, thereby improving the overall operational efficiency of the wide table document. Step S207: Based on the positioning anchor of the target data column, control the current view page of the interactive interface to move to the positioning view page. Exemplarily, after determining the target data column, the view page is moved based on the positioning anchor of the target data column. This controls the current view page of the interactive interface to move to the location view page. The concept of location anchors and the implementation of diagram movement using location anchors have been introduced in previous embodiments and will not be repeated here. When there are multiple target data columns, such as in step S206, where multiple target data columns are determined based on access frequency, the interactive interface is controlled to move sequentially from the current view page to the corresponding location view page based on the location anchor of each target data column. For example, the target data columns include data column #1, data column #2, and data column #3. Each time the terminal device receives a trigger operation, the diagram is sequentially moved horizontally to the location view page corresponding to data column #1, data column #2, and data column #3. This achieves multiple rounds of data column location, further improving efficient location and retrieval in wide table documents with a large number of data columns. In this embodiment, steps S201 and S202 are implemented in the same manner as steps S101 and S102 in the embodiment shown in FIG. 2 of this disclosure. I will not elaborate on this here.Corresponding to the interactive method for table documents in the above embodiment, FIG11 is a block diagram of the structure of an interactive device for table documents provided in an embodiment of the present disclosure. For ease of illustration, only the portions relevant to the embodiment of the present disclosure are shown. Referring to FIG11 , the interactive device 3 for table documents includes: a display module 31 for displaying a wide table document within an interactive interface. The wide table document has at least two data columns, at least one of which cannot be fully displayed within the current view page of the interactive interface; a processing module 32 for displaying at least one data label corresponding to the data column within the interactive interface based on the document content of the wide table document; and a control module 33 for controlling the interactive interface to move to a positioning view page in response to a triggering operation for a target data label. The positioning view page is used to position and display a target data column corresponding to the target data label. According to one or more embodiments of the present disclosure, a label control group is provided within an interactive interface; a processing module 32 is specifically configured to: obtain column headings corresponding to each data column; determine a target control object within the label control group based on the column headings; and configure the label control group based on the target control object to display the data label within the label control group. According to one or more embodiments of the present disclosure, when obtaining column headings corresponding to each data column, the processing module 32 is specifically configured to: obtain the object content of at least one data object under the data column; process the object content based on a language model to generate summarized content corresponding to the data column; and generate the column heading based on the summarized content. According to one or more embodiments of the present disclosure, the control module 33 is further configured to: receive a sliding operation on the interactive interface, the sliding operation being used to adjust the current view page of the interactive interface; and, in response to the sliding operation, set the data label to a target display mode, wherein the target display mode is determined based on the data column displayed on the current view page. According to one or more embodiments of the present disclosure, when the control module 33 sets the data label to the target display mode in response to a sliding operation, the control module 33 is specifically configured to: obtain, in response to the sliding operation, the target column title of the data column displayed at the target position on the current view page; determine, based on the target column title, the corresponding target data label and highlight the target data label. According to one or more embodiments of the present disclosure, when the control module 33 sets the data label to the target display mode in response to a sliding operation, the control module 33 is specifically configured to: obtain, in response to the sliding operation, the column title of the target data column displayed on the current view page; and update the data label displayed in the interactive interface based on the column title of the target data column.According to one or more embodiments of the present disclosure, the control module 33 is specifically configured to: determine at least one data column to be selected based on the target data tag corresponding to the trigger operation; sort the at least one data column to determine the target data column; and control the current view page of the interactive interface to move to the location view page based on the location anchor of the target data column. According to one or more embodiments of the present disclosure, the processing module 32 is further configured to: set a corresponding location anchor for the data column within the interactive interface; when controlling the current view page of the interactive interface to move to the location view page based on the location anchor of the target data column, the control module 33 is specifically configured to: obtain the location anchor of the target data column; and control the interactive interface to move to the location anchor to display the location view page. According to one or more embodiments of the present disclosure, when sorting the at least one data column to be selected to determine the target data column, the control module 33 is specifically configured to: obtain the access frequency of the data column to be selected within a target time period; sort the data columns to be selected from highest to lowest access frequency, and determine the at least one data column with the highest access frequency as the target data column. The display module 31, processing module 32, and control module 33 are connected in sequence. The interactive device 3 for spreadsheet documents provided in this embodiment can implement the technical solutions of the aforementioned method embodiments. Its implementation principles and technical effects are similar and will not be further elaborated upon in this embodiment. Figure 12 is a schematic structural diagram of an electronic device provided in an embodiment of the present disclosure. As shown in Figure 12, the electronic device 4 includes: a processor 41 and a memory 42 in communication with the processor 41; the memory 42 stores computer-executable instructions; and the processor 41 executes the computer-executable instructions stored in the memory 42 to implement the interactive method for spreadsheet documents in the embodiments shown in Figures 2-10. Optionally, the processor 41 and the memory 42 are connected via a bus 43. The relevant descriptions can be understood by referring to the corresponding descriptions and effects of the steps in the embodiments corresponding to Figures 2-10, and will not be elaborated upon here. The present embodiment provides a computer-readable storage medium storing computer-executable instructions. When executed by the processor, the computer-executable instructions are used to implement the interactive method for spreadsheet documents provided in any of the embodiments corresponding to Figures 2-10 of the present disclosure. An embodiment of the present disclosure provides a computer program product, including a computer program. When the computer program is executed by a processor, it implements the interactive method for a table document provided in any of the embodiments corresponding to Figures 2 to 10 of the present disclosure. In order to implement the above embodiments, an embodiment of the present disclosure also provides an electronic device.Referring to FIG13 , a schematic diagram of the structure of an electronic device 900 suitable for implementing embodiments of the present disclosure is shown. The electronic device 900 may be a terminal device or a server. Terminal devices may include, but are not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, personal digital assistants (PDAs), tablet computers (Android devices), portable multimedia players (PMPs), in-vehicle terminals (e.g., in-vehicle navigation terminals), and fixed terminals such as digital TVs and desktop computers. The electronic device shown in FIG13 is merely an example and should not limit the functionality and scope of use of the embodiments of the present disclosure. As shown in FIG13 , the electronic device 900 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 901, which may perform various appropriate actions and processes based on programs stored in a read-only memory (ROM) 902 or programs loaded from a storage device 908 into a random access memory (RAM) 903. RAM 903 also stores various programs and data required for the operation of electronic device 900. Processing device 901, ROM 902, and RAM 903 are interconnected via bus 904. An input / output (I / O) interface 905 is also connected to bus 904. Typically, the following devices may be connected to I / O interface 905: input device 906, including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output device 907, including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage device 908, including, for example, a magnetic tape, hard disk, etc.; and communication device 909. Communication device 909 may allow electronic device 900 to communicate with other devices wirelessly or wired to exchange data. Although FIG. 13 illustrates electronic device 900 with various devices, it should be understood that implementation or presence of all illustrated devices is not required. More or fewer devices may be implemented or provided alternatively. In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart may be implemented as a computer software program.For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network via the communication device 909, or installed from the storage device 908, or installed from the ROM 902. When the computer program is executed by the processing device 901, the method of the embodiment of the present disclosure is executed. Electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatuses, or devices, or any combination thereof. More specific examples of computer-readable storage media may include, but are not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present disclosure, a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such a propagated data signal may take a variety of forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium. This computer-readable signal medium can transmit, propagate, or transfer a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to wires, optical cables, RF (radio frequency), or any suitable combination thereof. The computer-readable medium may be included in the electronic device described above, or it may exist independently and not incorporated into the electronic device. The computer-readable medium carries one or more programs. When executed by the electronic device, the electronic device performs the methods described in the above embodiments. The computer program code for performing the operations of the present disclosure can be written in one or more programming languages, or a combination thereof. These programming languages ​​include object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as C or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server.In cases involving a remote computer, the remote computer can be connected to the user computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (e.g., via the Internet using an Internet service provider). The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operations of possible implementations of the systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagram may represent a module, program segment, or portion of code, which contains one or more executable instructions for implementing the specified logical functions. It should also be noted that in some alternative implementations, the functions marked in the blocks may occur in an order different from that marked in the accompanying drawings. For example, two blocks shown in succession may actually be executed substantially in parallel, or they may sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, as well as combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified functions or operations, or can be implemented using a combination of dedicated hardware and computer instructions. The units described in the embodiments of this disclosure may be implemented via software or hardware. The name of a unit does not, in some cases, limit the unit itself. For example, the first acquisition unit may also be described as a "unit for acquiring at least two Internet Protocol addresses." The functions described above may be at least partially performed by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like. In the context of this disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by, or in conjunction with, an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. The machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing.More specific examples of machine-readable storage media include electrical connections based on one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In a first aspect, according to one or more embodiments of the present disclosure, a method for interacting with a table document is provided, comprising: displaying a wide table document within an interactive interface, the wide table document having at least two data columns, at least one of the at least two data columns being incompletely displayed within a current view page of the interactive interface; displaying at least one data label corresponding to the data column within the interactive interface based on the document content of the wide table document; and, in response to a triggering operation for a target data label, controlling the interactive interface to display a positioning view page, the positioning view page being used to position and display a target data column corresponding to the target data label. According to one or more embodiments of the present disclosure, a label control group is provided within the interactive interface; displaying at least one data label corresponding to the data column within the interactive interface based on the document content of the wide table document includes: obtaining a column title corresponding to each data column; determining a target control object within the label control group based on the column title; and configuring the label control group based on the target control object to display the data label within the label control group. According to one or more embodiments of the present disclosure, obtaining a column title corresponding to each data column includes: obtaining object content of at least one data object under the data column; processing the object content based on a language model to generate summarized content corresponding to the data column; and generating the column title based on the summarized content. According to one or more embodiments of the present disclosure, the method further includes: receiving a sliding operation on the interactive interface, the sliding operation being used to adjust the current view page of the interactive interface; in response to the sliding operation, setting the data label as a target display mode, wherein the target display mode is determined based on the data column displayed on the current view page. According to one or more embodiments of the present disclosure, setting the data label as a target display mode in response to the sliding operation includes: in response to the sliding operation, obtaining a target column title of the data column displayed at a target position of the current view page; determining a corresponding target data label based on the target column title, and highlighting the target data label.According to one or more embodiments of the present disclosure, setting the data label to a target display mode in response to the sliding operation includes: obtaining a column title of a target data column displayed in the current view page in response to the sliding operation; and updating the data label displayed in the interactive interface based on the column title of the target data column. According to one or more embodiments of the present disclosure, controlling the interactive interface to display a positioning view page in response to a trigger operation on a target data label includes: determining at least one candidate data column based on the target data label corresponding to the trigger operation; sorting the at least one candidate data column to determine a target data column; and controlling the current view page of the interactive interface to move to the positioning view page based on a positioning anchor of the target data column. According to one or more embodiments of the present disclosure, the method further includes: setting a corresponding positioning anchor for the data column in the interactive interface; and controlling the current view page of the interactive interface to move to the positioning view page based on the positioning anchor of the target data column includes: obtaining the positioning anchor of the target data column; and controlling the interactive interface to move to the positioning anchor to display the positioning view page. According to one or more embodiments of the present disclosure, sorting the at least one candidate data column to determine a target data column includes: obtaining access frequencies of the candidate data column within a target time period; and arranging the candidate data columns from largest to smallest based on the access frequencies, and determining at least one candidate data column with the largest access frequency as the target data column. In a second aspect, according to one or more embodiments of the present disclosure, an interactive device for a table document is provided, comprising: a display module, configured to display a wide table document in an interactive interface, the wide table document having at least two data columns, at least one of the at least two data columns being unable to be fully displayed in a current view page of the interactive interface; a processing module, configured to display at least one data label corresponding to the data column in the interactive interface based on document content of the wide table document; and a control module, configured to control the interactive interface to display a positioning view page in response to a trigger operation for a target data label, the positioning view page being configured to position and display a target data column corresponding to the target data label. According to one or more embodiments of the present disclosure, a label control group is provided in the interactive interface; the processing module is configured to: obtain a column title corresponding to each of the data columns; determine a target control object in the label control group based on the column title; and configure the label control group based on the target control object to display the data label in the label control group.According to one or more embodiments of the present disclosure, when obtaining column headers corresponding to each data column, the processing module is specifically configured to: obtain object content of at least one data object under the data column; process the object content based on a language model to generate summarized content corresponding to the data column; and generate the column header based on the summarized content. According to one or more embodiments of the present disclosure, the control module is further configured to: receive a sliding operation on the interactive interface, the sliding operation being used to adjust the current view page of the interactive interface; and in response to the sliding operation, set the data label to a target display mode, wherein the target display mode is determined based on the data column displayed on the current view page. According to one or more embodiments of the present disclosure, when setting the data label to a target display mode in response to the sliding operation, the control module is specifically configured to: obtain a target column header for the data column displayed at a target position on the current view page in response to the sliding operation; determine a corresponding target data label based on the target column header, and highlight the target data label. According to one or more embodiments of the present disclosure, when the control module sets the data label to the target display mode in response to the sliding operation, it is specifically configured to: obtain the column title of the target data column displayed in the current view page in response to the sliding operation; and update the data label displayed in the interactive interface based on the column title of the target data column. According to one or more embodiments of the present disclosure, the control module is specifically configured to: determine at least one candidate data column based on the target data label corresponding to the triggering operation; sort the at least one candidate data column to determine the target data column; and control the current view page of the interactive interface to move to the location view page based on the location anchor of the target data column. According to one or more embodiments of the present disclosure, the processing module is further configured to: set a corresponding location anchor for the data column in the interactive interface; and when the control module controls the current view page of the interactive interface to move to the location view page based on the location anchor of the target data column, it is specifically configured to: obtain the location anchor of the target data column; and control the interactive interface to move to the location anchor to display the location view page. According to one or more embodiments of the present disclosure, when the control module sorts the at least one candidate data column and determines the target data column, it is specifically used to: obtain the access frequency of the candidate data column within the target time period; arrange the candidate data columns from large to small based on the access frequency, and determine at least one largest candidate data column as the target data column.In a third aspect, according to one or more embodiments of the present disclosure, an electronic device is provided, comprising: at least one processor and a memory; the memory storing computer-executable instructions; the at least one processor executing the computer-executable instructions stored in the memory, causing the at least one processor to perform the method for interacting with a table document as described in the first aspect and various possible designs of the first aspect. In a fourth aspect, according to one or more embodiments of the present disclosure, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer-executable instructions. When the processor executes the computer-executable instructions, the method for interacting with a table document as described in the first aspect and various possible designs of the first aspect is implemented. In a fifth aspect, according to one or more embodiments of the present disclosure, a computer program product is provided, comprising a computer program. When the computer program is executed by the processor, the method for interacting with a table document as described in the first aspect and various possible designs of the first aspect is implemented. The above description is merely a preferred embodiment of the present disclosure and an illustration of the technical principles employed. Those skilled in the art should understand that the scope of the present disclosure is not limited to technical solutions formed by specific combinations of the above technical features, but also encompasses other technical solutions formed by any combination of the above technical features or their equivalents without departing from the scope of the above disclosure. For example, a technical solution may be formed by replacing the aforementioned features with (but not limited to) technical features having similar functions disclosed in this disclosure. Furthermore, although the various operations are depicted in a specific order, this should not be construed as requiring that these operations be performed in the specific order shown or in a sequential order. Multitasking and parallel processing may be advantageous under certain circumstances. Similarly, although the above discussion includes several specific implementation details, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of separate embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented in multiple embodiments individually or in any suitable subcombination. Although the subject matter has been described using language specific to structural features and / or methodological logical actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely example forms of implementing the claims.

Claims

Claims 1. An interactive method for a table document, comprising: Displaying a wide table document in an interactive interface, the wide table document having at least two data columns, at least one of the at least two data columns cannot be completely displayed in a current view page of the interactive interface; Based on the document content of the wide table document, displaying at least one data label corresponding to the data column in the interactive interface; In response to a trigger operation on a target data tag, the interactive interface is controlled to display a positioning view page, where the positioning view page is used to position and display a data column corresponding to the target data tag.

2. The method according to claim 1, wherein: A label control group is provided in the interactive interface; based on the document content of the wide table document, at least one data label corresponding to the data column is displayed in the interactive interface, including: obtaining a column title corresponding to each of the data columns; determining a target control object in the label control group according to the column title; configuring the label control group based on the target control object to display the data label in the label control group.

3. The method according to claim 2, wherein: The obtaining of column headers corresponding to each of the data columns includes: obtaining object content of at least one data object under the data column; processing the object content based on a language model to generate summarized content corresponding to the data column; and generating the column header based on the summarized content.

4. The method according to any one of claims 1 to 3, further comprising: receiving a sliding operation on the interactive interface, the sliding operation being used to adjust a current view page of the interactive interface; and in response to the sliding operation, setting the data label to a target display mode, wherein the target display mode is determined based on a data column displayed on the current view page.

5. The method according to claim 4, wherein: The step of setting the data label as a target display mode in response to the sliding operation includes: obtaining a target column title of a data column displayed at a target position of the current view page in response to the sliding operation; determining a corresponding target data label according to the target column title, and highlighting the target data label.

6. The method according to claim 4, wherein: The step of setting the data label to a target display mode in response to the sliding operation includes: obtaining a column title of a target data column displayed in the current view page in response to the sliding operation; and updating the data label displayed in the interactive interface based on the column title of the target data column.

7. The method according to any one of claims 1 to 6, wherein: The step of controlling the interactive interface to display a positioning view page in response to a trigger operation on a target data tag includes: Based on the target data tag corresponding to the trigger operation, at least one data column to be selected is determined; the at least one data column to be selected is sorted to determine the target data column; based on the positioning anchor point of the target data column, the current view page of the interactive interface is controlled to move to the positioning view page.

8. The method according to claim 7, further comprising: In the interactive interface, setting a corresponding positioning anchor point for the data column; The controlling the current view page of the interactive interface to move to the positioning view page based on the positioning anchor point of the target data column includes: acquiring the positioning anchor point of the target data column; Control the interactive interface to move to the positioning anchor point to display the positioning view page.

9. The method according to claim 7, wherein: The step of sorting the at least one candidate data column to determine the target data column includes: obtaining the access frequency of the candidate data column within a target time period; arranging the candidate data columns from large to small based on the access frequency, and determining the largest at least one candidate data column as the target data column.

10. An interactive device for a table document, comprising: A display module is configured to display a wide table document in an interactive interface, wherein the wide table document has at least two data columns, and at least one of the at least two data columns cannot be completely displayed in a current view page of the interactive interface; a processing module is configured to display at least one data label corresponding to the data column in the interactive interface based on the document content of the wide table document; and a control module is configured to control the interactive interface to display a positioning view page in response to a trigger operation for a target data label, wherein the positioning view page is used to position and display the data column corresponding to the target data label.

11. An electronic device, comprising: Processor and memory; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory, so that the processor executes the interactive method for a table document as described in any one of claims 1 to 9.

12. A computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and when a processor executes the computer-executable instructions, the interactive method for a table document according to any one of claims 1 to 9 is implemented.

13. A computer program product, comprising a computer program, wherein: When the computer program is executed by a processor, the interactive method for a table document according to any one of claims 1 to 9 is implemented.

Images