Table editing method and device, computer equipment and readable storage medium

Abstract

The invention relates to a table editing method and device, computer equipment, a computer readable storage medium and a computer program product. The method comprises the following steps: acquiring a target table, and sending the target table to a plurality of user terminals; for each user terminal in the plurality of user terminals, receiving an editing result sent by the user terminal in real time in the process that the user terminal edits the target table received by the user terminal based on an editing request input by a corresponding user of the user terminal; and sending the editing result to other user terminals in the plurality of user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result. According to the method provided by the invention, the table editing efficiency can be improved in a multi-person online collaborative editing scene.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a table editing method, apparatus, computer equipment and computer-readable storage medium. Background Art

[0002] With the development of computer technology, electronic spreadsheets appear more and more frequently in people's work and daily life. Electronic spreadsheets have greatly improved people's work efficiency, and editing electronic spreadsheets has become a basic skill. In the existing method, only a single user can edit the electronic spreadsheet. In the scenario where multiple users need to edit the same electronic spreadsheet, the efficiency of this method is low. Summary of the invention

[0003] Based on this, it is necessary to provide a table editing method, device, computer equipment and computer-readable storage medium that can improve the efficiency of editing electronic tables in order to solve the above technical problems.

[0004] In a first aspect, the present application provides a table editing method, the method comprising:

[0005] Acquire a target table, and send the target table to multiple user terminals;

[0006] For each of the plurality of user terminals, in a process in which the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, receiving in real time the editing result sent by the user terminal;

[0007] The editing result is sent in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target table received by the other user terminals based on the editing result.

[0008] In one embodiment, the method further comprises:

[0009] Before the user terminal edits the target table received by the user terminal based on the editing request input by the user corresponding to the user terminal, the editing authority of the user corresponding to the user terminal is sent to the user terminal so that the user terminal verifies the editing request based on the editing authority.

[0010] In one embodiment, the editing permission includes an editable area corresponding to the user of the user terminal in the target table, and editing operations executable by the user terminal.

[0011] In one embodiment, after the real-time acceptance of the editing result sent by the user terminal, the method further includes:

[0012] Acquire a preset data verification rule, and verify the editing result based on the preset data verification rule;

[0013] If the verification result indicates that the edited content of the user terminal satisfies the preset data verification rule, sending the edited result to other user terminals among the multiple user terminals in real time;

[0014] When the verification result indicates that the edited content of the user terminal does not satisfy the preset data verification rule, an alarm message is sent to the user terminal.

[0015] In one of the embodiments, the preset data verification rules include whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within a preset data range.

[0016] In one embodiment, the editing result is compressed by the user terminal and then sent to the server; the real-time receiving of the editing result sent by the user terminal includes:

[0017] The editing result is decompressed, and the decompressed editing result is sent to the other user terminal.

[0018] In one of the embodiments, data transmission between the multiple user terminals and the server is based on a full-duplex communication protocol.

[0019] In a second aspect, the present application further provides a table editing device, the device comprising:

[0020] An acquisition module, used for acquiring a target table and sending the target table to a plurality of user terminals;

[0021] a receiving module, configured to receive, for each of the plurality of user terminals, in real time, an editing result sent by the user terminal during a process in which the user terminal edits a target table received by the user terminal based on an editing request input by a corresponding user of the user terminal;

[0022] The sending module is used to send the editing result to other user terminals among the multiple user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result.

[0023] In a third aspect, the present application further provides a computer device, which includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the method in any one of the above embodiments when executing the computer program.

[0024] In a fourth aspect, the present application further provides a computer-readable storage medium, wherein a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method in any one of the above embodiments are implemented.

[0025] The table editing method, device, computer equipment, computer-readable storage medium and computer program product obtain a target table and send the target table to multiple user terminals; for each of the multiple user terminals, in the process of editing the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, the editing result sent by the user terminal is received in real time; the editing result is sent in real time to other user terminals in the multiple user terminals, so that the other user terminals update the target table received by the other user terminals based on the editing result. The method provided by the present application can improve the efficiency of table editing in a multi-person online collaborative editing scenario. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions 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 related drawings can be obtained based on these drawings without paying creative work.

[0027] FIG1 is an application environment diagram of a table editing method in one embodiment;

[0028] FIG2 is a schematic diagram of a flow chart of a table editing method in one embodiment;

[0029] FIG3 is a schematic diagram of a flow chart of an editing result verification scheme in one embodiment;

[0030] FIG4 is a structural block diagram of a table editing device in one embodiment;

[0031] FIG. 5 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0032] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0033] The table editing method provided in the embodiment of the present application can be applied in the application environment shown in FIG. 1. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. The server 104 sends the acquired target table to multiple terminals 102, and receives the editing results for the target table sent by the terminal 102. Among them, the terminal 102 can be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, Internet of Things devices and portable wearable devices. The Internet of Things devices can be smart speakers, smart TVs, smart air conditioners, smart car devices, projection devices, etc. Portable wearable devices can be smart watches, smart bracelets, head-mounted devices, etc. The head-mounted device can be a virtual reality (VR) device, an augmented reality (AR) device, smart glasses, etc. The server 104 can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides cloud computing services.

[0034] In an exemplary embodiment, as shown in FIG2 , a table editing method is provided, which is described by taking the method applied to the server in FIG1 as an example, and includes the following steps 202 to 206. Among them:

[0035] S202: Acquire a target table, and send the target table to multiple user terminals.

[0036] The target table is a spreadsheet, which is a computer software tool used to create, edit, store and analyze data.

[0037] Optionally, the target table may be created according to user needs, or may be directly imported from a database, which is not specifically limited in the embodiments of the present application.

[0038] S204 . For each of the multiple user terminals, in the process of the user terminal editing the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, receiving the editing result sent by the user terminal in real time.

[0039] Optionally, editing operations on the target table include, but are not limited to, data input, cell content editing, format setting, cell operation, function calculation, and filtering and sorting.

[0040] S206: Send the editing result to other user terminals among the multiple user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result.

[0041] Among them, other user terminals will perform the same editing operation as in the editing result on the received target table, so that when one user terminal edits the target table, the target tables displayed by all user terminals will have the same changes.

[0042] In the above table editing method, a target table is obtained and sent to multiple user terminals; for each of the multiple user terminals, in the process of editing the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, the editing result sent by the user terminal is received in real time; the editing result is sent to other user terminals in the multiple user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result. The method provided by the present application can improve the efficiency of table editing in a multi-person online collaborative editing scenario.

[0043] In some embodiments, the method further includes: before the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, sending the editing authority of the corresponding user of the user terminal to the user terminal, so that the user terminal verifies the editing request based on the editing authority.

[0044] Among them, the editing permission is used to control the user's ability to modify, add, delete, and other operations on the table content. The editing permission specifies which users can access the target table and what operations these users can perform on the target table. Different editing permissions can be set for different users. For example, some users have read-only permissions, some users can only edit part of the content, and some users can edit all the content.

[0045] Optionally, if the editing request does not comply with the editing authority of the corresponding user, a warning message will pop up on the display screen of the user terminal to remind the user that he does not have the corresponding editing authority.

[0046] In this embodiment, the editing request is verified based on the editing authority, which can effectively ensure the security of the target table.

[0047] In some embodiments, the editing permission includes an editable area corresponding to a user of the user terminal in the target table, and editing operations executable by the user terminal.

[0048] In some embodiments, as shown in FIG3 , after receiving the editing result sent by the user terminal in real time, the method further includes:

[0049] S302: Obtain preset data verification rules, and verify the editing result based on the preset data verification rules.

[0050] S304: When the verification result indicates that the edited content of the user terminal meets the preset data verification rule, the editing result is sent in real time to other user terminals among the multiple user terminals.

[0051] S306: When the verification result indicates that the edited content of the user terminal does not satisfy the preset data verification rule, send an alarm message to the user terminal.

[0052] Among them, the preset data verification rules are used to ensure that the data in the table conforms to specific formats and conditions to prevent erroneous or inconsistent data from being entered.

[0053] In this embodiment, the editing result is verified based on the preset data verification rules, which can effectively prevent incorrect content from being input into the target table.

[0054] In some embodiments, the preset data verification rules include whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within the preset data range.

[0055] In some embodiments, the editing result is compressed by the user terminal and then sent to the server; receiving the editing result sent by the user terminal in real time includes: decompressing the editing result, and sending the decompressed editing result to other user terminals.

[0056] Optionally, in this embodiment, pako compression is performed on the editing results. In other embodiments, other forms of compression may also be performed on the editing results. The embodiments of the present application do not specifically limit this. Pako compression is a method of compressing data using the Deflate algorithm (a lossless data compression algorithm) to reduce the size of the data for more efficient storage or transmission.

[0057] In this embodiment, the user terminal compresses the editing result and sends it to the server, which can effectively reduce the size of the data for more efficient transmission.

[0058] In some embodiments, data transmission between multiple user terminals and the server is based on a full-duplex communication protocol.

[0059] Among them, the full-duplex communication protocol is a communication mode that allows both communicating parties to send and receive data independently at any time. This mode means that data can be transmitted in both directions simultaneously without waiting for the other party to complete sending or receiving.

[0060] In this embodiment, data is transmitted between multiple user terminals and the server based on a full-duplex communication protocol, and editing results can be transmitted in real time, so that target tables received by different user terminals can be updated simultaneously.

[0061] In one embodiment, another table editing method is provided, which includes the following contents: obtaining a target table and sending the target table to multiple user terminals; for each user terminal among the multiple user terminals, receiving in real time the editing result sent by the user terminal during a process in which the user terminal edits the target table received by the user terminal based on an editing request input by a corresponding user of the user terminal; and sending the editing result in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target table received by the other user terminals based on the editing result.

[0062] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0063] Based on the same inventive concept, the embodiment of the present application also provides a table editing device for implementing the table editing method involved above. The implementation solution provided by the device to solve the problem is similar to the implementation solution recorded in the above method, so the specific limitations in one or more table editing device embodiments provided below can refer to the limitations on the table editing method above, and will not be repeated here.

[0064] In an exemplary embodiment, as shown in FIG. 4 , a table editing device 400 is provided, comprising: an acquisition module 401 , a receiving module 402 and a sending module 403 , wherein:

[0065] The acquisition module 401 is used to acquire a target table and send the target table to multiple user terminals.

[0066] The receiving module 402 is used to receive, in real time, the editing result sent by each user terminal among the multiple user terminals when the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal.

[0067] The sending module 403 is configured to send the editing result to other user terminals among the multiple user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result.

[0068] In some embodiments, the table editing device 400 is specifically used to send the editing permission of the user corresponding to the user terminal to the user terminal before the user terminal edits the target table received by the user terminal based on the editing request input by the user corresponding to the user terminal, so that the user terminal verifies the editing request based on the editing permission.

[0069] In some embodiments, the table editing device 400 is further used for editing permissions including editable areas corresponding to the user of the user terminal in the target table, and editing operations executable by the user terminal.

[0070] In some embodiments, the table editing device 400 is also used to obtain preset data verification rules, and verify the editing results based on the preset data verification rules; when the verification results indicate that the editing content of the user terminal meets the preset data verification rules, the editing results are sent in real time to other user terminals among the multiple user terminals; when the verification results indicate that the editing content of the user terminal does not meet the preset data verification rules, an alarm message is sent to the user terminal.

[0071] In some embodiments, the table editing device 400 is also used to preset data verification rules including whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within a preset data range.

[0072] In some embodiments, the editing result is compressed by the user terminal and then sent to the server; the receiving module 402 is further used to decompress the editing result and send the decompressed editing result to the other user terminal.

[0073] In some embodiments, the table editing device 400 is also used for data transmission between multiple user terminals and a server based on a full-duplex communication protocol.

[0074] Each module in the above table editing device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module.

[0075] In an exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be shown in FIG5. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface is connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store table data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, a table editing method is implemented.

[0076] Those skilled in the art will understand that the structure shown in FIG. 5 is merely a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different arrangement of components.

[0077] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the following steps when executing the computer program: obtaining a target form and sending the target form to multiple user terminals; for each user terminal among the multiple user terminals, receiving in real time an editing result sent by the user terminal during a process in which the user terminal edits the target form received by the user terminal based on an editing request input by a corresponding user of the user terminal; and sending the editing result in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target form received by the other user terminals based on the editing result.

[0078] In one embodiment, the method implemented when the processor executes the computer program also includes: before the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, sending the editing permission of the corresponding user of the user terminal to the user terminal, so that the user terminal verifies the editing request based on the editing permission.

[0079] In one embodiment, the editing permissions implemented when the processor executes the computer program include the editable area corresponding to the user of the user terminal in the target table, and the editing operations executable by the user terminal.

[0080] In one embodiment, after the processor executes the computer program to implement real-time acceptance of the editing results sent by the user terminal, it also includes: obtaining preset data verification rules, and verifying the editing results based on the preset data verification rules; when the verification results indicate that the editing content of the user terminal meets the preset data verification rules, sending the editing results to other user terminals among the multiple user terminals in real time; when the verification results indicate that the editing content of the user terminal does not meet the preset data verification rules, sending an alarm message to the user terminal.

[0081] In one embodiment, the preset data verification rules implemented when the processor executes the computer program include whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within a preset data range.

[0082] In one embodiment, the editing results achieved when the processor executes the computer program are compressed by the user terminal and sent to the server; the real-time reception of the editing results sent by the user terminal includes: decompressing the editing results and sending the decompressed editing results to the other user terminals.

[0083] In one embodiment, the data transmission between the multiple user terminals and the server implemented when the processor executes the computer program is based on a full-duplex communication protocol.

[0084] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented: obtaining a target form and sending the target form to multiple user terminals; for each user terminal among the multiple user terminals, during the process in which the user terminal edits the target form received by the user terminal based on an editing request input by a corresponding user of the user terminal, receiving in real time an editing result sent by the user terminal; and sending the editing result in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target form received by the other user terminals based on the editing result.

[0085] In one embodiment, the method implemented when the computer program is executed by the processor also includes: before the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, sending the editing permission of the corresponding user of the user terminal to the user terminal, so that the user terminal verifies the editing request based on the editing permission.

[0086] In one embodiment, the editing permissions implemented when the computer program is executed by the processor include the editable area corresponding to the user of the user terminal in the target table, and the editing operations executable by the user terminal.

[0087] In one embodiment, after the computer program is executed by the processor and the editing result sent by the user terminal is accepted in real time, it also includes: obtaining preset data verification rules, and verifying the editing result based on the preset data verification rules; when the verification result indicates that the editing content of the user terminal meets the preset data verification rules, sending the editing result to other user terminals among the multiple user terminals in real time; when the verification result indicates that the editing content of the user terminal does not meet the preset data verification rules, sending an alarm message to the user terminal.

[0088] In one embodiment, the preset data verification rules implemented when the computer program is executed by the processor include whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within a preset data range.

[0089] In one embodiment, the editing results achieved when the computer program is executed by the processor are compressed by the user terminal and sent to the server; the real-time reception of the editing results sent by the user terminal includes: decompressing the editing results and sending the decompressed editing results to the other user terminals.

[0090] In one embodiment, the data transmission between the multiple user terminals and the server implemented when the computer program is executed by the processor is based on the full-duplex communication protocol.

[0091] In one embodiment, a computer program product is provided, comprising a computer program, which implements the following steps when executed by a processor: obtaining a target form and sending the target form to multiple user terminals; for each user terminal among the multiple user terminals, receiving in real time an editing result sent by the user terminal during a process in which the user terminal edits the target form received by the user terminal based on an editing request input by a corresponding user of the user terminal; and sending the editing result in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target form received by the other user terminals based on the editing result.

[0092] In one embodiment, the method implemented when the computer program is executed by the processor also includes: before the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, sending the editing permission of the corresponding user of the user terminal to the user terminal, so that the user terminal verifies the editing request based on the editing permission.

[0093] In one embodiment, the editing permissions implemented when the computer program is executed by the processor include the editable area corresponding to the user of the user terminal in the target table, and the editing operations executable by the user terminal.

[0094] In one embodiment, after the computer program is executed by the processor and the editing result sent by the user terminal is accepted in real time, it also includes: obtaining preset data verification rules, and verifying the editing result based on the preset data verification rules; when the verification result indicates that the editing content of the user terminal meets the preset data verification rules, sending the editing result to other user terminals among the multiple user terminals in real time; when the verification result indicates that the editing content of the user terminal does not meet the preset data verification rules, sending an alarm message to the user terminal.

[0095] In one embodiment, the preset data verification rules implemented when the computer program is executed by the processor include whether the data type of the input data in the editing content meets the preset data type, whether the data format of the input data in the editing content meets the preset data format, and whether the input data in the editing content is within a preset data range.

[0096] In one embodiment, the editing results achieved when the computer program is executed by the processor are compressed by the user terminal and sent to the server; the real-time reception of the editing results sent by the user terminal includes: decompressing the editing results and sending the decompressed editing results to the other user terminals.

[0097] In one embodiment, the data transmission between the multiple user terminals and the server implemented when the computer program is executed by the processor is based on the full-duplex communication protocol.

[0098] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0099] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0100] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0101] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A table editing method, characterized in that: The method comprises: Acquire a target table, and send the target table to multiple user terminals; For each of the plurality of user terminals, in a process in which the user terminal edits the target table received by the user terminal based on the editing request input by the corresponding user of the user terminal, receiving in real time the editing result sent by the user terminal; The editing result is sent in real time to other user terminals among the multiple user terminals, so that the other user terminals update the target table received by the other user terminals based on the editing result.

2. The method according to claim 1, characterized in that The method further comprises: Before the user terminal edits the target table received by the user terminal based on the editing request input by the user corresponding to the user terminal, the editing authority of the user corresponding to the user terminal is sent to the user terminal so that the user terminal verifies the editing request based on the editing authority.

3. The method according to claim 2, characterized in that The editing authority includes an editable area corresponding to the user of the user terminal in the target table, and an editing operation executable by the user terminal.

4. The method according to claim 1, characterized in that: After the real-time acceptance of the editing result sent by the user terminal, the method further includes: Acquire a preset data verification rule, and verify the editing result based on the preset data verification rule; If the verification result indicates that the edited content of the user terminal satisfies the preset data verification rule, sending the edited result to other user terminals among the multiple user terminals in real time; When the verification result indicates that the edited content of the user terminal does not satisfy the preset data verification rule, an alarm message is sent to the user terminal.

5. The method according to claim 4, characterized in that The preset data verification rules include whether the data type of the input data in the edited content meets the preset data type, whether the data format of the input data in the edited content meets the preset data format, and whether the input data in the edited content is within a preset data range.

6. The method according to claim 1, characterized in that The editing result is compressed by the user terminal and then sent to the server; the real-time receiving of the editing result sent by the user terminal includes: The editing result is decompressed, and the decompressed editing result is sent to the other user terminal.

7. The method according to claim 1, characterized in that The data transmission between the multiple user terminals and the server is based on the full-duplex communication protocol.

8. A table editing device, characterized in that: The device comprises: An acquisition module, used for acquiring a target table and sending the target table to a plurality of user terminals; a receiving module, configured to receive, for each of the plurality of user terminals, in real time, an editing result sent by the user terminal during a process in which the user terminal edits a target table received by the user terminal based on an editing request input by a corresponding user of the user terminal; The sending module is used to send the editing result to other user terminals among the multiple user terminals in real time, so that the other user terminals update the target table received by the other user terminals based on the editing result.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images