A method, device, computer storage medium and terminal for realizing data processing

Abstract

The present invention discloses a method, an apparatus, a computer storage medium and a terminal for implementing data processing. In an embodiment of the present invention, after determining the data type and the cell to be written to the data to be written into a spreadsheet, when it is judged that the matching type of the cell to be written is different from the data type, the data with the matching type and the data type different from the data type are rejected from being written into the cell to be written, thereby avoiding the writing of data that does not match the cell matching type, standardizing the data type of the data written into the spreadsheet, preventing data statistical errors caused by writing data that does not match the matching type into the cell, and providing a basis for improving the accuracy of data statistics when using the data in the spreadsheet for data statistics.

Description

Technical Field

[0001] This article relates to but is not limited to automated office technology, and in particular to a method, device, computer storage medium and terminal for implementing data processing. Background Art

[0002] Spreadsheets can be used to input data, display data, and calculate some simple addition and subtraction using formulas. By creating complex spreadsheet documents, users can perform tedious data calculations. In data statistics-related work, the frequency of use of spreadsheets remains high, such as using spreadsheets to create personnel reports, financial reports, etc.

[0003] In a conventional spreadsheet, a cell is a numeric cell when numbers are filled in, and a cell is a text cell when words are filled in. In order to facilitate data statistics, the data written into the spreadsheet will be standardized. Generally, the data type of the data to be written into the spreadsheet can be set by the user manually configuring the data type that can be written into the cell.

[0004] After writing data in a cell, if you set the data type that can be written to the cell, in order to avoid the data type of the data previously entered in the cell being different from the set data type, it is generally necessary to re-enter the data. Summary of the invention

[0005] The following is a summary of the subject matter described in detail herein. This summary is not intended to limit the scope of the claims.

[0006] The embodiments of the present invention provide a method, an apparatus, a computer storage medium and a terminal for implementing data processing, which can provide a basis for improving the accuracy of data statistics in electronic spreadsheets.

[0007] An embodiment of the present invention provides a method for implementing data processing, including:

[0008] Before writing data into a cell of a spreadsheet, determine the data type and the cell to be written;

[0009] When it is determined that the matching type of the cell to be written is different from the data type of the determined data, refusing to write the data in the cell to be written;

[0010] The matching type refers to the data type of the writable data set in the pre-configured cell.

[0011] In an exemplary embodiment, after determining the data type of the data and the cell to be written, the method further includes:

[0012] When it is determined that the matching type is the same as the data type, the data is written into the cell to be written.

[0013] In an exemplary embodiment, when it is determined that the matching type of the cell to be written is different from the data type of the determined data, the method further includes:

[0014] Feedback is given of prompt information that the matching type of the cell to be written is different from the data type of the determined data.

[0015] In an exemplary embodiment, after refusing to write data in the cell to be written, the method further includes:

[0016] When it is determined that the matching type is different from the data type, determining the matching type of each cell other than the cell to be written;

[0017] Determining the matching type that is the same as the data type;

[0018] According to the received external instruction, it is determined whether to write the data into a cell corresponding to the determined matching type which is the same as the data type.

[0019] In an exemplary embodiment, after determining the matching type that is the same as the data type, the method further includes:

[0020] The location information of cells whose matching type is the same as the data type is displayed in the electronic table in a preset manner.

[0021] In an exemplary embodiment, the method further comprises:

[0022] For one or more cells, a data input box corresponding to the matching type of the cell is set.

[0023] In an exemplary embodiment, before determining the data type of the data and the cell to be written, the method further includes:

[0024] The electronic table is drawn according to the preset number of rows m and the number of columns n.

[0025] In an exemplary embodiment, the method further comprises:

[0026] According to the preset correspondence between the matching type and the cell format, corresponding cell formats are set for cells of more than one matching type;

[0027] Wherein, the cell format includes: row height and / or column width.

[0028] In an exemplary embodiment, the method further comprises:

[0029] determining a user editing the electronic form;

[0030] The editing authority of the user who edits the electronic form is managed according to the pre-set editing authority of each user.

[0031] In an exemplary embodiment, the method further comprises:

[0032] The user's editing information on the electronic form is recorded in a preset area of ​​the electronic form.

[0033] On the other hand, an embodiment of the present invention further provides a computer storage medium, wherein the computer storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned method for realizing data processing is implemented.

[0034] In another aspect, an embodiment of the present invention further provides a terminal, comprising: a memory and a processor, wherein the memory stores a computer program; wherein:

[0035] The processor is configured to execute the computer program in the memory;

[0036] When the computer program is executed by the processor, the method for data processing as described above is implemented.

[0037] In another aspect, an embodiment of the present invention further provides a device for implementing data processing, comprising: a determining unit and a processing unit; wherein:

[0038] The determination unit is set to: before writing data into a cell of the spreadsheet, determine the data type of the data and the cell to be written;

[0039] The processing unit is configured to: when it is determined that the matching type of the cell to be written is different from the data type of the determined data, refuse to write data into the cell to be written;

[0040] The matching type refers to the data type of the writable data set in the pre-configured cell.

[0041] The embodiment of the present invention determines the data type and the cell to be written to the data to be written into the electronic form, and when it is judged that the matching type of the cell to be written is different from the data type, refuses to write the data whose matching type is different from the data type into the cell to be written, thereby avoiding the writing of data that does not match the matching type of the cell, standardizing the data type of the data written into the electronic form, preventing data statistical errors caused by writing data that does not match the matching type into the cell, and providing a basis for improving the accuracy of data statistics when using the data in the electronic form for data statistics.

[0042] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] The accompanying drawings are used to provide a further understanding of the technical solution of the present invention and constitute a part of the specification. Together with the embodiments of the present application, they are used to explain the technical solution of the present invention and do not constitute a limitation on the technical solution of the present invention.

[0044] Figure 1 A flowchart of a method for implementing data processing according to an embodiment of the present invention;

[0045] Figure 2 It is a setting interface of the data input box of the embodiment of the present invention;

[0046] Figure 3 is a schematic diagram of an example electronic spreadsheet of the present invention;

[0047] Figure 4 The present invention is a block diagram of a device for implementing data processing according to an embodiment of the present invention. DETAILED DESCRIPTION

[0048] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail with reference to the accompanying drawings. It should be noted that the embodiments and features in the embodiments of the present application can be combined with each other arbitrarily without conflict.

[0049] The steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions. Also, although a logical sequence is shown in the flowchart, in some cases, the steps shown or described can be performed in a sequence different from that shown here.

[0050] The inventor of the present application has analyzed and found that: even if the configuration of the data type of the data that can be written into the cell is completed, it is easy for the data type of the data written into the cell to be inconsistent with the set writable data type, resulting in errors in the subsequent data statistics using the data written into the cell, requiring the user to manually check. Table 1 is an application example of a related art spreadsheet. For example, in cell A3 in Table 1, the spreadsheet recognizes the input data as the value 7.11 by default, rather than the date July 11; in cell D3, the spreadsheet recognizes the data as the text "3 units" by default, rather than the value 3; these will cause errors in subsequent data statistics.

[0051] A B C D 1 date client Product Name Purchase quantity 2 2020 / 7 / 8 Company A Product 1 10 3 7.11 Company B Product 2 3 units

[0052] Table 1

[0053] Figure 1 Flow chart of a method for implementing data processing in an embodiment of the present invention, such as Figure 1 As shown, including:

[0054] Step 101, before writing data into a cell of the electronic spreadsheet, determine the data type and the cell to be written;

[0055] In an exemplary embodiment, the embodiment of the present invention writes data in a cell including but not limited to: writing data by importing, copying, cutting and directly entering data. Wherein, writing data by directly entering includes but not limited to: data inputted by a human body input device.

[0056] In an exemplary embodiment, the data type of the data can be determined by: analyzing the data composition structure of the data to be written by a string analysis method, and determining its data type according to the analysis result. In an exemplary embodiment of the present invention, other analysis methods can also be used to analyze the acquired data to be written to determine the data type of the data to be written.

[0057] In an illustrative example, the cell to be written may be determined in the following manner:

[0058] By identifying the cell selected by the user when performing the operation to be written; identifying the selected cell includes: identifying the cell in the selected state and identifying the cell where the cursor is located;

[0059] When writing data in import mode, determine the starting point of the data import of the spreadsheet, that is, the starting cell for writing data; take the cell where the starting point is located as the starting point, and determine the number of rows and columns of the cell according to the data to be imported; obtain the number of rows and columns of the set cell to the right and downward respectively, and determine the cell corresponding to the number of rows and columns as the area to be imported; import the data to be imported into the cells corresponding to the area to be imported in rows / columns. Among them, the starting cell can be the default cell of the first row and the first column; it can also be the cell selected by the cursor, or it can be the cell corresponding to the cursor position.

[0060] In an exemplary embodiment, the write instruction includes: information such as the data to be written, the row and column of the cell where the data is to be written, etc. The write instruction may be inputted by, but not limited to, keyboard, mouse, stylus or voice.

[0061] Step 102: when it is determined that the matching type of the cell to be written is different from the data type of the determined data, refusing to write data into the cell to be written;

[0062] The matching type refers to the data type of the writable data set in the pre-configured cell.

[0063] It should be noted that the data type of the writable data set in the cell can be configured in the following manner: receiving a setting instruction for setting the cell input by the user; the setting instruction may include: the cell area to be set and the data type of the writable data in the cell.

[0064] In an exemplary embodiment, the matching type is generally determined by reading the configuration information of the cells of the spreadsheet; the configuration information is generally stored in a physical file that records the cell attributes, and the matching type in the configuration information can be read from the physical file with reference to related technologies.

[0065] In an exemplary embodiment, when it is determined that the matching type of the cell to be written is different from the data type of the determined data, the method of the embodiment of the present invention further includes:

[0066] Feedback prompt information that the matching type of the cell to be written is different from the data type of the determined data.

[0067] It should be noted that the prompt information can be displayed through a pre-set pop-up interface.

[0068] In an exemplary embodiment, the embodiment of the present invention can configure the matching type of a cell in the following manner:

[0069] Determine the input direction of the spreadsheet;

[0070] When the input direction is vertical, configure the matching type of each column cell by column;

[0071] When the input direction is horizontal, configure the matching type of each row of cells by row.

[0072] It should be noted that the above-mentioned definition of vertical or horizontal in the embodiment of the present invention is common knowledge to those skilled in the art; wherein, when data of the same data type is written into a spreadsheet by column, the input direction is vertical; and when data of the same data type is written into a spreadsheet by row, the input direction is horizontal. The following explains the input direction through a horizontal application example: it is assumed that when the user organizes the data, the data type recorded in the cells in the same row is pre-set to be the same, that is, the input direction of the spreadsheet is determined to be horizontal. For example: the cells in the first row are used to record data of a date data type, the cells in the second row are used to record data of an email data type, and the cells in the third row are used to record data of a telephone data type, then the input direction of the data is horizontal; similarly, when the data type recorded in the cells in the same column is set to be the same, the input direction of the data is vertical.

[0073] The embodiment of the present invention avoids writing data that does not match the cell matching type into a cell by refusing to write data whose data type is different from the matching type into the cell to be written. By standardizing the data type of data written into the spreadsheet, a basis is provided for improving the accuracy of data statistics when the data recorded in the spreadsheet is subsequently used for data statistics.

[0074] The write instruction of the embodiment of the present invention is not executed before completing the determination of whether the matching type and the data type are the same. When it is determined that the matching type and the data type are not the same, the embodiment of the present invention does not continue to execute the subsequent operation of writing the data to be written into the cell.

[0075] In an exemplary embodiment, after determining the data type and the cell to be written in step 101, the method of the embodiment of the present invention further includes:

[0076] When it is determined that the matching type is the same as the data type, the data is written into the cell to be written.

[0077] It should be noted that whether the matching type is the same as the data type can be directly determined by comparison.

[0078] The embodiment of the present invention determines the data type and the cell to be written to the data to be written into the electronic form, and when it is judged that the matching type of the cell to be written is different from the data type, refuses to write the data whose matching type is different from the data type into the cell to be written, thereby avoiding the writing of data that does not match the matching type of the cell, standardizing the data type of the data written into the electronic form, preventing data statistical errors caused by writing data that does not match the matching type into the cell, and providing a basis for improving the accuracy of data statistics when using the data in the electronic form for data statistics.

[0079] In an exemplary embodiment, the data type and matching type in the embodiment of the present invention may include one or any combination of the following: text, value, date, and ID number. In an exemplary embodiment, the data type and matching type in the embodiment of the present invention may also include other data types set by the user according to the usage scenario, such as batch number, email address, phone number, grade, contact person, price, address, etc.

[0080] In an exemplary embodiment, after step 102 of refusing to write data in the cell to be written, the method of the embodiment of the present invention further includes:

[0081] When it is determined that the matching type is different from the data type, the matching type of each cell other than the cell to be written is determined;

[0082] Determine the matching type that is the same as the data type;

[0083] According to the received external instruction, determine whether to write data into the determined cell corresponding to the matching type with the same data type. Wherein, determine whether to write data into the determined cell corresponding to the matching type with the same data type, and display the cell corresponding to the matching type with the same data type to the user in a pop-up window, and write the data according to the user's selection result. When displaying the cells corresponding to the matching type with the same data type to the user, the cells can be sorted according to the length of time since the last operation on the cells, which is not limited here.

[0084] After the embodiment of the present invention refuses to write data in the cell to be written, it determines whether to write the data into the cell corresponding to the determined matching type with the same data type according to the received external instruction; that is, when processing the data to be written, before writing the data into the cell whose matching type is different from the data type of the data to be written, the processing of the embodiment of the present invention can prompt the user to write the data into the cell whose matching type is the same as the data type of the data to be written, thereby improving the data writing efficiency when the cell to be written is set incorrectly.

[0085] In an exemplary embodiment, after determining the matching type that is the same as the data type, the method of the embodiment of the present invention further includes:

[0086] Displays the location information of cells with the same matching type and data type in a spreadsheet by default.

[0087] In an exemplary embodiment, the preset method of the embodiment of the present invention may include one or any combination of the following: lines of different thicknesses that are different from other cells, preset background fills, and text information that identifies the rows and columns of the cells.

[0088] The embodiment of the present invention displays the location information of cells whose matching type is the same as the data type. When writing data to cells that are rejected from being written, the user can intuitively obtain the location of cells whose matching type is the same as the data type, and then process whether the data is written to cells whose matching type is the same as the data type.

[0089] In an exemplary embodiment, before writing data into a cell of the electronic spreadsheet in step 101, the method of the embodiment of the present invention further includes:

[0090] For one or more cells, set the data input box corresponding to its matching type.

[0091] In an exemplary embodiment, the data input box can be set according to different matching types. For example, when the matching type is date, the data input box can be a date selection panel; when the matching type is text, the data input box can be a regular text input box. Figure 2 Schematic diagram of the setting interface of the data input box of the embodiment of the present invention, such as Figure 2 As shown, after selecting a cell, the data input box can be selected and set through the interactive interface that pops up in the spreadsheet.

[0092] The embodiment of the present invention can ensure that the data type of the written data is the same as the matching type of the pre-configured cell by setting an input box for data writing.

[0093] In an exemplary embodiment, before step 101 determines the data type of the data and the cell to be written, the method of the embodiment of the present invention further includes:

[0094] Draw a spreadsheet according to the preset number of rows m and columns n, where m and n are positive integers.

[0095] In an exemplary embodiment, the embodiment of the present invention can load a program window for drawing a spreadsheet by loading a spreadsheet application, and draw the spreadsheet in the loaded program window.

[0096] In an exemplary embodiment, the embodiment of the present invention can create an electronic form according to a received creation instruction for creating an electronic form; the creation instruction includes: the number of rows m and the number of columns n of the electronic form. The method for drawing an electronic form in the embodiment of the present invention is the same as the principle of drawing an electronic form with fixed rows and columns in the related art. Figure 3 A schematic diagram of an example electronic spreadsheet of the present invention is shown in FIG. Figure 3 As shown, the spreadsheet only contains cells of m rows and n columns. Except for the drawn cells of m rows and n columns, other areas without cells are blank areas. Cell drawing, cell selection, and data writing to cells cannot be performed in the blank areas.

[0097] It should be noted that the number of rows m and the number of columns n of the electronic table drawn in the embodiment of the present invention can be set by the user according to the specific business of the electronic table; that is, for different businesses, the corresponding number of rows m and the number of columns n are set according to the data type and data volume contained in the business. After drawing the electronic table with the number of rows m and the number of columns n, other cells will not be drawn in the electronic table of the embodiment of the present invention. Therefore, the user cannot write data in areas other than the drawn cells, thereby realizing standardized management of the electronic table.

[0098] In an exemplary embodiment, before step 101, the method of the embodiment of the present invention further includes:

[0099] According to the correspondence between the preset matching types and the cell formats, corresponding cell formats are set for cells of one or more matching types;

[0100] The cell format includes: row height and / or column width.

[0101] It should be noted that the toolbar of the spreadsheet contains format options for adjusting the row height and column width of cells. When setting the cell format, the embodiment of the present invention can be implemented based on the options of the configuration format. When loading the spreadsheet, the row height and / or column width of the cell is determined directly according to the correspondence between the pre-set matching type and the cell format in the embodiment of the present invention; the cell format is adjusted according to the function of adjusting the row height and column width in the toolbar. By adjusting the cell format, the embodiment of the present invention can make the row height and column width of the cell load and display the data written to the cell more clearly and completely, and the user can also more intuitively check the data written in the cell. For example: for a cell whose data type is date and the date format is yyyy-mm-dd, the column width of the cell is adjusted to 11 characters.

[0102] In an exemplary embodiment, before step 101, the method of the embodiment of the present invention further includes:

[0103] Identify the user who edited the spreadsheet;

[0104] The editing authority of the users who edit the electronic form is managed according to the pre-set editing authority of each user.

[0105] In an exemplary instance, users of an embodiment of the present invention can be distinguished by user accounts; accordingly, editing permissions are set by user accounts; editing permissions include one or any combination of the following: prohibited from viewing, viewable and modifiable; wherein modification includes one or any combination of the following: adding, deleting and adjusting.

[0106] In an exemplary embodiment, the method of the embodiment of the present invention further includes:

[0107] Recording the user's editing information of the electronic form in a preset area of ​​the electronic form;

[0108] The editing information includes: editing time and / or editing user's account information.

[0109] In an exemplary embodiment, the editing time in the embodiment of the present invention includes: creation time and / or modification time; the editing user includes: creator and / or modifier.

[0110] In an exemplary embodiment, the present invention can set a fixed row or column in the electronic form as a preset area for recording the above editing information. The preset area can also be: one side of the text area; or a pop-up window area floating above the text.

[0111] In an exemplary embodiment, the embodiment of the present invention can set the edit information of the record to be unmodifiable, for example, setting the edit information to be viewable only. The embodiment of the present invention can use the worksheet protection function to set the cell recording the edit information to be viewable only.

[0112] The embodiment of the present invention can detect each editing of the user through relevant technologies, and obtain the editing information from the information including the log when the editing operation is detected.

[0113] An embodiment of the present invention further provides a computer storage medium, in which a computer program is stored. When the computer program is executed by a processor, the above-mentioned method for realizing data processing is implemented.

[0114] The embodiment of the present invention further provides a terminal, comprising: a memory and a processor, wherein a computer program is stored in the memory; wherein:

[0115] The processor is configured to execute the computer program in the memory;

[0116] When the computer program is executed by a processor, the method for implementing data processing as described above is implemented.

[0117] Figure 4 FIG. 1 is a structural block diagram of a device for implementing data processing according to an embodiment of the present invention, such as Figure 4 As shown, it includes: a determination unit and a processing unit; wherein,

[0118] The determination unit is set to: before writing data into a cell of the spreadsheet, determine the data type of the data and the cell to be written;

[0119] The processing unit is configured to: when it is determined that the matching type of the cell to be written is different from the data type of the determined data, refuse to write data into the cell to be written;

[0120] The matching type includes: the data type of the writable data set in the pre-configured cell.

[0121] The embodiment of the present invention determines the data type and the cell to be written to the data to be written in the electronic form, and when it is judged that the matching type of the cell to be written is different from the data type, refuses to write the data whose matching type is different from the data type in the cell to be written, thereby avoiding the writing of data of a data type that does not match the matching type of the cell, reducing the data statistical errors caused by writing data that does not match the matching data in the cell, and providing a basis for improving the accuracy of data statistics in the electronic form.

[0122] In an exemplary embodiment, the processing unit of the embodiment of the present invention is further configured to:

[0123] When it is determined that the matching type is the same as the data type, the data is written into the cell to be written.

[0124] In an exemplary embodiment, the device of the embodiment of the present invention further includes a prompting unit, which is configured to:

[0125] When the processing unit determines that the matching type of the cell to be written is different from the data type of the determined data, it feeds back prompt information that the matching type of the cell to be written is different from the data type of the determined data.

[0126] In an exemplary embodiment, the processing unit of the embodiment of the present invention is further configured to:

[0127] When it is determined that the matching type is different from the data type, the matching type of each cell other than the cell to be written is determined;

[0128] Determine the matching type that is the same as the data type;

[0129] According to the received external instruction, it is determined whether to write data into a cell corresponding to the determined matching type that is the same as the data type.

[0130] In an exemplary embodiment, the device of the embodiment of the present invention further includes a feedback display unit, which is configured to:

[0131] After the matching type identical to the data type is determined, the location information of the cells whose matching type is identical to the data type is displayed in the spreadsheet in a preset manner.

[0132] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a setting unit, which is configured to:

[0133] For one or more cells, set the data input box corresponding to the matching type of the cell.

[0134] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a table generating unit, which is configured as follows:

[0135] In the drawing area, a spreadsheet is drawn according to the preset number of rows m and the number of columns n.

[0136] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a format unit, which is configured as follows:

[0137] According to the preset correspondence between the matching type and the cell format, corresponding cell formats are set for cells of more than one matching type;

[0138] The cell format includes: row height and / or column width.

[0139] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a rights management unit, which is configured to:

[0140] Identify the user who edited the spreadsheet;

[0141] The editing authority of the users who edit the electronic form is managed according to the pre-set editing authority of each user.

[0142] In an exemplary embodiment, the apparatus of the embodiment of the present invention further includes a recording unit configured to:

[0143] Recording the user's editing information of the electronic form in a preset area of ​​the electronic form;

[0144] The editing information includes: editing time and / or editing user's account information.

[0145] “A person skilled in the art will appreciate that all or some of the steps, systems, and functional modules / units in the above disclosed methods may be implemented as software, firmware, hardware, and appropriate combinations thereof. In hardware implementations, the division between the functional modules / units mentioned in the above description does not necessarily correspond to the division of physical components; for example, a physical component may have multiple functions, or a function or step may be performed by several physical components in cooperation. Some or all components may be implemented as software executed by a processor, such as a digital signal processor or a microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or a non-transitory medium) and a communication medium (or a transient medium). As is known in the art, As is well known to those skilled in the art, the term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, as is well known to those skilled in the art, communication media typically contains computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media".

Claims

1. A method for implementing data processing, comprising: Before writing data into a cell of a spreadsheet, determine the data type and the cell to be written; When it is determined that the matching type of the cell to be written is different from the data type of the determined data, refusing to write the data in the cell to be written; The matching type refers to: the data type of the writable data set in the pre-configured cell; After refusing to write data in the cell to be written, the method further includes: determining the matching types of other cells except the cell to be written when it is judged that the matching type is different from the data type; determining the matching type that is the same as the data type; and determining whether to write the data into the cell corresponding to the determined matching type that is the same as the data type based on the received external instruction.

2. The method according to claim 1, characterized in that After determining the data type of the data and the cell to be written, the method further includes: When it is determined that the matching type is the same as the data type, the data is written into the cell to be written.

3. The method according to claim 1, characterized in that When it is determined that the matching type of the cell to be written is different from the data type of the determined data, the method further includes: Feedback is given of prompt information that the matching type of the cell to be written is different from the data type of the determined data.

4. The method according to claim 1, characterized in that After determining the matching type that is the same as the data type, the method further includes: The location information of cells whose matching type is the same as the data type is displayed in the electronic table in a preset manner.

5. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: For one or more cells, a data input box corresponding to the matching type of the cell is set.

6. The method according to any one of claims 1 to 4, characterized in that: Before determining the data type of the data and the cell to be written, the method further includes: The electronic table is drawn according to the preset number of rows m and the number of columns n.

7. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: According to the correspondence between the preset matching types and the cell formats, corresponding cell formats are set for cells of more than one matching type; Wherein, the cell format includes: row height and / or column width.

8. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: determining a user editing the electronic form; According to the preset editing authority of each user, editing authority management is performed on the users who edit the electronic form.

9. The method according to any one of claims 1 to 4, characterized in that: The method further comprises: The user's editing information on the electronic form is recorded in a preset area of ​​the electronic form.

10. A computer storage medium, wherein a computer program is stored in the computer storage medium, and when the computer program is executed by a processor, the method for realizing data processing according to any one of claims 1 to 9 is implemented.

11. A terminal, comprising: A memory and a processor, wherein the memory stores a computer program; wherein, The processor is configured to execute the computer program in the memory; When the computer program is executed by the processor, the method for implementing data processing according to any one of claims 1 to 9 is implemented.

12. A device for implementing data processing, comprising: Determine the unit and the processing unit; wherein, The determination unit is set to: before writing data into a cell of the spreadsheet, determine the data type of the data and the cell to be written; The processing unit is configured to: when it is determined that the matching type of the cell to be written is different from the data type of the determined data, refuse to write data into the cell to be written; The processing unit is further configured to: determine the matching type of each cell other than the cell to be written when it is determined that the matching type is different from the data type; determine the matching type that is the same as the data type; and determine whether to write the data into the cell corresponding to the determined matching type that is the same as the data type according to the received external instruction; The matching type refers to the data type of the writable data set in the pre-configured cell.

Images