Table processing method and device, electronic equipment, storage medium and program product

Abstract

A table processing method and device, electronic equipment, storage medium and program product. The method comprises: receiving a first input, the first input being natural language indicating data analysis on a first table, the first input being received and presented through an interaction area of an intelligent system, the intelligent system being associated with the first table; presenting a first output, the first output including a data analysis result of the first table; the data analysis result including a chart and / or a first data table; receiving a first operation on the data analysis result, generating a first instruction based on the data analysis result; the first instruction being used to create a chart component corresponding to the chart and / or a second table corresponding to the first data table; based on the first instruction, presenting the chart component and / or the second table in a table set. The data analysis result can be persistently saved and reused.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a table processing method and apparatus, electronic device, storage medium, and program product. Background Technology

[0002] In related technologies, artificial intelligence (AI) interfaces typically present output results using lightweight markup languages. While users can view charts and / or data tables in the current interface, persistent reuse of the output results is not possible. Summary of the Invention

[0003] A table processing method, apparatus, electronic device, storage medium, or program product is provided to solve or partially solve the above-mentioned problems to a certain extent.

[0004] Firstly, a table processing method is provided, including:

[0005] The system receives a first input, which is natural language indicating data analysis of a first table. The first input is received and presented through the interactive area of ​​the intelligent system, which is associated with the first table. The system presents a first output, which includes the data analysis results of the first table; the data analysis results include charts and / or the first data table. The system receives a first operation on the data analysis results and generates a first instruction based on the data analysis results; the first instruction is used to create a chart component corresponding to the chart and / or a second table corresponding to the first data table. Based on the first instruction, the chart component and / or the second table are presented in the table set.

[0006] Secondly, a table processing apparatus is provided, comprising: The first presentation module is configured to: receive a first input, the first input being natural language indicating data analysis of a first table, the first input being received and presented through the interactive area of ​​an intelligent system associated with the first table; and present a first output, the first output including data analysis results of the first table; the data analysis results including charts and / or a first data table. The second presentation module is configured to: receive a first operation on the data analysis result, generate a first instruction based on the data analysis result; the first instruction is used to create a chart component corresponding to the chart and / or a second table corresponding to the first data table; and present the chart component and / or the second table in a set of tables based on the first instruction.

[0007] Thirdly, an electronic device is provided, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the computer program, implements the method as described in the first aspect.

[0008] Fourthly, a non-transitory computer-readable storage medium is provided, the non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the method described in the first aspect.

[0009] Fifthly, a computer program product is provided, including computer program instructions that, when executed on a computer, cause the computer to perform the method as described in the first aspect.

[0010] The aforementioned table processing methods, devices, electronic equipment, storage media, and program products can convert charts and / or first data tables in data analysis results into operable objects (chart components and / or second tables) in the table, thus connecting the viewing and application of data analysis results and enabling persistent storage and reuse of data analysis results. Attached Figure Description

[0011] To more clearly illustrate the technical solutions, the accompanying drawings used in the description of various situations or related technologies will be briefly introduced below. Obviously, the accompanying drawings described below are only a presentation of some situations. For those skilled in the art, other drawings can be obtained from these drawings without creative effort.

[0012] Figure 1 A schematic diagram of an exemplary system in one scenario is shown.

[0013] Figure 2A A schematic diagram of an exemplary form page in one scenario is shown.

[0014] Figure 2B A schematic diagram of an exemplary form page in one scenario is shown.

[0015] Figure 3 A flowchart illustrating an exemplary table processing method in one scenario is shown.

[0016] Figures 4A-4B This diagram illustrates an example of a table page during the creation of a chart component in one scenario.

[0017] Figures 4C-4D This diagram illustrates an exemplary table page after creating a chart component in one scenario.

[0018] Figure 4EThis diagram illustrates a table page during an exemplary process of creating a second data table in one scenario.

[0019] Figure 4F This diagram illustrates an exemplary table page after creating a second data table in one scenario.

[0020] Figure 5 A schematic diagram of an exemplary form processing apparatus in one scenario is shown.

[0021] Figure 6 A schematic diagram of the hardware structure of an exemplary electronic device in one scenario is shown. Detailed Implementation

[0022] To make the technical solution and advantages clearer, the following detailed explanation is provided in conjunction with specific circumstances and with reference to the accompanying drawings.

[0023] It should be noted that, unless otherwise defined, the technical or scientific terms used in the following contexts should have the common meaning understood by a person with ordinary skills in the field. The terms "first," "second," and similar words used in the following contexts do not indicate any order, quantity, or importance, but are merely used to distinguish different components. Terms such as "including" or "contains" mean that the element or object preceding the word covers the element or object listed after the word and its equivalents, without excluding other elements or objects. Terms such as "connected" or "linked" are not limited to physical or mechanical connections, but can include electrical connections, whether direct or indirect. Terms such as "upper," "lower," "left," and "right" are used only to indicate relative positional relationships; when the absolute position of the described object changes, the relative positional relationship may also change accordingly.

[0024] It is understood that before using any of the following situations, we will inform users of the type, scope, and scenarios of the personal information involved through appropriate means and obtain their authorization.

[0025] For example, upon receiving a user's active request, a prompt message is sent to the user to explicitly inform them that the requested operation will require the acquisition and use of the user's personal information. This allows the user to choose, based on the prompt message, whether to provide personal information to the software or hardware such as electronic devices, applications, servers, or storage media performing the operations described below.

[0026] As an optional but not limited implementation, in response to a user's active request, sending a prompt message to the user can be done via a pop-up window, where the prompt message can be presented in text format. Furthermore, the pop-up window can also include a selection control allowing the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0027] It is understood that the above notification and user authorization process is merely illustrative and does not limit the implementation methods of the following situations. Other methods that comply with relevant laws and regulations may also be applied to the implementation methods of the following situations.

[0028] The term "in response to" as used herein refers to a state in which a corresponding event occurs or a condition is satisfied. It will be understood that the timing of subsequent actions performed in response to such event or condition is not necessarily strongly correlated with the time when the event occurs or the condition is met. For example, in some cases, subsequent actions may be performed immediately upon the occurrence of the event or the fulfillment of the condition; while in others, they may be performed some time after the occurrence of the event or the fulfillment of the condition.

[0029] Figure 1 A schematic diagram of an exemplary system 100 in one scenario is shown.

[0030] like Figure 1 As illustrated, by way of example, system 100 may include terminal devices 102A and 102B, server 106, and database server 108. A medium (e.g., a network) may be included between terminal devices 102A and 102B and server 106 and database server 108 to provide a communication link. This network may include various connection types, such as wired, wireless communication links, or fiber optic cables, etc.

[0031] The terminal devices 102A and 102B can be equipped with various applications (APPs) or software, such as collaborative office applications or software, video applications or software, live streaming applications or software, image processing applications or software, video conferencing applications or software, reading applications or software, social applications or software, payment applications or software, web browsers, and instant messaging tools.

[0032] The terminal devices 102A and 102B here can be either hardware or software. When terminal devices 102A and 102B are hardware, they can be various electronic devices or computer devices with displays, including but not limited to smartphones, tablets, e-book readers, Moving Picture Experts Group AudioLayer III (MP3) players, laptops, and desktop computers (PCs), etc. When terminal devices 102A and 102B are software, they can be installed in the electronic devices listed above. They can be implemented as multiple software programs or software modules (e.g., to provide distributed services) or as a single software program or software module. No specific limitations are set here.

[0033] Server 106 can be a server that provides various services, such as a backend server that supports various applications or software displayed on terminal devices 102A and 102B. Database server 108 can also be a database server that provides various services. It is understood that if server 106 can implement the relevant functions of database server 108, database server 108 may not need to be set up in system 100.

[0034] The server 106 and database server 108 here can be either hardware or software. When they are hardware, they can be implemented as a distributed server cluster consisting of multiple servers, or as a single server. When they are software, they can be implemented as multiple software programs or software modules (for example, to provide distributed services), or as a single software program or software module. No specific limitations are made here.

[0035] It should be noted that the table processing method provided in this scenario can be executed by terminal devices 102A and 102B or interactively by various devices in system 100. It should be understood that... Figure 1 The number of terminal devices, users, servers, and database servers shown is merely illustrative. Depending on implementation needs, there can be any number of terminal devices, users, servers, and database servers.

[0036] In some exemplary scenarios, user 104A can create a table using a collaborative office application or software installed on terminal device 102A, and create and configure component pages within the table. Optionally, user 104B can view the component page using a collaborative office application or software installed on terminal device 102B, and can edit the component page if they have editing permissions.

[0037] Figure 2AA schematic diagram of an exemplary form page 110 in one scenario is shown.

[0038] like Figure 2A As shown, user 104A can create tables using collaborative office applications or software installed on terminal device 102A. This table can be a tabular online database used to store and manage data. Unlike conventional spreadsheets, this table not only enables data storage, analysis, and visualization, but also allows for real-time synchronization of multi-user editing, annotation and discussion, and one-click tracing of historical records. Furthermore, it provides rich field, view, and plugin capabilities, allowing for flexible construction of customized business systems based on business needs, easily achieving personalized business management with a single table. In addition, through automation capabilities, project progress can be quickly synchronized and message notifications can be automatically sent without coding, freeing up manpower and improving work efficiency.

[0039] As an alternative, user 104A can create a form by selecting a suitable template on the form creation page of a collaborative office application or software. This form can be used for project management. For example, such as Figure 2A As shown, user 104A created a table to manage sales items. Optionally, in the initial state, table page 110 can be empty, and the sidebar of table page 110 can display a data table creation control 112, which user 104A can trigger to create a data table. The created data table can be displayed in table view as data table page 120, as shown. Figure 2A As shown. User 104A can create multiple data tables for the table on table page 110, for example, as follows: Figure 2A As shown, the table contains a sales data table and a sales team management data table.

[0040] In some cases, user 104A can also create component pages within the table. These component pages can be configured with various types of chart components, such as table components and graph components. Table components can present data in a table format, while graph components can display various graphs, such as bar charts, line charts, pie charts, etc. By configuring various components on the component page to visualize data from different perspectives, users can effectively improve their understanding of the data, facilitating data analysis.

[0041] Optionally, such as Figure 2A As shown, table page 110 may also include a component page creation control 114, which user 104A can trigger to create a component page. In response to the operation of creating a component page in the table, the component page can be displayed. (See reference...) Figure 2AAs shown. The component page is used to generate components based on data from the data table page in the table. Optionally, if user 104A triggers the creation of a new control 114 on the component page when displaying data table page 120 on table page 110, the created component page is associated with the data of data table page 120. In other words, components can be created on the component page based on the data of data table page 120. For example, created bar charts, line charts, etc., can be created based on the data of data table page 120. Of course, created table components can also be created based on the data of data table page 120. In this way, the created component page is related to the data of a specific data table page, allowing for multi-angle visualization of the data table corresponding to that data table page.

[0042] Figure 2B A schematic diagram of an exemplary form page in one scenario is shown.

[0043] like Figure 2B As shown, for example, after creating a component page, user 104A can configure and display the component page in table page 200. Optionally, the left-hand area (sidebar) of table page 200 can display various objects configured in the current table, including data tables (e.g., sales data tables, sales team management data tables), workflows, etc., in addition to component pages. When user 104A selects a component page in the left-hand area, the component page can be displayed in the right-hand area of ​​table page 200, and the component page can be configured and edited. Figure 2B As shown, optionally, the table page 200 may further include a canvas area 200A for drawing components, which can present the effect of the configured and edited component page. Optionally, as... Figure 2B As shown, the width of the canvas area 200A on the component page is determined based on the current display area, while the height of the canvas area 200A is not limited. This allows components to be arranged arbitrarily along the height direction. When there are too many components on the component page to be fully displayed in the current visible area, components outside the visible area can be scrolled into the visible area for display by scrolling the page.

[0044] In some cases, in response to an operation that creates a component on the component page, at least one component can be displayed on the component page. For example, such as... Figure 2BAs shown, the component page may further include an add control 202, which user 104A can trigger (e.g., click) to add components to the component page. Optionally, after the add control 202 is triggered, a pop-up window can be displayed at the associated location of the add control 202 (e.g., below), containing options for various types of components. By selecting the option corresponding to the added component, the corresponding component can be added to the component page.

[0045] For example, such as Figure 2B As shown, three components, 204A, 204B, and 204C, have been added to the component page. For example, component 204A can be a table component, and components 204B and 204C can be graph components. Specifically, component 204B is a bar chart, and component 204C is a line chart.

[0046] In some scenarios, tables can interact with AI. In response to a triggering action on the AI, an AI interface is displayed, which can receive input information and display output results. However, in related technologies, AI interfaces typically present output results in a lightweight markup language. While the charts and / or data tables in this output can be viewed within the AI ​​interface, they cannot be persistently reused.

[0047] Therefore, in one scenario, by providing a table processing method, charts and / or data tables in the data analysis results can be persistently reused.

[0048] Figure 3 A flowchart illustrating an exemplary table processing method in one scenario is shown. This table processing method can be used to enable the persistent reuse of charts and / or data tables in data analysis results. Optionally, this table processing method can be... Figure 1 The terminal equipment 102A and 102B can be used for implementation, or it can be implemented by Figure 1 The devices in System 100 work together through interactive methods.

[0049] like Figure 3 As shown, the table processing method may further include the following steps.

[0050] In S301, a first input is received. The first input is natural language indicating that data analysis should be performed on the first table. The first input is received and presented through the interactive area of ​​the intelligent system, which is associated with the first table.

[0051] Intelligent systems can be intelligent agents, possessing the core components or modules of large languages ​​or multimodal models. They have the capabilities of perception, planning, tool invocation, memory, reflection, and autonomous decision-making. They can break down complex goals, execute multi-round tasks step by step, autonomously correct their behavior, and independently complete complete complex tasks. The interactive area of ​​the intelligent system can be presented in response to the triggered operations of the intelligent agent system.

[0052] In some cases, the interactive area of ​​the intelligent system can be displayed as a sidebar on the side of the table page. This interactive area can receive a first input, and based on that input, the intelligent system can obtain a first table. The intelligent system can associate one or more tables, and the first table can refer to the table specified for analysis via the first input and associated with the intelligent system. The first table may include one or more data tables.

[0053] In S302, a first output is presented, which includes the data analysis results of the first table; the data analysis results include charts and / or the first data table.

[0054] The intelligent system can obtain data analysis results based on a first input and a first table. The data analysis results can refer to the data obtained by analyzing the first table based on the first input; for example, it can be obtained by performing operations such as aggregation, filtering, and sorting on the data in the first table. The data analysis results can include charts and / or the first data table. Charts can be used to visualize trends, comparisons, correlations, proportions, or other relationships between data, and can be displayed as bar charts, column charts, line charts, pie charts, donut charts, scatter plots, etc. The first data table can be a data table regenerated based on the first table, or it can be a data table within the first table. Charts and the first data table can be temporarily rendered in the interactive area. Then, based on the data analysis results, the first output is presented to the interactive area.

[0055] In some cases, the intelligent system may include template information, which may include style information, such as size information; based on this style information, rendering can be performed directly without additional configuration. Optionally, the template information may be constructed based on the style information of chart components and / or data tables in a table, enabling the style of the chart to be consistent with the visual effect of the chart components, the style of the first data table to be consistent with the visual effect of the data tables in the table; and allowing the first data table to have a better presentation, guiding the user to create a second table.

[0056] In some cases, the data tables output by intelligent systems can include multiple field types, such as numbers, text, single selection, multiple selection, currency, and dates.

[0057] In some cases, charts and the first data table can be read-only. Charts may not support in-depth data analysis, configuration editing, copying, deletion, and other operations, while the first data table may support filtering, sorting, grouping, editing fields, editing data rows, and other operations.

[0058] In S303, a first operation on the data analysis result is received, and a first instruction is generated based on the data analysis result; the first instruction is used to create a chart component corresponding to the chart and / or a second table corresponding to the first data table.

[0059] The first operation can be applied to the entire data analysis result or a portion thereof. When the data analysis result includes both charts and a first data table, the user can perform the first operation only on the chart to create the corresponding chart component; or only on the first data table to create the corresponding second table; or perform a batch of the first operation on both the chart and the first data table to create both the chart component and the second table. The implementation method of the first operation is not limited.

[0060] Based on the first operation performed on the data analysis results, a first instruction can be generated. This first instruction can be a machine-processable instruction that can be recognized and executed by collaborative office applications or software, and can be used to instruct the creation of chart components corresponding to the chart and / or a second table corresponding to the first data table. The second table can be a table formed by adding a second data table created based on the first data table to the first table, or it can be a new table created independently of the first table, with the second data table created based on the first data table added to the new table.

[0061] The charts in the data analysis results can correspond to the chart components created based on the first instruction, and the first data table in the data analysis results can correspond to the second data table created based on the first instruction, but they are not required to use the exact same data format. The charts and / or the first data table in the data analysis results can be temporarily rendered in the interactive area of ​​the intelligent system; the chart components and / or the second data table can be data that can be stored in a table by collaborative office applications or software, and can have various operation functions, such as moving, copying, editing, or configuring.

[0062] In S304, based on the first instruction, a chart component and / or a second table are presented in a set of tables.

[0063] The first instruction may include snapshot information of the chart and / or the first data table in the data analysis results. Therefore, when creating the chart component and / or the second table, it can be created directly based on the snapshot information in the first instruction, without having to re-acquire the first input or re-perform semantic parsing and data analysis on the first input. This reduces redundant processing, improves creation efficiency, and ensures that the created object is consistent with the data analysis results when the creation operation is triggered.

[0064] A table collection can be used to host tables created by collaborative office applications or software. It can be updated in real time as chart components and / or second tables are created. Initially, the table collection can host the first table. If the data analysis results include chart components, the table collection can be used to host the first table with added chart components. If the data analysis results include a first data table, and the second table is formed based on the first table, the table collection can be used to host the second table formed by adding a second data table to the first table. If the second table is created independently of the first table, the table collection can be used to host both the first and second tables.

[0065] Using the above methods, charts and / or the first data table in the data analysis results can be converted into operable objects in the table (chart components and / or the second table), opening up the link between viewing and applying the data analysis results, and persistently saving and reusing the data analysis results.

[0066] In some cases, a first control is displayed at the associated location of the data analysis result; receiving a first operation on the data analysis result and generating a first instruction based on the data analysis result includes: receiving a trigger operation on the first control and generating the first instruction based on the data analysis result.

[0067] The first control can be used to trigger the creation of a chart component based on a chart in the data analysis results and / or the creation of a second table based on a first data table in the data analysis results. The implementation of the first control is not limited. There may be a correspondence between the first control and the data analysis results; the corresponding first control can be displayed at the associated location of each chart and / or first data table, allowing the user to select the chart or first data table to be created as a chart component and / or a second table. In some cases, the same first operation can be performed repeatedly.

[0068] Displaying the first control at the relevant location in the chart allows direct initiation of the chart component creation process for charts in the data analysis results, reducing the number of steps required to create chart components. Furthermore, since the first command is generated based on the chart corresponding to the first control, the accuracy of the correspondence between the created chart component and the user-selected chart is improved.

[0069] In some cases, the data analysis result may include a chart, a first control associated with the chart, and a method for receiving a trigger operation on the first control to generate the first instruction based on the data analysis result. This may include: receiving a trigger operation on the first control and generating the first instruction based on the chart. In this case, the first instruction can be used to create a chart component corresponding to the chart.

[0070] like Figure 4A A schematic diagram of an exemplary form page in one scenario is shown, wherein 401: input box, 402: first input, 403: chart, 403A: first control.

[0071] In response to a trigger operation by the intelligent system, an interactive area of ​​the intelligent system can be displayed. In this exemplary scenario, a first input can be entered in the interactive area: "Calculate the monthly order change trend in 2026, analyze the trend changes, and provide the sum and average." Based on this first input, the intelligent system can obtain a first table from a table created by a collaborative office application or software. In this exemplary scenario, the first table may include order table 2601, order table 2602, order table 2603, and order table 2604. Based on the first input, the intelligent system can retrieve and analyze the first table to obtain data analysis results. Based on the data analysis results, a first output is displayed in the interactive area. In this exemplary scenario, the first output may include a chart, i.e. Figure 4A The chart showing the monthly order trend in 2026, along with the analysis results, indicates that "total orders: 1229, average monthly orders: 307.25. Order volume maintained a month-on-month growth from January to April 2026, with February seeing a doubling of growth compared to January (growth rate of 108.13%), March's growth slowing to 36.72%, and April's rebounding to 42.86%, showing an overall accelerating growth trend." In addition, the analysis process can also be output as the first output.

[0072] In this exemplary scenario, the first control can be named "Add Dashboard," and it is displayed in the chart-related location of the "2026 Monthly Order Trend Chart." Receiving a trigger action on "Add Dashboard" generates a first instruction based on the "2026 Monthly Order Trend Chart." This first instruction could be: "Build a 2026 order trend line chart, displaying the monthly order number trend for 2026, data source = order details table; horizontal axis = month; vertical axis = order number." Based on this first instruction, a "2026 Order Trend Chart" line chart is created in the first table. This line chart can be created within the component page.

[0073] In some scenarios, the data analysis results include a chart, and the first control associated with the chart includes a first sub-control. Receiving a trigger operation on the first control and generating the first instruction based on the data analysis results may include: receiving a trigger operation on the first sub-control and generating the first instruction based on the chart; the first instruction is used to instruct the creation of the chart component in a new component page. The new component page may refer to a component page newly created in response to the trigger operation of the first sub-control. The first instruction may be generated based on one or more of the following information: chart name, chart type, analysis description, configuration information, etc. For example, the first instruction may be structured as follows: Create a new dashboard, creating {chart name}, {chart type}, {analysis description}, and {configuration information}.

[0074] This technical solution allows charts from data analysis results to be directly created onto a new component page, eliminating the need to manually create the component page beforehand and facilitating independent management of the chart components generated from this data analysis.

[0075] like Figure 4B and Figure 4C A schematic diagram of an exemplary table page in one scenario is shown, wherein 403A: first control associated with the chart, 403A1: first child control, 403A2: second child control, 403A2a: next-level control, 405: first instruction, 406: new component page, and 409: chart component.

[0076] In this exemplary scenario, the first sub-control can be named "New Dashboard". Receiving a trigger operation on the first sub-control of "New Dashboard" can generate a first instruction based on the "2026 Monthly Order Trend Chart". This first instruction can be: "Build a 2026 order trend line chart in the new dashboard, displaying the monthly order number trend for 2026, with data source = order details table; horizontal axis = month; vertical axis = order number." Based on this first instruction, a chart component displaying the "Monthly Order Amount Trend" can be presented in the component page of the newly created "Order Management Dashboard" in the right sidebar.

[0077] In some scenarios, the data analysis results include a chart, and the first control associated with the chart includes a second sub-control. Receiving a trigger operation on the first control and generating the first instruction based on the data analysis results includes: receiving a trigger operation on the second sub-control and generating the first instruction based on the chart. The first instruction can be used to instruct the creation of the chart component in an existing component page. An existing component page refers to a component page that has already been created in the first table before the second sub-control is triggered. In some cases, the first instruction may also include the name of the existing component page associated with the second sub-control. For example, the first instruction may be structured as follows: creating {Chart Name}{Chart Type}, {Analysis Description}, and {Configuration Information} in {Dashboard}.

[0078] This technical solution allows charts from data analysis results to be added directly to existing component pages. This enables newly created chart components to be displayed together with existing components, facilitating users to comprehensively view and manage relevant data on the same component page and avoiding the creation of unnecessary component pages.

[0079] Furthermore, the second sub-control may include one or more next-level controls, which can be used to select a component page for creating the chart component from existing component pages. In this case, receiving a trigger operation on the second sub-control and generating the first instruction based on the chart may include: receiving a trigger operation on the next-level control and generating the first instruction based on the chart. The first instruction can be used to instruct the creation of a chart component in the component page corresponding to the triggered next-level control. In some cases, before receiving a trigger operation on the next-level control and generating the first instruction based on the chart, the trigger operation on the second sub-control may be received, and the next-level control may be presented.

[0080] like Figure 4B and Figure 4D A schematic diagram of an exemplary table page in one scenario is shown, where 408: an existing component page.

[0081] In this exemplary scenario, the second sub-control can be named "Add to Existing Dashboard". Receiving a trigger operation on the first sub-control of "New Dashboard" can present the next-level control of "a. Sales and Operations Dashboard"; receiving a trigger operation on the next-level control of "a. Sales and Operations Dashboard" can generate a first instruction based on the chart of "Monthly Order Trend Chart in 2026". This first instruction can be "Build a line chart of the 2026 order trend in the Sales and Operations Dashboard, displaying the monthly trend of order numbers in 2026, data source = order details table; horizontal axis = month; vertical axis = number of orders." Based on this first instruction, the corresponding chart component can be presented in the component page of "Sales and Operations Dashboard" in the table collection. For example, as... Figure 4DAs shown, the "Sales Management Dashboard" component page originally included a "Monthly Sales Amount Bar Chart" component. After the first command is executed, the newly added "Monthly Order Amount Trend" chart component can be displayed in the "Sales Management Dashboard" component page.

[0082] In some scenarios, the data analysis results may include a first data table, a first control associated with the first data table, and a method for receiving a trigger operation on the first control to generate the first instruction based on the data analysis results. This may include: receiving a trigger operation on the first control and generating the first instruction based on the first data table. In this case, the first instruction can be used to create a second table corresponding to the first data table.

[0083] The first instruction generated based on the first data table can be a natural language instruction formed from the fields and data rows of the first data table, and can be presented in the interactive area of ​​the intelligent system. For example, the template for this first instruction could be: "Build a data table, fields: {field list}. Fill in the following {N} records: {records in lightweight markup language format}". In some cases, the number of data rows can be limited.

[0084] like Figure 4E and Figure 4F A schematic diagram of an exemplary table page in one scenario is shown, where 404: first data table, 404A: first control associated with the first data table, and 410: second data table.

[0085] In response to a trigger operation by the intelligent system, an interactive area of ​​the intelligent system can be displayed. In this exemplary scenario, a first input can be entered in the interactive area: "Compare and find the 10 products with the highest refund rates and their information from the four tables of orders 2601-2604, and sort them from highest to lowest refund rate." Based on this first input, the intelligent system can obtain a first table, which is order table 2601, order table 2602, order table 2603, and order table 2604. Based on the first input, the intelligent system can retrieve and analyze the first table to obtain data analysis results. Based on the data analysis results, a first output is displayed in the interactive area. This first output may include a first data table and the analysis process.

[0086] In this exemplary scenario, the first control can be named "Add New Data Table," and it is displayed at the associated location of the first data table. Upon receiving a trigger operation on "Add New Data Table," a first instruction can be generated based on the first data table. This first instruction can be: "Create a data table with the following fields: Product Name, Return Rate, Product Identifier, Order Quantity, and Number of Refunded Orders. Enter the following 10 records:" Based on this first instruction, the second data table can be displayed in the component page of the created "2601-2604 Product Return Form".

[0087] In some cases, after creating the chart component corresponding to the chart and / or the second table corresponding to the first data table, a prompt message can be generated to indicate that the creation of the chart component and / or the second table is complete. The prompt message may differ depending on the first operation. This prompt message may include one or more pieces of information such as creation location, creation name, and creation configuration information. Creation location may represent the name of the component page where the chart component and / or the second data table resides; creation name may represent the name of the chart component and / or the second data table; and creation configuration information may represent the attribute information required for creating the chart component and / or the second data table.

[0088] like Figure 4D As shown, when the first instruction is "Build a 2026 order trend line chart in the Sales and Management dashboard to display the monthly trend of order numbers in 2026, data source = order details table; horizontal axis = month; vertical axis = number of orders.", the prompt message 410 can be "An order trend line chart component has been added to the Sales and Management dashboard; a line chart named '2026 Monthly Order Amount Trend' has been added, with the horizontal axis being the month field (display format 'Month X, 2026'), showing the monthly summary of order amount changes. You can open the Sales and Management dashboard to view the chart."

[0089] like Figure 4C As shown, when the first instruction is "Build a 2026 order trend line chart in the new dashboard, displaying the monthly trend of order numbers in 2026, data source = order details table; horizontal axis = month; vertical axis = number of orders.", the prompt message 410 can be "Order trend line chart component added; order management dashboard successfully created, and a line chart named '2026 Monthly Order Amount Trend' added, with the horizontal axis being the month field (display format '2026 Month X', showing the monthly summary of order amount changes; you can open the order management dashboard to view the chart."

[0090] like Figure 4F As shown, when the first instruction is "Create a data table with fields: Product Name, Return Rate, Product Identifier, Order Quantity, Number of Refunded Orders. Fill in the following 10 records...", instruction information 410 can be "The 2601-2604 Product Return Table has been created and records have been added; the data table named 2601-2604 Product Return Table has been successfully added, and fields such as product information, refund rate, and product identifier have been filled in. You can view this data table in the left sidebar."

[0091] In some cases, after creating the chart component corresponding to the chart and / or the second table corresponding to the first data table, a second control can be generated. This second control receives trigger operations and can display the corresponding chart component or the second data table. In some cases, the second controls corresponding to different chart components or second data tables can be different. Optionally, the second control can be named according to its creation name.

[0092] like Figure 4C As shown, the second control 411 can be "Order Management Dashboard (Dashboard has been built)", which can receive trigger operations on the second control and display the order management dashboard.

[0093] like Figure 4D As shown, the second control 411 can be a "sales and operations dashboard (the dashboard has been built)", which can receive trigger operations on the second control and display the sales and operations dashboard.

[0094] like Figure 4F As shown, the second control 411 can be "2601-2604 Product Return Order Table (Data Table has been built)", which receives trigger operations on the second control and displays the 2601-2604 Product Return Order Table.

[0095] In some cases, the first control can be used to create a second data table; based on the first instruction, the second table is presented in a set of tables, including: based on the first instruction, obtaining the fields and data rows of the first data table; based on the fields and data rows of the first data table, creating the second data table in the first table to obtain the second table; or, based on the fields and data rows of the first data table, creating the second table and creating the second data table in the second table; and presenting the second table in the set of tables.

[0096] In this scenario, irrelevant substantive content can be obtained based on internal table rules, rather than from the first instruction, thus improving the efficiency of the first data table migration. For example, the first instruction may not include the field types of the first data table; instead, the type of each field in the first instruction can be obtained based on internal table rules, thereby forming the second table.

[0097] In some cases, creating the second data table may include: comparing the fields of the first table with the fields of the first data table to obtain a field to be added; the field to be added may be used to characterize a field that exists in the first table but does not exist in the first data table; obtaining data to be added from the first table based on the field to be added; the data to be added may represent the data corresponding to the field to be added in the second data table; and the second data table may be created based on the fields and data rows of the first data table, as well as the field to be added and the data to be added.

[0098] When converting the first data table into the second data table, it can automatically supplement the relevant fields and data that are missing in the first data table but already exist in the first table, reducing the operation of data entry, so that the created second data table contains more complete data content, improving the creation efficiency and data integrity of the second data table, and making it easier for users to view and process the data based on the second data table.

[0099] In some cases, presenting the first output may include: analyzing the first table based on the first input to obtain a third data table; obtaining the chart based on the third data table and configuration information; the configuration information may be used to indicate the attribute information required to create the chart, the attribute information including the chart type; and presenting the chart.

[0100] The third data table can refer to the data set used to generate the chart, formed by processing the data in the first table, and can serve as the data source for the chart. The third data table can be the same as or different from the first data table. The chart type of the configuration information can be obtained through intent recognition of the first input. In some cases, the configuration information may also include other information such as horizontal axis information, vertical axis information, and / or sorting information, which can be determined based on the chart type.

[0101] By first analyzing the first table to obtain the third data table, and then obtaining the chart based on the third data table and configuration information, the data processing process can be combined with the chart generation process. This allows the chart to be generated based on the analyzed and processed data, and accurately present the relationship between fields according to the configuration information, thereby improving the matching degree between the chart and the data analysis instructions and the visualization accuracy of the data analysis results.

[0102] In some cases, before obtaining the chart based on the third data table and configuration information, the system can analyze whether it supports chart types based on the first input recognition, considering the chart types supported by the intelligent system. If the intelligent system supports chart types based on the first input recognition, the chart can be obtained based on the third data table and configuration information. If not, the intelligent system will not generate a chart.

[0103] In some cases, before displaying the first control in the associated position of the data analysis results, the intelligent system can detect the computational capability range of the first table; based on this computational capability range, it analyzes whether the first table supports generating chart components corresponding to the chart and / or a second table corresponding to the first data table. If it supports generating chart components corresponding to the chart and / or a second table corresponding to the first data table, the first control can be displayed in the associated position of the data analysis results; if it does not support the chart type configured in the information, the first control will not be displayed. This computational capability range can be obtained based on the permissions of the first table. For example, if there is no permission to edit chart components, the first control may not be displayed in the associated position of the chart; if there is no permission to create a data table, the first control may not be displayed in the associated position of the first data table.

[0104] In some cases, before displaying the first control in the associated position of the chart, the intelligent system can also detect the computing power range of the chart component created by the first table; based on the computing power range, it analyzes whether the chart component of the first table supports the chart type of the configuration information; if it supports the chart type of the configuration information, the first control can be created in the associated position of the data analysis results; if it does not support the chart type of the configuration information, the first control is not created.

[0105] In some cases, before the first sub-control is displayed in the associated position of the data analysis results, the intelligent system can detect the calculation capability range of the chart component created by the new component page in the first table; based on the calculation capability range, it analyzes whether the chart component of the new component page has a chart type with configuration information; if it supports the chart type with configuration information, the first sub-control can be created in the associated position of the data analysis results; if it does not support the chart type with configuration information, the first sub-control is not created.

[0106] In some cases, before displaying the second sub-control in the associated position of the data analysis results, the intelligent system can detect the calculation capability range of the chart component created by the existing component page in the first table; based on the calculation capability range, it can analyze whether the chart component of the existing component page has a chart type with configuration information; if it supports the chart type with configuration information, the second sub-control can be created in the associated position of the data analysis results; if it does not support the chart type with configuration information, the second sub-control will not be created.

[0107] In some cases, the computational capabilities of chart components created by different existing component pages may differ. Therefore, before displaying the next-level control of the second sub-control at the associated location of the data analysis results, the intelligent system can detect the computational capabilities of the chart components created by each existing component page; and create the corresponding next-level control based on the existing component page corresponding to the chart type that supports configuration information.

[0108] In some cases, each chart type can be configured with a corresponding instruction template, which can be used to generate a first instruction. Furthermore, generating a first instruction based on data analysis results may include: obtaining a first instruction template according to the chart type; and filling the first instruction template with the chart type and a third data table to obtain the first instruction. By setting a first instruction template, the first instruction can be generated quickly and completely, improving computational efficiency.

[0109] In some scenarios, presenting the chart component in a set of tables based on the first instruction may include: obtaining the third data table and the configuration information based on the first instruction; creating the chart component according to the third data table and the configuration information; and presenting the chart component in the set of tables. In this scenario, the created chart component can reuse the data source and chart type corresponding to the chart, thereby improving the consistency between the chart component and the data analysis results.

[0110] In some cases, the method may further include: updating the first output in response to an update operation on the first table; updating the first instruction based on the updated first output; and updating the chart component and / or the second table based on the updated first instruction. In this scenario, the chart component and / or the second table can promptly reflect the latest data in the first table, maintaining consistency between the source data, analysis results, and the created object. This reduces the need to re-initiate data analysis, manually modify chart components, or repeatedly enter table data, thereby improving the efficiency and accuracy of data updates and the reuse of analysis results.

[0111] In some scenarios, generating the first instruction based on the data analysis results may include: receiving and presenting a second input in the interactive area of ​​the intelligent system, the second input being natural language, and the second input including at least one of the chart type, data source, and fields from the data analysis results. In this scenario, adjustments to the chart components and the second data table are allowed without needing to access a dedicated configuration interface for item-by-item settings, reducing the configuration difficulty and operational cost of the chart components, and improving the match between the first instruction and actual creation requirements.

[0112] In some scenarios, the intelligent system is associated with the first table, including at least one of the following: the intelligent system is invoked in the interactive interface of the first table; the intelligent system is invoked in the collaborative space to which the first table belongs; the intelligent system is invoked in the instant messaging application of the first account, where the first account has permission to access the first table. In this scenario, the intelligent system can determine the first table and its corresponding access permissions based on the invocation entry point, thereby directly performing data analysis and content creation on the first table in different collaborative scenarios, reducing the need for users to switch between multiple applications or pages and re-designate the first table. Simultaneously, restricting the intelligent system's access to the first table through the first account's access permissions helps to balance the convenience of table data processing with permission security.

[0113] In some cases, the table processing method may further include: in response to a second operation on a first data table in the data analysis results, copying the fields, data rows, and delimiters used to separate the fields and / or data rows of the first data table; and in response to a third operation on the first table and / or the second table, pasting the copied fields and data rows into the first table and / or the second table according to the delimiters.

[0114] In some cases, the table processing method may also include: receiving a fourth operation on a first data point in the chart, and displaying the data information corresponding to the first data point at the associated position of the first data point.

[0115] In some cases, table processing can be accomplished through interaction between the intelligent system and other intelligent agents. These other intelligent agents may include decision-making agents, dashboard agents, and table agents. The decision-making agent can receive data analysis results from the intelligent system, determine whether to display a first control at the relevant location based on the first table analysis, and route first instructions. If the first instruction is used to create a chart component corresponding to a chart, the decision-making agent can send the first instruction to the dashboard agent, which then presents the chart component in the table set based on the first instruction. If the first instruction is used to create a second table corresponding to a first data table, the decision-making agent can send the first instruction to the table agent, which then presents the second table in the table set based on the first instruction.

[0116] The above methods can decouple semantic interaction, task scheduling, and component generation, and improve the execution adaptability of different types of visualization tasks.

[0117] It should be noted that in some cases, the above method can be executed by a single device, such as a computer or server. In other cases, the above method can also be applied to a distributed scenario, where multiple devices cooperate to complete the task. In such a distributed scenario, one of these devices may execute only one or more steps of the above method, and the multiple devices will interact with each other to complete the method described.

[0118] It should be noted that the above descriptions cover some situations. Other situations fall within the scope of the appended claims. In some cases, the actions or steps described in the claims can be performed in a different order than those described above and still achieve the desired result. Furthermore, the processes depicted in the drawings do not necessarily require the specific or sequential order shown to achieve the desired result. In some embodiments, multitasking and parallel processing are possible or may be advantageous.

[0119] In some cases, a form processing device is also provided. Figure 5 A schematic diagram of an exemplary form processing apparatus in one scenario is shown. (e.g.) Figure 5 As shown, the table processing device 500 can be used to implement a table processing method, and may further include the following modules: The first presentation module 501 is configured to: receive a first input, the first input being natural language indicating data analysis of a first table, the first input being received and presented through the interactive area of ​​an intelligent system, the intelligent system being associated with the first table; and present a first output, the first output including data analysis results of the first table; the data analysis results including charts and / or a first data table.

[0120] The second presentation module 502 can be configured to: receive a first operation on the data analysis result, generate a first instruction based on the data analysis result; the first instruction is used to create a chart component corresponding to the chart and / or a second table corresponding to the first data table; and present the chart component and / or the second table in a set of tables based on the first instruction.

[0121] For ease of description, the above devices are described in terms of function, divided into various modules. Of course, in practice, the functions of each module can be implemented in one or more software and / or hardware components.

[0122] The apparatuses described above are used to implement the corresponding table processing methods in any of the aforementioned situations, and have the beneficial effects of the corresponding methods, which will not be elaborated further here.

[0123] In some cases, corresponding to any of the above methods, an electronic device is also provided, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement any of the above table processing methods. In some cases, this electronic device can be used to implement... Figure 1 Electronic devices 110, servers 130.

[0124] Figure 6 A schematic diagram illustrating a more specific hardware structure of an electronic device is shown. This device may include: a processor 2010, a memory 2020, an input / output interface 2030, a communication interface 2040, and a bus 2050. The processor 2010, memory 2020, input / output interface 2030, and communication interface 2040 are internally connected to each other via the bus 2050.

[0125] The processor 2010 can be implemented using a general-purpose central processing unit (CPU), microprocessor, application specific integrated circuit (ASIC), or one or more integrated circuits to execute relevant programs and achieve the above-mentioned technical solutions.

[0126] The memory 2020 can be implemented in the form of read-only memory (ROM), random access memory (RAM), static storage device, dynamic storage device, etc. The memory 2020 can store the operating system and other applications. When the above technical solutions are implemented through software or firmware, the relevant program code is stored in the memory 2020 and is called and executed by the processor 2010.

[0127] The input / output interface 2030 is used to connect input / output devices to enable information input and output. These input / output devices can be configured as components or parts within electronic devices, or they can be externally connected to electronic devices to provide corresponding functions. Input devices may include microphones, various sensors, etc., while output devices may include displays, speakers, vibrators, indicator lights, etc.

[0128] The communication interface 2040 is used to connect a communication component (not shown in the figure) to enable communication interaction between the electronic device and other devices. The communication component can communicate via wired means (e.g., Universal Serial Bus (USB), network cable, etc.) or wireless means (e.g., mobile network, Wireless Fidelity (Wi-Fi) connection, Bluetooth, etc.).

[0129] Bus 2050 includes a pathway for transmitting information between various devices of an electronic device (e.g., processor 2010, memory 2020, input / output interface 2030, and communication interface 2040).

[0130] It should be noted that although the above-described electronic device only shows the processor 2010, memory 2020, input / output interface 2030, communication interface 2040, and bus 2050, in specific implementations, the electronic device may also include other devices necessary for normal operation. Furthermore, those skilled in the art will understand that the above-described electronic device may only include the devices necessary for implementing the above solution, and does not necessarily include all the devices shown in the figures.

[0131] The aforementioned electronic device is used to implement the corresponding table processing method in any of the preceding examples, and has the beneficial effects of the corresponding method, which will not be elaborated here.

[0132] In some cases, corresponding to the methods described above, a non-transitory computer-readable storage medium is also provided, which stores computer instructions for causing the computer to perform the table processing method described above.

[0133] The aforementioned non-transitory computer-readable storage media include both permanent and non-permanent, removable and non-removable media, which can be used to store information by any method or technology. Information can be computer instructions, data structures, components of computer programs, or other data. Examples of non-transitory computer-readable storage media include, but are not limited to, Static Random-Access Memory (SRAM), Dynamic Random-Access Memory (DRAM), other types of Random Access Memory (RAM), Read-Only Memory (ROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), flash memory or other memory technologies, Compact Disc Read-Only Memory (CD-ROM), Digital Video Disc (DVD) or other optical storage, magnetic tape, magnetic magnetic disk storage or other magnetic storage devices, or any other non-transfer medium that can be used to store information accessible by a computer.

[0134] The computer instructions stored in the aforementioned non-transitory computer-readable storage medium are used to cause the computer to perform the table processing method as described in any of the above examples, and have the beneficial effects of the corresponding method, which will not be elaborated further here.

[0135] In some cases, a computer program product is also provided, including computer program instructions, which, when run on a computer, cause the computer to perform the above-described table processing method and have the corresponding beneficial effects, which will not be elaborated further here.

[0136] Those skilled in the art should understand that the discussion of any of the above situations is merely illustrative and is not intended to imply that the scope of protection is limited to these examples; under the same concept, the technical means in the above situations can also be combined, the steps can be implemented in any order, and there are many other variations of different aspects of the situations as described above, which are not provided in detail for the sake of brevity.

[0137] Furthermore, to simplify the description and discussion, and to avoid obscuring the above-described situation, the well-known power / ground connections to the integrated circuit (IC) chip and other components may or may not be shown in the provided drawings. Additionally, the apparatus may be shown in block diagram form to avoid obscuring the above-described situation, and this also takes into account the fact that the details of the implementation of these block diagram apparatuses are highly dependent on the platform on which the above-described situation will be implemented (i.e., these details should be entirely within the understanding of those skilled in the art). In the context of the specific details (e.g., circuits) described to illustrate the above-described situation, it will be apparent to those skilled in the art that the above-described situation can be implemented without these specific details or with variations thereof. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0138] Although several scenarios have been described, many substitutions, modifications, and variations of these scenarios will be apparent to those skilled in the art based on the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the examples in the scenarios discussed.

[0139] The foregoing is intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the foregoing should be included within the scope of protection.

Claims

1. A table processing method, comprising: The system receives a first input, which is natural language indicating data analysis of a first table. The first input is received and presented through the interactive area of ​​the intelligent system, which is associated with the first table. The system presents a first output, which includes the data analysis results of the first table; the data analysis results include charts and / or the first data table. Receive a first operation on the data analysis result, and generate a first instruction based on the data analysis result; The first instruction is used to create the chart component corresponding to the chart and / or the second table corresponding to the first data table; Based on the first instruction, the chart component and / or the second table are presented in the table set.

2. The method of claim 1, further comprising: The first control is displayed at the associated location of the data analysis results; Receiving a first operation on the data analysis result and generating a first instruction based on the data analysis result includes: receiving a trigger operation on the first control and generating the first instruction based on the data analysis result.

3. The method as described in claim 2, wherein the data analysis result includes a chart, the first control associated with the chart includes a first sub-control, receiving a trigger operation on the first control, and generating the first instruction based on the data analysis result, including: Receive a trigger operation on the first sub-control and generate the first instruction based on the chart; The first instruction is used to instruct the creation of the chart component in a new component page.

4. The method as described in claim 2, wherein the data analysis result includes a chart, the first control associated with the chart includes a second sub-control, receiving a trigger operation on the first control, and generating the first instruction based on the data analysis result, including: Receive a trigger operation on the second sub-control and generate the first instruction based on the chart; The first instruction is used to instruct the creation of the chart component in an existing component page.

5. The method as described in claim 2, wherein the first control is used to create a second data table; Based on the first instruction, the second table is presented in the table set, including: Based on the first instruction, obtain the fields and data rows of the first data table; Based on the fields and data rows of the first data table, create the second data table in the first table to obtain the second table; or, based on the fields and data rows of the first data table, create the second table and create the second data table in the second table; The second table is presented in the set of tables.

6. The method of claim 5, wherein, Creating the second data table includes: By comparing the fields of the first table with the fields of the first data table, the fields to be added are obtained; the fields to be added are used to represent fields that exist in the first table but do not exist in the first data table; Based on the field to be added, obtain the data to be added from the first table; the data to be added represents the data corresponding to the field to be added in the second data table. Create the second data table based on the fields and data rows of the first data table, as well as the fields to be added and the data to be added.

7. The method of claim 1, wherein, The first output is presented, including: Based on the first input, the first table is analyzed to obtain the third data table; The chart is obtained based on the third data table and configuration information; the configuration information is used to indicate the attribute information required to create the chart, and the attribute information includes the chart type; The chart is presented.

8. The method of claim 7, wherein, Based on the first instruction, the chart component is presented in the table collection, including: Based on the first instruction, the third data table and the configuration information are obtained; The chart component is created based on the third data table and the configuration information; The chart component is presented in the set of tables.

9. The method of claim 1, further comprising: In response to the update operation of the first table, update the first output; Update the first instruction based on the updated first output; Based on the updated first instruction, update the chart component and / or the second table.

10. The method of claim 1, wherein generating the first instruction based on the data analysis result comprises: The system receives and presents a second input in the interactive area of ​​the intelligent system. The second input is natural language and includes at least one of the chart type, data source, and field from the data analysis results.

11. The method according to any one of claims 1-10, wherein the intelligent system is associated with the first table, comprising at least one of the following: The intelligent system is invoked in the interactive interface of the first table; The intelligent system is invoked in the collaborative space to which the first table belongs; The intelligent system is invoked in the instant messaging application of the first account, which has permission to access the first form.

12. A form processing apparatus, comprising: The first presentation module is configured to: receive a first input, the first input being natural language indicating data analysis of a first table, the first input being received and presented through the interactive area of ​​an intelligent system, the intelligent system being associated with the first table; The system presents a first output, which includes the data analysis results of the first table; the data analysis results include charts and / or the first data table. The second presentation module is configured to: receive a first operation on the data analysis result, and generate a first instruction based on the data analysis result; The first instruction is used to create the chart component corresponding to the chart and / or the second table corresponding to the first data table; Based on the first instruction, the chart component and / or the second table are presented in the table set.

13. An electronic device, comprising: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the computer program, implements the method as described in any one of claims 1-11.

14. A non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the method according to any one of claims 1-11.

15. A computer program product comprising computer program instructions that, when executed on a computer, cause the computer to perform the method as described in any one of claims 1-11.

Images