Data insertion method, device, equipment and storage medium

Abstract

The present disclosure is about a data insertion method, device, equipment and storage medium, and relates to the field of data processing technology. In the present disclosure, when an instruction for inserting table data in a first table file into an online document is received, the first table file is displayed, and in response to an operation of selecting a data range in the first table file, the first table data corresponding to the data range is displayed in the online document. The efficiency of inserting table data is effectively improved. At the same time, the table data displayed in the online document is determined through the generated table data reference relationship, and the table data inserted into the online document is updated, thereby improving the timeliness and accuracy of the table data in the document.

Description

Technical Field

[0001] The present disclosure relates to the field of data processing technology, and in particular to a data insertion method, device, equipment and storage medium. Background Art

[0002] Online documents are usually collaboratively edited or read by multiple users at the same time. When using online documents, users often need to insert a large amount of table data into the online document content.

[0003] In the related art, the table data is inserted into the online document content by copying the table data or taking a screenshot of the view of the table data. However, both methods have shortcomings. For example, the user needs to manually select the required table data and then insert it into the corresponding online document, which is a cumbersome operation process. Summary of the invention

[0004] The present invention provides a data insertion method, device, equipment and storage medium, which can realize real-time update of table data in online documents and improve timeliness and accuracy.

[0005] The technical solution of the embodiment of the present disclosure is as follows:

[0006] According to a first aspect of an embodiment of the present disclosure, a data insertion method is provided. The method may include: when receiving an instruction for inserting table data in a first table file into an online document, displaying the first table file; in response to an operation of selecting a data range in the first table file, displaying the first table data corresponding to the data range in the online document.

[0007] Optionally, displaying first table data corresponding to a data range in an online document includes: generating a first table data reference relationship based on the data range, the first table data reference relationship being used to associate the online document with the data range in a first table file; and displaying first table data corresponding to the data range associated with the online document in the online document based on the first table data reference relationship.

[0008] Optionally, the data range includes a starting cell and an ending cell, and generating a first table data reference relationship according to the data range includes: assigning a table data reference variable corresponding to the online document according to identification information of the starting cell, the ending cell and the first table file to obtain the first table data reference relationship.

[0009] Optionally, the table data reference variable includes a first field, a second field and a third field. According to the identification information of the starting cell, the ending cell and the first table file, the table data reference variable corresponding to the online document is assigned to obtain a first table data reference relationship, including: writing the identification information of the starting cell, the ending cell and the first table file into the first field, the second field and the third field respectively.

[0010] Optionally, the insertion position of the first table data is the input position of the instruction.

[0011] Optionally, the first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position.

[0012] Optionally, the method also includes: in response to receiving an instruction to edit the first table data in the online document, determining the corresponding first table data reference relationship according to the relationship identifier corresponding to the insertion position of the first table data; displaying the first table file according to the first table data reference relationship, and displaying the data range corresponding to the first table data in the first table file; in response to the operation of modifying the data range, updating the first table data in the online document according to the third table data corresponding to the modified data range.

[0013] Optionally, the method further includes: in response to an operation of modifying the data range, updating the first table data reference relationship according to the modified data range.

[0014] Optionally, the method further includes adding the first table data reference relationship to a document model corresponding to the online document; and synchronizing the document model corresponding to the online document to a server.

[0015] Optionally, before receiving an instruction for inserting table data into an online document, the method further includes: in response to receiving an instruction for displaying the online document, obtaining a document model corresponding to the online document from a server, the document model including content information of the online document and a reference relationship of second table data, the content information of the online document including second table data inserted in the online document, the second table data being obtained by the server from a second table file according to a reference relationship of the second table data; and displaying the online document according to the content information of the online document.

[0016] Optionally, the online document also includes a data update control, and the method also includes: in response to an operation on the data update control, obtaining the latest first table data corresponding to a data range associated with the online document according to a first table data reference relationship corresponding to the online document; and updating the online document according to the latest first table data.

[0017] Optionally, the method further includes: displaying a data update control in the online document in response to receiving the update prompt information sent by the server.

[0018] Optionally, the method further includes: in response to an operation of modifying at least one cell data in the first table data in the online document, determining a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data. Determining table file update information according to the first table data reference relationship and the modified at least one cell data, the table file update information at least including identification information of the first table file, the modified at least one cell data and location information of the at least one cell data in the first table file. Sending the table file update information to a server so that the server updates the first table file according to the table file update information.

[0019] Optionally, when an instruction for inserting table data in a first table file into an online document is received, the first table file is displayed, including: in response to the instruction, displaying a table list, wherein the table list includes multiple table controls, one table control corresponding to one table file; in response to a selection operation on the first table control, displaying the first table file corresponding to the first table control.

[0020] According to a second aspect of an embodiment of the present disclosure, a data insertion device is provided. The device may include: a table file display unit and a table data display unit; the table file display unit is used to display the first table file when receiving an instruction for inserting table data in the first table file into the online document; the table data display unit is used to display the first table data corresponding to the data range in the online document in response to an operation of selecting a data range in the first table file.

[0021] Optionally, the table data display unit is specifically used to: generate a first table data reference relationship based on the data range, the first table data reference relationship is used to associate the online document with the data range in the first table file; according to the first table data reference relationship, display the first table data corresponding to the data range associated with the online document in the online document.

[0022] Optionally, the table data display unit is specifically used to assign a table data reference variable corresponding to the online document according to the identification information of the starting cell, the ending cell and the first table file to obtain a first table data reference relationship.

[0023] Optionally, the table data reference variable includes a first field, a second field and a third field, and the table data display unit is specifically used to write the identification information of the starting cell, the ending cell and the first table file into the first field, the second field and the third field respectively.

[0024] Optionally, the insertion position of the first table data is the input position of the instruction.

[0025] Optionally, the first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position.

[0026] Optionally, the table data display unit is also used to: in response to receiving an instruction to edit the first table data in the online document, determine the corresponding first table data reference relationship according to the relationship identifier corresponding to the insertion position of the first table data; display the first table file according to the first table data reference relationship, and display the data range corresponding to the first table data in the first table file; in response to the operation of modifying the data range, update the first table data in the online document according to the third table data corresponding to the modified data range.

[0027] Optionally, the table data display unit is further used to respond to an operation of modifying the data range and update the first table data reference relationship according to the modified data range.

[0028] Optionally, the table data display unit is further used to: add the first table data reference relationship to the document model corresponding to the online document, and synchronize the document model corresponding to the online document to the server.

[0029] Optionally, before receiving an instruction for inserting table data into an online document, the table data display unit is further used to, in response to receiving an instruction for displaying the online document, obtain a document model corresponding to the online document from the server, the document model including content information of the online document and a reference relationship of the second table data, the content information of the online document including the second table data inserted in the online document, the second table data being obtained by the server from the second table file according to the reference relationship of the second table data; and display the online document according to the content information of the online document.

[0030] Optionally, the online document also includes a data update control and a table data display unit, which is also used to respond to the operation of the data update control, obtain the latest first table data corresponding to the data range associated with the online document according to the first table data reference relationship corresponding to the online document; and update the online document according to the latest first table data.

[0031] Optionally, the table data display unit is further configured to display a data update control in the online document in response to receiving update prompt information sent by the server.

[0032] Optionally, the table data display unit is further configured to, in response to an operation of modifying at least one cell data in the first table data in the online document, determine a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data. Determine table file update information according to the first table data reference relationship and the modified at least one cell data, the table file update information at least including identification information of the first table file, the modified at least one cell data and location information of the at least one cell data in the first table file. Send the table file update information to a server so that the server updates the first table file according to the table file update information.

[0033] Optionally, the table data display unit is also used to display a table list in response to an instruction, wherein the table list includes multiple table controls, and one table control corresponds to one table file; in response to a selection operation on a first table control, a first table file corresponding to the first table control is displayed.

[0034] According to a third aspect of an embodiment of the present disclosure, an electronic device is provided, which may include: a processor and a memory for storing processor executable instructions; wherein the processor is configured to execute instructions to implement any one of the optional data insertion methods in the above-mentioned first aspect.

[0035] According to a fourth aspect of an embodiment of the present disclosure, a computer-readable storage medium is provided, on which instructions are stored. When the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute any one of the optional data insertion methods in the above-mentioned first aspect.

[0036] According to a fifth aspect of an embodiment of the present disclosure, a computer program product is provided, which includes computer instructions. When the computer instructions are executed on an electronic device, the electronic device executes a data insertion method as optionally implemented in any one of the first aspects.

[0037] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure.

[0038] The technical solution provided by the embodiments of the present disclosure brings at least the following beneficial effects:

[0039] Based on any of the above aspects, in the present disclosure, when an instruction for inserting table data in a first table file into an online document is received, the first table file is displayed; in response to an operation of selecting a data range in the first table file, the first table data corresponding to the data range is displayed in the online document. Since the table data reference relationship describes the data range corresponding to the target table data, such as the row and column, when the online document is displayed, the table data inserted in the document is obtained from the target table file based on the data range described by the reference relationship. Therefore, even if the table data in the target table file changes, the corresponding latest table data can be obtained based on the table data reference relationship, thereby realizing real-time update of the table data in the online document and improving the timeliness and accuracy of the table data. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The drawings herein are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the description are used to explain the principles of the present disclosure, and do not constitute improper limitations on the present disclosure.

[0041] Figure 1 A schematic diagram of the structure of an online document application system provided by an embodiment of the present disclosure is shown;

[0042] Figure 2 A schematic diagram of a data insertion method provided by an embodiment of the present disclosure is shown;

[0043] Figure 3 A schematic diagram of an online document editing interface provided by an embodiment of the present disclosure is shown;

[0044] Figure 4 A schematic diagram showing another online document editing interface provided by an embodiment of the present disclosure is shown;

[0045] Figure 5 A schematic diagram showing another online document editing interface provided by an embodiment of the present disclosure;

[0046] Figure 6 A schematic diagram showing another online document editing interface provided by an embodiment of the present disclosure;

[0047] Figure 7 A schematic diagram showing a flow chart of another data insertion method provided by an embodiment of the present disclosure is shown;

[0048] Figure 8 A schematic diagram showing another online document editing interface provided by an embodiment of the present disclosure;

[0049] Fig. 9 A schematic diagram showing a flow chart of another data insertion method provided by an embodiment of the present disclosure is shown;

[0050] Fig.10 A schematic diagram showing a flow chart of another data insertion method provided by an embodiment of the present disclosure is shown;

[0051] Fig.11 A schematic diagram of the structure of a data insertion device provided by an embodiment of the present disclosure is shown;

[0052] Fig.12 A schematic structural diagram of an electronic device provided by an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0053] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.

[0054] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present disclosure. Instead, they are merely examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0055] It should also be understood that the term “comprising” indicates the presence of described features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, elements and / or components.

[0056] The data involved in the present disclosure may be data authorized by the user or fully authorized by all parties.

[0057] As described in the background art, online documents are usually collaboratively edited or read by multiple users at the same time. When using online documents, users often need to insert a large amount of table data into the online document content.

[0058] In the related art, the table data is inserted into the online document content by copying the table data or taking a screenshot of the view of the table data. However, both methods have shortcomings. For example, the user needs to manually select the required table data and then insert it into the corresponding online document. The operation process is relatively cumbersome, which seriously affects the user experience.

[0059] Based on this, an embodiment of the present disclosure provides a data insertion method, including: when receiving an instruction for inserting table data in a first table file into an online document, displaying the first table file; in response to an operation of selecting a data range in the first table file, displaying the first table data corresponding to the data range in the online document.

[0060] The following is an exemplary description of the application scenario of the data insertion method provided in the embodiment of the present disclosure:

[0061] Figure 1 A schematic diagram of an online document application system provided by an embodiment of the present disclosure is shown in FIG. Figure 1 As shown, the communication system may include: a server 110 and a terminal device 120. The server 110 may establish a connection with the terminal device 120 via a wired network or a wireless network.

[0062] The server 110 may be used to receive a document model from the terminal device 120, wherein the document model includes content information of an online document and a corresponding table data reference relationship, wherein the table data reference relationship is used to describe the data range of the table data inserted in the online document in the corresponding table file, wherein the reference variable points to the table data corresponding to the target cell, and the table file identification information is used to uniquely identify the target table file. The number of table data reference relationships in a document model may be one or more.

[0063] In some embodiments, the server may be a single server, or a server cluster composed of multiple servers (or micro servers). The server cluster may also be a distributed cluster. The present disclosure does not limit the specific implementation of the server 110.

[0064] The terminal device 120 can be used to obtain the document model of the online document from the server 110, display the online document according to the document model, and receive the user's editing operation on the online document, such as inserting the target table data in the target table file into the online document. The terminal device 120 can also generate a table data reference relationship corresponding to the online document according to the data range of the target table data in the target table file, add the table data reference relationship to the document model, and send the document model to the server.

[0065] In some embodiments, the terminal device may be a mobile phone, tablet computer, desktop, laptop, handheld computer, notebook computer, ultra-mobile personal computer (UMPC), netbook, cellular phone, personal digital assistant (PDA), augmented reality (AR)\virtual reality (VR) device, etc., which can install and use online document editing applications, and the present disclosure does not impose any special restrictions on the specific form of the terminal. It can interact with the user through one or more methods such as keyboard, touchpad, touch screen, remote control, voice interaction or handwriting device.

[0066] Optionally, the above Figure 1 In the online document application system shown, the server 110 may be connected to at least one terminal device 120. The present disclosure does not limit the number and type of the terminal device 120.

[0067] It should be noted that the terminal device 120 and the server 110 may be independent devices or integrated into the same device, and the present invention does not make any specific limitation on this.

[0068] When the terminal device 120 and the server 110 are integrated into the same device, the communication between the terminal device 120 and the server 110 is the communication between the internal modules of the device. In this case, the communication process between the two is the same as "the communication process between the terminal device 120 and the server 110 when they are independent of each other".

[0069] In the following embodiments provided by the present invention, the terminal device 120 and the server 110 are mainly configured independently of each other as an example for description.

[0070] The data insertion method provided by the embodiment of the present disclosure can be applied to the aforementioned Figure 1 The terminal device 120 is shown.

[0071] Figure 2 A data insertion method flow chart provided in an embodiment of the present disclosure is as follows: Figure 2 As shown, when the data insertion method is applied to a terminal device, the data insertion method may include:

[0072] S201. When receiving an instruction for inserting table data in a first table file into an online document, display the first table file.

[0073] Specifically, the instruction to insert table data is input by the user in the online document editing interface. In response to the instruction to insert table data into the online document, a table list is displayed, wherein the table list includes multiple table controls, one table control corresponds to one table file, and in response to a selection operation on a first table control, a first table file corresponding to the first table control is started.

[0074] Exemplary, participating Figure 3 , Figure 3 The present disclosure shows an online document editing interface. When the user right-clicks on the interface to start the insert control menu 310 or triggers the insert control 320, a control menu is displayed. The control menu includes multiple controls for the user to insert content into the online document, such as the insert picture control 301, the insert table control 302, the insert attachment control 303, the insert online table reference control 304, and the insert code block control 305. Among them, the insert picture control 301 is used to insert a picture into the online document. The insert table control 302 is used to insert a table into the online document. After the table is successfully inserted, the table data will not be updated in real time. The insert attachment control 303 is used to insert an attachment into the online document. The insert online table reference control 304 is used to insert table data into the online document. After using this function to insert table data into the online document, the table data in the online document will be updated as the corresponding table data in the table file changes, and will also be updated as the reference relationship of the table data corresponding to the online document changes. For a detailed description of the aforementioned "table data reference relationship", please refer to the following embodiment. The insert code block control 305 is used to insert a code block into an online document. Figure 3 In the example shown, the user can input an instruction for inserting table data into the online document by operating the insert online table reference control 304 .

[0075] Figure 4 This is another schematic diagram of an online document editing interface according to an embodiment of the present disclosure. Figure 4 When the user selects to insert an online table reference control 304, in response to the generated instruction for inserting table data into the online document, a corresponding table list 410 is displayed on the online document editing interface. The table list 410 includes multiple table controls 401, each of which corresponds to a table file. The table control also displays the table file name, and the user can select the required table control according to the table file name. Further, in response to the user's selection operation on a table control, the first table file corresponding to the table control is opened.

[0076] Figure 5 An online document editing interface shown in the present disclosure, see Figure 5In response to the instruction to start the first table file, the first table file is displayed on the interface, and the user can select the required data range in the first table file.

[0077] It can be seen from the above embodiments that when the user inputs an instruction to insert table data into an online document, a table list is displayed, and the first table file is selected in the table list so that the user can select the first table file therefrom, and can start the first table file by operating the corresponding table control and select the required first table data therefrom.

[0078] In some embodiments, the first form file is an online form file uploaded to the server in advance.

[0079] On the one hand, by uploading the first table file as an online table file to the server, when other users start the corresponding online document, they can also obtain the table data of the first table file from the server according to the table data reference relationship in the document model, so as to realize the real-time update of the table data in the online document in the working scenario of multiple people editing the online document, thereby improving the timeliness and accuracy of the table data. On the other hand, by uploading the table file to the server in advance and making it an online table file, any user can access the table file in the server. At the same time, it is not limited to selecting the data to be inserted from the local table file of the user-side device, but also convenient for users to insert table data into online documents anytime and anywhere.

[0080] S202: In response to an operation of selecting a data range in the first table file, display first table data corresponding to the data range in the online document.

[0081] Specifically, the data range includes a starting cell, an ending cell, and an intermediate cell determined based on the starting cell and the ending cell; for example, when the starting cell is A1 and the ending cell is F5, the data range selected by the user can be the cell in the 1st row and column A to the cell in the 5th row and column F in the target table file.

[0082] For example, see Figure 6 , the data range selected by the user in the target table file. The data range selected by the user at this time is the cell in the 1st row and column A to the cell in the 5th row and column F in the target table file.

[0083] like Figure 7 As shown, in the above S202, displaying the first table data corresponding to the data range in the online document specifically includes:

[0084] S701. Generate a first table data reference relationship according to a data range, where the first table data reference relationship is used to associate an online document with a data range in a first table file.

[0085] Specifically, according to the identification information of the starting cell, the ending cell and the first table file, a table data reference variable corresponding to the online document is assigned a value to obtain the first table data reference relationship.

[0086] In this implementation, the table reference function of the online document corresponds to a table data reference variable. After the online document application is started, the online document application stores the variable in the memory. When it is necessary to generate a table data reference relationship, the variable is assigned using the identification information of the starting cell, the identification information of the ending cell, and the identification information of the target table file, so that the identification information of the starting cell, the identification information of the ending cell, and the identification information of the target table file are saved in the variable. When it is necessary to display the inserted table data in the document, the online document application can obtain the corresponding table data by reading the value of the variable according to the read value.

[0087] In some embodiments, the table data reference variable includes a first field, a second field, and a third field. According to the identification information of the starting cell, the ending cell, and the first table file, the table data reference variable corresponding to the online document is assigned to obtain the first table data reference relationship, including: writing the identification information of the starting cell, the ending cell, and the first table file into the first field, the second field, and the third field respectively.

[0088] Exemplarily, the format of the table data reference relationship is TABLE_REFERENCE(Table 1, A1:F5), where TABLE_REFERENCE represents that the current data is a table data reference relationship, the first field is "A1" which is the starting cell of the table data reference relationship, the second field is "F5" which is the ending cell of the table data reference relationship, A1:F5 indicates that the table data corresponding to the cell in the 1st row and column A to the cell in the 5th row and column F in the specified Table 1 is the data range corresponding to the table data reference relationship, and the third field "Table 1" is the table file corresponding to the table data reference relationship.

[0089] In some embodiments, the first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position. The relationship identifier is used to uniquely determine the insertion position of the table data corresponding to the table data reference relationship in the online document, and the insertion position is determined according to the input position of the instruction for inserting the table data into the online document.

[0090] Since there may be multiple table data in an online document, and the multiple table data correspond to multiple data table reference relationships, the display position of the table data corresponding to each table data reference relationship in the online document can be determined through the relationship identifier, which is equivalent to the input position of the data insertion instruction. For example, the user enters the data insertion instruction in the fifth line of the online document. At this time, the relationship identifier corresponds to the fifth line. When the online document is started, the table data reference relationship corresponding to the data table that should be displayed in the fifth line is determined according to the relationship identifier. If there are other table data reference relationships, the corresponding table data is displayed in other positions according to the relationship identifier. From the above, it can be seen that the variable identifier is used to locate the table data reference relationship and the corresponding table data in the online document.

[0091] For example, when the user inputs an instruction to insert table data in the 6th line of the online document editing interface, the user selects the required data range and generates a corresponding table data reference relationship. At this time, the variable corresponding to the table data reference relationship is identified as the 6th line. When the corresponding table data is displayed in the online document according to the table data reference relationship, the table data is displayed in the 6th line of the online document.

[0092] As can be seen from the above, since different table data can be inserted in different positions of an online document, and different table data come from different table files and / or correspond to different data ranges, in actual applications, an online document can correspond to multiple table data reference variables, and different table data reference variables correspond to table data inserted in different positions. Based on this, by setting an identifier for each table data reference variable, and by establishing an association between the variable identifier and the data insertion position, an association is established between the table data corresponding to the table data reference variable and the insertion position, which can ensure that the table data can be displayed at the corresponding position.

[0093] In another implementation, the table data reference relationship includes at least one reference variable and table file identification information, the at least one reference variable points to the table data corresponding to at least one target cell, and the table file identification information is used to uniquely identify the target table file.

[0094] Exemplarily, a table data reference relationship is generated according to the data range, wherein the table data reference relationship is a temporary variable, and each of them points to the table data corresponding to at least one target cell, and the table file identification information is used to uniquely identify the target table file, wherein the table file identification information can be the file name or table name of the current target table file.

[0095] By generating a table data reference relationship through reference variables corresponding to multiple discontinuous target cells selected by the user, the user can select the data corresponding to the required cells in the target table file to generate the corresponding table data reference relationship, and further display the corresponding table data in the online document. For example, when the data range required by the user is the table data corresponding to cells A1-A15 and C1-C15, since the table data in column B of cells is not the data required by the user, 30 corresponding reference variables are generated according to cells A1-A15 and C1-C15. The table data reference relationship generated by the 30 reference variables can display the table data corresponding to cells A1-A15 and C1-C15 in the online document. Therefore, a new implementation method for users to select data ranges is added, which makes the user's data range selection method more flexible and avoids selecting invalid table data that users do not need, thereby affecting the accuracy of the table data.

[0096] S702: Displaying first table data corresponding to a data range associated with the online document in the online document according to the first table data reference relationship.

[0097] As can be seen from S701-S702, a specific implementation method for generating a table data reference relationship is provided. In this implementation method: the table reference function of the online document corresponds to a table data reference variable. After the online document application is started, the online document application stores the variable in the memory. When it is necessary to generate a table data reference relationship, the variable is assigned using the identification information of the starting cell, the identification information of the ending cell, and the identification information of the target table file, so that the identification information of the starting cell, the identification information of the ending cell, and the identification information of the target table file are saved in the variable. When it is necessary to display the inserted table data in the document, the online document application can obtain the corresponding table data by reading the value of the variable according to the read value.

[0098] For example, see Figure 8 , Figure 8 This is a schematic diagram of an online document editing interface shown in the present disclosure, in which corresponding first table data is displayed.

[0099] For example, after inserting table data of a certain data range in table file 1 into online document 1, when the table data corresponding to the data range in table file 1 is modified, in the prior art, the user needs to manually copy the modified table data back to the online document, which is cumbersome and time-consuming.

[0100] In combination with the disclosed solution, it can be known from S201-S202 that when an instruction for inserting table data in a first table file into an online document is received, the first table file is displayed; in response to an operation of selecting a data range in the first table file, the first table data corresponding to the data range is displayed in the online document. Since the table data reference relationship describes the data range corresponding to the target table data, such as the row and column, when displaying the online document, the table data inserted in the document is obtained from the target table file according to the data range described by the reference relationship. Therefore, even if the table data in the target table file changes, the corresponding latest table data can be obtained according to the table data reference relationship, thereby realizing real-time update of the table data in the online document and improving the timeliness and accuracy of the table data.

[0101] In some embodiments, it also includes: adding the table data reference relationship to the document model corresponding to the online document, and synchronizing the document model corresponding to the online document to the server.

[0102] Specifically, the document model also includes content information of the online document. The user can start the corresponding online document by selecting the document model to implement the editing operation on the online document.

[0103] By adding the reference relationship of table data to the document model corresponding to the online document, the document model corresponding to the online document is synchronized to the server. Users can obtain the corresponding document model from the server and display the corresponding table data on the online document interface, realizing the real-time update of table data in the scenario where multiple people edit the same online document. At the same time, when the document model saved locally by the user is damaged or lost, the document model in the server can be obtained to avoid further losses caused by the damage or loss of the document model.

[0104] In some embodiments, the method further includes: in response to receiving an instruction to edit first table data in an online document, determining a relationship identifier corresponding to an insertion position of the first table data to determine a table data reference relationship corresponding to the first table data, displaying the first table file according to the table data reference relationship corresponding to the first table data, with the data range corresponding to the first table data in the first table file highlighted; in response to an operation to modify the data range, updating the first table data in the online document according to third table data corresponding to the modified data range.

[0105] In some embodiments, in response to an operation of modifying the data range, the corresponding table data reference relationship is updated according to the modified data range.

[0106] Specifically, the updated table data reference relationship is added to the document model and uploaded to the server. When other users obtain the document model, the corresponding table data is displayed in the online document through the updated table data relationship, thereby realizing real-time updating of the table data in the online document and improving the timeliness and accuracy of the table data.

[0107] In some embodiments, the method further includes: in response to receiving an instruction to edit first table data in an online document, determining a relationship identifier corresponding to an insertion position of the first table data to determine a table data reference relationship corresponding to the first table data, displaying the first table file according to the table data reference relationship corresponding to the first table data, and highlighting the data range corresponding to the first table data in the first table file; in response to an operation to modify data corresponding to at least one cell in the first table file, updating the first table data in the online document according to third table data corresponding to the data corresponding to at least one cell in the modified first table file.

[0108] In some embodiments, the method further includes: sending the third table data to the server, so that the server updates the first table file according to the third table data. It should be noted that the current user has the authority to modify the first table file.

[0109] In some embodiments, the online document editing interface also includes a data update control, such as Fig. 9 As shown, if the online document is activated, it also includes:

[0110] S901. In response to an operation on the data update control, the latest first table data corresponding to the data range associated with the online document is obtained according to a reference relationship of the first table data corresponding to the online document.

[0111] S902: Display the online document according to the content information of the online document.

[0112] In some embodiments, the data insertion method further includes: in response to receiving update prompt information sent by the server, displaying a data update control in the online document. The update prompt information is sent when the server determines that the table data inserted in the online document has changed according to the table data reference relationship corresponding to the online document.

[0113] It can be seen from S901-S902 that since the data update control is generated based on the update prompt information sent by the system, when the data update control is displayed in the online document, it means that the data in the online document is to be updated at this time. By selecting the data update control by the user, the table data in the online document is updated in a timely manner, which improves the timeliness and accuracy of the table data and further enhances the user experience.

[0114] In some embodiments, see Fig.10 , the method further comprises:

[0115] S1001. In response to receiving an instruction to start an online document, obtain a document model corresponding to the online document from a server.

[0116] Specifically, the document model includes the content information of the online document and the second table data reference relationship. The content information of the online document includes the second table data inserted in the online document. The second table data is obtained by the server from the second table file according to the second table data reference relationship. The second table data refers to the table data that has been inserted into the online document before the online document is started. According to the data range corresponding to the table data reference relationship, the table data of the corresponding data range is obtained in the second table file. For example, the starting cell of the data range is A1 and the ending cell is F5, then the data range is from the cell in the 1st row and the A column to the cell in the 5th row and the F column in the second table file. The second table data is obtained according to the table data corresponding to the cell in the 1st row and the A column to the cell in the 5th row and the F column in the second table file.

[0117] S1002: Display the online document according to the content information of the online document.

[0118] Exemplarily, assuming that before opening an online document for a certain time, the table data in table file 1 has been inserted into the online document, then when the online document is opened, the table data from table file 1 will be directly displayed in the online document. In combination with the above S1002, it can be known that the table file 1 here is the second table file, and the table data from table file 1 in the online document is the second table data. Then, if after opening the online document this time, the instruction to insert the table data is input, and table file 2 is opened as needed, and the table data in table file 2 is inserted into the online document, then the table file 2 is the first table file, and the table data from table file 2 inserted into the online document is the first table data. It should be noted that the above table file 1 and table file 2 can be the same table file or different table files.

[0119] It can be known from S1001-S1002 that in response to receiving an instruction to start an online document, a document model corresponding to the online document is obtained from a server, and the table data displayed in the online document is determined by obtaining the document model corresponding to the online document from the server and the table data reference relationship. The document model includes content information of the online document and a corresponding table data reference relationship. According to the data range of the specified table data in the specified table file described by the table data reference relationship, the specified table data is obtained in the specified table file; wherein, the specified table data refers to the table data inserted in the online document. According to the content information of the online document and the obtained specified table data, the online document is displayed, thereby realizing real-time updating of the table data in other users' online documents, and improving the timeliness and accuracy of the table data in the document.

[0120] In some embodiments, before receiving an instruction for inserting table data into an online document, the method further includes: in response to receiving an instruction to start the online document, obtaining a document model corresponding to the online document from a server, and displaying the online document according to content information of the online document.

[0121] Specifically, the document model includes the content information of the online document and the corresponding table data reference relationship. The content information of the online document includes the data range of the specified table data in the specified table file described by the server according to the table data reference relationship, and the specified table data obtained in the specified table file. The specified table data refers to the table data inserted in the online document.

[0122] Exemplarily, before the user receives the document model from the server, the server determines the first table file corresponding to the table data reference relationship according to the table data reference relationship in the document model, and the first table file is the target table file opened by the user when the corresponding table data reference relationship is generated. The server determines the corresponding table data according to the data range corresponding to the table data reference relationship, adds the table data to the document model, and sends it to the user.

[0123] It can be seen that users display online documents through the content information of online documents in the document model, and at the same time, the table data corresponding to the previously determined designated table file is directly displayed in the online document, without having to send the table data corresponding to the reference relationship of the table data to the server again, which improves work efficiency and ensures the real-time and accuracy of the table data. This greatly shortens the startup time required for users to open online documents, effectively improving the user experience.

[0124] In some embodiments, the data insertion method further includes: in response to an operation of modifying at least one cell data in the first table data in the online document, determining the corresponding first table data reference relationship according to the relationship identifier corresponding to the insertion position of the first table data, and determining the table file update information according to the first table data reference relationship and the modified at least one cell data. The table file update information includes at least the identification information of the first table file, the modified at least one cell data and the position information of the at least one cell data in the first table file. The table file update information is sent to the server so that the server updates the first table file according to the table file update information.

[0125] Specifically, when the first table data is displayed in the online document, it includes multiple cell data, and each cell corresponds to different data. For example, the first table data includes three cells, namely cells A1-A3, the data corresponding to cell A1 is 20, the data corresponding to cell A2 is 30, and the data corresponding to cell A3 is 50. Then cell A1 and the corresponding data 20 are one cell data.

[0126] Specifically, when the user has the authority to modify the first table file, when the user inputs an operation to modify at least one cell data, at least one cell data can be selected for the position corresponding to the first table data in the online document. At this time, the cell changes to an editable state, and the user can enter any data to modify at least one cell data. It should be noted that the selection method can be double-clicking or touch clicking with the cursor. For example, the user selects cell A1 by touch, and cell A1 changes to an editable state. The user enters 50, and the data corresponding to cell A1 is changed from 20 to 50. At this time, the table file update information determined is (identification information of the first table file: 50:A1), and the table file update information is sent to the server. The server changes the value corresponding to cell A1 in the first table file from 20 to 50 according to the table file update information. Real-time update of data in online table files is realized.

[0127] In this embodiment, the first table file is an online table file. The server is a server for storing online table files, and the solution provided by the present disclosure is implemented through the interaction between the server storing the online table file and the server storing the document model. In some embodiments, the server can also be a server storing the document model, and the solution provided by the present disclosure can be implemented by the one server.

[0128] In some embodiments, the table file update information may further include identification information of the first table file, all modified cell data, and location information of the cell data in the first table file. The table file update information is sent to the server so that the server updates the first table file according to the table file update information. Since the table file update information includes all cell data and location information of the cell data in the first table file, the data range corresponding to the first table file is overwritten by the table file update information, thereby implementing the update of the first table file.

[0129] From the above, it can be seen that when the user needs to update the data in the table file, there is no need to obtain and display the corresponding table file. It is only necessary to modify at least one cell data of the table data in the online document to realize real-time update of the corresponding data in the table file, thereby improving timeliness and accuracy.

[0130] It is understandable that, in actual implementation, the terminal / server of the embodiment of the present disclosure may include one or more hardware structures and / or software modules for implementing the aforementioned corresponding data insertion method, and these execution hardware structures and / or software modules may constitute an electronic device. It should be easily appreciated by those skilled in the art that, in combination with the algorithm steps of each example described in the embodiments disclosed herein, the present disclosure can be implemented in the form of hardware or a combination of hardware and computer software. Whether a function is executed in the form of hardware or computer software driving hardware depends on the specific application and design constraints of the technical solution. Professional and technical personnel may 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 disclosure.

[0131] Based on such understanding, the embodiments of the present disclosure also provide a data insertion device, which can be applied to electronic devices. Fig.11 FIG. 2 shows a schematic diagram of the structure of a data insertion device provided by an embodiment of the present disclosure. Fig.11 As shown, the data inserting device may include: a table file display unit 111 and a table data display unit 112 .

[0132] According to a second aspect of an embodiment of the present disclosure, a data insertion device is provided. The device may include: a table file display unit and a table data display unit; the table file display unit 111 is used to display the first table file when receiving an instruction for inserting table data in the first table file into the online document; the table data display unit 112 is used to display the first table data corresponding to the data range in the online document in response to an operation of selecting a data range in the first table file.

[0133] Optionally, the table data display unit 112 is specifically used to: generate a first table data reference relationship based on the data range, the first table data reference relationship is used to associate the online document with the data range in the first table file; according to the first table data reference relationship, display the first table data corresponding to the data range associated with the online document in the online document.

[0134] Optionally, the table data display unit 112 is specifically used to assign a table data reference variable corresponding to the online document according to the identification information of the starting cell, the ending cell and the first table file to obtain a first table data reference relationship.

[0135] Optionally, the table data reference variable includes a first field, a second field and a third field, and the table data display unit 112 is specifically used to write the identification information of the starting cell, the ending cell and the first table file into the first field, the second field and the third field respectively.

[0136] Optionally, the insertion position of the first table data is the input position of the instruction.

[0137] Optionally, the first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position.

[0138] Optionally, the table data display unit 112 is further used to: in response to receiving an instruction to edit the first table data in the online document, determine the corresponding first table data reference relationship according to the relationship identifier corresponding to the insertion position of the first table data; display the first table file according to the first table data reference relationship, and display the data range corresponding to the first table data in the first table file; in response to the operation of modifying the data range, update the first table data in the online document according to the third table data corresponding to the modified data range.

[0139] Optionally, the table data display unit 112 is further configured to respond to an operation of modifying the data range and update the first table data reference relationship according to the modified data range.

[0140] Optionally, the table data display unit 112 is further used to: add the first table data reference relationship to the document model corresponding to the online document, and synchronize the document model corresponding to the online document to the server.

[0141] Optionally, before receiving an instruction for inserting table data into an online document, the table data display unit 112 is further used to obtain a document model corresponding to the online document from the server in response to receiving an instruction for displaying the online document, the document model including content information of the online document and a reference relationship of the second table data, the content information of the online document including the second table data inserted in the online document, the second table data being obtained by the server from the second table file according to the reference relationship of the second table data; and displaying the online document according to the content information of the online document.

[0142] Optionally, the online document also includes a data update control, and the table data display unit 112 is also used to respond to the operation of the data update control, obtain the latest first table data corresponding to the data range associated with the online document according to the first table data reference relationship corresponding to the online document; and update the online document according to the latest first table data.

[0143] Optionally, the table data display unit 112 is further configured to display a data update control in the online document in response to receiving update prompt information sent by the server.

[0144] Optionally, the table data display unit 112 is further used to determine the corresponding first table data reference relationship according to the relationship identifier corresponding to the insertion position of the first table data in response to the operation of modifying at least one cell data in the first table data in the online document. Determine the table file update information according to the first table data reference relationship and the at least one cell data after modification, the table file update information at least including the identification information of the first table file, the at least one cell data after modification, and the position information of the at least one cell data in the first table file. Send the table file update information to the server so that the server updates the first table file according to the table file update information.

[0145] Optionally, the table data display unit 112 is also used to display a table list in response to an instruction, wherein the table list includes multiple table controls, and one table control corresponds to one table file; in response to a selection operation on a first table control, a first table file corresponding to the first table control is displayed.

[0146] As described above, the embodiments of the present disclosure can divide the functional modules of the electronic device according to the above method examples. Among them, the above integrated modules can be implemented in the form of hardware or in the form of software functional modules. In addition, it should be noted that the division of modules in the embodiments of the present disclosure is schematic and is only a logical function division. There may be other division methods in actual implementation. For example, each functional module can be divided according to each function, or two or more functions can be integrated into one processing module.

[0147] Regarding the data insertion device in the above embodiment, the specific manner in which each module performs operations and the beneficial effects possessed have been described in detail in the aforementioned method embodiment and will not be repeated here.

[0148] The embodiment of the present disclosure also provides an electronic device. Fig.12 The electronic device provided by the embodiment of the present disclosure is shown in the structural diagram. The electronic device may be a data insertion device and may include at least one processor 121 , a communication bus 122 , a memory 123 and at least one communication interface 124 .

[0149] Processor 121 may be a processor (central processing unit, CPU), microprocessor unit, ASIC, or one or more integrated circuits for controlling the execution of the program of the disclosed solution. Fig.11 The function of the table data display unit 112 in the electronic device is similar to Fig.12 The functions implemented by the processor 121 in are the same.

[0150] The communication bus 122 may include a pathway for transmitting information between the above-mentioned components.

[0151] The communication interface 124 uses any transceiver-like device for communicating with other devices or communication networks, such as servers, Ethernet, radio access networks (RAN), wireless local area networks (WLAN), etc. As an example,

[0152] The memory 123 may be a read-only memory (ROM) or other types of static storage devices that can store static information and instructions, a random access memory (RAM) or other types of dynamic storage devices that can store information and instructions, or an electrically erasable programmable read-only memory (EEPROM), a compact disc read-only memory (CD-ROM) or other optical disc storage, optical disc storage (including compressed optical disc, laser disc, optical disc, digital versatile disc, Blu-ray disc, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto. The memory may exist independently and be connected to the processing unit through a bus. The memory may also be integrated with the processing unit.

[0153] The memory 123 is used to store application code for executing the solution of the present disclosure, and the execution is controlled by the processor 121. The processor 121 is used to execute the application code stored in the memory 123, so as to realize the functions in the method of the present disclosure.

[0154] In a specific implementation, as an embodiment, the processor 121 may include one or more CPUs, such as Fig.12 CPU0 and CPU1 in.

[0155] In a specific implementation, as an embodiment, the electronic device may include multiple processors, such as Fig.12 1 and 125. Each of these processors may be a single-CPU processor or a multi-CPU processor. A processor herein may refer to one or more devices, circuits, and / or processing cores for processing data (e.g., computer program instructions).

[0156] In a specific implementation, as an embodiment, the electronic device may further include an input device 126 and an output device 127. The input device 126 communicates with the output device 127 and may accept user input in a variety of ways. For example, the input device 126 may be a mouse, a keyboard, a touch screen device, or a sensor device. The output device 127 communicates with the processor 121 and may display information in a variety of ways. For example, the output device 121 may be a liquid crystal display (LCD), a light emitting diode (LED) display device, etc.

[0157] Those skilled in the art will understand that Fig.12 The structure shown in the figure does not constitute a limitation on the electronic device, and may include more or less components than shown in the figure, or combine certain components, or adopt a different component arrangement.

[0158] The disclosed embodiment also provides an electronic device. The electronic device may be a data insertion device. The electronic device may have relatively large differences due to different configurations or performances, and may include one or more processors and one or more memories. Among them, at least one instruction is stored in the memory, and at least one instruction is loaded and executed by the processor to implement the data insertion method provided by the above-mentioned various method embodiments. Of course, the electronic device may also have components such as a wired or wireless network interface, a keyboard, and an input and output interface for input and output. The electronic device may also include other components for implementing the functions of the device, which will not be repeated here.

[0159] The present disclosure also provides a computer-readable storage medium including instructions, and the computer-readable storage medium stores instructions. When the instructions in the computer-readable storage medium are executed by the processor of a computer device, the computer can execute the data insertion method provided in the above-mentioned embodiment. For example, the computer-readable storage medium can be a memory 123 including instructions, and the above instructions can be executed by the processor 121 of the terminal to complete the above method. For another example, the computer-readable storage medium can be a memory including instructions, and the above instructions can be executed by the processor of an electronic device to complete the above method. Optionally, the computer-readable storage medium can be a non-temporary computer-readable storage medium, for example, the non-temporary computer-readable storage medium can be a ROM, RAM, CD-ROM, magnetic tape, floppy disk, and optical data storage device, etc.

[0160] The present disclosure also provides a computer program product, which includes computer instructions. When the computer instructions are executed on an electronic device, the electronic device executes the above Figures 1 to 10 The data insertion method shown in any of the accompanying drawings.

[0161] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are to be considered exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.

[0162] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A data insertion method, characterized in that: The method comprises: When receiving an instruction for inserting the table data in the first table file into the online document, displaying the first table file; In response to an operation of selecting a data range in the first table file, generating a first table data reference relationship according to the data range, wherein the first table data reference relationship is used to associate the online document with the data range in the first table file; According to the first table data reference relationship, the first table data corresponding to the data range associated with the online document is displayed in the online document.

2. The data insertion method according to claim 1, characterized in that: The data range includes a starting cell and an ending cell, and generating a first table data reference relationship according to the data range includes: According to the identification information of the starting cell, the ending cell and the first table file, a table data reference variable corresponding to the online document is assigned a value to obtain the first table data reference relationship.

3. The data insertion method according to claim 2, characterized in that: The table data reference variable includes a first field, a second field, and a third field. The table data reference variable corresponding to the online document is assigned a value according to the start cell, the end cell, and the identification information of the first table file to obtain the first table data reference relationship, including: The identification information of the starting cell, the ending cell and the first table file are written into the first field, the second field and the third field respectively.

4. The data insertion method according to any one of claims 1 to 3, characterized in that: The insertion position of the first table data is the input position of the instruction.

5. The data insertion method according to claim 4, characterized in that: The first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position.

6. The data insertion method according to claim 5, characterized in that: The method further comprises: In response to receiving an instruction to edit the first table data in the online document, determining a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data; Displaying the first table file according to the reference relationship of the first table data, wherein the first table file displays a data range corresponding to the first table data; In response to the operation of modifying the data range, the first table data in the online document is updated according to the third table data corresponding to the modified data range.

7. The data insertion method according to claim 6, characterized in that: The method further comprises: In response to an operation of modifying the data range, the first table data reference relationship is updated according to the modified data range.

8. The data insertion method according to any one of claims 1 to 3, characterized in that: Also includes: Adding the first table data reference relationship to the document model corresponding to the online document; The document model corresponding to the online document is synchronized to the server.

9. The data insertion method according to claim 1, characterized in that: Before receiving the instruction for inserting the table data into the online document, the method further includes: In response to receiving an instruction to display the online document, obtaining a document model corresponding to the online document from a server, the document model including content information of the online document and a second table data reference relationship, the content information of the online document including second table data inserted in the online document, the second table data being obtained by the server from a second table file according to the second table data reference relationship; The online document is displayed according to the content information of the online document.

10. The data insertion method according to any one of claims 1 to 3, characterized in that: The online document further includes a data update control, and the method further includes: In response to an operation on the data update control, acquiring the latest first table data corresponding to the data range associated with the online document according to a reference relationship of the first table data corresponding to the online document; The online document is updated according to the latest first table data.

11. The data insertion method according to claim 10, characterized in that: Also includes: In response to receiving the update prompt information sent by the server, displaying the data update control in the online document.

12. The data insertion method according to claim 5, characterized in that: The method further comprises: In response to an operation of modifying at least one cell data in the first table data in the online document, determining a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data; Determine table file update information according to the first table data reference relationship and the at least one cell data after modification, wherein the table file update information at least includes identification information of the first table file, the at least one cell data after modification, and location information of the at least one cell data in the first table file; The table file update information is sent to a server, so that the server updates the first table file according to the table file update information.

13. The data insertion method according to claim 1, characterized in that: The method of displaying the first table file when receiving an instruction for inserting table data in the first table file into the online document comprises: In response to the instruction, displaying a table list, wherein the table list includes a plurality of table controls, and one table control corresponds to one table file; In response to a selection operation on a first table control, the first table file corresponding to the first table control is displayed.

14. A data insertion device, characterized in that: include: a table file display unit, configured to display the first table file when receiving an instruction for inserting table data in the first table file into the online document; A table data display unit is used to generate a first table data reference relationship based on the data range in response to an operation of selecting a data range in the first table file, wherein the first table data reference relationship is used to associate the online document with the data range in the first table file; and display the first table data corresponding to the data range associated with the online document in the online document according to the first table data reference relationship.

15. The data inserting device according to claim 14, characterized in that: The data range includes a starting cell and an ending cell, and the table data display unit is specifically used for: According to the identification information of the starting cell, the ending cell and the first table file, a table data reference variable corresponding to the online document is assigned a value to obtain the first table data reference relationship.

16. The data inserting device according to claim 15, characterized in that: The table data reference variable includes a first field, a second field and a third field, and the table data display unit is specifically used for: The identification information of the starting cell, the ending cell and the first table file are written into the first field, the second field and the third field respectively.

17. The data insertion device according to any one of claims 14 to 16, characterized in that: The insertion position of the first table data is the input position of the instruction.

18. The data inserting device according to claim 17, characterized in that: The first table data reference relationship has a relationship identifier, and the relationship identifier of the first table data reference relationship corresponds to the insertion position.

19. The data inserting device according to claim 18, characterized in that: The table data display unit is also used for: In response to receiving an instruction to edit the first table data in the online document, determining a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data; Displaying the first table file according to the reference relationship of the first table data, wherein the first table file displays a data range corresponding to the first table data; In response to the operation of modifying the data range, the first table data in the online document is updated according to the third table data corresponding to the modified data range.

20. The data inserting device according to claim 19, characterized in that: The table data display unit is further used to respond to an operation of modifying the data range and update the first table data reference relationship according to the modified data range.

21. The data insertion device according to any one of claims 14 to 16, characterized in that: The table data display unit is further used to: add the first table data reference relationship to the document model corresponding to the online document, and synchronize the document model corresponding to the online document to the server.

22. The data inserting device according to claim 14, characterized in that: Before receiving the instruction for inserting table data into the online document, the table data display unit is further used to In response to receiving an instruction to display the online document, obtaining a document model corresponding to the online document from a server, the document model including content information of the online document and a second table data reference relationship, the content information of the online document including second table data inserted in the online document, the second table data being obtained by the server from a second table file according to the second table data reference relationship; The online document is displayed according to the content information of the online document.

23. The data insertion device according to any one of claims 14 to 16, characterized in that: The online document further includes a data update control, and the table data display unit is further used to obtain the latest first table data corresponding to the data range associated with the online document according to the first table data reference relationship corresponding to the online document in response to the operation of the data update control; The online document is updated according to the latest first table data.

24. The data insertion device according to claim 23, characterized in that: The table data display unit is further configured to display the data update control in the online document in response to receiving the update prompt information sent by the server.

25. The data inserting device according to claim 18, characterized in that The table data display unit is also used for: In response to an operation of modifying at least one cell data in the first table data in the online document, determining a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data; Determine table file update information according to the first table data reference relationship and the at least one cell data after modification, wherein the table file update information at least includes identification information of the first table file, the at least one cell data after modification, and location information of the at least one cell data in the first table file; The table file update information is sent to a server, so that the server updates the first table file according to the table file update information.

26. The data inserting device according to claim 14, characterized in that: The table data display unit is further used to display a table list in response to the instruction, wherein the table list includes multiple table controls, and one table control corresponds to a table file; in response to a selection operation on a first table control, the first table file corresponding to the first table control is displayed.

27. An electronic device, characterized in that: include: processor; A memory for storing the processor executable instructions; wherein the processor is configured to execute the instructions to implement the data insertion method according to any one of claims 1 to 13.

28. A computer-readable storage medium, characterized in that: When the instructions in the computer-readable storage medium are executed by a processor, the processor implements the data insertion method according to any one of claims 1 to 13.

29. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the data insertion method according to any one of claims 1 to 13 is implemented.

Images