Data processing methods, apparatus, devices, storage media, and programs

Abstract

This application provides a data processing method, apparatus, device, and storage medium. Specifically, data can first be presented to the user via a table. Next, the user can trigger a trigger command on the table. A data processing assembly can be displayed according to the trigger command triggered by the user. The data processing assembly includes a text input area. The user can enter target text via the text input area. The target text is used to indicate the table expression that the user wants to insert. After obtaining a data processing command for the data processing assembly, the corresponding target expression can be determined based on the target text.

Description

Technical Field

[0001] [Cross - reference to Related Applications] This application claims priority to a Chinese patent application filed on August 31, 2023, with application number 202311120124.9 and invention title "Data Processing Method, Apparatus, Device, and Storage Medium", and all the contents of this application are incorporated herein by reference.

[0002] [Technical Field] This application relates to the field of computers, and particularly to data processing methods, apparatuses, devices, and storage media.

Background Art

[0003] With the development of computer technology, presenting data through tables has become a common technical means. By presenting data through tables, data with the same attributes can be presented in the same row / column, facilitating user viewing.

[0004] Currently, users can process data by calling formulas. Here, a formula is a processing logic pre - deployed inside software with table editing functions (hereinafter referred to as table software). Users can input or select the corresponding formula and select the data corresponding to the formula from the table software. Next, the processing result obtained by processing the selected data by the processing logic can be displayed on the table software. Formulas can complexly process data in table software and improve the efficiency of table editing.

[0005] However, the formula function of current table software is not user - friendly.

Summary of the Invention

[0006] To solve the problems of the prior art, this application provides a data processing method, apparatus, device, and storage medium.

[0007] Based on this, the proposed technology in this application is as follows:

[0008] According to a first aspect, the present application provides a data processing method, the method being: In response to receiving a trigger command in the table, the data processing assembly including the text input area is displayed, The process includes, in response to a data processing command for the data processing assembly, parsing the target text received via the text input area into a target expression and displaying the target expression.

[0009] In some possible implementations, the target text includes an expression type description text, and the processing logic described in the expression type description text matches the processing logic of the target expression.

[0010] In some possible implementations, the method is The data processing assembly further includes displaying at least one of the target expression, illustrative information of the target expression, and descriptive information of the target expression, wherein the descriptive information of the target expression is used to introduce the processing logic of the target expression.

[0011] In some possible implementations, the target text further includes data range description text, which is used to describe a first data range, and the method is This further includes executing the target expression on the data in the first data range and displaying the results in the table.

[0012] In some possible implementations, the target display area further includes an inserted assembly, and the method The process further includes inserting the target expression into the target table in response to an expression insertion operation triggered via the insertion assembly.

[0013] In some possible implementations, the trigger instruction is triggered on a target cell in the table, and inserting the target expression into the target table is This includes inserting the target formula into the target cell.

[0014] In some possible implementations, parsing the target text received via the text input area into a target expression is performed as follows: Sending the target text to the target model, This includes receiving a target expression analyzed by the target model based on the target text.

[0015] According to a second aspect, the present application provides a data processing method, the method being used in a server of target software, the target software having a table processing function, and the method is The acquisition of target text obtained by the client of the target software and sent to the server, Sending the target text to the target model, Receiving a target expression that matches the target text, which is fed back from the target model, This includes sending the target expression to the aforementioned client.

[0016] In some possible implementations, after sending the target text to the target model, the method, The process involves receiving instruction analysis information transmitted by the target model, wherein the instruction analysis information is obtained by semantic analysis of the target text. Based on the instruction analysis information, determine at least one intermediate expression, The method further includes transmitting information of at least one intermediate expression to the target model, wherein the target expression is determined from a plurality of intermediate expressions.

[0017] In some possible implementations, the instruction parsing information includes a first vector, the first vector corresponds to the target text, Determining multiple intermediate equations based on the first analytical information is, Obtaining feature vectors from multiple candidate equations, This includes determining at least one intermediate expression from the plurality of candidate expressions based on the first vector and the feature vector of the candidate expression.

[0018] According to a third aspect, the present application provides a data processing device comprising a display unit for displaying a data processing assembly including a text input area in response to the reception of a trigger command in a table, and a processing unit for parsing a target text received through the text input area into a target expression in response to a data processing command to the data processing assembly.

[0019] In some possible implementations, the target text includes an expression type description text, and the processing logic described in the expression type description text matches the processing logic of the target expression.

[0020] In some possible implementations, the display unit is specifically used to display at least one of the target expression, illustrative information of the target expression, and descriptive information of the target expression in the data processing assembly, wherein the descriptive information of the target expression is used to introduce the processing logic of the target expression.

[0021] In some possible embodiments, the target text further includes a data range description text, the data range description text is used to describe a first data range, the processing unit further executes the target formula on the data in the first data range, and is used to display the execution result in the table.

[0022] In some possible embodiments, the target display area further includes an insertion assembly, and specifically, the display unit is used to insert the target formula into the target table in response to a formula insertion operation triggered via the insertion assembly.

[0023] In some possible embodiments, the trigger instruction is triggered for a target cell in the table, and specifically, the display unit is used to insert the target formula into the target cell.

[0024] In some possible embodiments, the device further includes a transmission unit and an acquisition unit, the transmission unit is used to transmit the target text to a target model, and the reception unit is used to receive a target formula analyzed based on the target text by the target model.

[0025] According to a fourth aspect, the present application provides a data processing device, the device is used in a server of target software, the target software has a table processing function, the device includes an acquisition unit for acquiring target text acquired by a client of the target software and transmitted to the server, a first transmission unit for transmitting the target text to a target model, a reception unit for receiving a target formula matching the target text fed back from the target model, and a second transmission unit for transmitting the target formula to the client.

[0026] In some possible realizations, the apparatus further includes a processing unit, the receiving unit further used to receive instruction parsing information transmitted by the target model, the instruction parsing information obtained by semantic analysis of the target text, the processing unit used to determine at least one intermediate expression based on the instruction parsing information, the first transmitting unit further used to transmit information of the at least one intermediate expression to the target model, the target expression being determined from the plurality of intermediate expressions.

[0027] In some possible implementations, the instruction parsing information includes a first vector, the first vector corresponding to the target text, and the processing unit specifically obtains feature vectors of a plurality of candidate expressions, which are used to determine at least one intermediate expression from the plurality of candidate expressions based on the first vector and the feature vectors of the candidate expressions.

[0028] According to the fifth aspect, this application provides an electronic device, which is One or more processors, Includes a memory device in which one or more programs are stored, The one or more programs are executed by the one or more processors to cause the one or more processors to implement the method described in any one of the first embodiments or the method described in any one of the second embodiments.

[0029] According to the sixth aspect, the present application provides a computer-readable medium on which a computer program is stored, wherein when the program is executed by a processor, the method described in any one of the first aspects is realized, or the method described in any one of the second aspects is realized.

[0030] According to the seventh aspect, the present application provides a computer program product which, when the computer program product is run on a device, causes the device to perform the method according to the first aspect or the method according to the second aspect. [Brief explanation of the drawing]

[0031] To more clearly illustrate the embodiments of this application or the technical concepts in the prior art, the following briefly introduces the drawings that may be used in the embodiments or prior art descriptions. It is obvious that the drawings in the following description are only some of the embodiments described in this application, and a person skilled in the art can obtain other drawings based on these without expending any creative effort.

[0032] To more clearly illustrate the embodiments of this application or the technical concepts in the prior art, the following briefly introduces the drawings that may be used in the embodiments or prior art descriptions. It is obvious that the drawings in the following description are only some of the embodiments described in this application, and a person skilled in the art can obtain other drawings based on these without expending any creative effort. [Figure 1] This is a schematic diagram of an application scenario according to the embodiments of this application. [Figure 2] This is a flowchart of the data processing method according to an embodiment of this application. [Figure 3] This is a schematic diagram of one exemplary application scenario according to the embodiments of this application. [Figure 4] This is a flowchart of the data processing method according to an embodiment of this application. [Figure 5] This is a schematic diagram of the interaction of the data processing method according to the embodiment of this application. [Figure 6] This is a schematic diagram of a data processing device according to an embodiment of the present application. [Figure 7] This is a schematic diagram of a data processing device according to an embodiment of the present application. [Figure 8] This is a schematic diagram of an electronic device according to an embodiment of this application. [Modes for carrying out the invention]

[0033] The embodiments of this application will be described in more detail below with reference to the drawings. While several embodiments of this application are shown in the drawings, it should be understood that this application may be implemented in various forms and should not be construed as being limited to the embodiments described herein. On the contrary, these embodiments are provided for a more thorough and complete understanding of this application. It should also be understood that the drawings and embodiments of this application are for illustrative purposes only and are not intended to limit the scope of protection of this application.

[0034] It should be understood that the steps described in the method embodiments of this application may be performed in a different order and / or in parallel. Furthermore, the method embodiments may include additional steps and / or omit the execution of the indicated steps. The scope of this application is not limited in this respect.

[0035] As used herein, the term “including” and its variations are open inclusions, i.e., “including, but not limited to.” The term “based on” means “based at least partially.” The term “one embodiment” means “at least one embodiment,” the term “another embodiment” means “at least one other embodiment,” and the term “several embodiments” means “at least several embodiments.” Relevant definitions of other terms are given in the following description.

[0036] It should be noted that the concepts of "first," "second," etc., as used in this application are used solely to distinguish between different objects, devices, modules, or units, and are not intended to limit the order or interdependence of the functions performed by these devices, modules, or units.

[0037] It should be noted that the modifications “one” and “multiple” used in this application are general rather than restrictive, and should be understood as “one or more” unless otherwise explicitly stated in the context, as should be understood by those skilled in the art.

[0038] Data processing via tables is convenient and fast. Currently, more and more users choose to process data via tables. Therefore, many application programs provide functionality for processing data via tables. This functionality may also be called table processing functionality. Software that possesses table processing functionality may also be called table-based software. For example, to facilitate user data processing, table processing functionality can be integrated into instant messaging (IM) software. Accordingly, IM software that inherits table processing functionality may also be called table-based software.

[0039] When processing data through tables, users may need to perform operations such as calculations, transformations, and analyses of the data in the tables. To facilitate user operations, table software can provide an expression insertion function. Users can insert expressions into tables using this function. Here, an expression is a pre-configured operational logic in the table software. By inserting an expression, data can be processed according to this operational logic.

[0040] Next, to facilitate data processing according to the processing logic corresponding to the expression, the user can select or input data corresponding to the expression. Finally, the processed data can be presented in a table. In other words, the user can use pre-configured processing logic by inserting an expression. By presenting the pre-configured processing logic in the form of an expression, the user can call the expression to process data and improve the efficiency of data processing.

[0041] A large number of expressions means that there is a large amount of processing logic pre-configured in table-based software. Accordingly, when users process data using table-based application programs, they are more likely to call pre-configured processing logic by inserting expressions. For this reason, current table-based application programs often have a large number of expressions pre-configured to meet the different needs of different users.

[0042] However, in real-world applications, users may not fully understand table-based software and may not know which expressions are built into it. Therefore, while some (or more) steps in the data processing process could be completed by calling an expression, users may not be able to improve the efficiency of data processing by calling an expression because they do not fully understand the expressions built into the software.

[0043] Let's illustrate with an example. Suppose that table software A has formula B built in, and that formula B is used for addition. After entering formula B, the user can select the data to be added. Table software A can automatically add the data according to formula B. In this way, the user does not need to manually enter each data and addition operator, reducing the amount of input required from the user and improving processing efficiency.

[0044] However, if the user does not understand formula B and is unaware that it can be used to perform addition, the user will not be able to quickly add data using formula B. Thus, even if formula B for addition is built into the table software A, it will not improve the efficiency of the user performing addition and calculations.

[0045] To solve the problems of the prior art, the embodiments of this application provide a data processing method, which will be described in detail below with reference to the drawings. This application has the following beneficial effects. This application provides a data processing method, apparatus, device, and storage medium. Specifically, data can first be presented to the user via a table. Next, the user can trigger a trigger command on the table. A data processing assembly can be displayed according to the trigger command triggered by the user. The data processing assembly includes a text input area. The user can enter target text via the text input area. The target text is used to indicate the expression in the table that the user wants to insert. After obtaining a data processing command for the data processing assembly, the corresponding target expression can be determined based on the target text. In other words, if the user needs to insert an expression in a table, the user can first trigger a trigger command, then enter the target text in the text input area, and then trigger a data processing command to easily display the target expression corresponding to the target text. In this way, the user can achieve automatic expression input without understanding the specific expression, reducing the barrier to use and improving the user experience.

[0046] First, let's introduce an exemplary application scenario of the embodiment of this application. Referring to Figure 1, this figure is a block schematic diagram of an exemplary application scenario according to the embodiment of this application. The implementation shown in Figure 1 includes a client 110, a server 120, and a target model 130. Here, the client 110 and the server 120 can be connected via a network. The server 120 and the target model 130 can also be connected via a network.

[0047] Here, client 110 may run on a terminal device used by the user, such as the user's mobile phone or computer. Server 120 may run on a server device or server cluster to provide services to client 110. Data interaction can occur between client 110 and server 120.

[0048] Target model 130 may run on a server or server cluster. Selectively, the server (or server cluster) for implementing target model 130 and the server (or server cluster) for implementing server 120 may be the same or different. Target model 130 is used to provide services of the target model to external parties. For example, target model 130 may run the target model. Server 120 may send data to be processed to target model 130, and target model 130 may process the data to be processed by the target model and send the processed data to server 120. Selectively, the target model may be a language model (LM) or a large language model (LLM).

[0049] The above describes exemplary application scenarios of the embodiments of this application. Below, we will exemplify a data processing method according to the embodiments of this application.

[0050] Referring to Figure 2, Figure 2 is a flowchart of a data processing method according to an embodiment of the present application, and the embodiment of the present application is applicable to application scenarios where data is processed via a table. Here, this data processing method may be performed by a data processing device, and this data processing determination device may be implemented by software.

[0051] It should be noted that the data processing device in the embodiment corresponding to Figure 1 and the data processing device in the embodiment corresponding to Figure 2 may be different devices. For example, the data processing device in the embodiment corresponding to Figure 4 may run on a server of table software, and the data processing device in the embodiment corresponding to Figure 2 may run on a client of table software.

[0052] Optionally, this data processing device may be integrated into a client of the table software. Here, the software client runs on a terminal device used by a user, such as a mobile phone or a computer. The client may be an application program client or a web page client of the table software. The software server may run on a server or a server cluster to provide services corresponding to the software client. Optionally, this table software may be instant messaging (IM) software with table functionality. When this data processing device is integrated into a client, it can communicate with the server and use the target model via the server. Optionally, in the application scenario shown in Figure 1, this data processing device may be integrated into client 110. For ease of explanation, the following description will use the example of the data processing device being integrated into a client.

[0053] As shown in Figure 2, this method specifically includes the following steps.

[0054] S201: In response to receiving a trigger command in the table, displays the data processing assembly.

[0055] In embodiments of this application, the data processing device may receive a trigger command triggered by a user and display a processing assembly based on the trigger command data. Here, the table is a table displayed by a client of table software. The trigger command is a command triggered by the user in the table. The data processing assembly includes a text input area. The text input area is used to receive text entered by the user.

[0056] In the embodiments of this application, the data processing assembly may be presented based on user operation. This operation corresponds to a trigger command. Specifically, the data processing assembly may be hidden before the trigger command is received. After the trigger command is received, the data processing assembly can be displayed. Here, the operation corresponding to the trigger command may include a first operation. The first operation may include pressing a pre-configured shortcut key, clicking a pre-configured control, or issuing a voice command, etc. The embodiments of this application are not limited to the first operation.

[0057] Selectively, a trigger command may be directed at a table displayed to the client, or at some of the data in the table. For example, in some possible implementations, a trigger command may be directed at a first data range in the table, where the first data range corresponds to some or all of the data in the table. For ease of explanation, we will refer to the data corresponding to the first data range as the first data.

[0058] Selectively, the first data range may correspond to a single cell in a table. Specifically, the user may select a cell in a table and trigger a trigger command in that cell. Accordingly, the target expression inserted into the table described below may be inserted into this cell. For ease of explanation, the cell into which the target expression is inserted may be called the target cell. In other words, the trigger command may be triggered by the user on the target cell.

[0059] Accordingly, the operation corresponding to the trigger command may further include an operation for determining a first data range. This operation for determining the first data range may be called a second operation. Optionally, the second operation may include, for example, a box selection operation. The user can obtain the first data range by selecting the data that needs to be processed through the box selection operation.

[0060] Selectively, the second operation may be triggered before the first operation. That is, in order to trigger the trigger instruction, the user may first trigger the second operation and select the first data range corresponding to the target data in the table that needs to be processed. Then, the user may trigger the first operation and invoke a hidden data processing assembly.

[0061] In other words, if a user wants to process data using a certain expression, the user may trigger a first operation. After obtaining the first operation triggered by the user, the user may be shown a data processing assembly. The data processing assembly includes a text input area. After the data processing assembly is shown, the user may enter target text into the text input area.

[0062] Selectively, the data processing assembly may further include prompt information. This prompt information may correspond to a text input area to prompt the user that they can process the data in the table by entering text information into the text input area.

[0063] Selectively, a data processing assembly may further include data processing controls. These data processing controls are used to trigger a third operation, which corresponds to a data processing instruction. For an introduction to the third operation and data processing instructions, please refer to the following; further explanation is not provided here.

[0064] In some possible implementations, the model may determine the expression corresponding to the target text. Here, the model may be a model with natural language processing (NLP) capabilities, such as a language model or a large-scale language model. Optionally, the data processing assembly may correspond to a cloud service corresponding to the model. For ease of explanation, this cloud service may be called the first cloud service.

[0065] In other words, the user may call a first cloud service to process data in a first data range in a table by target text. Accordingly, the data processing unit may be a software module for implementing the first cloud service on the client. The data processing assembly may be a display area corresponding to the first cloud service. The data processing unit may determine the expression the user wants to input into the table by calling the server of the first cloud service.

[0066] Thus, the first operation described above may be an operation that uses the first cloud service. For example, the user may first trigger the second operation to determine the first data display range, then trigger a right-click operation to bring up a menu, and then trigger a left-click operation on the operation control corresponding to the first cloud service in the menu.

[0067] In the above implementation, the data processing assembly is displayed based on a trigger instruction. In some other possible implementations, the data processing assembly may be located in a specific area of ​​the client interface of the table software, for example, in the menu bar of the client interface. Accordingly, if a user wants to insert an expression into a table, the user may enter the target text through the text input area of ​​the data processing assembly by switching the text input cursor to the data processing assembly.

[0068] After presenting the data processing assembly to the user, the user may enter target text in a text input area to trigger a data processing command. Here, the target text is used to indicate the expression the user wants to insert into the table, and the data processing command is used to initiate a flow that determines the expression based on the target text.

[0069] In the embodiments of this application, the target expression is determined based on the target text. Accordingly, the target text may include relevant information to indicate the target expression. Optionally, the target text may include an expression type description text, which is used to describe the target expression. Specifically, the processing logic described in the expression type description text is the same as the processing logic of the target expression.

[0070] Selectively, the target text may further include target cell description text. The target cell description text is used to describe the target cell.

[0071] In some other possible implementations, the target text may further include data range description text, which is used to describe the data range to be processed that the target expression is targeting. See below for an introduction to data range description text; no further explanation is provided here.

[0072] Selectively, the user may obtain a data processing command by triggering a third operation. The third operation may include, for example, a click operation triggered by the user on a data processing control. That is, the user may trigger a third operation after completing the input of target text. Accordingly, the data processing device may execute step S202 described below to issue a data processing command in response to the third operation.

[0073] S202: In response to a data processing instruction for the data processing assembly, the target text received via the text input area is parsed into a target expression.

[0074] After receiving a data processing command triggered by a user, the data processing device may determine the expression the user wants to insert into the table based on the target text received in the text input area. Optionally, the expression parsed based on the target text may be called the target expression.

[0075] In some possible implementations, the target text entered by the user may be sufficiently clear. Accordingly, the complete target expression may be determined based on the target text. Alternatively, in some other possible implementations, the target text entered by the user may not be sufficient to determine the complete target expression. In this case, illustrative information and / or descriptive information for the target expression may be determined based on the target text. In other words, parsing the target text into a target expression may include parsing the target text into illustrative information and / or descriptive information for the target expression. Here, the complete target expression includes an expression that is directly usable for data processing. An introduction to illustrative information and descriptive information for target expressions is provided below and will not be explained further here.

[0076] Selectively, the data processing device may send data processing instructions and target text to the server, and the server may determine a target expression based on the target text. After the server has determined the target expression, the client may receive the target expression sent by the server. Selectively, the server may obtain the target expression by parsing the target text using a model to determine the user's intent. For an introduction to the contents of this section, please refer to the following; no further explanation is provided here.

[0077] After determining the target expression, the data processing device may display the target expression to the user and / or process the data in the table based on the target expression. These are described below.

[0078] First, let's look at how to display the target expression.

[0079] In some possible implementations, the data processing device may present a target expression in a cell within a table. Specifically, the data processing device may insert a target expression into a cell in a table. Selectively, the cell into which the expression is inserted may be a user-selected cell, a pre-configured cell, or a randomly selected cell.

[0080] Let's illustrate with an example. If a user wants to insert formula B into cell A in a table, the user may first select cell A by clicking on it. Next, the user may trigger the first and third operations described above, and then trigger the third operation after entering the target text into the text input area. Accordingly, the target formula corresponding to the target text, i.e., formula B, may be determined based on the data processing command corresponding to the third operation. Next, the data processing device may insert formula B into cell A and display formula B at the position corresponding to cell A.

[0081] Alternatively, in some other possible implementations, the target expression may be displayed in a pre-configured display area. For example, as can be seen from the above introduction, the target text is entered by the user in a text input area in the data processing assembly. Accordingly, the target expression corresponding to the target text may be determined and then displayed in the data processing assembly.

[0082] Specifically, the data display assembly may include a target display area. After determining the target expression, the target expression may be displayed in the target display area. Here, the target display area is the relevant area in the data display assembly for displaying the target expression. Selectively, before displaying the target expression, the target display area may be hidden and / or collapsed.

[0083] As can be seen from the above introduction, parsing target text into target expressions may include parsing target text into illustrative information and / or descriptive information of target expressions. Accordingly, displaying target expressions may include displaying target expressions, or it may include displaying target expressions, displaying illustrative information of target expressions, and displaying descriptive information of at least one of the descriptive information of target expressions. This will be explained in detail below.

[0084] Here, the illustrative information for the target expression is used to indicate the basic form of the target expression. Based on the illustrative information for the target expression, the user may determine the logical structure of the target expression and each input parameter in the target expression. For example, the user may obtain the illustrative information for the target expression by replacing the input parameters in the target expression with the illustrative information for the input parameters. The illustrative information for the input parameters are typical input parameters. Based on the illustrative information for the input parameters, the user may determine the data type of the input parameters. In this way, based on the illustrative information for the target expression, the user can understand the input parameters of the target expression and the basic information of each input parameter, making it easier for the user to process target data using the target expression.

[0085] The descriptive information of a target expression is used to introduce the target expression. Selectively, the descriptive information of a target expression may also be used to introduce the purpose of the target expression and / or the processing logic corresponding to the target expression. In this way, based on the descriptive information of the target expression, the user can determine whether the target expression can meet the need to process the target data.

[0086] And / or, the descriptive information of the target expression may further include introductory information for each input parameter in the target expression. The introductory information for the input parameters may be used to describe the meaning represented by the input parameter and the value range of the input parameter. In this way, based on the descriptive information of the target expression, the user can determine what data needs to be entered into the target expression and the specific format of the data to be entered.

[0087] In this way, based on the example information and descriptive information of the target expression, the user can understand the target expression and determine whether or not the target expression can process the target data, and what data needs to be input into the target expression when processing the target data.

[0088] As can be seen from the above introduction, the target expression, the example information for the target expression, and the descriptive information for the target expression may be displayed via the target display area of ​​the data assembly. In order to distinguish between different contents displayed in the target display area, the target expression, the example information for the target expression, and the descriptive information for the target expression (if any) may be displayed in different ways.

[0089] For example, the target expression, illustrative information of the target expression, and descriptive information of the target expression (if any) may be presented in different sub-areas of the target display area using different presentation methods.

[0090] In other words, the target expression may be presented in the first sub-region of the target display region using the first presentation method, illustrative information of the target expression may be presented in the second sub-region of the target display region using the second presentation method, and descriptive information of the target expression may be presented in the third sub-region of the target display region using the third presentation method.

[0091] Selectively, the target expression, the example information for the target expression, and the descriptive information for the target expression (if any) may be distinguished by different background colors. Alternatively, the example information for the target expression and the descriptive information for the target expression may be distinguished by different fonts, font sizes, or other methods. Alternatively, separators may be added between the first, second, and third sub-regions to prompt the user that the first, second, and third sub-regions are different display regions and that they display different content.

[0092] Selectively, because the actions of the target expression and the illustrative information of the target expression are similar, the first sub-region and the second sub-region may be the same display region, and the first display method and the second display method may be the same display method.

[0093] In the implementation described above, the target expression and related information for the target expression may be displayed in the target display area. However, the user's fundamental objective is not to view the target expression or related information for the target expression, but to process the target data using the target expression. Accordingly, in order to meet the data processing needs, the user also needs to insert the target data into the target cell.

[0094] In some possible implementations, the information presented in the target display area is copyable. Accordingly, the user can select and copy the target formula (or example information for the target formula) from the target display area and paste the copied target formula (or example information for the target formula) into the target cell.

[0095] In the above implementation, target expressions can be added to target cells in a table, but users must manually perform operations such as selection, copy, and paste, which is relatively cumbersome and results in a relatively poor user experience. Therefore, in some possible implementations, the data processing unit can automatically insert target expressions into the table.

[0096] Specifically, the user may trigger a fourth operation. After receiving the fourth operation, the data processing device may insert the target expression into the table. Here, the fourth operation may be triggered by an insert control. The insert control may be a control displayed in the target display area. In other words, the user may first view the information of the target expression displayed in the target display area. After determining that the target expression is correct, the user may insert the target expression into the table by triggering the insert control.

[0097] When presenting data via a table, the data may be entered into the cells of the table. Accordingly, when inserting a target expression into a table, the target expression may be inserted into a specific cell. The specific cell into which the above target expression is inserted may be called the target cell. Selectively, the target cell may be a cell that is pre-configured in the target table. Alternatively, the target cell may be the cell corresponding to the first operation. That is, if the user triggers the first operation on cell A in the target table, the target expression may be inserted into cell A after obtaining the fourth operation.

[0098] The following describes a method for presenting target expressions, linking it to actual application scenarios. Referring to Figure 3, after determining the first piece of information, the screen displayed by the client may include the interface shown in Figure 3. The interface shown in Figure 3 includes a table display area 310 and a data processing assembly 320. Here, the table display area 310 is used to display tables and the data in those tables, and the data processing assembly 320 is used to display related information for the target expression. The data processing assembly 320 corresponds to the aforementioned data processing assembly.

[0099] The table display area 310 includes cell 311, and the user may trigger a first operation on cell 311 to facilitate the client displaying the data processing assembly to the user, which will input target text and trigger a third operation. After obtaining the third operation triggered by the user, the target expression may be determined and the data processing assembly 320 may display the target expression.

[0100] The data processing assembly 320 corresponds to the data processing described above. It includes a display area 321, a display area 322, an operation control 323, and an operation control 324.

[0101] Here, display area 321 corresponds to the target display area described above and includes display sub-area 321-1 and display sub-area 321-2. Display sub-area 321-1 corresponds to the first display area described above and is used to display illustrative information of the target expression. Display sub-area 321-2 corresponds to the third display area described above and is used to display descriptive information of the target expression. In the implementation corresponding to Figure 3, display sub-area 321-1 has a different background color from display sub-area 321-2 and is used to distinguish the target expression from the illustrative information of the target expression.

[0102] Display area 322 is used to display a text input box. Selectively, this text input box may be for entering target text, i.e., the aforementioned target text input area. Sub-display area 322 may include prompt information 322-1. Prompt information 322-1 is used to prompt the user sub-display area 322 to include a text input area.

[0103] Operation control 323 is used to trigger the fourth operation. The user may trigger the fourth operation by clicking operation control 323. After obtaining the click operation triggered by the user on operation control 323, a target expression may be inserted into cell 311.

[0104] The operation control 324 is used to trigger a reset operation. After the reset operation is received, the contents displayed in the data processing assembly 320 may be cleared.

[0105] The above explains how to display target expressions. Below, we will explain how to process data in a table based on target expressions.

[0106] In the embodiments of this application, the target expression may be determined based on target text entered by the user. Selectively, if the information in the target text entered by the user is sufficient to determine the data to be processed based on the target text, the data to be processed by the target expression may be processed after the target expression has been determined.

[0107] Specifically, the target text may include data range description text. The data range description text is used to describe the first data range. The first data range is the data range in the table of data to be processed. In this way, after determining the target expression and the first data range, the target expression may be executed on the data in the first data range, and the execution result obtained by executing the target expression may be displayed in the table. Selectively, the execution result may be displayed in the target cell.

[0108] This application provides a data processing method. Specifically, data can first be presented to the user via a table. Next, the user can trigger a trigger command on the table. A data processing assembly can be displayed according to the trigger command triggered by the user. The data processing assembly includes a text input area. The user can enter target text via the text input area. The target text is used to indicate the expression in the table that the user wants to insert. After obtaining a data processing command for the data processing assembly, the corresponding target expression can be determined based on the target text. In other words, if the user needs to insert an expression in a table, the user can first trigger a trigger command, then enter the target text in the text input area, and then trigger a data processing command to easily display the target expression corresponding to the target text. In this way, the user can achieve automatic expression input without understanding the specific expression, reducing the barrier to use and improving the user experience.

[0109] The above describes the relevant aspects of the data processing device on the client side in the data processing method according to the embodiments of this application. In some possible implementations, the target text may be processed by a model.

[0110] The following section illustrates the data processing method according to the embodiment of this application, from the perspective of the server for the table software, while referring to Figure 4.

[0111] Referring to Figure 4, Figure 4 is a flowchart of a data processing method according to an embodiment of the present application, and the embodiment of the present application is applicable to application scenarios in which expressions are inserted into a table. Here, this data processing method may be executed by a data processing device running on a server.

[0112] It should be noted that the data processing device in the embodiment corresponding to Figure 4 and the data processing device in the embodiment corresponding to Figure 2 may be different devices. For example, the data processing device in the embodiment corresponding to Figure 4 may run on a server of table software, and the data processing device in the embodiment corresponding to Figure 2 may run on a client of table software.

[0113] This data processing device may be implemented by software. Optionally, the device may include a model for processing target request data based on example data, or the device may be associated with a model for processing target request data based on example data. Optionally, the model may include, for example, an LM model or an LLM model. In the embodiments of this application, this model may be referred to as a target model.

[0114] Optionally, this data processing unit may be integrated into a server of table software. Here, the server of table software may run on a server or a server cluster to provide services corresponding to clients of this software. When this data processing unit is integrated into a server, it may communicate with clients to obtain target request data to be processed, which is sent by the clients. Optionally, this data processing unit may communicate with a target model to facilitate the transmission of example data and target request data to the target model. For the sake of clarity, the following explanation will use the example of the data processing unit being integrated into a server.

[0115] As shown in Figure 4, this method specifically includes the following steps.

[0116] S401: Get the target text.

[0117] To determine the expression a user wants to insert into a table, the user may call a data processing assembly on the client of the table software and enter the target text through the text input box of the data processing assembly. Based on the data processing instruction to the data processing assembly, the client of the table software may send the target text to the server of the table software. Accordingly, a data processing device running on the server of the table software may retrieve the target text.

[0118] S402: Send target text to target model.

[0119] After obtaining the target text, the data processing device may send the target text to the target model. Optionally, the target model may be a model with semantic analysis capabilities, such as an LM or LLM. Accordingly, the target text may be natural language text, and the target expression parsed based on the target text may be implemented based on a structured language. For example, the target expression may be implemented based on the JavaScript Object Notation (JSON) language.

[0120] Accordingly, the data processing device may send prompt information to the target model. The prompt information may include the target text and other information. For a detailed explanation of how the target model determines the target expression, please refer to the corresponding embodiment shown in Figure 5 below. Further explanation is not provided here.

[0121] S403: Receives the target expression fed back from the target model.

[0122] After obtaining the target text, the target model may analyze the target text to determine the corresponding target expression.

[0123] Selectively, the target model may send relevant information about the target expression to the server, for example, illustrative information and / or descriptive information about the target expression to the server. Alternatively, the server may pre-store relevant information about the target expression. After receiving the target expression as feedback from the target model, the server may present the target expression and its related information to the user by querying the relevant information about the target expression based on the target expression.

[0124] As can be seen from the above introduction, the expression may be an arithmetic logic pre-configured in the table software. Accordingly, the target expression may be an expression that can be identified by the table software.

[0125] S404: Send target expression to client.

[0126] After the target model determines the target expression corresponding to the target text, the data processing device may send the target expression to the client to facilitate the client presenting the target expression to the user.

[0127] In the implementation described above, the target expression may be determined based on the target model and target text. Below, we will introduce a method for determining the target expression using the target model, using the implementation shown in Figure 1 as an example.

[0128] In some possible implementations, client 110 may send target text to target model via server 120. Target model 130 may parse the target text to determine the user's intent, further determine a corresponding target expression, and then send relevant information about the target expression to client 110 via server 120.

[0129] Selectively, if the target model 130 is a model with context learning capabilities such as LM or LLM, the target model 130 may first perform context learning on the relevant information of the expression function, and then process the target text based on the results of the context learning. In this way, by performing context learning on the information related to the expression function, the target expression determined by the target model 130 will match the user's intent better.

[0130] Selectively, related information on expression functions may be pre-organized and stored. When it is necessary to determine the target model target expression, the server 120 may acquire related information on expression functions and send it to the target model 130 via prompt information to facilitate context learning by the target model 130 based on the related information on expression functions.

[0131] As can be seen from the above introduction, the target expression may correspond to the expression function provided by the table software. Based on the target expression, the processing logic provided by the table software may be called to process the data. Therefore, in the process of determining the target expression, the relevant information for context learning may include relevant information about the expression function provided by the table software. For example, it may include documentation introducing the expression function provided by the table software that corresponds to the table software.

[0132] In real-world scenarios, table-based software may offer a variety of expression functions. Consequently, if the number of expression functions is large, but the amount of data that can be carried in the prompt information is limited, the prompt information may not be able to fully carry all the relevant information for all expression functions in the table-based software. Thus, the target model 130 may not be able to fully perform contextual learning for the relevant information of the expression functions in the table-based software, and may not be able to correctly determine the target expression.

[0133] Therefore, in some possible implementations, the target model 130 may be identified multiple times. This will be explained in detail below, with reference to Figure 5.

[0134] Referring to Figure 5, Figure 5 is a flowchart of a method for determining a target expression according to an embodiment of the present application, which is applied to the network architecture shown in Figure 1, and the application context of the expression corresponding to the target text can be determined by the target model 130. Here, the target model 130 is a model that has word semantic recognition capability, and the target model 130 is capable of context learning. For example, the target model 130 may include an LM model or an LLM model.

[0135] As shown in Figure 5, this method specifically includes the following steps.

[0136] S501: Client 110 sends the target text to Server 120.

[0137] Please refer to the above for an introduction to the target text; no further explanation will be provided here.

[0138] S502: Server 120 sends the target text to target model 130.

[0139] After receiving the target text sent by client 110, server 120 may send the target text to target model 130. Selectively, server 120 may send the target text to target model 130 via the first prompt information.

[0140] It should be explained that, prior to step S405, the target model 130 does not need to perform contextual learning on the target text and does not need to have the ability to determine the target expression based on the target text.

[0141] S503: Target model 130 determines instruction analysis information based on the target text.

[0142] After acquiring the target text, the target model 130 may perform semantic analysis on the target text to determine the instruction analysis information corresponding to the target text. Selectively, the first prompt information may include relevant information for semantic analysis so that the target model 130 performs context learning. In this way, the target model 130 can correctly determine the instruction analysis information by first performing context learning and then analyzing the target text.

[0143] In the embodiments of this application, the instruction analysis information may be a vector. That is, the target model 130 may vectorize (embed) the target text. For the sake of clarity, the vector corresponding to the instruction analysis information may be called the first vector.

[0144] S504: Target model 130 sends instruction analysis information to server 120.

[0145] After determining the instruction analysis information corresponding to the target text, the target model 130 may send the instruction analysis information to the server 120.

[0146] S505: Server 120 determines at least one intermediate expression based on the instruction analysis information.

[0147] After obtaining instruction analysis information, the server 120 may determine at least one intermediate expression based on the instruction analysis information. The similarity between the intermediate expression and the target expression is higher than the similarity between the non-intermediate expression and the target expression.

[0148] In the embodiments of this application, the intermediate expression is determined based on the expression function provided by the table software. The intermediate expression may be used to invoke the expression function. In other words, the intermediate expression is an expression that can be provided by the table software. The descriptive information corresponding to the intermediate expression is matched with the instruction analysis information. That is, if the expressions that can be provided by the client 110 are candidate expressions, the server 120 may select a target expression that matches the instruction analysis information from among the multiple candidate expressions.

[0149] Specifically, multiple candidate expressions may be predetermined. Among the candidates, the intermediate expression is an expression function that can be provided by the table software. The descriptive information corresponding to the intermediate expression is matched with the instruction analysis information. In other words, if the expressions that can be provided by the client 110 are the candidate expressions, the server 120 may select an intermediate expression that matches the instruction analysis information from among the multiple candidate expressions. In this embodiment, the intermediate expression may be determined based on the feature vector of the candidate expression. For example, the intermediate expression may be determined based on the similarity between the feature vector of the candidate expression and the vector corresponding to the instruction analysis information.

[0150] Selectively, the feature vector of the candidate expression may be obtained by vectorizing the descriptive information of the candidate expression. Here, the descriptive information of the candidate expression is related information for describing the candidate expression. For example, it may include information such as the function of the candidate expression, the function corresponding to the candidate expression, and the related parameters required for the candidate expression. Selectively, the descriptive information of the expression may be determined by the introductory information of the table software. The introductory information of the table software may include, for example, information such as the specification or user manual of the table software.

[0151] In actual applications, the descriptive information of candidate expressions may be vectorized in advance to obtain a feature vector for each candidate expression. These feature vectors may then be stored in a database 140 (not shown). Alternatively, the feature vectors of candidate expressions may be obtained from the database after acquiring the instruction analysis information.

[0152] Next, the similarity between the first vector and the feature vectors of each candidate equation may be calculated. For example, the cosine similarity and double dot (ddot) of the first vector and the feature vectors of the candidate equations may be calculated, and at least one intermediate equation may be determined based on the calculation results.

[0153] S506: Server 120 transmits information about at least one intermediate expression to target model 130.

[0154] After determining at least one intermediate formula, the server 120 may send relevant information for at least one intermediate formula to the target model 130. Here, the relevant information for an intermediate formula may include, for example, a representation of the intermediate formula, a description of the intermediate formula, and a vector corresponding to the intermediate formula.

[0155] Specifically, the server 120 may generate a second prompt and send the second prompt to the target model 130. The second prompt may include information on the intermediate expression. Optionally, the second prompt may further include target text or instruction parsing information.

[0156] Before generating the second prompt information, one or more decisions may be made. For example, it may be determined whether the target text is unrelated to the expression function of table software, whether the number of identifiers (tokens) included in the second prompt information exceeds a predetermined threshold, and whether the relationship between the intermediate expression and the target text is reasonable. After passing these decisions, the corresponding second prompt information may be generated.

[0157] S507: The target model 130 performs context learning on information from at least one intermediate expression to determine the target expression.

[0158] After obtaining information on at least one intermediate expression, the target model 130 may perform context learning based on the information on the intermediate expression, process the target text (or instruction parsing information) after context learning, and determine the information on the target expression corresponding to the target text.

[0159] S408: Target model 130 transmits target expression information to client 110 via server 120.

[0160] After determining the target expression information, the target model 130 may send the target expression information to the client 110 via the server 120. Accordingly, the data processing device may acquire and display the target expression information.

[0161] In other words, if there is too much related information for an expression to be carried by the prompt information, the target model 130 may first perform a preliminary analysis of the target text and determine the instruction analysis information corresponding to the target text. Then, the server 120 may perform a preliminary selection of candidate expressions based on the instruction analysis information and find information on intermediate expressions that have a relatively high degree of relevance to the instruction analysis information. In this way, the server 120's selection filters out expressions unrelated to the target text and selects intermediate expressions that have a relatively high degree of relevance to the target text. Since the number of intermediate expressions is smaller than the number of candidate expressions, the prompt information can carry the related information for the intermediate expressions. Furthermore, since the information on the intermediate expressions has been selected based on the instruction analysis information, and the degree of relevance between the intermediate expressions and the target expression is higher than the degree of relevance between non-intermediate expressions and the target expression, the target model 130 performs context learning based on the information on the intermediate expressions, and this does not affect the accuracy of the target model 130. In this way, the amount of data in the prompt information is reduced while guaranteeing the accuracy of the target expression.

[0162] Based on the data processing method according to the embodiment of the above method, the embodiment of this application further provides two data processing devices, which operate as a client and server of table software, respectively. The data processing devices will be described below with reference to the drawings.

[0163] As shown in Figure 6, this figure is a schematic diagram of the structure of a data device running on a client of table software according to an embodiment of this application. As shown in Figure 6, this data processing device 600 is A display unit 610 for displaying a data processing assembly including a text input area in response to receiving a trigger command in the table, The system includes a processing unit 620 for parsing target text received via the text input area into a target expression in response to a data processing command for the data processing assembly.

[0164] In some possible implementations, the target text includes an expression type description text, and the processing logic described in the expression type description text matches the processing logic of the target expression.

[0165] In some possible implementations, the display unit 610 is specifically used to display at least one of the target expression, illustrative information of the target expression, and descriptive information of the target expression in the data processing assembly, wherein the descriptive information of the target expression is used to introduce the processing logic of the target expression.

[0166] In some possible implementations, the target text further includes data range description text, which is used to describe a first data range, and the processing unit 620 is further used to execute the target expression on the data in the first data range and to display the results in the table.

[0167] In some possible implementations, the target display area further includes an insertion assembly, and the display unit 620 is specifically used to insert the target expression into the target table in response to an expression insertion operation triggered via the insertion assembly.

[0168] In some possible implementations, the trigger instruction is triggered on a target cell in the table, and the display unit 620 is specifically used to insert the target expression into the target cell.

[0169] In some possible implementations, the device further includes a transmitting unit and an acquiring unit, the transmitting unit being used to transmit the target text to a target model, and the acquiring unit being used to receive a target expression parsed by the target model based on the target text.

[0170] As shown in Figure 7, this figure is a schematic diagram of the structure of a data device running on a server of table software according to an embodiment of this application. As shown in Figure 7, this data processing device 700 is An acquisition unit 710 for acquiring target text acquired by the client of the target software and transmitted to the server, A first transmission unit 720 for transmitting the target text to the target model, A receiving unit 730 for receiving a target expression that matches the target text, which is fed back from the target model, The system includes a second transmitting unit 740 for transmitting the target expression to the client.

[0171] Selectively, the acquisition unit 710 and the receiving unit 720 may be the same unit or different units. The first transmission unit 720 and the second transmission unit 740 may be the same unit or different units.

[0172] In some possible realizations, the apparatus further includes a processing unit, the receiving unit 730 is used to receive instruction parsing information transmitted by the target model, the instruction parsing information is obtained by semantic analysis of the target text, the processing unit is used to determine at least one intermediate expression based on the instruction parsing information, and the first transmitting unit 720 is used to transmit information of the at least one intermediate expression to the target model, the target expression is determined from the plurality of intermediate expressions.

[0173] In some possible implementations, the instruction parsing information includes a first vector, the first vector corresponding to the target text, and the processing unit specifically obtains feature vectors of a plurality of candidate expressions, which are used to determine at least one intermediate expression from the plurality of candidate expressions based on the first vector and the feature vectors of the candidate expressions.

[0174] Based on the data processing method according to the embodiment of the above method, the present application further provides an electronic device comprising one or more processors and a memory device storing one or more programs, wherein the one or more programs are executed by the one or more processors, causing the one or more processors to implement the data processing method described in any one of the embodiments described above.

[0175] Referring to Figure 8, the following shows a schematic diagram of the structure of an electronic device 800 suitable for realizing an embodiment of this application. The terminal devices in the embodiment of this application may include, but are not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (portable Android devices, tablet computers), PMPs (Portable Media Players), and in-vehicle terminals (e.g., in-vehicle navigation terminals), as well as fixed terminals such as digital TVs (televisions) and desktop computers. The electronic devices shown in the figure are merely examples and do not impose any limitations on the functions and scope of use of the embodiment of this application.

[0176] As shown in Figure 8, the electronic device 800 may include a processing unit (e.g., a central processor, graphics processor, etc.) 801, which can perform various appropriate operations and processes based on programs stored in read-only memory (ROM) 802 or programs loaded from storage device 808 into random access memory (RAM) 803. RAM 803 further stores various programs and data necessary for operating the electronic device 800. The processing unit 801, ROM 802, and RAM 803 are connected to each other via bus 804. An input / output (I / O) interface 805 is also connected to bus 804.

[0177] Generally, devices such as input devices 808 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, and gyroscopes; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, and vibrators; storage devices 808 including, for example, magnetic tape and hard disks; and communication devices 809 can be connected to the I / O interface 805. The communication device 809 can allow the electronic device 800 and other devices to exchange data via wireless or wired communication. Figure 7 shows an electronic device 800 with various devices, but it should be understood that it is not required to implement or have all of the devices shown. More or fewer devices may be implemented or have all of them instead.

[0178] In particular, according to embodiments of this application, the process described above with reference to the flowchart may be implemented as a computer software program. For example, embodiments of this application include a computer program product which includes a computer program placed on a non-temporary computer-readable medium, and this computer program includes program code for performing the method shown in the flowchart. In such embodiments, this computer program may be downloaded and installed from a network via a communication device 809, or installed from a storage device 808, or installed from a ROM 802. When this computer program is executed by the processing unit 801, the above-described functions, limited by the method of embodiments of this application, are performed.

[0179] The electronic device according to the embodiment of this application belongs to the same inventive concept as the data processing method and file transmission method according to the above embodiment. Technical details not described in detail in this embodiment can be referenced to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0180] Based on the method according to the embodiment of the above method, the embodiment of this application provides a computer storage medium on which a computer program is stored, and when the program is executed by a processor, the data processing method described in any one of the above embodiments is realized.

[0181] It should be noted that the computer-readable medium in this application may be a computer-readable signal medium, a computer-readable storage medium, or any combination thereof. The computer-readable storage medium may be, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage mediums may include, but are not limited to, an electrical connection having one or more wires, a portable computer magnetic disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact magnetic disk read-only memory (CD-ROM), an optical memory device, a magnetic memory device, or any suitable combination thereof. In this application, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, apparatus, or device. In this application, the computer-readable signal medium may include data signals propagated in the baseband or as part of a carrier, which carry computer-readable program code. The data signals propagated in this manner may include, but are not limited to, electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium may be any computer-readable medium other than a computer-readable storage medium, which can transmit, propagate, or transmit programs for use by or in combination with instruction execution systems, apparatus, or devices. The program code contained on the computer-readable medium may be transmitted by any suitable medium, including, but not limited to, electric wires, optical cables, RF (radio frequency), or any suitable combination thereof.

[0182] In some embodiments, the client and server may communicate using any currently known or future-to-be-developed network protocol such as HTTP (Hypertext Transfer Protocol), and may interconnect with digital data communications (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks ("LANs"), wide area networks ("WANs"), the World Wide Web (e.g., the Internet), end-to-end networks (e.g., ad hoc end-to-end networks), and any currently known or future-to-be-developed networks.

[0183] The computer-readable medium described above may be included in the electronic device described above, or it may be a standalone entity not incorporated into the electronic device.

[0184] The computer-readable medium contains one or more programs, and when these one or more programs are executed by the electronic device, the electronic device is instructed to execute the data processing method described above.

[0185] Computer program code for performing the operations of this application can be organized in one or more programming languages ​​or a combination thereof, and such programming languages ​​include, but are not limited to, object-oriented programming languages ​​such as Java, Smalltalk, and C++, and also include ordinary procedural programming languages ​​such as the C language or similar programming languages. The program code may run entirely on the user's computer, partially on the user's computer, run as a single standalone software package, run partially on the user's computer and partially on a remote computer, or run entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or it may be connected to an external computer (for example, connected via the Internet using an Internet service provider).

[0186] The flowcharts and block diagrams in the drawings illustrate the systematic architecture, functions, and operations that can be implemented according to the systems, methods, and computer program products of each embodiment of this application. In this regard, each block in the flowchart or block diagram may represent a module, program segment, or part of code, which contains one or more executable instructions for implementing a defined logic function. It should be noted that in some implementations as replacements, the functions described in the blocks may occur in a different order than those shown in the drawings. For example, two consecutively shown blocks may actually be executed almost in parallel, or in some cases in reverse order, depending on the function. It should also be noted that each block in the block diagram and / or flowchart, and combinations of blocks in the block diagram and / or flowchart, may be implemented by a dedicated hardware-based system that performs the defined function or operation, or by a combination of dedicated hardware and computer instructions.

[0187] The units mentioned in the description of the embodiments of this application may be implemented in software or in hardware. Herein, the name of the unit / module is not necessarily limited to the unit itself; for example, a voice data acquisition module may be described as a "data acquisition module."

[0188] The functions described above in this specification may be performed, at least in part, by one or more hardware logic components. For example, typical types of hardware logic components that can be used include, but are not limited to, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems on chips (SOCs), and composite programmable logic circuits (CPLDs).

[0189] In the context of this application, a machine-readable medium may be a tangible medium that contains or stores a program for use by or in combination with an instruction execution system, apparatus, or device. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A 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 above. More specific examples of machine-readable storage media include one or more wire-based electrical connections, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the above.

[0190] It should be noted that each embodiment in this specification is described in an incremental manner, each embodiment focuses on the differences from other embodiments, and any identical or similar parts between embodiments should refer to one another. For systems or apparatus disclosed in embodiments, the description should be simple to correspond to the methods disclosed in embodiments, and relevant parts should refer to parts of the description of the method section.

[0191] It should be understood that in this application, "at least one" means one or more, and "multiple" means two or more. "And / or" is used to describe the relationship between related objects and indicates that there may be three possible relationships. For example, "A and / or B" may represent three cases: A alone, B alone, and a combination of A and B, where A and B may be singular or plural. The letter " / " generally indicates that the related objects before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these objects, including any combination of single or multiple objects. For example, at least one of a, b, or c may represent a, b, c, "a and b", "a and c", "b and c", or "a, b, and c", where a, b, and c may be single or plural.

[0192] Furthermore, in this specification, relational terms such as "first" and "second," etc., are used solely to distinguish one entity or operation from another, and do not necessarily require or imply the existence of any such actual relationship or order between these entities or operations. The terms "include," "incorporate," or any other variations thereof are intended to cover non-exclusive "include," thereby meaning that a process, method, article, or apparatus containing a set of elements includes not only those elements but also other elements not explicitly listed, or further elements specific to such a process, method, article, or apparatus. Unless otherwise specified, an element limited by the phrase "includes one..." does not preclude the existence of other identical elements in a process, method, article, or apparatus containing such element.

[0193] The above description of the disclosed embodiments will enable those skilled in the art to implement or use the present application. Various modifications to these embodiments will be obvious to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of this application. Thus, this application is not limited to these embodiments shown herein, but rather conforms to the broadest extent that is consistent with the principles and novel features disclosed herein.

Claims

1. A data processing method, In response to receiving a trigger command in the table, the data processing assembly including the text input area is displayed, A data processing method comprising parsing target text received through the text input area into a target expression in response to a data processing command for the data processing assembly.

2. The method according to claim 1, wherein the target text includes an expression type description text, and the processing logic described in the expression type description text matches the processing logic of the target expression.

3. The method according to claim 2, further comprising displaying at least one of the target expression, illustrative information of the target expression, and descriptive information of the target expression in the data processing assembly, wherein the descriptive information of the target expression is used to introduce the processing logic of the target expression.

4. The target text further includes data range description text, which is used to describe a first data range. The method according to claim 2 or 3, further comprising executing the target expression on the data in the first data range and displaying the execution result in the table.

5. The target display area further includes the inserted assembly, The method according to claim 4, further comprising inserting the target expression into the target table in response to an expression insertion operation triggered via the insertion assembly.

6. The trigger command is triggered on the target cell in the table, and inserting the target expression into the target table is The method according to claim 5, comprising inserting the target formula into the target cell.

7. The above-mentioned parsing of the target text received via the text input area into a target expression is, Sending the target text to the target model, The method according to claim 1, comprising receiving a target expression analyzed by the target model based on the target text.

8. A data processing method used in a server of target software, wherein the target software has a table processing function. The acquisition of target text obtained by the client of the target software and sent to the server, Sending the target text to the target model, Receiving a target expression that matches the target text, which is fed back from the target model, A data processing method, which includes transmitting the target expression to the client.

9. After sending the target text to the target model, The process involves receiving instruction analysis information transmitted by the target model, wherein the instruction analysis information is obtained by semantic analysis of the target text. Based on the instruction analysis information, determine at least one intermediate expression, The method of claim 8, further comprising transmitting information of at least one intermediate expression to the target model, wherein the target expression is determined from a plurality of intermediate expressions.

10. The instruction parsing information includes a first vector, the first vector corresponds to the target text, Determining multiple intermediate equations based on the first analytical information is, Obtaining feature vectors from multiple candidate equations, The method according to claim 9, further comprising determining at least one intermediate expression from the plurality of candidate expressions based on the first vector and the feature vector of the candidate expression.

11. A data processing device, A display unit for displaying a data processing assembly, including a text input area, in response to receiving a trigger command in a table, The system includes a processing unit for parsing target text received via the text input area into a target expression in response to a data processing command for the data processing assembly, The display unit further comprises a data processing device used to display the target expression.

12. A data processing device used in a server for target software, wherein the target software has a table processing function, and the device is An acquisition unit for acquiring target text acquired by the client of the target software and transmitted to the server, A first transmission unit for sending the target text to the target model, A receiving unit for receiving a target expression that matches the target text, which is fed back from the target model, A data processing device comprising a second transmission unit for transmitting the target expression to the client.

13. It is an electronic device, One or more processors, Includes a memory device in which one or more programs are stored, An electronic device in which one or more of the aforementioned programs are executed by one or more processors to cause one or more processors to implement the method according to any one of claims 1 to 10.

14. A computer-readable medium having a computer program stored in it, wherein when the program is executed by a processor, the method according to any one of claims 1 to 10 is realized.

Images