Data processing method and apparatus, device, and storage medium

Abstract

The present application provides a data processing method and apparatus, a device, and a storage medium. Specifically, data can be first displayed to a user by means of a table. Then, the user can trigger a trigger instruction for the table. On the basis of the trigger instruction triggered by the user, a data processing component can be displayed. The data processing component comprises a text input area. The user can input a target text by means of the text input area. The target text is used for indicating a formula that the user wants to insert into the table. Once a data processing instruction for the data processing component is acquired, a corresponding target formula can be determined on the basis of the target text.

Description

Data processing method, device, equipment and storage medium

[0001] CROSS-REFERENCE TO RELATED APPLICATIONS

[0002] This application claims priority to the Chinese patent application filed on August 31, 2023, with application number 202311120124.9 and invention name “A data processing method, device, equipment and storage medium”. The entire contents of that application are incorporated by reference into this application. Technical Field

[0003] The present application relates to the field of computers, and in particular to a data processing method, apparatus, device, and storage medium. Background Art

[0004] With the development of computer technology, displaying data in tables has become a common technical means. By displaying data in tables, data with the same attributes can be displayed in the same row or column, making it easier for users to view.

[0005] Currently, users can process data by calling formulas. Among them, formulas are processing logic pre-deployed in software with table editing functions (hereinafter referred to as table-type software). Users can enter or select the corresponding formula and select the data corresponding to the formula from the table-type software. Then, the processing results obtained by processing the selected data through the processing logic can be displayed in the table-type software. Through formulas, complex processing can be performed on the data in the table-type software, improving the efficiency of table editing.

[0006] However, the formula function of current spreadsheet software is not convenient for users to use.

[0007] Summary of the Invention

[0008] In order to solve the problems of the prior art, the present application provides a data processing method, apparatus, device and storage medium.

[0009] Based on this, the technical solutions provided by this application are as follows:

[0010] In a first aspect, the present application provides a data processing method, the method comprising:

[0011] In response to receiving a trigger instruction in the form, displaying a data processing component, the data processing component including a text input area;

[0012] In response to the data processing instruction for the data processing component, the target text received through the text input area is parsed into a target formula and the target formula is displayed.

[0013] In some possible implementations, the target text includes a formula type description text, and the processing logic described in the formula type description text matches the processing logic of the target formula.

[0014] In some possible implementations, the method further includes:

[0015] At least one of the target formula, example information of the target formula, and description information of the target formula is displayed in the data processing component, where the description information of the target formula is used to introduce the processing logic of the target formula.

[0016] In some possible implementations, the target text further includes data range description text, where the data range description text is used to describe the first data range; and the method further includes:

[0017] The target formula is executed on the data in the first data range, and the execution result is displayed in the table.

[0018] In some possible implementations, the target display area further includes an insertion component; and the method further includes:

[0019] In response to a formula inserting operation triggered by the inserting component, the target formula is inserted into the target table.

[0020] In some possible implementations, the trigger instruction is triggered for a target cell in the table; and inserting the target formula into the target table includes:

[0021] Insert the target formula into the target cell.

[0022] In some possible implementations, parsing the target text received through the text input area into a target formula includes:

[0023] Sending the target text to the target model;

[0024] Receive a target formula parsed by the target model based on the target text.

[0025] In a second aspect, the present application provides a data processing method, which is applied to a server of a target software having a table processing function, and comprises:

[0026] Acquiring a target text, wherein the target text is acquired by a client of the target software and sent to the server;

[0027] Sending the target text to the target model;

[0028] receiving a target formula fed back by the target model, wherein the target formula matches the target text;

[0029] The target formula is sent to the client.

[0030] In some possible implementations, after sending the target text to the target model, the method further includes:

[0031] Receiving instruction parsing information sent by the target model, where the instruction parsing information is obtained by semantically parsing the target text;

[0032] Determine at least one intermediate formula according to the instruction parsing information;

[0033] Information of the at least one intermediate formula is sent to the target model, where the target formula is determined from the plurality of intermediate formulas.

[0034] In some possible implementations, the instruction parsing information includes a first vector, where the first vector corresponds to the target text;

[0035] Determining a plurality of intermediate formulas according to the first parsing information includes:

[0036] Obtaining feature vectors of multiple candidate formulas;

[0037] At least one intermediate formula is determined from the plurality of candidate formulas according to the first vector and the feature vectors of the candidate formulas.

[0038] In a third aspect, the present application provides a data processing device, comprising: a display unit for displaying a data processing component in response to receiving a trigger instruction in a table, wherein the data processing component includes a text input area; and a processing unit for parsing a target text received through the text input area into a target formula in response to a data processing instruction for the data processing component.

[0039] In some possible implementations, the target text includes a formula type description text, and the processing logic described in the formula type description text matches the processing logic of the target formula.

[0040] In some possible implementations, the display unit is specifically used to display at least one of the target formula, example information of the target formula, and description information of the target formula in the data processing component, and the description information of the target formula is used to introduce the processing logic of the target formula.

[0041] In some possible implementations, the target text also includes a data range description text, and the data range description text is used to describe the first data range; the processing unit is also used to execute the target formula on the data in the first data range and display the execution results in the table.

[0042] In some possible implementations, the target display area further includes an insertion component; the display unit is specifically configured to insert the target formula into the target table in response to a formula insertion operation triggered by the insertion component.

[0043] In some possible implementations, the trigger instruction is triggered for a target cell in the table; and the display unit is specifically configured to insert the target formula into the target cell.

[0044] In some possible implementations, the device further includes a sending unit and an acquiring unit, wherein the sending unit is configured to send the target text to the target model; and the receiving unit is configured to receive a target formula parsed by the target model based on the target text.

[0045] In a fourth aspect, the present application provides a data processing device, which is applied to a server side of a target software, and the target software has a table processing function. The device includes: an acquisition unit, used to acquire a target text, and the target text is acquired by a client side of the target software and sent to the server side; a first sending unit, used to send the target text to a target model; a receiving unit, used to receive a target formula fed back by the target model, and the target formula matches the target text; and a second sending unit, used to send the target formula to the client.

[0046] In some possible implementations, the device also includes a processing unit; the receiving unit is further used to receive instruction parsing information sent by the target model, and the instruction parsing information is obtained by semantically parsing the target text; the processing unit is used to determine at least one intermediate formula based on the instruction parsing information; the first sending unit is further used to send information of the at least one intermediate formula to the target model, and the target formula is determined from the multiple intermediate formulas.

[0047] In some possible implementations, the instruction parsing information includes a first vector, which corresponds to the target text; the processing unit is specifically used to obtain feature vectors of multiple candidate formulas; and determine at least one intermediate formula from the multiple candidate formulas based on the first vector and the feature vectors of the candidate formulas.

[0048] In a fifth aspect, the present application provides an electronic device, including:

[0049] one or more processors;

[0050] a storage device having one or more programs stored thereon,

[0051] When the one or more programs are executed by the one or more processors, the one or more processors implement any of the methods described in the first aspect, or implement any of the methods described in the second aspect.

[0052] In a sixth aspect, the present application provides a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the program implements any of the methods described in the first aspect, or implements any of the methods described in the second aspect.

[0053] In a seventh aspect, the present application provides a computer program product, which, when running on a device, enables the device to execute the method described in the first aspect, or execute the method described in the second aspect. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments recorded in this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0055] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments recorded in this application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0056] FIG1 is a schematic diagram of an application scenario provided by an embodiment of the present application;

[0057] FIG2 is a flow chart of a data processing method provided in an embodiment of the present application;

[0058] FIG3 is a schematic diagram of an exemplary application scenario provided in an embodiment of the present application;

[0059] FIG4 is a flow chart of a data processing method provided in an embodiment of the present application;

[0060] FIG5 is an interactive diagram of a data processing method provided in an embodiment of the present application;

[0061] FIG6 is a schematic diagram of a data processing device provided in an embodiment of the present application;

[0062] FIG7 is a schematic diagram of a data processing device provided in an embodiment of the present application;

[0063] FIG8 is a schematic diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0064] The following describes embodiments of the present application in more detail with reference to the accompanying drawings. Although certain embodiments of the present application are shown in the accompanying drawings, it should be understood that the present application can be implemented in various forms and should not be construed as being limited to the embodiments described herein. Instead, these embodiments are provided to provide a more thorough and complete understanding of the present application. It should be understood that the drawings and embodiments of the present application are for illustrative purposes only and are not intended to limit the scope of protection of the present application.

[0065] It should be understood that the various steps described in the method embodiments of the present application can be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present application is not limited in this respect.

[0066] As used herein, the term "including" and its variations are open-ended, i.e., "including but not limited to." The term "based on" means "based, at least in part, on." The term "one embodiment" means "at least one embodiment," the term "another embodiment" means "at least one additional embodiment," and the term "some embodiments" means "at least some embodiments." Other terms are defined in the following description.

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

[0068] It should be noted that the modifications of "one" and "multiple" mentioned in this application are illustrative rather than restrictive. Those skilled in the art should understand that unless otherwise clearly indicated in the context, they should be understood as "one or more".

[0069] Data processing using spreadsheets is convenient and fast. Currently, more and more users are choosing to process data using spreadsheets. Consequently, many applications offer data processing capabilities using spreadsheets. This functionality can be referred to as spreadsheet processing. Software with spreadsheet processing capabilities can be referred to as spreadsheet software. For example, to facilitate data processing, spreadsheet processing functionality can be integrated into instant messaging (IM) software. Accordingly, IM software that inherits this functionality can be referred to as spreadsheet software.

[0070] When processing data using spreadsheets, users may need to perform calculations, conversions, and analyses on the data. To facilitate this, spreadsheet software offers a formula insertion feature. This feature allows users to insert formulas into a spreadsheet. A formula is a calculation logic pre-set within the spreadsheet software. By inserting a formula, data can be processed according to that calculation logic.

[0071] Next, the user can select or enter the data corresponding to the formula so that the data can be processed according to the processing logic corresponding to the formula. Finally, the processed data can be displayed in a table. In other words, the user can use the preset processing logic by inserting the formula. In this way, the preset processing logic is presented in the form of a formula, and the user can process the data by calling the formula, which improves the efficiency of data processing.

[0072] The more formulas there are, the more pre-set processing logic a spreadsheet application has. Consequently, when users use spreadsheet applications to process data, they are more likely to invoke pre-set processing logic by inserting formulas. For this reason, current spreadsheet applications often come pre-deployed with a large number of formulas to meet the diverse needs of different users.

[0073] However, in actual application scenarios, users may not have a sufficient understanding of spreadsheet software and are not aware of the built-in formulas. Therefore, even if one (or more) steps in the data processing process can be completed by calling formulas, due to insufficient understanding of the built-in formulas, users cannot improve data processing efficiency by calling formulas.

[0074] For example, suppose spreadsheet software A has a built-in formula B, which performs a summation operation. After entering formula B, the user can select the data to be summed. Spreadsheet software A automatically sums the data based on formula B. This eliminates the need for the user to manually enter each data point and the addition operator, reducing user input and improving processing efficiency.

[0075] However, if the user is not familiar with formula B and does not know that it can perform addition operations, then the user cannot quickly sum the data using formula B. Thus, even if spreadsheet selection software A has a built-in formula B for summation, it will not improve the user's summation efficiency.

[0076] In order to solve the problems of the prior art, the embodiment of the present application provides a data processing method, which is described in detail below in conjunction with the drawings in the specification. The present application has the following beneficial effects: the present application provides a data processing method, apparatus, device and storage medium. Specifically, first, data can be displayed to the user through a table. Then, the user can trigger a trigger instruction for the table. According to the trigger instruction triggered by the user, the data processing component can be displayed. The data processing component includes a text input area. The user can enter the target text through the text input area. The target text is used to indicate the formula that the user wants to insert into the table. After obtaining the data processing instruction for the data processing component, the corresponding target formula can be determined according to the target text. That is to say, if the user needs to insert a formula into the table, the user can first trigger the trigger instruction, then enter the target text in the text input area, and then trigger the data processing instruction to display the target formula corresponding to the target text. In this way, the automatic input of the formula can be achieved without the user knowing the specific formula, which lowers the usage threshold and improves the user experience.

[0077] First, an exemplary application scenario of an embodiment of the present application is introduced. Referring to FIG. 1 , this figure is a schematic diagram of the framework of an exemplary application scenario provided by an embodiment of the present application. The implementation shown in FIG. 1 includes a client 110, a server 120, and a target model 130. 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.

[0078] The client 110 may be run on a terminal device used by a user, such as a mobile phone, computer, or other terminal device. The server 120 may be run on a server or server cluster to provide services for the client 110. Data can be exchanged between the client 110 and the server 120.

[0079] The target model 130 can run on a server or a server cluster. Optionally, the server (or server cluster) used to implement the model method 130 and the server (or server cluster) used to implement the server 120 can be the same or different. The target model 130 is used to provide target model services to the outside world. For example, a target model can be running in the target model 130. The server 120 can send data to be processed to the target model 130, and the target model 130 can process the data to be processed through the target model and send the processed data to the server 120. Optionally, the above-mentioned target model can be a language model (LM) or a large language model (LLM).

[0080] The above introduces the exemplary application scenarios of the embodiments of the present application. The following is an exemplary introduction to the data processing method provided by the embodiments of the present application.

[0081] Referring to Figure 2, Figure 2 is a flow chart of a data processing method provided in an embodiment of the present application. This embodiment of the present application is applicable to application scenarios where data is processed through tables. The data processing method can be executed by a data processing device, and the data processing determination device can be implemented by software.

[0082] It should be noted that the data processing device in the embodiment corresponding to FIG1 may be different from the data processing device in the embodiment corresponding to FIG2. For example, the data processing device in the embodiment corresponding to FIG4 may run on the server side of spreadsheet software, while the data processing device in the embodiment corresponding to FIG2 may run on the client side of spreadsheet software.

[0083] Optionally, the data processing device can be integrated into the client of the table-type software. The client of the software runs on the terminal device used by the user, such as a mobile phone or a computer. The client can be an application client or a web client of the table-type software. The server of the software can run on a server or a server cluster to provide corresponding services for the client of the software. Optionally, the table-type software can be an instant messaging (IM) software with a table function. If the data processing device is integrated into the client, the data processing device can communicate with the server to use the target model through the server. Optionally, in the application scenario shown in Figure 1, the data processing device can be integrated into the client 110. For ease of introduction, the following description will be given by taking the data processing device integrated into the client as an example.

[0084] As shown in FIG2 , the method specifically includes the following steps:

[0085] S201: In response to receiving a trigger instruction in a table, displaying a data processing component.

[0086] In an embodiment of the present application, a data processing device can receive a trigger instruction triggered by a user and display a data processing component based on the trigger instruction. The table is a table displayed by a client of spreadsheet software. The trigger instruction is an instruction triggered by the user within the table. The data processing component includes a text input area. The text input area is used to receive text input by the user.

[0087] In an embodiment of the present application, a data processing component may be displayed based on a user operation. This operation corresponds to a trigger instruction. Specifically, before receiving the trigger instruction, the data processing component may be hidden. After receiving the trigger instruction, the data processing component may be displayed. The operation corresponding to the trigger instruction may include a first operation. The first operation may include pressing a preset shortcut key, clicking a preset control, or issuing a voice command. The embodiment of the present application does not limit the first operation.

[0088] Optionally, the trigger instruction may be directed to the table displayed by the client, or to a portion of the data in the table. For example, in some possible implementations, the trigger instruction may be directed to a first data range in the table. The first data range corresponds to a portion of or all of the data in the table. For ease of explanation, the data corresponding to the first data range is referred to herein as first data.

[0089] Optionally, the first data range may correspond to a cell in a table. Specifically, a user may select a cell in the table and trigger a trigger instruction in that cell. Accordingly, the target formula inserted into the table described below may be inserted into this cell. For ease of description, the cell into which the target formula is inserted may be referred to as the target cell. In other words, the trigger instruction may be triggered by the user on the target cell.

[0090] Accordingly, the operation corresponding to the trigger instruction may further include an operation for determining the first data range. The operation for determining the first data range may be referred to as a second operation. Optionally, the second operation may include, for example, a box selection operation. The user may select the data to be processed through the box selection operation to obtain the first data range.

[0091] Optionally, the second operation can be triggered before the first operation. That is, to trigger the trigger instruction, the user can first trigger the second operation and select the first data range corresponding to the target data to be processed in the table. Then, the user can trigger the first operation to call up the hidden data processing component.

[0092] That is, if a user wants to use a formula to process data, the user can trigger a first operation. After receiving the first operation triggered by the user, a data processing component can be displayed to the user. The data processing component includes a text input area. After the data processing component is displayed, the user can enter the target text in the text input area.

[0093] Optionally, the data processing component may further include prompt information. The prompt information may correspond to the text input area and be used to prompt the user to process the data in the table by inputting text information in the text input area.

[0094] Optionally, the data processing component may further include a data processing control. The data processing control is used to trigger a third operation. The third operation corresponds to the data processing instruction. A description of the third operation and the data processing instruction is provided below and is not repeated here.

[0095] In some possible implementations, a formula corresponding to the target text can be determined using a model. The model can be a model with natural language processing (NLP) capabilities, such as a language model or a large language model. Optionally, the data processing component can correspond to a cloud service corresponding to the model. For ease of description, the cloud service can be referred to as a first cloud service.

[0096] That is, a user can call the first cloud service to process data in a first data range in a table using target text. Accordingly, the data processing device can be a software module on the client that implements the first cloud service. The data processing component can be a display area corresponding to the first cloud service. The data processing device can determine the formula that the user wants to enter into the table by calling the server side of the first cloud service.

[0097] In this way, the first operation can be an operation of using the first cloud service. For example, the user can first trigger the second operation to determine the display range of the first data, then trigger the right-click operation to call up the menu, and then trigger the left-click operation on the operation control corresponding to the first cloud service in the menu.

[0098] In the above implementation, the data processing component is displayed based on a trigger instruction. In some other possible implementations, the data processing component can also be deployed in a specific area of ​​the client interface of the spreadsheet software, for example, it can be deployed in the menu bar of the client interface. Accordingly, if the user wants to insert a formula in the spreadsheet, the user can switch the text input cursor to the data processing component and enter the target text through the text input area of ​​the data processing component.

[0099] After the data processing component is presented to the user, the user can enter target text in the text input area to trigger the data processing instruction. The target text is used to indicate the formula that the user wants to insert into the table, and the data processing instruction is used to start the process of determining the formula based on the target text.

[0100] In an embodiment of the present application, the target formula is determined based on the target text. Accordingly, the target text may include relevant information indicating the target formula. Optionally, the target text may include a formula type description text, which is used to describe the target formula. Specifically, the processing logic described in the formula type description text is the same as the processing logic of the target formula.

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

[0102] Optionally, in some other possible implementations, the target text may further include a data range description text, which is used to describe the data range to be processed by the target formula. For an introduction to the data range description text, please refer to the following and will not be repeated here.

[0103] Optionally, the user can trigger a third operation to obtain the data processing instruction. The third operation may, for example, include a single-click operation triggered by the user on the data processing control. That is, after completing the input of the target text, the user can trigger the third operation. Accordingly, the data processing device can obtain the data processing instruction based on the third operation and execute step S202 described below.

[0104] S202: In response to the data processing instruction for the data processing component, the target text received through the text input area is parsed into a target formula

[0105] After receiving the data processing instruction triggered by the user, the data processing device can determine the formula that the user wants to insert into the table based on the target text received in the text input area. Optionally, the formula parsed based on the target text can be called the target formula.

[0106] In some possible implementations, the target text input by the user may be clear enough. Accordingly, a complete target formula can be determined based on the target text. Alternatively, in some other possible implementations, the target text input by the user may not be sufficient to determine a complete target formula. Then, example information of the target formula and / or description information of the target formula can be determined based on the target text. That is, parsing the target text into a target formula may include parsing the target text into example information of the target formula and / or description information of the target formula. Among them, the complete target formula includes a formula that can be directly used for data processing. The introduction of the example information of the target formula and the description information of the target formula can be found below and will not be repeated here.

[0107] Optionally, the data processing device can send data processing instructions and the target text to the server, so that the server can determine the target formula based on the target text. After the server determines the target formula, the client can receive the target formula sent by the server. Optionally, the server can parse the target text using a model to determine the user's intent, thereby obtaining the target formula. This section is described below and will not be repeated here.

[0108] After determining the target formula, the data processing device may display the target formula to the user and / or process the data in the table according to the target formula.

[0109] First, let's introduce how to display the target formula.

[0110] In some possible implementations, the data processing device may display the target formula in a cell within a table. Specifically, the data processing device may insert the target formula into a cell within the table. Optionally, the cell into which the formula is inserted may be a cell selected by the user, a pre-set cell, or a randomly selected cell.

[0111] For example, if a user wants to insert formula B into cell A in a table, the user can first select the cell by clicking on cell A, for example. The user can then trigger the first and third operations described above, enter the target text in the text input area, and then trigger the third operation. Accordingly, based on the data processing instruction corresponding to the third operation, the target formula corresponding to the target text, i.e., formula B, can be determined. The data processing device can then insert formula B into cell A and display formula B at the location corresponding to cell A.

[0112] Alternatively, in some other possible implementations, the target formula may be displayed in a preset display area. For example, as previously described, the target text is input by the user in a text input area in the data processing component. Accordingly, after determining the target formula corresponding to the target text, the target formula may be displayed in the data processing component.

[0113] Specifically, the data display component may include a target display area. After determining the target formula, the target formula may be displayed in the target display area. The target display area is a relevant area in the data display component for displaying the target formula. Optionally, before displaying the target formula, the target display area may be in a hidden state and / or a collapsed state.

[0114] As described above, parsing the target text into a target formula may include parsing the target text into example information of the target formula and / or description information of the target formula. Accordingly, displaying the target formula may include displaying the target formula or at least one of the following: displaying the target formula, displaying example information of the target formula, and displaying description information of the target formula. This is described in detail below.

[0115] The example information of the target formula is used to indicate the basic form of the target formula. Based on the example information of the target formula, the user can determine the logical structure of the target formula and the various input parameters in the target formula. For example, the input parameters in the target formula can be replaced with the example information of the input parameters to obtain the example information of the target formula. The example information of the input parameters is a typical input parameter. Based on the example information of the input parameters, the data type of the input parameters can be determined. In this way, based on the example information of the target formula, the user can understand the input parameters of the target formula and the basic information of each input parameter, so that the user can use the target formula to process the target data.

[0116] The target formula's description is used to introduce the target formula. Optionally, the target formula's description can be used to describe the target formula's purpose and / or the processing logic corresponding to the target formula. Thus, based on the target formula's description, the user can determine whether the target formula meets the requirements for processing the target data.

[0117] Alternatively, the target formula description information may include information about each input parameter in the target formula. The input parameter description information may describe the meaning of the input parameter and the range of values ​​the input parameter can take. Thus, based on the target formula description information, the user can determine which data to enter into the target formula and the specific format of the input data.

[0118] In this way, based on the example information and description information of the target formula, the user can understand the target formula and thereby determine whether the target data can be processed through the target formula, and what data needs to be input into the target formula when processing the target data through the target formula.

[0119] As described above, the target formula, example information of the target formula, and description information of the target formula can be displayed in the target display area of ​​the data component. In order to distinguish the different contents displayed in the target display area, the target formula, example information of the target formula, and description information of the target formula (if any) can be displayed in different ways.

[0120] For example, the target formula, example information of the target formula, and description information of the target formula (if any) may be displayed in different sub-areas of the target display area in different display modes.

[0121] That is to say, the target formula can be displayed in the first sub-area of ​​the target display area through the first display method, the example information of the target formula can be displayed in the second sub-area of ​​the target display area through the second display method, and the descriptive information of the target formula can be displayed in the third sub-area of ​​the target display area through the third display method.

[0122] Optionally, the target formula, example information of the target formula, and description information of the target formula (if any) can be distinguished by different background colors. Alternatively, the example information of the target formula and description information of the target formula can be distinguished by different fonts, font sizes, etc. Alternatively, a separator can be added between the first sub-area, the second sub-area, and the third sub-area to prompt the user that the first sub-area, the second sub-area, and the third sub-area are different display areas and display different contents.

[0123] Optionally, since the target formula and the example information of the target formula have similar functions, the first sub-region and the second sub-region may be the same display region, and the first display mode and the second display mode may also be the same display mode.

[0124] In the implementation described above, the target formula and related information can be displayed in the target display area. However, the user's fundamental purpose is not to view the target formula or related information, but to process the target data using the target formula. Accordingly, to meet the data processing requirements, the user also needs to insert the target data into the target cell.

[0125] In some possible implementations, the information displayed in the target display area is in a copyable state. Accordingly, the user can select the target formula (or example information of the target formula) from the target display area and copy it, and then paste the copied target formula (or example information of the target formula) into the target cell.

[0126] Although the above implementation can add the target formula to the target cell in the table, it requires the user to manually select, copy and paste, which is cumbersome and has a poor user experience. Therefore, in some possible implementations, the data processing device can automatically insert the target formula into the table.

[0127] Specifically, the user can trigger a fourth operation. After receiving the fourth operation, the data processing device can insert the target formula into the table. The fourth operation can be triggered by an insert control. The insert control can be a control displayed in the target display area. In other words, the user can first view the target formula information displayed in the target display area. After confirming that the target formula is correct, the target formula can be inserted into the table by triggering the insert control.

[0128] When displaying data in a table, the data can be filled in the cells of the table. Accordingly, when inserting a target formula into a table, the target formula can be inserted into a specific cell. The specific cell for inserting the target formula can be referred to as the target cell. Optionally, the target cell can be a pre-set cell in the target table. Alternatively, the target cell can be the cell corresponding to the first operation. That is, if the user triggers the first operation for cell A in the target table, then after obtaining the fourth operation, the target formula can be inserted into cell A.

[0129] The following describes a method for displaying the target formula in conjunction with actual application scenarios. Referring to FIG3 , after determining the first information, the screen displayed by the client may include an interface as shown in FIG3 . The interface shown in FIG3 includes a table display area 310 and a data processing component 320 . The table display area 310 is used to display the table and the data in the table, and the data processing component 320 is used to display the relevant information of the target formula. The data processing component 320 corresponds to the aforementioned data processing component

[0130] Table display area 310 includes cell 311. A user can trigger a first operation on cell 311, causing the client to display a data processing component to the user. The user can then enter target text through the data processing component and trigger a third operation. After receiving the third operation triggered by the user, a target formula can be determined and displayed through data processing component 320.

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

[0132] Among them, display area 321 corresponds to the aforementioned target display area, including display sub-area 321-1 and display sub-area 321-2. Display sub-area 321-1 corresponds to the aforementioned first display area and is used to display example information of the target formula. Display sub-area 321-2 corresponds to the aforementioned third display area and is used to display description information of the target formula. In the implementation corresponding to Figure 3, the background colors of display sub-area 321-1 and display sub-area 321-2 are different to distinguish the target formula from the example information of the target formula.

[0133] Display area 322 is used to display a text input box. Optionally, the text input box can be used to enter target text, i.e., the aforementioned target text input area. Sub-display area 322 can include prompt information 322-1. Prompt information 322-1 is used to prompt the user that sub-display area 322 includes a text input area.

[0134] The operation control 323 is used to trigger the fourth operation. The user can trigger the fourth operation by clicking the operation control 323. After obtaining the click operation triggered by the user on the operation control 323, the target formula can be inserted into the cell 311.

[0135] The operation control 324 is used to trigger a reset operation. After the reset operation is obtained, the content displayed in the data processing component 320 can be cleared.

[0136] The above describes how to display the target formula. The following describes how to process the data in the table based on the target formula.

[0137] In an embodiment of the present application, a target formula can be determined based on a target text input by a user. Optionally, if the target text input by the user contains sufficient information to determine the data to be processed based on the target text, then after the target formula is determined, the data to be processed can be processed using the target formula.

[0138] 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 of the data to be processed in the table. Thus, after determining the target formula and the first data range, the target formula can be executed on the data in the first data range, and the execution results of the target formula can be displayed in the table. Optionally, the execution results can be displayed in the target cell.

[0139] The present application provides a data processing method. Specifically, first, data can be displayed to the user through a table. Then, the user can trigger a trigger instruction for the table. According to the trigger instruction triggered by the user, the data processing component can be displayed. The data processing component includes a text input area. The user can enter the target text through the text input area. The target text is used to indicate the formula that the user wants to insert into the table. After obtaining the data processing instruction for the data processing component, the corresponding target formula can be determined according to the target text. That is to say, if the user needs to insert a formula into the table, the user can first trigger the trigger instruction, then enter the target text in the text input area, and then trigger the data processing instruction to display the target formula corresponding to the target text. In this way, the automatic input of the formula can be achieved without the user understanding the specific formula, which lowers the usage threshold and improves the user experience.

[0140] The above describes the relevant contents of the data processing device in the client in the data processing method provided by the embodiment of the present application. In some possible implementations, the target text can be processed by a model.

[0141] 4 , an exemplary introduction to the data processing method provided in the embodiment of the present application will be given from the perspective of the server of the spreadsheet software.

[0142] 4 is a flow chart of a data processing method provided by an embodiment of the present application, which is applicable to application scenarios where formulas are inserted into tables. The data processing method can be executed by a data processing device running on a server.

[0143] It should be noted that the data processing device in the embodiment corresponding to FIG4 may be a different device from the data processing device in the embodiment corresponding to FIG2. For example, the data processing device in the embodiment corresponding to FIG4 may run on the server side of spreadsheet software, while the data processing device in the embodiment corresponding to FIG2 may run on the client side of spreadsheet software.

[0144] The data processing device can be implemented by software. Optionally, the device can include a model for processing the target request data based on the sample data, or the device can be associated with a model for processing the target request data based on the sample data. Optionally, the above-mentioned model can include, for example, a LM model or an LLM model. In the embodiments of the present application, the model can be referred to as a target model.

[0145] Optionally, the data processing device can be integrated into the server side of spreadsheet software. The server side of spreadsheet software can run on a server or server cluster to provide corresponding services to the client side of the software. If the data processing device is integrated into the server side, it can communicate with the client side to obtain the target request data to be processed sent by the client side. Optionally, the data processing device can also communicate with the target model to send sample data and target request data to the target model. For ease of description, the following description uses the example of the data processing device being integrated into the server side.

[0146] As shown in FIG4 , the method specifically includes the following steps:

[0147] S401: Obtain target text.

[0148] To determine the formula a user wants to insert into a spreadsheet, the user can invoke a data processing component on the spreadsheet software client and enter the target text into the data processing component's text input box. Based on the data processing instructions directed to the data processing component, the spreadsheet software client can send the target text to the spreadsheet software server. In response, the data processing device running on the spreadsheet software server can retrieve the target text.

[0149] S402: Send the target text to the target model.

[0150] After acquiring 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 a semantic parsing function, such as a LM or LLM. Accordingly, the target text is a natural language text, and the target formula parsed from the target text may be implemented based on a structured language. For example, the target formula may be implemented based on the JavaScript Object Notation (JSON) language.

[0151] Accordingly, the data processing device may send a prompt message to the target model. The prompt message may include the target text and other information. For a detailed description of determining the target formula through the target model, please refer to the description of the corresponding embodiment of Figure 5 below. No further details will be given here.

[0152] S403: Receive the target formula fed back by the target model.

[0153] After obtaining the target text, the target model can parse the target text to determine the corresponding target formula.

[0154] Optionally, the target model may also send relevant information about the target formula to the server, such as example information about the target formula and / or description information about the target formula. Alternatively, the relevant information about the target formula may be pre-stored on the server. After obtaining the target formula fed back by the target model, the server may query relevant information about the target formula based on the target formula, thereby displaying the target formula and relevant information about the target formula to the user.

[0155] As described above, the formula can be the calculation logic pre-set in the spreadsheet software. Accordingly, the target formula can be a formula that can be recognized by the spreadsheet software.

[0156] S404: Send the target formula to the client.

[0157] After determining the target formula corresponding to the target text through the target model, the data processing device can send the target formula to the client so that the client can display the target formula to the user.

[0158] In the implementation described above, the target formula can be determined by the target model based on the target text. The following uses the implementation shown in FIG1 as an example to describe a method for determining the target formula using the target model.

[0159] In some possible implementations, the client 110 may send the target text to the target model via the server 120. The target model 130 may parse the target text to determine the user's intent, thereby determining the corresponding target formula, and then send relevant information about the target formula to the client 110 via the server 120.

[0160] Alternatively, if target model 130 is a model with contextual learning capabilities, such as LM or LLM, target model 130 may first perform contextual learning on information related to the formula function, and then process the target text based on the results of the contextual learning. In this way, by performing contextual learning on information related to the formula function, the target formula determined by target model 130 is more closely aligned with the user's intent.

[0161] Optionally, information related to the formula function can be pre-organized and stored. When the target model is required to determine the target formula, the server 120 can obtain information related to the formula function and send the information related to the formula function to the target model 130 via prompt information, so that the target model 130 can perform context learning based on the information related to the formula function.

[0162] As described above, the target formula can correspond to the formula function provided by spreadsheet software. Based on the target formula, the processing logic provided by the spreadsheet software can be called to process the data. Therefore, in the process of determining the target formula, the relevant information used for context learning may include information about the formula function provided by the spreadsheet software. For example, it may include documentation corresponding to the spreadsheet software that describes the formula function provided by the spreadsheet software.

[0163] In actual scenarios, spreadsheet software may provide multiple formula functions. Accordingly, if the number of formula functions is large and the amount of data that can be carried by prompt information is limited, the prompt information may not be able to fully carry the relevant information of all formula functions in the spreadsheet software. As a result, the target model 130 cannot fully learn the relevant information of the formula functions of the spreadsheet software in the context and may not be able to accurately determine the target formula.

[0164] Therefore, in some possible implementations, multiple recognitions may be performed using the target model 130. This will be described in detail below with reference to FIG5.

[0165] Referring to FIG5 , FIG5 is a flow chart of a method for determining a target formula provided by an embodiment of the present application. The embodiment of the present application is applicable to the network architecture shown in FIG1 , and determines the application scenario of the formula corresponding to the target text through the target model 130. The target model 130 is a model with semantic recognition capabilities, and the target model 130 can perform context learning. For example, the target model 130 can include a LM model or an LLM model.

[0166] As shown in FIG5 , the method specifically includes the following steps:

[0167] S501: The client 110 sends a target text to the server 120.

[0168] For an introduction to the target text, please refer to the previous article and will not be repeated here.

[0169] S502: The server 120 sends the target text to the target model 130.

[0170] After acquiring the target text sent by the client 110, the server 120 may send the target text to the target model 130. Optionally, the server 120 may send the target text to the target model 130 via a first prompt message.

[0171] It should be noted that, before step S405 , the target model 130 may not have performed context learning on the target text and does not have the ability to determine the target formula according to the target text.

[0172] S503: The target model 130 determines instruction parsing information according to the target text.

[0173] After acquiring the target text, target model 130 can perform semantic parsing on the target text to determine the instruction parsing information corresponding to the target text. Optionally, the first prompt information can include relevant information for semantic parsing, allowing target model 130 to perform context learning. In this way, target model 130 first performs context learning and then parses the target text, accurately determining the instruction parsing information.

[0174] In the embodiment of the present application, the instruction parsing information may be a vector. That is, the target model 130 may vectorize (embedding) the target text. For ease of introduction, the vector corresponding to the instruction parsing information may be referred to as a first vector.

[0175] S504 : The target model 130 sends instruction parsing information to the server 120 .

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

[0177] S505: The server 120 determines at least one intermediate formula according to the instruction parsing information.

[0178] After obtaining the instruction parsing information, the server 120 may determine at least one intermediate formula based on the instruction parsing information, wherein the intermediate formula has a higher degree of similarity to the target formula than the non-intermediate formula has to the target formula.

[0179] In an embodiment of the present application, the intermediate formula is determined based on the formula function provided by the spreadsheet software. The intermediate formula can be used to call the formula function. In other words, the intermediate formula is a formula that the spreadsheet software can provide. In addition, the description information corresponding to the intermediate formula matches the instruction parsing information. In other words, if the formula that the client 110 can provide is used as a candidate formula, the server 120 can select a target formula that matches the instruction parsing information from multiple candidate formulas.

[0180] Specifically, a plurality of candidate formulas may be predetermined. Among the candidate formulas, the intermediate formula is a formula function that can be provided by spreadsheet software. Moreover, the description information corresponding to the intermediate formula matches the instruction parsing information. That is to say, if the formula that can be provided by the client 110 is taken as a candidate formula, the server 120 can select an intermediate formula that matches the instruction parsing information from a plurality of candidate formulas. In this embodiment, the intermediate formula may be determined based on the feature vector of the candidate formula. For example, the intermediate formula may be determined based on the similarity between the feature vector of the candidate formula and the vector corresponding to the instruction parsing information.

[0181] Optionally, the feature vector of the candidate formula can be obtained by vectorizing the description information of the candidate formula. The description information of the candidate formula is the relevant information used to describe the candidate formula. For example, it may include information such as the role of the candidate formula, the function corresponding to the candidate formula, and the relevant parameters required by the candidate formula. Optionally, the description information of the formula can be determined by the introduction information of the spreadsheet software. The introduction information of the spreadsheet software may include, for example, the instruction manual or user manual of the spreadsheet software.

[0182] In practical applications, the description information of the candidate formulas can be vectorized in advance to obtain the feature vector of each candidate formula. The feature vectors of the candidate formulas can then be stored in a database 140 (not shown). After obtaining the instruction parsing information, the feature vectors of the candidate formulas can be obtained from the database.

[0183] Next, the similarity between the first vector and the eigenvector of each candidate formula may be calculated, for example, the cosine similarity and double dot product (ddot) between the first vector and the eigenvector of the candidate formula may be calculated, and then at least one intermediate formula may be determined based on the calculation results.

[0184] S506 : The server 120 sends information of at least one intermediate formula to the target model 130 .

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

[0186] Specifically, the server 120 may generate a second prompt message and then send the second prompt message to the target model 130. The second prompt message may include information about the intermediate formula. Optionally, the second prompt message may also include target text or instruction parsing information.

[0187] Before generating the second prompt message, one or more judgments may be performed. For example, the judgment may include whether the target text is unrelated to the formula function of the spreadsheet software, whether the number of tokens included in the second prompt message exceeds a preset threshold, and whether the correlation between the intermediate formula and the target text is reasonable. After the judgment is passed, the corresponding second prompt message may be generated.

[0188] S507: The target model 130 performs context learning on information of at least one intermediate formula and determines a target formula.

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

[0190] S408 : The target model 130 sends information of the target formula to the client 110 via the server 120 .

[0191] After determining the target formula information, the target model 130 may send the target formula information to the client 110 via the server 120. Accordingly, the data processing device may obtain the target formula information and display it.

[0192] That is to say, if the formula has too much relevant information and cannot be carried by the prompt information, the target model 130 can first perform a preliminary analysis of the target text to determine the instruction parsing information corresponding to the target text. Then, the server 120 can perform a preliminary screening of the candidate formulas based on the instruction parsing information to find the information of the intermediate formulas with a high degree of relevance to the instruction parsing information. In this way, through the screening by the server 120, formulas that are not related to the target text can be filtered out, and intermediate formulas with a high degree of relevance to the target text can be screened out. Since the number of intermediate formulas is less than the number of candidate formulas, the prompt information can carry the relevant information of the intermediate formulas. Moreover, since the information of the intermediate formulas is screened based on the instruction parsing information, the degree of relevance between the intermediate formulas and the target formula is higher than the degree of relevance between the non-intermediate formulas and the target formula, the accuracy of the target model 130 will not be affected by the context learning based on the information of the intermediate formulas. In this way, the data volume of the prompt information is reduced while ensuring the accuracy of the target formula.

[0193] Based on the data processing method provided in the above method embodiment, the present application embodiment further provides two data processing devices, which respectively run on the client and server of the spreadsheet software. The data processing devices will be described below with reference to the accompanying drawings.

[0194] Referring to FIG6 , which is a schematic diagram of the structure of a data processing device running on a client of a spreadsheet software according to an embodiment of the present application, the data processing device 600 includes:

[0195] A display unit 610 is configured to display a data processing component in response to receiving a trigger instruction in a form, wherein the data processing component includes a text input area;

[0196] The processing unit 620 is configured to parse the target text received through the text input area into a target formula in response to the data processing instruction for the data processing component.

[0197] In some possible implementations, the target text includes a formula type description text, and the processing logic described in the formula type description text matches the processing logic of the target formula.

[0198] In some possible implementations, the display unit 610 is specifically used to display at least one of the target formula, example information of the target formula, and description information of the target formula in the data processing component, where the description information of the target formula is used to introduce the processing logic of the target formula.

[0199] In some possible implementations, the target text also includes a data range description text, and the data range description text is used to describe the first data range; the processing unit 620 is also used to execute the target formula on the data in the first data range and display the execution results in the table.

[0200] In some possible implementations, the target display area further includes an insertion component; the display unit 620 is specifically configured to insert the target formula into the target table in response to a formula insertion operation triggered by the insertion component.

[0201] In some possible implementations, the trigger instruction is triggered for a target cell in the table; and the display unit 620 is specifically configured to insert the target formula into the target cell.

[0202] In some possible implementations, the device further includes a sending unit and an acquiring unit, wherein the sending unit is configured to send the target text to the target model; and the receiving unit is configured to receive a target formula parsed by the target model based on the target text.

[0203] Referring to FIG7 , which is a schematic diagram of the structure of a data processing device running on a server of a spreadsheet software according to an embodiment of the present application, the data processing device 700 includes:

[0204] An acquisition unit 710 is configured to acquire a target text, where the target text is acquired by the client of the target software and sent to the server;

[0205] A first sending unit 720 is configured to send the target text to a target model;

[0206] A receiving unit 730 is configured to receive a target formula fed back by the target model, where the target formula matches the target text;

[0207] The second sending unit 740 is configured to send the target formula to the client.

[0208] Optionally, the acquiring unit 710 and the receiving unit 720 may be the same unit or different units. The first sending unit 720 and the second sending unit 740 may be the same unit or different units.

[0209] In some possible implementations, the device also includes a processing unit; the receiving unit 730 is further used to receive instruction parsing information sent by the target model, and the instruction parsing information is obtained by semantically parsing the target text; the processing unit is used to determine at least one intermediate formula based on the instruction parsing information; the first sending unit 720 is further used to send information of the at least one intermediate formula to the target model, and the target formula is determined from the multiple intermediate formulas.

[0210] In some possible implementations, the instruction parsing information includes a first vector, which corresponds to the target text; the processing unit is specifically used to obtain feature vectors of multiple candidate formulas; and determine at least one intermediate formula from the multiple candidate formulas based on the first vector and the feature vectors of the candidate formulas.

[0211] Based on the data processing method provided in the above method embodiments, the present application also provides an electronic device, including: one or more processors; a storage device on which one or more programs are stored, and when the one or more programs are executed by the one or more processors, the one or more processors implement the data processing method described in any of the above embodiments.

[0212] Reference is now made to FIG8 , which shows a schematic diagram of the structure of an electronic device 800 suitable for implementing an embodiment of the present application. The terminal device in the embodiment of the present application may include, but is not limited to, mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (Personal Digital Assistants), PADs (portable Android devices), PMPs (Portable Media Players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), and fixed terminals such as digital TVs (televisions), desktop computers, and the like. The electronic device shown in the figure is merely an example and should not limit the functions and scope of use of the embodiments of the present application.

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

[0214] Typically, the following devices may be connected to the I / O interface 805: an input device 808 including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; an output device 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; a storage device 808 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 809. The communication device 809 may allow the electronic device 800 to communicate with other devices wirelessly or by wire to exchange data. Although FIG. 7 shows the electronic device 800 with various devices, it should be understood that not all of the devices shown are required to be implemented or present. More or fewer devices may be implemented or present instead.

[0215] In particular, according to an embodiment of the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present application includes a computer program product, which includes a computer program carried on a non-transitory computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions defined in the method of the embodiment of the present application are performed.

[0216] The electronic device provided in the embodiment of the present application and the data processing method and file sending method provided in the above embodiment belong to the same inventive concept. For technical details not fully described in this embodiment, please refer to the above embodiment, and this embodiment has the same beneficial effects as the above embodiment.

[0217] Based on the method provided in the above method embodiments, an embodiment of the present application provides a computer storage medium on which a computer program is stored, wherein when the program is executed by a processor, the data processing method as described in any of the above embodiments is implemented.

[0218] It should be noted that the computer-readable medium mentioned above in this application can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination of the above. More specific examples of computer-readable storage media can include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this application, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, device, or device. In this application, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, which carries computer-readable program code. This propagated data signal can take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium may be transmitted using any suitable medium, including but not limited to wires, optical cables, RF (radio frequency), etc., or any suitable combination thereof.

[0219] In some embodiments, the client and server can communicate using any currently known or later developed network protocol, such as HTTP (Hypertext Transfer Protocol), and can be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or later developed network.

[0220] The computer-readable medium may be included in the electronic device, or may exist independently without being incorporated into the electronic device.

[0221] The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device executes the data processing method.

[0222] Computer program code for performing the operations of the present application may be written in one or more programming languages, or a combination thereof, including, but not limited to, object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a stand-alone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0223] The flow charts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present application. In this regard, each box in the flow chart or block diagram can represent a module, program segment or a part of code, and the module, program segment or a part of code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order than that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented by a dedicated hardware-based system that performs the specified function or operation, or can be implemented by a combination of dedicated hardware and computer instructions.

[0224] The units involved in the embodiments described in this application may be implemented by software or hardware. In some cases, the name of a unit / module does not constitute a limitation of the unit itself. For example, a voice data acquisition module may also be described as a "data acquisition module."

[0225] The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, and without limitation, exemplary types of hardware logic components that may be used include: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chip (SOCs), complex programmable logic devices (CPLDs), and the like.

[0226] In the context of the present application, a machine-readable medium can be a tangible medium that can contain or store a program for use by an instruction execution system, device or equipment or used in combination with an instruction execution system, device or equipment. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared or semiconductor system, device or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium can include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0227] It should be noted that the various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. Reference can be made to the common and similar parts between the various embodiments. For the systems or devices disclosed in the embodiments, since they correspond to the methods disclosed in the embodiments, the description is relatively simple, and the relevant parts can be referred to the description of the methods.

[0228] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0229] It should also be noted that, in this document, relational terms such as first and second, etc., are used only to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "comprises," "comprising," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or elements inherent to such process, method, article, or device. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article, or device comprising the element.

[0230] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present application. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application is not limited to the embodiments shown herein, but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A data processing method, comprising: In response to receiving a trigger instruction in the form, displaying a data processing component, the data processing component including a text input area; In response to the data processing instruction for the data processing component, the target text received through the text input area is parsed into a target formula.

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

3. The method according to claim 2, further comprising: At least one of the target formula, example information of the target formula and description information of the target formula is displayed in the data processing component, and the description information of the target formula is used to introduce the processing logic of the target formula.

4. The method according to claim 2 or 3, wherein the target text further comprises a data range description text, wherein the data range description text is used to describe the first data range; the method further comprises: The target formula is executed on the data in the first data range, and the execution result is displayed in the table.

5. The method according to claim 4, wherein the target display area further comprises an insertion component; the method further comprises: In response to a formula insertion operation triggered by the insertion component, the target formula is inserted into the target table.

6. The method according to claim 5, wherein the trigger instruction is triggered for a target cell in the table; and the inserting the target formula into the target table comprises: Insert the target formula in the target cell.

7. The method according to claim 1, wherein parsing the target text received through the text input area into a target formula comprises: Sending the target text to the target model; Receive a target formula parsed by the target model based on the target text.

8. A data processing method, wherein the method is applied to a server of a target software, the target software having a table processing function, the method comprising: Acquire a target text, where the target text is acquired by a client of the target software and sent to the server; Sending the target text to the target model; Receiving a target formula fed back by the target model, wherein the target formula matches the target text; The target formula is sent to the client.

9. The method according to claim 8, wherein after sending the target text to the target model, the method further comprises: Receiving instruction parsing information sent by the target model, wherein the instruction parsing information is obtained by semantically parsing the target text; Determine at least one intermediate formula according to the instruction parsing information; Information of the at least one intermediate formula is sent to the target model, the target formula being determined from the plurality of intermediate formulas.

10. The method according to claim 9, wherein the instruction parsing information comprises a first vector, and the first vector corresponds to the target text; Determining a plurality of intermediate formulas according to the first parsing information comprises: Obtaining feature vectors of multiple candidate formulas; At least one intermediate formula is determined from the multiple candidate formulas according to the first vector and the feature vector of the candidate formula.

11. A data processing device, comprising: A display unit, for displaying a data processing component in response to receiving a trigger instruction in a form, wherein the data processing component includes a text input area; a processing unit, configured to parse a target text received through the text input area into a target formula in response to a data processing instruction for the data processing component; The display unit is also used to display the target formula.

12. A data processing device, wherein the device is applied to a server of a target software, the target software has a table processing function, and the device comprises: An acquisition unit, used for acquiring a target text, wherein the target text is acquired by a client of the target software and sent to the server; A first sending unit, configured to send the target text to a target model; A receiving unit, configured to receive a target formula fed back by the target model, wherein the target formula matches the target text; The second sending unit is used to send the target formula to the client.

13. An electronic device comprising: one or more processors; a storage device having one or more programs stored thereon, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 10.

14. A computer readable medium having a computer program stored thereon, wherein: When the program is executed by a processor, the method according to any one of claims 1 to 10 is implemented.

Images