Table input method, device and equipment for text data based on speech recognition

Abstract

The present invention relates to the technical field of table data input, and in particular to a table input method for text data based on voice recognition, comprising: obtaining text data to be input corresponding to the user's voice input data, wherein the text data includes characters to be input and switch command words; according to the position of the switch command words in the text data to be input, extracting characters between the switch command words and combining them into several groups of character strings; according to the row number and column number information of the current cell, inputting each group of character strings into the corresponding cell according to the row number and column number information of the current cell and the position of the switch command words in the text data to be input. Compared with the prior art, the present invention can effectively improve the process efficiency of data input tables, efficiently shorten the overall operation time, and liberate the labor of manual input processes such as mouse operation and keyboard typing.

Description

Technical Field

[0001] The present invention relates to the technical field of table data input, and in particular to a table input method, device, equipment and storage medium for text data based on speech recognition. Background Art

[0002] Entering data into Excel reports is a very common operation in the office process on PC or mobile terminals. In the specific operation process, sometimes users need to frequently switch between the two interfaces of data source and data input to complete the whole process of "reading to entering" data, or need to read data in other devices or real-life scenarios and then return to the data entry terminal to record data. The complicated click steps of switching between the two operation scenarios of data reading and entry reduce the efficiency of the operation, and there are a large number of row and column switching operations in the manual entry of report data, especially in application scenarios with large workload of data reading and entry, which further highlights the inconvenience and unfriendliness of the operation process. Summary of the invention

[0003] Based on this, the purpose of the present invention is to provide a table input method, device, equipment and storage medium for text data based on voice recognition, which obtains the characters to be input and the switching command words through voice recognition, and inputs the characters to be input into the corresponding cells with the help of the switching command words, which can effectively improve the process efficiency of data input tables, efficiently shorten the overall operation time, and liberate the labor of manual entry processes such as mouse operation and keyboard typing.

[0004] In a first aspect, an embodiment of the present application provides a method for inputting text data into a table based on speech recognition, comprising the following steps:

[0005] Acquire text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and a switching command word;

[0006] According to the position of the switching command word in the text data to be input, extract the characters between the switching command words and combine them into a plurality of character strings;

[0007] The number of rows and columns of the current cell is obtained, and the groups of character strings are input into corresponding cells according to the number of rows and columns of the current cell and the position of the switching command word in the text data to be input.

[0008] In a second aspect, an embodiment of the present application provides a form input device for text data based on speech recognition, comprising:

[0009] An acquisition module, used for acquiring text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and a switching command word;

[0010] An extraction module, used for extracting characters between the switching command words according to the positions of the switching command words in the text data to be input, and combining them into a plurality of character strings;

[0011] The input module is used to obtain the row number and column number information of the current cell, and input each group of character strings into the corresponding cell according to the row number and column number information of the current cell and the position of the switching command word in the text data to be input.

[0012] In a third aspect, an embodiment of the present application provides a computer device comprising: a processor, a memory, and a computer program stored in the memory and executable on the processor; when the computer program is executed by the processor, the steps of the table input method for text data based on speech recognition as described in the first aspect are implemented.

[0013] In a fourth aspect, an embodiment of the present application provides a storage medium storing a computer program, which, when executed by a processor, implements the steps of the table input method for text data based on speech recognition as described in the first aspect.

[0014] In an embodiment of the present application, a table input method, apparatus, device and storage medium for text data based on voice recognition are provided, which obtains the characters to be input and the switch command words through voice recognition, and inputs the characters to be input into the corresponding cells with the help of the switch command words, which can effectively improve the process efficiency of data input into the table, effectively shorten the overall operation time, and liberate the labor of manual input processes such as mouse operation and keyboard typing.

[0015] For better understanding and implementation, the present invention is described in detail below with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 A flowchart of a method for inputting text data into a table based on speech recognition provided in the first embodiment of the present application;

[0017] Figure 2 A schematic diagram of the process of S1 in the form input method of text data based on speech recognition provided in the first embodiment of the present application;

[0018] Figure 3 A schematic diagram of the process of S3 in the form input method of text data based on speech recognition provided in the first embodiment of the present application;

[0019] Figure 4A schematic diagram of the process of S3 in the form input method of text data based on speech recognition provided in the second embodiment of the present application;

[0020] Figure 5 A schematic diagram of the process of S3 in the form input method of text data based on speech recognition provided in the third embodiment of the present application;

[0021] Figure 6 A schematic diagram of the structure of a text data table input device based on speech recognition provided in the fourth embodiment of the present application;

[0022] Figure 7 A schematic diagram of the structure of a computer device provided in the fifth embodiment of the present application. DETAILED DESCRIPTION

[0023] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0024] The terms used in this application are for the purpose of describing specific embodiments only and are not intended to limit this application. The singular forms of "a", "said" and "the" used in this application and the appended claims are also intended to include plural forms unless the context clearly indicates other meanings. It should also be understood that the term "and / or" used herein refers to and includes any or all possible combinations of one or more associated listed items.

[0025] It should be understood that, although the terms first, second, third, etc. may be used in the present application to describe various information, these information should not be limited to these terms. These terms are only used to distinguish the same type of information from each other. For example, without departing from the scope of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Depending on the context, the words "if" / "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determination".

[0026] See also Figure 1 , Figure 1 A flowchart of a method for inputting text data into a table based on speech recognition provided in the first embodiment of the present application is provided. The method comprises the following steps:

[0027] S1: Acquire text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and a switching command word.

[0028] The execution subject of the table input method for text data based on speech recognition is the input device of the table input method for text data based on speech recognition (hereinafter referred to as the input device). In an optional embodiment, the input device may be a computer device or other application devices such as mobile devices that have the function of converting voice input data into report format information.

[0029] The input device can be connected to a microphone to obtain the user's voice input data, perform speech recognition on the voice input data, and obtain the text data to be input corresponding to the user's voice input data. Among them, the text data to be input includes characters to be input and switching command words.

[0030] The characters to be input include ordinary characters and special characters. Among them, the ordinary characters are characters such as letters and numbers, and the special characters are characters such as letters and punctuation marks, such as characters of types like "-", "~", and "+".

[0031] The switching command words are used to trigger the operation of switching the rows and columns of cells in the table when inputting table data. Among them, the switching command words include column switching command words and row switching command words. In an optional embodiment, the input device uses single characters such as "empty" and "turn" as the recognition words of the preset switching command words to identify the positions of the switching command words in the text data to be input in the text data to be input.

[0032] Please refer to Figure 2 , Figure 2 , which is a schematic flowchart of S1 in the table input method for text data based on speech recognition provided by the first embodiment of this application, and further includes step S101, specifically as follows:

[0033] S101: According to a preset special character conversion table, extract the characters associated with the special character recognition words recorded in the special character conversion table from the characters to be input as the characters to be replaced, convert the characters to be replaced into the special characters corresponding to the special character recognition words, and obtain the text data to be input after replacement processing.

[0034] Specifically, the special character recognition words are "bar", "plus", "multiply", "divide", etc. The special character corresponding to the special character recognition word "bar" is "-", the special character corresponding to the special character recognition word "plus" is "+", the special character corresponding to the special character recognition word "multiply" is "*", and the special character corresponding to the special character recognition word "divide" is "%".

[0035] In order to avoid the characters in the same table being too close to each other, users usually use special characters to separate them. When users use special characters to input data by voice, the special characters are easily recognized as ordinary characters. For example, when users use "-" as voice input data, the input device easily recognizes it as the word "bar".

[0036] In this embodiment, the input device obtains several special character recognition words preset by the user and their corresponding special characters, constructs the special character conversion table, extracts characters associated with the special character recognition words recorded in the special character conversion table from the characters to be input according to the special character conversion table, uses the characters to be replaced, converts the characters to be replaced into the special characters corresponding to the special character recognition words, and obtains the text data to be input after the replacement process. This avoids the display of the table data being too confusing after input, which is not easy to consult later.

[0037] S2: According to the position of the switch command word in the text data to be input, characters between the switch command words are extracted and combined into a plurality of character strings.

[0038] Since the cells are converted when the switch command words are used for table data input, in this embodiment, the input device extracts the characters between the switch command words according to the position of the switch command words in the text data to be input, and combines them into several groups of character strings, thereby dividing the text data to be input into several groups of character strings.

[0039] S3: Obtain the row number and column number information of the current cell, and input each group of character strings into a corresponding cell according to the row number and column number information of the current cell and the position of the switch command word at the text data to be input.

[0040] In this embodiment, when the user selects a cell as the input position, the input device obtains the row number and column number of the current cell, and inputs the groups of strings into the corresponding cells according to the row number and column number information of the current cell and the position of the switch command word in the text data. Specifically, the input device inputs the group of strings before the first switch command word position into the current cell, and inputs the group of strings after the first switch command word position into the next cell corresponding to the current cell; similarly, according to the positions of the remaining switch command words in the text data, the remaining groups of strings are input into the corresponding cells.

[0041] See also Figure 3 , Figure 3The flowchart of S3 in the form input method of text data based on speech recognition provided in the first embodiment of the present application includes steps S301 to S302, which are as follows:

[0042] S301: When the switch command word is a column switch command word, input the next group of character strings corresponding to the column switch command word into a cell in the same row and the next column of the table corresponding to the current cell.

[0043] In this embodiment, when the switch command word is a column switch command word, the input device obtains a group of character strings following the position of the column switch command word as the next group of character strings corresponding to the column switch command word, and inputs them into the cell in the same row and the next column of the table corresponding to the current cell, thereby completing the column change operation of the table input.

[0044] S302: When the switch command word is a row switch command word, input the next group of character strings corresponding to the row switch command word into the cell of the next row and the first column of the table corresponding to the current cell.

[0045] In this embodiment, when the switch command word is a row switch command word, the input device obtains a group of character strings following the row switch command word position as the next group of character strings corresponding to the row switch command word, and inputs them into the cell of the next row and the first column of the table corresponding to the current cell, thereby completing the row break operation of the table input. By using the switch command word, the row break and column break operations of the voice-controlled table data input are realized, thereby effectively improving the process efficiency of data input into the table.

[0046] The cell information also includes character format information of the current cell, wherein the character format information represents the format expression of the data of the current cell. In an optional embodiment, the character format information may be in text format, Arabic numeral format, integer format, etc.

[0047] See also Figure 4 , Figure 4 The flowchart of S3 in the form input method of text data based on speech recognition provided in the second embodiment of the present application further includes step S303, which is as follows:

[0048] S303: Obtaining character format information of each cell, formatting the character string in the cell according to the character format information of each cell, and obtaining the character string corresponding to the cell after the formatting process.

[0049] The character format information is the format expression of the string in the current cell, which can be Arabic numeral format or integer format;

[0050] In order to improve the distinctiveness of characters in a string input into a cell and enable users to more easily obtain a string in a corresponding data format when facing a table, in this embodiment, the input device obtains character format information of each cell pre-set by the user, formats the string in the cell according to the character format information of each cell, and obtains the string corresponding to the cell after formatting.

[0051] See also Figure 5 , Figure 5 The flowchart of S3 in the form input method of text data based on speech recognition provided in the third embodiment of the present application further includes step S304, which is as follows:

[0052] S304: In response to a cell format switching instruction, the cell format switching instruction includes cells corresponding to a target row and a target column and format switching information, and according to the format switching information, format switching processing is performed on the character strings in the cells corresponding to the target row and the target column, and the character strings corresponding to the cells after the format switching processing are obtained.

[0053] The cell format switching instruction is issued by the user and received by the input device.

[0054] In this embodiment, the input device obtains the cell format switching instruction sent by the user and responds to obtain the cell corresponding to the target row and target column and the format switching information, wherein the format switching information is used to convert the string in the cell into the target format, and the target format can be Arabic numeral format, integer format

[0055] According to the format switching information, format switching processing is performed on the character strings in the cells corresponding to the target row and the target column, and the character strings corresponding to the cells after the format switching processing are obtained.

[0056] Please refer to Figure 6 , Figure 6 This is a schematic diagram of the structure of a table input device for text data based on voice recognition provided in the fourth embodiment of the present application. The device can implement all or part of the table input device for text data based on voice recognition through software, hardware, or a combination of both. The device 6 includes:

[0057] An acquisition module 61 is used to acquire text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and a switching command word;

[0058] An extraction module 62, configured to extract characters between the switching command words according to the positions of the switching command words in the text data to be input, and combine them into a plurality of character strings;

[0059] The input module 63 is used to obtain the row number and column number information of the current cell, and input each group of character strings into the corresponding cell according to the row number and column number information of the current cell and the position of the switching command word in the text data to be input.

[0060] In this embodiment, the acquisition module is used to acquire the text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and switch command words; the extraction module is used to extract the characters between the switch command words according to the position of the switch command words in the text data to be input, and combine them into several groups of character strings; the input module is used to acquire the number of rows and columns of the current cell, and input each group of character strings into the corresponding cell according to the number of rows and columns of the current cell and the position of the switch command words in the text data to be input. By acquiring the characters to be input and the switch command words through voice recognition, and inputting the characters to be input into the corresponding cells with the help of the switch command words, the process efficiency of the data input form can be effectively improved, the overall operation time can be effectively shortened, and the labor of manual input processes such as mouse operation and keyboard typing can be liberated.

[0061] Please refer to Figure 7 , Figure 7 The structural diagram of the computer device provided for the fifth embodiment of the present application, the computer device 6 includes: a processor 71, a memory 72, and a computer program 73 stored in the memory 72 and executable on the processor 71; the computer device can store multiple instructions, and the instructions are suitable for the processor 71 to load and execute the method steps of the first, second, and third embodiments mentioned above. The specific execution process can refer to the specific description of the first, second, and third embodiments, which will not be repeated here.

[0062] Among them, the processor 71 may include one or more processing cores. The processor 71 uses various interfaces and lines to connect various parts in the server, and executes various functions and processes data of the form input device 5 based on voice recognition text data by running or executing instructions, programs, code sets or instruction sets stored in the memory 72, and calling the data in the memory 72. Optionally, the processor 71 can be implemented in at least one hardware form of digital signal processing (Digital Signal Processing, DSP), field programmable gate array (Field-Programmable Gate Array, FPGA), and programmable logic array (Programble Logic Array, PLA). The processor 71 can integrate one or more combinations of a central processing unit 71 (Central Processing Unit, CPU), a graphics processor 71 (Graphics Processing Unit, GPU) and a modem. Among them, the CPU mainly processes the operating system, user interface and application programs; the GPU is responsible for rendering and drawing the content to be displayed on the touch display screen; the modem is used to process wireless communication. It can be understood that the above-mentioned modem may not be integrated into the processor 71, and it can be implemented by a single chip.

[0063] Among them, the memory 72 may include a random access memory 72 (Random Access Memory, RAM), and may also include a read-only memory 72 (Read-Only Memory). Optionally, the memory 72 includes a non-transitory computer-readable storage medium. The memory 72 can be used to store instructions, programs, codes, code sets or instruction sets. The memory 72 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 at least one function (such as touch instructions, etc.), instructions for implementing the above-mentioned various method embodiments, etc.; the data storage area may store data involved in the above-mentioned various method embodiments, etc. The memory 72 may also be optionally at least one storage device located away from the aforementioned processor 71.

[0064] An embodiment of the present application also provides a storage medium, which can store multiple instructions. The instructions are suitable for being loaded by a processor and executing the method steps of the above-mentioned first, second, and third embodiments. The specific execution process can be found in the specific description of the first, second, and third embodiments, which will not be repeated here.

[0065] The technicians in the relevant field can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In practical applications, the above-mentioned function allocation can be completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, which will not be repeated here.

[0066] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0067] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraint algorithm of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0068] In the embodiments provided by the present invention, it should be understood that the disclosed devices / terminal equipment and methods can be implemented in other ways. For example, the device / terminal equipment embodiments described above are only schematic. For example, the division of the modules or units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0069] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0070] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0071] If the integrated module / unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of each of the above-mentioned method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form, etc.

[0072] The present invention is not limited to the above-mentioned embodiments. If various changes or modifications to the present invention do not depart from the spirit and scope of the present invention, and if these changes and modifications fall within the scope of the claims and equivalent technologies of the present invention, the present invention is also intended to include these changes and modifications.

Claims

1. A method for inputting text data into a table based on speech recognition, characterized in that: The following steps are involved: Acquire voice input data of the user, and text data to be input corresponding to the voice input data, wherein the text data to be input includes characters to be input and a switch command word, and the switch command word includes a column switch command word and a row switch command word; According to the position of the switching command word in the text data to be input, extract the characters between the switching command words and combine them into a plurality of character strings; Obtaining the row number and column number information of the current cell, and according to the row number and column number information of the current cell and the position of the switch command word at the text data to be input, when the switch command word is a column switch command word, inputting the next group of character strings corresponding to the column switch command word into the cell of the same row and the next column of the table corresponding to the current cell; When the switch command is a row switch command, the next group of character strings corresponding to the row switch command is input into the next row and the first column of the table corresponding to the current cell, and each group of character strings is input into the corresponding cell.

2. The method for inputting text data into a table based on speech recognition according to claim 1, characterized in that: The method of obtaining the user's voice input data and the text data to be input corresponding to the voice input data comprises the following steps: According to a preset special character conversion table, characters associated with the special character recognition words recorded in the special character conversion table are extracted from the characters to be input as characters to be replaced, and the characters to be replaced are converted into special characters corresponding to the special character recognition words to obtain the text data to be input after the replacement processing, wherein the special character conversion table includes several special character recognition words and their corresponding special characters.

3. The form input method of text data based on speech recognition according to claim 1, characterized in that: The step of inputting each group of character strings into a corresponding cell according to the cell information and the switching command word at the position of the text data to be input also includes the steps of: The character format information of each cell is obtained, wherein the character format information is a format expression of data in the current cell, and the character string in the cell is formatted according to the character format information of each cell, and the character string corresponding to the cell after the formatting is obtained.

4. The form input method of text data based on speech recognition according to claim 1, characterized in that: The step of inputting each group of character strings into a corresponding cell according to the cell information and the switching command word at the position of the text data to be input also includes the steps of: In response to a cell format switching instruction, the cell format switching instruction includes cells corresponding to a target row and a target column and format switching information. According to the format switching information, format switching processing is performed on the character strings in the cells corresponding to the target row and the target column, and the character strings corresponding to the cells after the format switching processing are obtained.

5. A text data table input device based on speech recognition, characterized in that: include: An acquisition module, used for acquiring text data to be input corresponding to the user's voice input data, wherein the text data to be input includes characters to be input and a switching command word, and the switching command word includes a column switching command word and a row switching command word; An extraction module, used for extracting characters between the switching command words according to the positions of the switching command words in the text data to be input, and combining them into a plurality of character strings; An input module, used for obtaining the row number and column number information of the current cell, and according to the row number and column number information of the current cell and the position of the switch command word in the text data to be input, when the switch command word is a column switch command word, inputting the next group of character strings corresponding to the column switch command word into the cell of the same row and the next column of the table corresponding to the current cell; When the switch command is a row switch command, the next group of character strings corresponding to the row switch command is input into the next row and the first column of the table corresponding to the current cell, and each group of character strings is input into the corresponding cell.

6. A computer device, characterized in that: include: A processor, a memory, and a computer program stored in the memory and executable on the processor; when the computer program is executed by the processor, the steps of the form input method for text data based on speech recognition as described in any one of claims 1 to 4 are implemented.

7. A storage medium, characterized in that: The storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the form input method of text data based on speech recognition as claimed in any one of claims 1 to 5 are implemented.

Images