Table document editing method and device, storage medium and electronic equipment

Abstract

The invention discloses a table document editing method and device, a storage medium and electronic device.The method comprises the steps that a table editing instruction input by a user for an operation interface is received, an editing script for a table document editor is generated based on the table editing instruction, the editing script is input into the table document editor, and the table document editor is edited according to the editing script. And controlling the table document editor to execute the editing script, wherein the editing script is used for carrying out change processing on a current display document of the table document editor. By the adoption of the method and device, the editing script is generated through the user instruction, the editing script is used for enabling the table document editor to automatically complete change of the document, editing operation of the table document is simplified, and the use threshold of the table document editor is lowered.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a table document editing method, device, storage medium and electronic device. Background Art

[0002] In application scenarios such as coordination and office work, users can often use spreadsheet document editors such as Excel to create spreadsheet documents to obtain intuitive statistical data documents. Users can use spreadsheet document editors to create documents of various styles. The spreadsheet document editor also has a variety of rich functions. However, the function menu of the spreadsheet document editor has too much content, and advanced functions such as function calculation have a certain operation threshold. It is difficult for users to quickly select a series of functions they need, and it is also difficult for users to skillfully use advanced functions such as function calculation and statistical table production. It is necessary to propose a spreadsheet document editing method that simplifies the operation of the spreadsheet document editor. Summary of the invention

[0003] The embodiments of the present application provide a table document editing method, device, storage medium and electronic device, which can generate an editing script through user instructions, and use the editing script to enable the table document editor to automatically complete the changes to the document, simplify the editing operation of the table document, and lower the threshold for using the table document editor. The technical solution is as follows:

[0004] In a first aspect, an embodiment of the present application provides a method for editing a table document, the method comprising:

[0005] Receiving table editing instructions input by the user on the operation interface;

[0006] Generate an editing script for a table document editor based on the table editing instruction;

[0007] The editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

[0008] In a second aspect, an embodiment of the present application provides a table document editing device, the device comprising:

[0009] An editing instruction receiving module, used for receiving a table editing instruction inputted by a user on an operation interface;

[0010] A script generation module, used to generate an editing script for a table document editor based on the table editing instruction;

[0011] A script input module is used to input the editing script into the table document editor and control the table document editor to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

[0012] In a third aspect, an embodiment of the present application provides a computer storage medium, wherein the computer storage medium stores a plurality of instructions, wherein the instructions are suitable for being loaded by a processor and executing the above-mentioned method steps.

[0013] In a fourth aspect, an embodiment of the present application provides an electronic device, which may include: a processor and a memory; wherein the memory stores a computer program, and the computer program is suitable for being loaded by the processor and executing the above-mentioned method steps.

[0014] In one or more embodiments of the present application, a table editing instruction input by a user to an operation interface is received, an editing script for a table document editor is generated based on the table editing instruction, the editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, and the editing script is used to modify the currently displayed document of the table document editor. The editing script is generated through user instructions, and the editing script is used to enable the table document editor to automatically complete the modification of the document, thereby simplifying the editing operation of the table document and lowering the threshold for using the table document editor. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0016] Figure 1 It is a schematic diagram of a framework of a table document editing device provided in an embodiment of the present application;

[0017] Figure 2 It is a flowchart of a table document editing method provided in an embodiment of the present application;

[0018] Figure 3 It is a flowchart of a table document editing method provided in an embodiment of the present application;

[0019] Figure 4 This is an example schematic diagram of a modification process and a withdrawal process provided by an embodiment of the present application;

[0020] Figure 5 It is a flowchart of a table document editing method provided in an embodiment of the present application;

[0021] Figure 6 It is a structural schematic diagram of a table document editing device provided in an embodiment of the present application;

[0022] Figure 7 It is a structural schematic diagram of a table document editing device provided in an embodiment of the present application;

[0023] Figure 8 It is a structural schematic diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0024] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0025] Users can use computers, tablet computers, mobile phones and other terminal devices to open table document editors, such as Excel, etc. The table document editor can be an application in the terminal device, that is, the application corresponding to the table document editor is opened in the terminal device, and the front end of the terminal device can also display the editor interface of the table document editor. The table document editor can also be opened in the browser of the terminal device, that is, the table document editor is in an online form, and there can be a window of the editor interface of the table document editor in the browser. It can be understood that there are many functions in the table document editor, including relatively simple functions such as entering values ​​in cells, changing cell colors, changing cell sizes, and changing text fonts in cells, and relatively complex functions such as input functions, mixed calculations of multiple functions, and statistical chart generation. Different functions can also be combined to achieve different editing purposes for table documents. However, in order to achieve some editing purposes with more complex operations, users need to have a high degree of understanding of the various functions in the table document editor and a high degree of operation, that is, a certain operation threshold is required. If users want to edit table documents according to their expectations, they need to perform more complex operations on the table document editor.

[0026] The table document editing method provided in the embodiment of the present application can be implemented by a computer program and can be run on a table document editing device based on the von Neumann system. The computer program can be integrated into an application or run as an independent tool application. The table document editing device provided in the embodiment of the present application can be a terminal device such as a computer, a tablet computer, a mobile phone, or a module or application in the terminal device for implementing the table document editing method. The table document editing device can generate an editing script. The script (Script) uses a specific descriptive language and is an executable file written in a certain format. The editing script is a script that can control the table document editor to execute related functions in the table document editor according to the content of the editing script. For example, the editing script can control the table document editor to change the currently displayed document of the table document editor. The currently displayed document is the table document being displayed in the table document editor, and it is also the table document that the user wants to edit and change. Please refer to Figure 1 , a framework schematic diagram of a table document editing device is provided for an embodiment of the present application. The table document editing device may include an operation interface, a script generation component, and a script injection entry. The table document editing device may display an operation interface on a terminal device to facilitate the user to operate the table document editing device. It can be understood that if the table document editor is an application in the terminal device, that is, the editor interface of the table document editor is displayed on the front end of the terminal device, then the operation interface of the table document editing device may also be displayed on the front end of the terminal device. If the table document editor is in an online form, that is, the editor interface of the table document editor is opened in a window of a browser, then the table document editing device may also create a window in the browser to display the operation interface.

[0027] The operation interface is used to receive table operation instructions input by the user. The table operation instructions are used to instruct the table document editing device to generate a corresponding editing script, thereby controlling the table document editor to achieve the editing purpose of the table operation instructions. For example, the user wants to swap the rows and columns of all data in the currently displayed document. For example, the value "100" was originally in the first row and second column. After the rows and columns are swapped, the value "100" should be in the second row and first column. If the user changes the data in each table in turn, it requires very tedious and complicated operations. The user can input the table operation instruction of "swap the rows and columns of all data in the document" to the table document editing device based on the operation interface. The table document editor can generate an editing script based on the table operation instruction. The editing script can control the table document editor to automatically swap the rows and columns of all data in the currently displayed document, thereby simplifying the user's editing operations on the table document.

[0028] The script generation component is used to generate a corresponding editing script based on the table editing instructions received based on the operation interface. Then the table document editing device can input the editing script into the table document editor through the script injection entrance, thereby controlling the table document editor to execute the editing script and make changes to the currently displayed document.

[0029] The table document editing method provided by this application is described in detail below in conjunction with specific embodiments.

[0030] See also Figure 2 , which is a flowchart of a table document editing method provided in an embodiment of the present application. Figure 2 As shown, the method of the embodiment of the present application may include the following steps S101-S103.

[0031] S101, receiving a table editing instruction input by a user on an operation interface.

[0032] Specifically, the table document editing device can display an operation interface on the terminal screen of the terminal device, and the operation interface can facilitate the user to operate the table document editing device. The user can input a table instruction on the operation interface, and the table document editing device can receive the table editing instruction input by the user on the operation interface. For example, the user can input the table editing instruction by voice, that is, the user can speak the table editing instruction, and the table document editing device can collect the user's voice data to obtain the table editing instruction. Similarly, the user can also input the table editing instruction by inputting text, that is, the user can input text data on the operation interface, and the table document editing device can obtain the table editing instruction through the text data.

[0033] S102: Generate an editing script for a table document editor based on the table editing instruction.

[0034] Specifically, the table document editing device can generate an editing script for the table document editor based on the table editing instruction. The editing script is a script that can control the table document editor to execute relevant functions in the table document editor according to the content of the editing script. For example, if the table editing instruction input by the user is "mark all the data in the second column of the document as yellow", then the editing script generated by the table document editing device contains a series of functions that need to be executed in sequence, such as selecting the second column, turning on the "highlight" function, selecting yellow, etc. The editing script can control the table document editor to execute relevant functions according to the editing script, thereby achieving the purpose of marking all the data in the second column as yellow.

[0035] S103, inputting the editing script into the table document editor, and controlling the table document editor to execute the editing script.

[0036] Specifically, the table document editing device can input the editing script into the table document editor, thereby controlling the table document editor to execute the editing script. The editing script is used to change the currently displayed document of the table document editor. The currently displayed document is the table document being displayed in the table document editor, and is also the table document that the user wants to edit and change. It can be understood that multiple table documents can also be opened at the same time in the table document editor, but only one table document can be displayed on the screen. The user can display the table document that he wants to edit and change on the terminal screen as the currently displayed document.

[0037] In an embodiment of the present application, a table editing instruction input by a user to an operation interface is received, an editing script for a table document editor is generated based on the table editing instruction, the editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, and the editing script is used to modify the currently displayed document of the table document editor. The editing script is generated by the user instruction, and the editing script is used to enable the table document editor to automatically complete the modification of the document, thereby simplifying the editing operation of the table document and lowering the threshold for using the table document editor.

[0038] See also Figure 3 , which is a flowchart of a table document editing method provided in an embodiment of the present application. Figure 3 As shown, the method of the embodiment of the present application may include the following steps S201-S209.

[0039] S201, receiving an instruction to open an operation interface of a spreadsheet document editor opened in a browser, creating an operation window in the browser, and displaying the operation interface in the operation window.

[0040] Specifically, the table document editor can be opened in the browser of the terminal device, that is, the table document editor is in an online form, and a window of the editor interface of the table document editor can exist in the browser. If the table document editor is opened in the browser, the table document editing device can create a window in the browser to display the operation interface. After the user opens the table document editor in the browser, the user can send an operation interface opening instruction for the table document editor to the table document editing device. The operation interface opening instruction can be used to open the operation interface that helps control the table document editor. After the table document editing device receives the operation interface opening instruction for the table document editor opened in the browser, it can create an operation window in the browser and display the operation interface in the operation window.

[0041] Optionally, the table document editor may be not only in an online form, but also an application in a terminal device. The table document editor may open an application corresponding to the table document editor in the terminal device, and may display an editor interface of the table document editor at the front end of the terminal device. The table document editing device may also be an application in the terminal device. If an instruction to open the operation interface of the table document editor opened at the front end is received, the table document editing device may open the operation interface at the front end of the terminal device.

[0042] S202: receiving a table editing instruction input by a user on an operation interface.

[0043] Specifically, the user may input a table editing instruction on the operation interface, and the table document editing device may receive the table editing instruction input by the user on the operation interface.

[0044] S203: If the table editing instruction is voice data, semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction.

[0045] Specifically, the user can input the table editing instructions in the operation interface by voice input, and the table document editing device can collect the user's voice data to obtain the table editing instructions. It can be understood that if the user orally speaks the table editing instructions, there may be environmental noise in the collected voice data, as well as irrelevant words and sentences said by the user due to inaccurate and concise description. Therefore, if the table editing instructions are voice data, the table document editing device can perform semantic analysis on the voice data corresponding to the table editing instructions, so as to obtain the instruction keywords in the table editing instructions, thereby achieving the purpose of concise table editing instructions.

[0046] Optionally, the table document editing device may first perform text conversion processing on the voice data to obtain the text content corresponding to the voice data, and then perform semantic analysis processing on the text content to obtain the instruction keywords. For example, the user may voice input the voice data of "I want to change the background of all cells in the 10th column of the table document to yellow" as a table editing instruction, and the table document editing device will perform semantic analysis processing on the table editing instruction to obtain the instruction keywords "10th column", "cell background" and "yellow", which can concisely and clearly express the editing purpose corresponding to the user's table editing instruction.

[0047] Optionally, the user can also input table editing instructions by inputting text, that is, the user can input text data on the operation interface, and the table document editing device can obtain the table editing instructions through the text data, that is, the table document editing device can perform semantic analysis on the text data to obtain instruction keywords.

[0048] S204, based on the instruction keywords, using the script editing model to generate an editing script for the table document editor.

[0049] Specifically, the table document editing device can input instruction keywords into the script editing model, and the script editing model can output an editing script for the table document editor based on the instruction keywords. The script editing model is used to generate an editing script corresponding to the instruction keywords according to the instruction keywords.

[0050] Optionally, the table document editing device can create an initial script editing model, and then obtain sample keywords and sample editing scripts corresponding to the sample keywords, wherein the sample editing script can be a sample editing script obtained by the staff through manual writing based on the sample keywords. The table document editing device can use the sample keywords to perform at least one round of model training on the initial script editing model, and each round of model training can obtain the predicted editing script corresponding to the sample keywords, that is, the sample keywords are input into the initial script editing model, and the initial script editing model can output the predicted editing script corresponding to the sample keywords. The table document editing device can calculate the loss value of the initial script editing model based on the sample editing script of the predicted editing script, and adjust the parameters of the initial script editing model based on the loss value during the back propagation training process until the initial script editing model completes the model training and obtains the script editing model. Among them, the loss value can be expressed as a value of the difference between the predicted editing script and the sample editing script, and the initial script editing model and the script editing model can be large language models (LLMs).

[0051] S205, inputting the editing script into the table document editor, and controlling the table document editor to execute the editing script.

[0052] Specifically, the table document editing device can input the editing script into the table document editor, thereby controlling the table document editor to execute the editing script. The editing script is used to change the currently displayed document of the table document editor. The currently displayed document is the table document being displayed in the table document editor, and is also the table document that the user wants to edit and change. It can be understood that multiple table documents can also be opened at the same time in the table document editor, but only one table document can be displayed on the screen. The user can display the table document that he wants to edit and change on the terminal screen as the currently displayed document.

[0053] S206, receiving a withdrawal instruction input by the user on the operation interface, generating a withdrawal script based on the withdrawal instruction, inputting the withdrawal script into the table document editor, and controlling the table document editor to withdraw the content of the changes made to the currently displayed document by the editing script.

[0054] Specifically, if the user is not satisfied with the changes made by the editing script to control the table document editor, or the user has other editing ideas and wants to re-edit, the user can input a withdrawal instruction for the operation interface, and the withdrawal instruction is used to instruct the table document editing device to withdraw the changes made by the editing script to the currently displayed document. The user can use voice input to withdraw the instruction, for example, the user can open the operation interface and say "withdraw" or a sentence containing "withdraw", and the user can also enter and exit the withdrawal instruction by inputting text, for example, the user can enter the text "withdraw" in the operation interface, and the withdrawal function button can also be displayed on the operation interface. The user clicks the withdrawal function button to confirm the withdrawal instruction input to the operation interface.

[0055] If the table document editing device receives a revocation instruction input by the user to the operation interface, it can generate a revocation script based on the revocation instruction. The revocation script is a script that controls the table document editor to revocation the changes made to the currently displayed document by the editing script. The revocation script is then input into the table document editor to control the table document editor to revocation the changes made to the currently displayed document by the editing script, thereby restoring the currently displayed document to its original state before the changes were made.

[0056] Please also see Figure 4 , an example schematic diagram of change processing and withdrawal processing is provided for the embodiment of the present application, the table document editor can be in an online form, that is, the editor interface of the table document editor can be opened in the window of the browser, and the user can input a table editing instruction of "set the background of all cells in the second row to a color with RGB value of 150" into the operation interface of the table document editing device, then the table document editing device performs semantic analysis on the table editing instruction, and can obtain the instruction keywords "second row", "cell background" and "RGB value 150", then the table document editing device can use the script editing model to generate an editing script corresponding to the instruction keywords and input the editing script into the table document editor, and the table document editor can perform change processing on the currently displayed document based on the editing script, and change the background color of all cells in the second row to a color with RGB value of 150, 150, 150. If a withdrawal instruction input by the user for the operation interface is received, a withdrawal script can be generated and input into the table document editor, and the table document editor is controlled to withdraw the content of the change processing of the currently displayed document, that is, to restore the background color of all cells in the second row to the color before the change processing.

[0057] S207: Receive negative feedback information from the user regarding the edited script.

[0058] Specifically, the table document editing device can use a script editing model to generate an editing script. The editing script generated by the script editing model may not fully meet the user's editing purpose. If the user is not satisfied with the change processing brought about by the editing script generated by the script editing model, the user can send negative feedback information about the editing script to the table document editing device based on the operation interface. For example, after the table document editor completes the change processing, the table document editing device can pop up a user feedback collection window on the operation interface and display prompt content, such as "Are you satisfied with this change processing?", and display positive feedback function keys, such as "satisfied", and negative feedback function keys, such as "unsatisfied", in the user feedback collection window. The user can send positive feedback information about the editing script to the table document editing device by clicking the positive feedback function key, indicating that the content of the editing script is accurate, and can send negative feedback information about the editing script to the table document editing device by clicking the negative feedback function key, indicating dissatisfaction with the editing script, that is, the content of the editing script is inaccurate.

[0059] The table document editing device can receive negative feedback information from users regarding the editing script as well as negative feedback information.

[0060] S208, generate manual editing prompt information based on instruction keywords, send the manual editing prompt information to the staff terminal, receive the manual editing script returned by the staff terminal based on the manual editing prompt information, input the manual editing script into the table document editor, and control the table document editor to execute the manual editing script.

[0061] Specifically, if negative feedback information is received from the user regarding the editing script, it means that the user is not satisfied with the editing script generated by the script editing model, and the table document editing device can notify the staff to manually write to obtain the correct manual editing script. The table document editing device can generate manual writing prompt information based on the instruction keywords, and send the manual writing prompt information to the staff terminal. The staff terminal is a terminal device held by the staff during working hours. The staff can use the staff terminal to complete manual writing and other tasks. The manual writing prompt information is used to prompt the staff that the user is not satisfied with the editing script generated by the corresponding script writing model, and prompt the staff to manually write according to the instruction keywords. After receiving the manual writing prompt information on the staff terminal, the staff can manually write according to the instruction keywords to generate a manual editing script, and use the staff terminal to send the manually written script to the table document editing device.

[0062] After receiving the manual editing script returned by the staff terminal based on the manual editing prompt information, the table document editing device can input the manual editing script into the table document editor and control the table document editor to execute the manual editing script.

[0063] S209, performing at least one round of model training on the script editing model based on the instruction keywords, obtaining a training editing script corresponding to the instruction keywords, and performing parameter update processing on the script editing model based on the training editing script and the manual editing script.

[0064] Specifically, the table document editing device can perform at least one round of model training on the script editing model based on the instruction keywords to obtain the training editing script corresponding to the instruction keywords, that is, the table document editing device can input the instruction keywords into the script editing model, and the script editing model can output the training editing script corresponding to the instruction keywords, and then perform parameter update processing on the script editing model based on the training editing script and the manual editing script, that is, the script editing model can be parameter updated based on the loss values ​​of the training editing script and the manual editing script during the back propagation training process, and the script editing model after the parameter update processing is used to replace the script editing model to generate an editing script corresponding to the table editing instruction input by the user later, thereby achieving the purpose of gradually updating and improving the script editing model during use.

[0065] In an embodiment of the present application, an operation interface opening instruction for a table document editor opened in a browser is received, an operation window is created in the browser, the operation interface is displayed in the operation window, and a table editing instruction input by a user for the operation interface is received. If the table editing instruction is voice data, a semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction, thereby eliminating environmental noise and irrelevant words and sentences that the user says due to inaccurate and concise descriptions, thereby achieving the purpose of concise table editing instructions. Based on the instruction keywords, a script editing model is used to generate an editing script for the table document editor, the editing script is input into the table document editor, the table document editor is controlled to execute the editing script, the editing script is generated through user instructions, and the editing script is used to enable the table document editor to automatically complete the changes to the document, thereby simplifying the editing operation of the table document and lowering the threshold for using the table document editor. Receive a withdrawal instruction input by the user for the operation interface, generate a withdrawal script based on the withdrawal instruction, input the withdrawal script into the table document editor, control the table document editor to withdraw the changes made to the currently displayed document by the editing script, directly withdraw all changes, simplify the user withdrawal processing steps, receive negative feedback from the user on the editing script, generate manual editing prompt information based on instruction keywords, send the manual editing prompt information to the staff terminal, receive the manual editing script returned by the staff terminal based on the manual editing prompt information, input the manual editing script into the table document editor, control the table document editor to execute the manual editing script, perform at least one round of model training on the script editing model based on the instruction keywords, obtain the training editing script corresponding to the instruction keywords, perform parameter update processing on the script editing model based on the training editing script and the manual editing script, gradually update and improve the script editing model during use, and further improve the accuracy of editing script generation.

[0066] See also Figure 5 , which is a flowchart of a table document editing method provided in an embodiment of the present application. Figure 5 As shown, the method of the embodiment of the present application may include the following steps S301-S305.

[0067] S301, receiving an instruction to open an operation interface of a spreadsheet document editor opened in a browser, creating an operation window in the browser, and displaying the operation interface in the operation window.

[0068] For details, please refer to S201.

[0069] S302, receiving a selection instruction from a user for a target function button in the operation interface, where the target function button is any function button displayed in the operation interface.

[0070] Specifically, in addition to obtaining table editing instructions based on voice data or text data input by the user, the table document editing device can also display at least one function button on the operation interface, and each function button can correspond to an editing purpose and an editing script. The table document editing device can obtain editing scripts corresponding to different editing purposes, such as row and column swapping, filtering, sorting, statistical table generation and other different editing purposes, and display the function buttons corresponding to these editing purposes on the operation interface, and can save the function buttons, the editing texts corresponding to the function buttons, and the association between the function buttons and the editing texts in an integrated function set, so that the table document editing device can find the corresponding editing text in the integrated function set according to the function buttons.

[0071] The user can select a target function button on the operation interface. When the table document editing device receives the user's selection instruction for the target function button in the operation interface, it means that the table document editing device receives the table editing instruction input by the user on the operation interface. The target function button can be any function button displayed in the operation interface. Among them, the selection instruction can be the user clicking on the target function button. For example, there can be function buttons such as "row and column exchange", "filter", "sort", and "statistical table generation" on the operation interface. The user can select the "row and column exchange" function button as the target function button on the operation interface. Then the user's table editing instruction is to exchange the rows and columns of all data in the currently displayed document. The table document editing device can obtain the corresponding editing script in the integrated function set according to the target function button "row and column exchange".

[0072] S303: Obtain an editing script for a table document editor corresponding to a target function key in an integrated function set, wherein the integrated function set includes editing scripts corresponding to all function keys.

[0073] Specifically, the table document editing device can obtain the editing script for the table document editor corresponding to the target function key in the integrated function set. It can be understood that the integrated function set includes editing scripts corresponding to all function keys, and all editing scripts are saved in the integrated function set after editing is completed, thereby realizing the reuse of editing scripts and further improving the convenience of table document editing.

[0074] S304, inputting the editing script into the table document editor, and controlling the table document editor to execute the editing script.

[0075] For details, please refer to S205.

[0076] S305, receiving a withdrawal instruction input by the user on the operation interface, generating a withdrawal script based on the withdrawal instruction, inputting the withdrawal script into the table document editor, and controlling the table document editor to withdraw the content of the changes made to the currently displayed document by the editing script.

[0077] For details, please refer to S206.

[0078] In an embodiment of the present application, an operation interface opening instruction for a table document editor opened in a browser is received, an operation window is created in the browser, the operation interface is displayed in the operation window, a user selection instruction for a target function button in the operation interface is received, the target function button is any function button displayed in the operation interface, an editing script for the table document editor corresponding to the target function button is obtained in an integrated function set, the integrated function set includes editing scripts corresponding to all function buttons, the editing script is reused, the convenience of table document editing is further improved, the editing script is input into the table document editor, and the table document editor is controlled to execute the editing script. The editing script is generated through user instructions, and the editing script is used to enable the table document editor to automatically complete the changes to the document, simplifying the editing operation of the table document and lowering the threshold for using the table document editor. The user receives a withdrawal instruction input for the operation interface, generates a withdrawal script based on the withdrawal instruction, inputs the withdrawal script into the table document editor, controls the table document editor to withdraw the content of the changes made to the currently displayed document by the editing script, directly withdraws all changes, and simplifies the user withdrawal processing steps.

[0079] The following will be combined with the attached Figure 6 -Attached Figure 7 , the table document editing device provided in the embodiment of the present application is introduced in detail. It should be noted that the attached Figure 4 -Attached Figure 7 The table document editing device in the present application is used to execute Figure 2-Figure 5 For the convenience of explanation, only the part related to the embodiment of the present application is shown. For the specific technical details not disclosed, please refer to the present application. Figure 2-Figure 5 The embodiment shown.

[0080] See also Figure 6 , which shows a schematic diagram of the structure of a table document editing device provided by an exemplary embodiment of the present application. The table document editing device can be implemented as all or part of the device through software, hardware or a combination of both. The device 1 includes an editing instruction receiving module 11, a script generating module 12 and a script input module 13.

[0081] The editing instruction receiving module 11 is used to receive the table editing instruction input by the user on the operation interface;

[0082] A script generation module 12, used to generate an editing script for a table document editor based on the table editing instruction;

[0083] The script input module 13 is used to input the editing script into the table document editor and control the table document editor to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

[0084] In this embodiment, a table editing instruction input by a user to an operation interface is received, an editing script for a table document editor is generated based on the table editing instruction, the editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, and the editing script is used to modify the currently displayed document of the table document editor. The editing script is generated by the user instruction, and the editing script is used to enable the table document editor to automatically complete the modification of the document, thereby simplifying the editing operation of the table document and lowering the threshold for using the table document editor.

[0085] See also Figure 7 , which shows a schematic diagram of the structure of a table document editing device provided by an exemplary embodiment of the present application. The table document editing device can be implemented as all or part of the device through software, hardware or a combination of both. The device 1 includes an operation interface opening module 14, an editing instruction receiving module 11, a script generating module 12, a script input module 13, a withdrawal processing module 15, a negative feedback module 16 and a model updating module 17.

[0086] The operation interface opening module 14 is used to receive an operation interface opening instruction for the table document editor opened in the browser;

[0087] An operation window is created in the browser, and an operation interface is displayed in the operation window.

[0088] The editing instruction receiving module 11 is used to receive the table editing instruction input by the user on the operation interface;

[0089] Optionally, the editing instruction receiving module 11 is specifically used to receive a selection instruction from a user for a target function button in the operation interface, and the target function button is any function button displayed in the operation interface.

[0090] A script generation module 12, used to generate an editing script for a table document editor based on the table editing instruction;

[0091] Optionally, the script generation module 12 is specifically used to obtain an editing script for a table document editor corresponding to the target function key in an integrated function set, wherein the integrated function set includes editing scripts corresponding to all function keys.

[0092] Optionally, the script generation module 12 is specifically configured to perform semantic analysis on the table editing instruction to obtain instruction keywords in the table editing instruction if the table editing instruction is voice data;

[0093] Based on the instruction keywords, a script editing model is used to generate an editing script for the table document editor.

[0094] The script input module 13 is used to input the editing script into the table document editor and control the table document editor to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

[0095] A withdrawal processing module 15, configured to receive a withdrawal instruction input by the user on the operation interface, and generate a withdrawal script based on the withdrawal instruction;

[0096] The revocation script is input into the table document editor to control the table document editor to revocation the content of the modification process performed by the editing script on the currently displayed document.

[0097] A negative feedback module 16, configured to receive negative feedback information from the user regarding the edited script;

[0098] Generate manual editing prompt information based on the instruction keyword, and send the manual editing prompt information to the staff terminal, wherein the manual editing prompt information is used to instruct the staff to write a manual editing script for the instruction keyword;

[0099] Receiving the manually edited script returned by the staff terminal based on the manually written prompt information;

[0100] The manual editing script is input into the table document editor, and the table document editor is controlled to execute the manual editing script.

[0101] A model updating module 17, configured to perform at least one round of model training on the script editing model based on the instruction keyword to obtain a training editing script corresponding to the instruction keyword;

[0102] The script editing model is subjected to parameter update processing based on the training editing script and the manual editing script.

[0103] In this embodiment, an operation interface opening instruction for a table document editor opened in a browser is received, an operation window is created in the browser, an operation interface is displayed in the operation window, and a table editing instruction input by a user for the operation interface is received. If the table editing instruction is voice data, a semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction, thereby eliminating environmental noise and irrelevant words and sentences that the user says due to inaccurate and concise descriptions, so as to achieve the purpose of concise table editing instructions. Based on the instruction keywords, an editing script for the table document editor is generated using a script editing model. A selection instruction for a target function button in the operation interface can also be received from the user, the target function button being any function button displayed in the operation interface, and an editing script for the table document editor corresponding to the target function button is obtained in the integrated function set, the integrated function set including the editing scripts corresponding to all function buttons, realizing the reuse of editing scripts, and further improving the convenience of table document editing. The editing script is input into the table document editor, the table document editor is controlled to execute the editing script, the editing script is generated through user instructions, and the editing script is used to enable the table document editor to automatically complete the changes to the document, simplifying the editing operation of the table document and lowering the threshold for using the table document editor. Receive a withdrawal instruction input by the user for the operation interface, generate a withdrawal script based on the withdrawal instruction, input the withdrawal script into the table document editor, control the table document editor to withdraw the changes made to the currently displayed document by the editing script, directly withdraw all changes, simplify the user withdrawal processing steps, receive negative feedback from the user on the editing script, generate manual editing prompt information based on instruction keywords, send the manual editing prompt information to the staff terminal, receive the manual editing script returned by the staff terminal based on the manual editing prompt information, input the manual editing script into the table document editor, control the table document editor to execute the manual editing script, perform at least one round of model training on the script editing model based on the instruction keywords, obtain the training editing script corresponding to the instruction keywords, perform parameter update processing on the script editing model based on the training editing script and the manual editing script, gradually update and improve the script editing model during use, and further improve the accuracy of editing script generation.

[0104] It should be noted that the table document editing device provided in the above embodiment only uses the division of the above functional modules as an example when executing the table document editing method. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above. In addition, the table document editing device provided in the above embodiment and the table document editing method embodiment belong to the same concept, and the implementation process thereof is detailed in the method embodiment, which will not be repeated here.

[0105] The serial numbers of the above-mentioned embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments.

[0106] The present application also provides a computer storage medium, which can store multiple instructions, and the instructions are suitable for being loaded and executed by a processor as described above. Figure 1-Figure 5 The table document editing method of the embodiment shown in the figure can be found in the specific execution process. Figure 1-Figure 5 The specific description of the illustrated embodiment will not be repeated here.

[0107] The present application also provides a computer program product, which stores at least one instruction, and the at least one instruction is loaded and executed by the processor as described above. Figure 1-Figure 5 The table document editing method of the embodiment shown in the figure can be found in the specific execution process. Figure 1-Figure 5 The specific description of the illustrated embodiment will not be repeated here.

[0108] Please refer to Figure 8 , which shows a block diagram of the structure of an electronic device provided by an exemplary embodiment of the present application. The electronic device in the present application may include one or more of the following components: a processor 110, a memory 120, an input device 130, an output device 140, and a bus 150. The processor 110, the memory 120, the input device 130, and the output device 140 may be connected via the bus 150.

[0109] The processor 110 may include one or more processing cores. The processor 110 uses various interfaces and lines to connect various parts of the entire electronic device, and executes various functions and processes data of the terminal 100 by running or executing instructions, programs, code sets or instruction sets stored in the memory 120, and calling data stored in the memory 120. Optionally, the processor 110 can be implemented in at least one hardware form of digital signal processing (DSP), field-programmable gate array (FPGA), and programmable logic array (PLA). The processor 110 can integrate one or a combination of a central processing unit (CPU), a graphics processing unit (GPU), and a modem. Among them, the CPU mainly processes the operating system, user pages, and applications; the GPU is responsible for rendering and drawing display content; and the modem is used to process wireless communications. It can be understood that the above-mentioned modem may not be integrated into the processor 110, but may be implemented separately through a communication chip.

[0110] The memory 120 may include a random access memory (RAM) or a read-only memory (ROM). Optionally, the memory 120 includes a non-transitory computer-readable medium (Non-Transitory Computer-Readable Storage Medium). The memory 120 may be used to store instructions, programs, codes, code sets or instruction sets. The memory 120 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for implementing at least one function (such as a touch function, a sound playback function, an image playback function, etc.), instructions for implementing the above-mentioned various method embodiments, etc. The operating system may be an Android system, including a system deeply developed based on the Android system, an IOS system developed by Apple, including a system deeply developed based on the IOS system or other systems.

[0111] The memory 120 can be divided into an operating system space and a user space. The operating system runs in the operating system space, and native and third-party applications run in the user space. In order to ensure that different third-party applications can achieve good operating results, the operating system allocates corresponding system resources to different third-party applications. However, the requirements for system resources in different application scenarios in the same third-party application are also different. For example, in the local resource loading scenario, the third-party application has higher requirements for disk reading speed; in the animation rendering scenario, the third-party application has higher requirements for GPU performance. The operating system and third-party applications are independent of each other, and the operating system often cannot perceive the current application scenario of the third-party application in a timely manner, resulting in the operating system being unable to perform targeted system resource adaptation according to the specific application scenario of the third-party application.

[0112] In order for the operating system to distinguish the specific application scenarios of third-party applications, it is necessary to open up data communication between third-party applications and the operating system so that the operating system can obtain the current scenario information of third-party applications at any time, and then perform targeted system resource adaptation based on the current scenario.

[0113] The input device 130 is used to receive input commands or data, and includes but is not limited to a keyboard, a mouse, a camera, a microphone, or a touch device. The output device 140 is used to output commands or data, and includes but is not limited to a display device and a speaker. In one example, the input device 130 and the output device 140 can be combined, and the input device 130 and the output device 140 are touch screen displays.

[0114] The touch display screen can be designed as a full screen, a curved screen or a special-shaped screen. The touch display screen can also be designed as a combination of a full screen and a curved screen, or a combination of a special-shaped screen and a curved screen, which is not limited in the embodiments of the present application.

[0115] In addition, those skilled in the art will appreciate that the structure of the electronic device shown in the above drawings does not constitute a limitation on the electronic device, and the electronic device may include more or fewer components than shown, or combine certain components, or arrange the components differently. For example, the electronic device also includes a radio frequency circuit, an input unit, a sensor, an audio circuit, a wireless fidelity (WiFi) module, a power supply, a Bluetooth module and other components, which will not be described in detail here.

[0116] exist Figure 8 In the electronic device shown, the processor 110 may be used to call a table document editing application stored in the memory 120, and specifically perform the following operations:

[0117] Receiving table editing instructions input by the user on the operation interface;

[0118] Generate an editing script for a table document editor based on the table editing instruction;

[0119] The editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

[0120] In one embodiment, before executing the table editing instruction received from the user on the operation interface, the processor 110 further performs the following operations:

[0121] Receive an instruction to open an operation interface of a spreadsheet document editor opened in a browser;

[0122] An operation window is created in the browser, and an operation interface is displayed in the operation window.

[0123] In one embodiment, when the processor 110 receives a table editing instruction input by a user on an operation interface, the processor 110 specifically performs the following operations:

[0124] Receiving a selection instruction from a user for a target function button in an operation interface, wherein the target function button is any function button displayed in the operation interface;

[0125] The generating an editing script for a table document editor based on the table editing instruction includes:

[0126] An editing script for a table document editor corresponding to the target function key is obtained in an integrated function set, wherein the integrated function set includes editing scripts corresponding to all function keys.

[0127] In one embodiment, when the processor 110 generates an editing script for a table document editor based on the table editing instruction, the processor 110 specifically performs the following operations:

[0128] If the table editing instruction is voice data, semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction;

[0129] Based on the instruction keywords, a script editing model is used to generate an editing script for the table document editor.

[0130] In one embodiment, when executing the table-based document editing method, the processor 110 further performs the following operations:

[0131] receiving a withdrawal instruction input by the user on the operation interface, and generating a withdrawal script based on the withdrawal instruction;

[0132] The revocation script is input into the table document editor to control the table document editor to revocation the content of the modification process performed by the editing script on the currently displayed document.

[0133] In one embodiment, when executing the table-based document editing method, the processor 110 further performs the following operations:

[0134] receiving negative feedback information from the user regarding the edited script;

[0135] Generate manual editing prompt information based on the instruction keyword, and send the manual editing prompt information to the staff terminal, wherein the manual editing prompt information is used to instruct the staff to write a manual editing script for the instruction keyword;

[0136] Receiving the manually edited script returned by the staff terminal based on the manually written prompt information;

[0137] The manual editing script is input into the table document editor, and the table document editor is controlled to execute the manual editing script.

[0138] In one embodiment, when executing the table-based document editing method, the processor 110 further performs the following operations:

[0139] Perform at least one round of model training on the script editing model based on the instruction keyword to obtain a training editing script corresponding to the instruction keyword;

[0140] The script editing model is subjected to parameter update processing based on the training editing script and the manual editing script.

[0141] In this embodiment, an operation interface opening instruction for a table document editor opened in a browser is received, an operation window is created in the browser, an operation interface is displayed in the operation window, and a table editing instruction input by a user for the operation interface is received. If the table editing instruction is voice data, a semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction, thereby eliminating environmental noise and irrelevant words and sentences that the user says due to inaccurate and concise descriptions, so as to achieve the purpose of concise table editing instructions. Based on the instruction keywords, an editing script for the table document editor is generated using a script editing model. A selection instruction for a target function button in the operation interface can also be received from the user, the target function button being any function button displayed in the operation interface, and an editing script for the table document editor corresponding to the target function button is obtained in the integrated function set, the integrated function set including the editing scripts corresponding to all function buttons, realizing the reuse of editing scripts, and further improving the convenience of table document editing. The editing script is input into the table document editor, the table document editor is controlled to execute the editing script, the editing script is generated through user instructions, and the editing script is used to enable the table document editor to automatically complete the changes to the document, simplifying the editing operation of the table document and lowering the threshold for using the table document editor. Receive a withdrawal instruction input by the user for the operation interface, generate a withdrawal script based on the withdrawal instruction, input the withdrawal script into the table document editor, control the table document editor to withdraw the changes made to the currently displayed document by the editing script, directly withdraw all changes, simplify the user withdrawal processing steps, receive negative feedback from the user on the editing script, generate manual editing prompt information based on instruction keywords, send the manual editing prompt information to the staff terminal, receive the manual editing script returned by the staff terminal based on the manual editing prompt information, input the manual editing script into the table document editor, control the table document editor to execute the manual editing script, perform at least one round of model training on the script editing model based on the instruction keywords, obtain the training editing script corresponding to the instruction keywords, perform parameter update processing on the script editing model based on the training editing script and the manual editing script, gradually update and improve the script editing model during use, and further improve the accuracy of editing script generation.

[0142] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in the embodiments of this specification are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions. For example, the form editing instructions and negative feedback information involved in this specification are all obtained with full authorization.

[0143] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing related hardware through a computer program, and the program can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes of the embodiments of the above-mentioned methods. The storage medium can be a disk, an optical disk, a read-only storage memory, or a random access memory, etc.

[0144] The above disclosure is only the preferred embodiment of the present application, which certainly cannot be used to limit the scope of rights of the present application. Therefore, equivalent changes made according to the claims of the present application are still within the scope covered by the present application.

Claims

1. A table document editing method, characterized in that: The method comprises: Receiving table editing instructions input by the user on the operation interface; Generate an editing script for a table document editor based on the table editing instruction; The editing script is input into the table document editor, and the table document editor is controlled to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

2. The method according to claim 1, characterized in that Before receiving the table editing instruction input by the user on the operation interface, the method further includes: Receive an instruction to open an operation interface of a spreadsheet document editor opened in a browser; An operation window is created in the browser, and an operation interface is displayed in the operation window.

3. The method according to claim 1, characterized in that The receiving of a table editing instruction input by a user on an operation interface includes: Receiving a selection instruction from a user for a target function button in an operation interface, wherein the target function button is any function button displayed in the operation interface; The generating an editing script for a table document editor based on the table editing instruction includes: An editing script for a table document editor corresponding to the target function key is obtained in an integrated function set, wherein the integrated function set includes editing scripts corresponding to all function keys.

4. The method according to claim 1, characterized in that: The generating an editing script for a table document editor based on the table editing instruction includes: If the table editing instruction is voice data, semantic analysis is performed on the table editing instruction to obtain instruction keywords in the table editing instruction; Based on the instruction keywords, a script editing model is used to generate an editing script for the table document editor.

5. The method according to claim 1, characterized in that The method further comprises: receiving a withdrawal instruction input by the user on the operation interface, and generating a withdrawal script based on the withdrawal instruction; The revocation script is input into the table document editor to control the table document editor to revocation the content of the modification process performed by the editing script on the currently displayed document.

6. The method according to claim 4, characterized in that The method further comprises: receiving negative feedback information from the user regarding the edited script; Generate manual editing prompt information based on the instruction keyword, and send the manual editing prompt information to the staff terminal, wherein the manual editing prompt information is used to instruct the staff to write a manual editing script for the instruction keyword; Receiving the manually edited script returned by the staff terminal based on the manually written prompt information; The manual editing script is input into the table document editor, and the table document editor is controlled to execute the manual editing script.

7. The method according to claim 6, characterized in that The method further comprises: Perform at least one round of model training on the script editing model based on the instruction keyword to obtain a training editing script corresponding to the instruction keyword; The script editing model is subjected to parameter update processing based on the training editing script and the manual editing script.

8. A table document editing device, characterized in that: The device comprises: An editing instruction receiving module, used for receiving a table editing instruction inputted by a user on an operation interface; A script generation module, used to generate an editing script for a table document editor based on the table editing instruction; A script input module is used to input the editing script into the table document editor and control the table document editor to execute the editing script, wherein the editing script is used to modify the currently displayed document of the table document editor.

9. A computer storage medium, characterized in that: The computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the method steps according to any one of claims 1 to 7.

10. An electronic device, characterized in that: include: A processor and a memory; wherein the memory stores a computer program, and the computer program is suitable for being loaded by the processor and executing the method steps as claimed in any one of claims 1 to 7.

Images