CN114564924B

CN114564924B - Data insertion method, device, equipment and storage medium

Info

Publication number: CN114564924B
Application number: CN202210206271.7A
Authority: CN
Inventors: 张驰; 卫宁宁
Original assignee: Beijing Dajia Internet Information Technology Co Ltd
Current assignee: Beijing Dajia Internet Information Technology Co Ltd
Priority date: 2022-02-28
Filing date: 2022-02-28
Publication date: 2025-02-25
Anticipated expiration: 2042-02-28
Also published as: CN114564924A

Abstract

The present disclosure relates to a data insertion method, apparatus, device, and storage medium, and relates to the field of data processing technology, in which, when an instruction for inserting form data in a first form file into an online document is received, and displaying the first table file, and displaying first table data corresponding to the data range in the online document in response to the operation of selecting the data range in the first table file. The efficiency of table data insertion is effectively improved, meanwhile, table data displayed in the online document is determined through the generated table data reference relation, the update of the table data inserted into the online document is realized, and the timeliness and the accuracy of the table data in the document are improved.

Description

Data insertion method, device, equipment and storage medium

Technical Field

The present disclosure relates to the field of data processing technologies, and in particular, to a data insertion method, apparatus, device, and storage medium.

Background

Online documents are typically edited or read cooperatively by multiple users simultaneously. Users often need to insert a large amount of form data into the online document content during use of the online document.

In the related art, form data is inserted into online document content by copying the form data or by screenshot a view of the form data. However, both the two methods have disadvantages, for example, a user needs to manually select required table data and insert the table data into a corresponding online document, and the operation process is complicated.

Disclosure of Invention

The data insertion method, the device, the equipment and the storage medium can realize real-time update of the table data in the online document and improve timeliness and accuracy.

The technical scheme of the embodiment of the disclosure is as follows:

According to a first aspect of embodiments of the present disclosure, a data insertion method is provided. The method may include displaying a first form file when an instruction for inserting form data in the first form file into an online document is received, and displaying first form data corresponding to a data range in the online document in response to an operation of selecting the data range in the first form file.

Optionally, displaying the first form data corresponding to the data scope in the online document comprises generating a first form data reference relation according to the data scope, wherein the first form data reference relation is used for associating the online document with the data scope in the first form file, and displaying the first form data corresponding to the data scope associated with the online document in the online document according to the first form data reference relation.

Optionally, the data range comprises a start cell and a stop cell, and the first table data reference relation is generated according to the data range, which comprises the steps of assigning values to table data reference variables corresponding to the online document according to the identification information of the start cell, the stop cell and the first table file to obtain the first table data reference relation.

Optionally, the table data reference variable comprises a first field, a second field and a third field, and the table data reference variable corresponding to the online document is assigned according to the identification information of the start cell, the end cell and the first table file to obtain a first table data reference relation, which comprises the steps of writing the identification information of the start cell, the end cell and the first table file into the first field, the second field and the third field respectively.

Optionally, the insertion position of the first table data is an input position of the instruction.

Optionally, the first table data reference relationship has a relationship identification, the relationship identification of the first table data reference relationship corresponding to the insertion location.

Optionally, the method further comprises the steps of responding to an instruction for editing the first table data in the online document, determining a corresponding first table data reference relation according to a relation identifier corresponding to the insertion position of the first table data, displaying a first table file according to the first table data reference relation, displaying a data range corresponding to the first table data in the first table file, responding to an operation for modifying the data range, and updating the first table data in the online document according to third table data corresponding to the modified data range.

Optionally, the method further comprises, in response to the operation of modifying the data range, updating the first table data reference relationship in accordance with the modified data range.

Optionally, the method further comprises adding the first form data reference relationship to a document model corresponding to the online document, and synchronizing the document model corresponding to the online document to the server.

Optionally, before receiving the instruction for inserting the form data into the online document, the method further comprises the steps of responding to the receiving of the instruction for displaying the online document, acquiring a document model corresponding to the online document from a server, wherein the document model comprises content information of the online document and a second form data reference relation, the content information of the online document comprises the second form data which is inserted into the online document, the second form data is acquired from a second form file by the server according to the second form data reference relation, and displaying the online document according to the content information of the online document.

Optionally, the online document further comprises a data updating control, and the method further comprises responding to the operation of the data updating control, acquiring the latest first form data corresponding to the data range associated with the online document according to the first form data reference relation corresponding to the online document, and updating the online document according to the latest first form data.

Optionally, the method further comprises the step of displaying a data update control in the online document in response to receiving the update prompt information sent by the server.

Optionally, the method further comprises determining a corresponding first form data reference relationship according to a relationship identifier corresponding to an insertion position of the first form data in response to an operation of modifying at least one cell data in the first form data in the online document. And determining table file updating information according to the first table data reference relation and the at least one modified cell data, wherein the table file updating information at least comprises identification information of a first table file, the at least one modified cell data and position information of the at least one cell data in the first table file. And sending the table file updating information to a server so that the server updates the first table file according to the table file updating information.

Optionally, when an instruction for inserting the table data in the first table file into the online document is received, displaying the first table file comprises displaying a table list in response to the instruction, wherein the table list comprises a plurality of table controls, one table control corresponds to each table file, and displaying the first table file corresponding to the first table control in response to the selection operation of the first table control.

According to a second aspect of embodiments of the present disclosure, there is provided a data insertion device. The apparatus may include a table file display unit for displaying a first table file when an instruction for inserting the table data in the first table file into an online document is received, and a table data display unit for displaying first table data corresponding to a data range in the online document in response to an operation of selecting the data range in the first table file.

Optionally, the table data display unit is specifically configured to generate a first table data reference relationship according to the data scope, where the first table data reference relationship is used to associate the online document with the data scope in the first table file, and display, in the online document, first table data corresponding to the data scope associated with the online document according to the first table data reference relationship.

Optionally, the table data display unit is specifically configured to assign a table data reference variable corresponding to the online document according to the identification information of the start cell, the end cell and the first table file, so as to obtain a first table data reference relationship.

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 configured to write identification information of the start cell, the end cell and the first table file into the first field, the second field and the third field, respectively.

Optionally, the table data display unit is further configured to determine a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data in response to receiving an instruction for editing the first table data in the online document, display a first table file according to the first table data reference relationship, display a data range corresponding to the first table data in the first table file, and update the first table data in the online document according to third table data corresponding to the modified data range in response to an operation for modifying the data range.

Optionally, the table data display unit is further configured to update the first table data reference relationship according to the modified data range in response to an operation of modifying the data range.

Optionally, the table data display unit is further configured to add the first table data reference relationship to a document model corresponding to the online document, and synchronize the document model corresponding to the online document to the server.

Optionally, before receiving the instruction for inserting the form data into the online document, the form data display unit is further configured to obtain, from the server, in response to receiving the instruction for displaying the online document, a document model corresponding to the online document, the document model including content information of the online document and a second form data reference relationship, the content information of the online document including second form data that has been inserted into the online document, the second form data being obtained by the server from the second form file according to the second form data reference relationship, and display the online document according to the content information of the online document.

Optionally, the online document further comprises a data updating control, the form data display unit is further used for responding to the operation of the data updating control, acquiring the latest first form data corresponding to the data range associated with the online document according to the first form data reference relation corresponding to the online document, and updating the online document according to the latest first form data.

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

Optionally, the table data display unit is further configured to determine, in response to an operation of modifying at least one cell data in the first table data in the online document, a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data. And determining table file updating information according to the first table data reference relation and the at least one modified cell data, wherein the table file updating information at least comprises identification information of a first table file, the at least one modified cell data and position information of the at least one cell data in the first table file. And sending the table file updating information to a server so that the server updates the first table file according to the table file updating information.

Optionally, the table data display unit is further configured to display a table list in response to the instruction, where the table list includes a plurality of table controls, one table control corresponding to each table file, and display a first table file corresponding to the first table control in response to a selection operation of the first table control.

According to a third aspect of embodiments of the present disclosure, there is provided an electronic device that may include a processor and a memory for storing processor-executable instructions, wherein the processor is configured to execute the instructions to implement any of the optional data insertion methods of the first aspect described above.

According to a fourth aspect of embodiments of the present disclosure, there is provided a computer-readable storage medium having instructions stored thereon, which, when executed by a processor of an electronic device, enable the electronic device to perform any one of the above-described optional data insertion methods of the first aspect.

According to a fifth aspect of embodiments of the present disclosure, there is provided a computer program product comprising computer instructions which, when run on an electronic device, cause the electronic device to perform the data insertion method as optionally implemented in any of the first aspects.

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

The technical scheme provided by the embodiment of the disclosure at least brings the following beneficial effects:

Based on any one of the above aspects, in the present disclosure, when an instruction for inserting form data in a first form file into an online document is received, the first form file is displayed, and in response to an operation of selecting a data range in the first form file, the first form data corresponding to the data range is displayed in the online document. Because the table data reference relation describes the data range, such as the line and the column, corresponding to the target table data, and when the online document is displayed, the table data inserted in the document is acquired from the target table file according to the data range described by the reference relation, even if the table data in the target table file changes, the corresponding latest table data can be acquired according to the table data reference relation, thereby realizing the real-time update of the table data in the online document and improving the timeliness and accuracy of the table data.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure and do not constitute an undue limitation on the disclosure.

FIG. 1 illustrates a schematic diagram of an online document application system provided by an embodiment of the present disclosure;

fig. 2 is a schematic flow chart of a data insertion method according to an embodiment of the disclosure;

FIG. 3 illustrates a schematic diagram of an online document editing interface provided by an embodiment of the present disclosure;

FIG. 4 illustrates a schematic diagram of yet another online document editing interface provided by an embodiment of the present disclosure;

FIG. 5 illustrates a schematic diagram of yet another online document editing interface provided by an embodiment of the present disclosure;

FIG. 6 illustrates a schematic diagram of yet another online document editing interface provided by an embodiment of the present disclosure;

FIG. 7 is a flow chart illustrating yet another method of data insertion provided by an embodiment of the present disclosure;

FIG. 8 illustrates a schematic diagram of yet another online document editing interface provided by an embodiment of the present disclosure;

FIG. 9 is a flow chart illustrating yet another method of data insertion provided by an embodiment of the present disclosure;

FIG. 10 is a flow chart illustrating yet another method of data insertion provided by an embodiment of the present disclosure;

FIG. 11 is a schematic diagram showing a structure of a data insertion device according to an embodiment of the present disclosure;

Fig. 12 shows a schematic structural diagram of an electronic device according to an embodiment of the disclosure.

Detailed Description

In order to enable those skilled in the art to better understand the technical solutions of the present disclosure, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with some aspects of the present disclosure as detailed in the accompanying claims.

It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, and/or components.

The data referred to in this disclosure may be data authorized by the user or sufficiently authorized by the parties.

As described in the background section, online documents are typically edited or read cooperatively by multiple users simultaneously. Users often need to insert a large amount of form data into the online document content during use of the online document.

In the related art, form data is inserted into online document content by copying the form data or by screenshot a view of the form data. However, both the two modes have the defects that for example, a user is required to manually select required form data and then insert the form data into a corresponding online document, the operation process is complicated, and the use experience of the user is seriously affected.

Based on this, the embodiment of the disclosure provides a data insertion method, which comprises the steps of displaying a first table file when an instruction for inserting the table data in the first table file into an online document is received, and displaying the first table data corresponding to the data range in the online document in response to an operation of selecting the data range in the first table file.

The following describes an application scenario of the data insertion method provided by the embodiment of the present disclosure in an exemplary manner:

Fig. 1 is a schematic diagram of an online document application system according to an embodiment of the disclosure, and as shown in fig. 1, 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 through a wired network or a wireless network.

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

In some embodiments, the server may be a single server, or may be a server cluster composed of multiple servers (or micro servers). The server cluster may also be a distributed cluster. The present disclosure is also not limited to a particular implementation of server 110.

The terminal device 120 may be configured to obtain a document model of an online document from the server 110, display the online document according to the document model, and receive an editing operation of the online document by a user, such as an operation of inserting target table data in a target table file into the online document. The terminal device 120 may 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, and add the table data reference relationship to the document model, and send the document model to the server.

In some embodiments, the terminal device may be a mobile phone, a tablet computer, a desktop, a laptop, a handheld computer, a notebook, an ultra-mobile personal computer (UMPC), a netbook, a cellular phone, a Personal Digital Assistant (PDA), an augmented reality (augmented reality, AR) \virtual reality (VR) device, or the like, that may install and use an online document editing application, and the present disclosure does not limit the specific form of the terminal. The system can perform man-machine interaction with a user through one or more modes of a keyboard, a touch pad, a touch screen, a remote controller, voice interaction or handwriting equipment and the like.

Alternatively, the server 110 in the online document application system shown in fig. 1 described above may be connected to at least one terminal device 120. The present disclosure is not limited in the number and type of terminal devices 120.

It should be noted that, the terminal device 120 and the server 110 may be independent devices, or may be integrated in the same device, which is not particularly limited in the present invention.

When the terminal device 120 and the server 110 are integrated in the same device, the communication between the terminal device 120 and the server 110 is performed by a communication between internal modules of the device. In this case, the communication flow therebetween is the same as "in the case where the terminal device 120 and the server 110 are independent of each other".

In the following embodiments provided in the present invention, explanation will be mainly given by taking an example in which the terminal device 120 and the server 110 are provided independently of each other.

The data insertion method provided by the embodiment of the present disclosure may be applied to the terminal device 120 shown in fig. 1.

Fig. 2 is a flowchart of a data insertion method according to an embodiment of the present disclosure, as shown in fig. 2, when the data insertion method is applied to a terminal device, the data insertion method may include:

s201, when an instruction for inserting form data in the first form file into the online document is received, the first form file is displayed.

Specifically, the instruction for inserting the form data is input by a user in an online document editing interface. And in response to an instruction for inserting the table data into the online document, displaying a table list, wherein the table list comprises a plurality of table controls, one table control corresponds to one table file, and in response to a selection operation of the first table control, starting the first table file corresponding to the first table control.

Illustratively, referring to FIG. 3, FIG. 3 is an online document editing interface shown in the present disclosure, when a user clicks right on the interface to activate an insert control menu 310 or trigger an insert control 320, a control menu is displayed that includes a plurality of controls for the user to insert content in the online document, such as an insert picture control 301, an insert form control 302, an insert attachment control 303, an insert online form reference control 304, and an insert code block control 305. Wherein insert picture control 301 is used to insert a picture in an online document. The insert form control 302 is used to insert forms in online documents that will not update the form data in real time after the form insertion is successful. The insert attachment control 303 is used to insert attachments in online documents. The insert online form reference control 304 is used to insert form data into an online document, and after the form data is inserted into the online document using this function, the form data in the online document is updated according to the change of the corresponding form data in the form file, and also updated according to the change of the form data reference relationship corresponding to the online document, for a detailed description of the foregoing "form data reference relationship", please refer to the following embodiments. An insert code block control 305 is used to insert code blocks in an online document. In connection with the example shown in FIG. 3, a user may input instructions for inserting form data into an online document by operating insert online form reference control 304.

FIG. 4 is a schematic diagram of another online document editing interface shown in an embodiment of the present disclosure. Referring to fig. 4, when the user selects the insert online form reference control 304, in response to the generated instruction for inserting form data into the online document, a corresponding form list 410 is displayed in the online document editing interface, where the form list 410 includes a plurality of form controls 401, each form control corresponds to a form file, and a form file name is displayed on the form control, so that the user can select a desired form control according to the form file name. Further, in response to the selection operation of a certain form control by a user, a first form file corresponding to the form control is opened.

FIG. 5 is an illustration of an online document editing interface, as shown in the present disclosure, in which a user may select a desired data range in a first form file in response to an instruction to launch the first form file, by displaying the first form file on the interface.

As can be seen from the above embodiments, when a user inputs an instruction for inserting form data into an online document, a form list is displayed, and a first form file is selected in the form list, so that the user can select the first form file from the list, and the user can start the first form file by operating a corresponding form control, thereby selecting the required first form data.

In some embodiments, the first form file is an online form file that is previously uploaded to the server.

On the one hand, the first table file is uploaded to the server as the online table file, and when other users start corresponding online documents, table data of the first table file can be obtained from the server according to the table data reference relation in the document model, so that real-time updating of the table data in the online documents is realized under the working scene of editing the online documents by multiple persons, and timeliness and accuracy of the table data are improved. On the other hand, the form file is uploaded to the server in advance to be an online form file, so that any user can access the form file in the server. Meanwhile, the method is not only limited to selecting the data to be inserted from the form file local to the user side equipment, but also convenient for the user to insert the form data into the online document at any time and any place.

S202, in response to the operation of selecting the data range in the first table file, displaying the first table data corresponding to the data range in the online document.

Specifically, the data range includes a start cell, a stop cell, and an intermediate cell determined according to the start cell and the stop cell, for example, when the start cell is A1 and the stop cell is an F5 user selected data range may be from an a-th row to an F-th row in the target table file.

For example, referring to fig. 6, the data range selected by the user in the target table file is the 1 st row a column cell to the 5 th row F column cell in the target table file.

As shown in fig. 7, in S202, the first table data corresponding to the data range is displayed in the online document, and specifically includes:

s701, generating a first table data reference relation according to the data range, wherein the first table data reference relation is used for associating the online document with the data range in the first table file.

Specifically, 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, and the first table data reference relation is obtained.

In this implementation, the form referencing function of the online document has a form data referencing variable corresponding to the variable, and the online document application stores the variable in memory after the online document application is started. When the table data reference relation needs to be generated, the variable is assigned by 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 stored in the variable. When the inserted form data needs to be displayed in the document, the online document application can acquire the corresponding form data by reading the value of the variable and according to the read value.

In some embodiments, the table data reference variables include a first field, a second field and a third field, and assigning values to the table data reference variables corresponding to the online document according to the identification information of the start cell, the end cell and the first table file to obtain the first table data reference relationship, including writing the identification information of the start cell, the end cell and the first table file into the first field, the second field and the third field respectively.

The format of the TABLE data REFERENCE relationship is table_reference (TABLE 1, A1: F5), where table_reference represents that the current data is the TABLE data REFERENCE relationship, the first field is "A1" is the start cell of the TABLE data REFERENCE relationship, the second field is "F5" is the end cell of the TABLE data REFERENCE relationship, A1: F5 represents the TABLE data corresponding to the 1 st row, a column cell to the 5 th row, and a column cell in the designated TABLE 1, is the data range corresponding to the TABLE data REFERENCE relationship, and the third field is the TABLE file corresponding to the TABLE data REFERENCE relationship.

In some embodiments, the first table data reference relationship has a relationship identification, the relationship identification of the first table data reference relationship corresponding to the insertion location. The relation identification is used for uniquely determining the form data corresponding to the form data reference relation, and the insertion position in the online document is determined according to the input position of the instruction for inserting the form data into the online document.

Because there may be a plurality of table data in an online document, the plurality of table data correspond to a plurality of data table reference relationships, through the relationship identifier, the display position of the table data corresponding to each table data reference relationship in the online document can be determined, which corresponds to the input position of the data insertion instruction, for example, the instruction of inputting data by the user 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 which should be displayed in the fifth line is determined according to the relationship identifier, if other table data reference relationships exist, the corresponding table data is displayed in other positions according to the relationship identifier, and from the above, the variable identifier is used for positioning the table data reference relationship and the corresponding table data in the online document.

For example, when a user inputs an instruction for inserting table data in the 6 th line of the online document editing interface, a required data range is selected, a corresponding table data reference relation is generated, at this time, a variable corresponding to the table data reference relation is identified as the 6 th line, and when the corresponding table data is displayed in the online document according to the table data reference relation, the table data is displayed in the 6 th line of the online document.

As can be seen from the foregoing, since different table data may be inserted at different locations in one online document, where different table data may be from different table files and/or correspond to different data ranges, in practical application, one online document may correspond to a plurality of table data reference variables, where different table data reference variables correspond to table data inserted at different locations. Based on this, by setting an identification for each table data reference variable and establishing an association between the table data corresponding to the table data reference variable and the insertion position by establishing an association between the variable identification and the data insertion position, it is possible to ensure that the table data can be displayed at the corresponding position.

In a further implementation, the table data reference relationship includes at least one reference variable that points to the table data corresponding to the at least one target cell, respectively, and table file identification information that is used to uniquely identify the target table file.

Illustratively, a table data reference relationship is generated from the data scope, wherein the table data reference relationship is a temporary variable. The table file identification information is used for uniquely determining the target table file, wherein the table file identification information can be a file name or a table name of the current target table file.

The generated table data reference relation can enable a user to select data corresponding to a required cell in the target table file to generate the corresponding table data reference relation through a plurality of discontinuous reference variables corresponding to the target cell selected by the user, and further corresponding table data is displayed in the online document, for example, when a data range required by the user is the table data corresponding to the cells A1-A15 and C1-C15, the table data of the cell B column is not the data required by the user, at the moment, 30 corresponding reference variables are generated according to the cells A1-A15 and C1-C15, and the table data corresponding to the cells A1-A15 and C1-C15 can be displayed in the online document through the table data reference relation generated by the 30 reference variables.

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 relation.

As can be seen from S701-S702, a specific implementation of generating a table data reference relationship is provided, in which a table data reference variable corresponds to a table reference function of an online document, and the online document application stores the variable in a memory after the online document application is started. When the table data reference relation needs to be generated, the variable is assigned by 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 stored in the variable. When the inserted form data needs to be displayed in the document, the online document application can acquire the corresponding form data by reading the value of the variable and according to the read value.

Exemplary, referring to fig. 8, fig. 8 is a schematic diagram of an online document editing interface in which corresponding first form data is displayed, as shown in the present disclosure.

For example, after the form data of a certain data range in the form file 1 is inserted into the online document 1, when the form data corresponding to the data range in the form file 1 is modified, in the prior art, the user needs to manually copy the modified form data into the online document again, which is complex in operation and poor in timeliness.

In connection with the present disclosure, it is known from S201 to S202 that when an instruction for inserting the form data in the first form file into the online document is received, the first form file is displayed, and in response to an operation of selecting the data range in the first form file, the first form data corresponding to the data range is displayed in the online document. Because the table data reference relation describes the data range, such as the line and the column, corresponding to the target table data, and when the online document is displayed, the table data inserted in the document is acquired from the target table file according to the data range described by the reference relation, even if the table data in the target table file changes, the corresponding latest table data can be acquired according to the table data reference relation, thereby realizing the real-time update of the table data in the online document and improving the timeliness and accuracy of the table data.

In some embodiments, further comprising adding the tabular data reference relationship to a document model corresponding to the online document, and synchronizing the document model corresponding to the online document to the server.

Specifically, the document model also includes content information for the online document. The user can start the corresponding online document by selecting the document model, so as to realize the editing operation of the online document.

The document model corresponding to the online document is synchronized to the server by adding the tabular data reference relationship to the document model corresponding to the online document. The user can obtain the corresponding document model from the server, and the corresponding form data is displayed on the online document interface, so that the real-time update of the form data is realized under the scene of editing the same online document by multiple persons, and meanwhile, when the document model stored locally by the user is damaged or lost, the further loss caused by the damage or loss of the document model can be avoided by obtaining the document model in the server.

In some embodiments, the method further comprises determining a relationship identifier corresponding to an insertion position of the first table data in response to receiving an instruction for editing the first table data in the online document, so as 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, wherein a data range corresponding to the first table data in the first table file is highlighted, and updating the first table data in the online document according to third table data corresponding to the modified data range in response to an operation for modifying the data range.

In some embodiments, in response to an operation to modify the data range, the corresponding table data reference relationship is updated according to the modified data range.

Specifically, the updated table data reference relation is added into the document model and uploaded to the server, and when other users acquire the document model, corresponding table data is displayed in the online document through the updated table data relation, so that real-time update of the table data in the online document is realized, and timeliness and accuracy of the table data are improved.

In some embodiments, the method further comprises determining a relationship identifier corresponding to an insertion position of the first table data in response to receiving an instruction for editing the first table data in the online document, determining 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, wherein a data range corresponding to the first table data in the first table file is highlighted, and 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 in response to an operation of modifying the data corresponding to at least one cell in the first table file.

In some embodiments, the method further comprises sending third table data to the server to cause the server to update the first table file based on the third table data. It should be noted that, the current user has the right to modify the first table file.

In some embodiments, the online document editing interface further includes a data update control, as shown in FIG. 9, that, in the event that the online document has been launched, further includes:

S901, responding to the operation of the data updating control, and acquiring the latest first form data corresponding to the data range associated with the online document according to the first form data reference relation corresponding to the online document.

S902, displaying the online document according to the content information of the online document.

In some embodiments, the data insertion method further includes displaying a data update control in the online document in response to receiving the update prompt sent by the server. The update prompt information is sent when the server determines that the form data inserted in the online document changes according to the form data reference relation corresponding to the online document.

As can be seen from S901-S902, since the data update control is generated according to the update prompt information sent by the system, when the data update control is displayed in the online document, it is explained that the data in the online document is to be updated at this time, by selecting the data update control by the user, the timely update of the table data in the online document is realized, the timeliness and accuracy of the table data are improved, and the user experience is further improved.

In some embodiments, referring to fig. 10, the method further comprises:

S1001, responding to receiving an instruction for starting an online document, and acquiring a document model corresponding to the online document from a server.

Specifically, the document model includes content information of the online document and a second table data reference relationship, the content information of the online document includes second table data inserted in the online document, and the second table data is obtained from a second table file by the server according to the second table data reference relationship. The second form data refers to form data that has been inserted into the online document prior to the online document being launched. And acquiring the table data of the corresponding data range from the second table file according to the data range corresponding to the table data reference relation. For example, if the start cell of the data range is A1 and the end cell is F5, the data range is from the 1st row, the a column cell to the 5 th row, and the F column cell in the second table file. And obtaining second table data according to the table data corresponding to the 1st row and the A column cells to the 5 th row and the F column cells in the second table file.

S1002, displaying the online document according to the content information of the online document.

Illustratively, assuming that the form data in form file 1 has been inserted into the online document prior to some opening of the online document, the form data from form file 1 will be displayed directly in the online document upon opening of the online document. In conjunction with the above S1002, the form file 1 is a second form file, and the form data from the form file 1 in the online file is the second form data. Then, if an instruction for inserting the table data is input after the online document is opened this time, and the table file 2 is opened as required, and the table data in the table file 2 is inserted into the online document, the table file 2 is the first table file, and the table data from the table file 2 inserted into the online document is the first table data. Note that, the table file 1 and the table file 2 may be the same table file or may be different table files.

It is 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, the online document is displayed according to the content information of the online document and the corresponding table data reference relationship by obtaining the document model corresponding to the online document from the server, the table data displayed in the online document is determined, the document model includes the content information of the online document and the corresponding table data reference relationship, the specified table data is obtained in the specified table file according to the data range of the specified table data described by the table data reference relationship, wherein the specified table data is the table data inserted in the online document, and the online document is displayed according to the content information of the online document and the obtained specified table data, so that the real-time update of the table data in the online document of other users is realized, and the timeliness and accuracy of the table data in the document are improved.

In some embodiments, before receiving the instruction for inserting the form data into the online document, further comprising, in response to receiving the instruction to launch the online document, obtaining a document model corresponding to the online document from the server, and displaying the online document according to content information of the online document.

Specifically, the document model includes content information of the online document and a corresponding table data reference relationship, the content information of the online document includes a data range of specified table data in a specified table file described by the server according to the table data reference relationship, the specified table data is acquired in the specified table file, and the specified table data refers to the table data inserted in the online document.

Illustratively, before a user receives a document model from a server, the server determines a first table file corresponding to a table data reference relationship according to the table data reference relationship in the document model, and when the first table file is generated for the corresponding table data reference relationship, the user opens a target table file. The server determines corresponding table data according to the data range corresponding to the table data reference relation, adds the table data into the document model and sends the document model to the user.

Therefore, the user can display the online document through the content information of the online document in the document model, and meanwhile, according to the form data corresponding to the specified form file determined before, the user can directly display the online document without sending the form data corresponding to the reference relation of the form data to the server again, so that the working efficiency is improved, and the instantaneity and the accuracy of the form data are ensured. The starting method and the device for opening the online document can greatly shorten the starting time required by the user to open the online document, and effectively improve the use experience of the user.

In some embodiments, the data insertion method further comprises the steps of responding to the operation of modifying at least one cell data in the first table data in the online document, determining a corresponding first table data reference relation according to a relation identifier corresponding to the insertion position of the first table data, and determining table file updating information according to the first table data reference relation and the modified at least one cell data. The table file updating information at least comprises identification information of the first table file, modified at least one cell data and position information of the at least one cell data in the first table file. And sending the table file updating information to the server so that the server updates the first table file according to the table file updating information.

Specifically, when the first table data is displayed in the online document, the first table data includes a plurality of cell data, where the cell data corresponds to different data for each cell, for example, the first table data includes three cells, respectively, cell A1-A3, cell A1 corresponds to 20, cell A2 corresponds to 30, and cell A3 corresponds to 50. Then cell A1 and corresponding data 20 are one cell data.

Specifically, when the user inputs the operation of modifying at least one cell data under the condition that the user has the authority of modifying the first table file, the 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 is changed to be in an editable state, and the user can input any data to modify the at least one cell data. It should be noted that, the selection manner may be double-click or touch click through the cursor. For example, when the user selects the cell A1 by touch, the cell A1 is changed to an editable state, and the user inputs 50, that is, the data corresponding to the cell A1 is changed from 20 to 50. The table file update information determined at this time is (identification information of the first table file: 50: A1), the table file update information is transmitted to the server, and the server changes the numerical value corresponding to the cell A1 in the first table file from 20 to 50 based on the table file update information. The real-time update of the data in the online form file is realized.

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

In some embodiments, the table file update information may further include identification information of the first table file, all cell data after modification, and location information of the cell data in the first table file. And sending the table file updating information to the server so that the server updates the first table file according to the table file updating information. Because the table file updating information comprises all cell data and the position information of the cell data in the first table file, the data range corresponding to the first table file is covered by the table file updating information, so that the updating of the first table file is realized.

According to the method, when a user needs to update the data in the table file, the user does not need to acquire and display the corresponding table file, and only needs to modify at least one cell data of the table data in the online document, so that the corresponding data in the table file can be updated in real time, and timeliness and accuracy are improved.

It will be appreciated that, in actual implementation, the terminal/server of the embodiments of the present disclosure may include one or more hardware structures and/or software modules for implementing the foregoing corresponding data insertion method, where the executing hardware structures and/or software modules may constitute an electronic device. Those of skill in the art will readily appreciate that the algorithm steps of the examples described in connection with the embodiments disclosed herein may be implemented as hardware or a combination of hardware and computer software. Whether a function is implemented as hardware or computer software driven hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present disclosure.

Based on such understanding, the embodiment of the present disclosure also correspondingly provides a data insertion device, which can be applied to an electronic device. Fig. 11 shows a schematic structural diagram of a data insertion device provided by an embodiment of the present disclosure. As shown in fig. 11, the data inserting apparatus may include a table file display unit 111 and a table data display unit 112.

According to a second aspect of embodiments of the present disclosure, there is provided a data insertion device. The apparatus may include a table file display unit and a table data display unit, a table file display unit 111 for displaying a first table file when an instruction for inserting the table data in the first table file into the online document is received, and a table data display unit 112 for displaying first table data corresponding to the data range in the online document in response to an operation of selecting the data range in the first table file.

Optionally, the table data display unit 112 is specifically configured to generate a first table data reference relationship according to the data scope, where the first table data reference relationship is used to associate the online document with the data scope in the first table file, and display, in the online document, first table data corresponding to the data scope associated with the online document according to the first table data reference relationship.

Optionally, the table data display unit 112 is specifically configured to assign a value to a table data reference variable corresponding to the online document according to the identification information of the start cell, the end cell and the first table file, so as to obtain a first table data reference relationship.

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 configured to write identification information of the start cell, the end cell, and the first table file into the first field, the second field, and the third field, respectively.

Optionally, the table data display unit 112 is further configured to determine a corresponding first table data reference relationship according to a relationship identifier corresponding to an insertion position of the first table data in response to receiving an instruction for editing the first table data in the online document, display a first table file according to the first table data reference relationship, display a data range corresponding to the first table data in the first table file, and update the first table data in the online document according to a third table data corresponding to the modified data range in response to an operation for modifying the data range.

Optionally, the table data display unit 112 is further configured to update the first table data reference relationship according to the modified data range in response to the operation of modifying the data range.

Optionally, the table data display unit 112 is further configured to add the first table data reference relationship to a document model corresponding to the online document, and synchronize the document model corresponding to the online document to the server.

Optionally, before receiving the instruction for inserting the form data into the online document, the form data display unit 112 is further configured to obtain, from the server, in response to receiving the instruction for displaying the online document, a document model corresponding to the online document, the document model including content information of the online document and second form data reference relationships, the content information of the online document including second form data that has been inserted into the online document, the second form data being obtained by the server from the second form file according to the second form data reference relationships, and display the online document according to the content information of the online document.

Optionally, the online document further includes a data update control, and the form data display unit 112 is further configured to, in response to an operation of the data update control, obtain, according to a first form data reference relationship corresponding to the online document, latest first form data corresponding to a data range associated with the online document, and update the online document according to the latest first form data.

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

Optionally, the table data display unit 112 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 the insertion position of the first table data. And determining table file updating information according to the first table data reference relation and the modified at least one cell data, wherein the table file updating information at least comprises identification information of the first table file, the modified at least one cell data and position information of the at least one cell data in the first table file. And sending the table file updating information to the server so that the server updates the first table file according to the table file updating information.

Optionally, the table data display unit 112 is further configured to display a table list in response to the instruction, where the table list includes a plurality of table controls, and one table control corresponds to one table file, and display a first table file corresponding to the first table control in response to the selection operation of the first table control.

As above, the embodiments of the present disclosure may divide functional modules of an electronic device according to the above-described method examples. The integrated modules may be implemented in hardware or in software functional modules. In addition, it should be further noted that the division of the modules in the embodiments of the present disclosure is merely a logic function division, and other division manners may be implemented in practice. For example, each functional module may be divided corresponding to each function, or two or more functions may be integrated in one processing module.

The specific manner in which each module performs the operation and the beneficial effects of the data insertion device in the foregoing embodiment are described in detail in the foregoing method embodiment, and are not described herein again.

The embodiment of the disclosure also provides electronic equipment. Fig. 12 shows a schematic structural diagram of an electronic device provided by an embodiment of the present disclosure. The electronic device may be a data insertion apparatus and may include at least one processor 121, a communication bus 122, a memory 123, and at least one communication interface 124.

The processor 121 may be a processor (central processing units, CPU), a microprocessor unit, ASIC, or one or more integrated circuits for controlling the execution of programs in accordance with aspects of the present disclosure. As an example, in connection with fig. 11, the table data display unit 112 in the electronic device realizes the same function as the processor 121 in fig. 12.

Communication bus 122 may include a path to transfer information between the components.

Communication interface 124, using any transceiver-like means for communicating with other devices or communication networks, such as servers, ethernet, radio access network (radio access network, RAN), wireless local area network (wireless local area networks, WLAN), etc. As an example of this, in one embodiment,

Memory 123 may be, but is not limited to, a read-only memory (ROM) or other type of static storage device that can store static information and instructions, a random access memory (random access memory, RAM) or other type of dynamic storage device that can store information and instructions, or an electrically erasable programmable read-only memory (ELECTRICALLY ERASABLE PROGRAMMABLE READ-only memory, EEPROM), a compact disc read-only memory (compact disc read-only memory) or other optical disk storage, a compact disc storage (including compact 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 desired program code in the form of instructions or data structures and that can be accessed by a computer. The memory may be stand alone and be connected to the processing unit by a bus. The memory may also be integrated with the processing unit.

Wherein the memory 123 is used for storing application program codes for executing the disclosed scheme and is controlled to be executed by the processor 121. The processor 121 is configured to execute application code stored in the memory 123 to implement the functions in the methods of the present disclosure.

In a particular implementation, processor 121 may include one or more CPUs, such as CPU0 and CPU1 of FIG. 12, as an embodiment.

In a particular implementation, as one embodiment, an electronic device may include multiple processors, such as processor 121 and processor 125 in FIG. 12. Each of these processors may be a single-core (single-CPU) processor or may be a multi-core (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).

In a specific implementation, the electronic device may also include an input device 126 and an output device 127, as one embodiment. The input device 126 and the output device 127 communicate, and may accept user input in a variety of ways. For example, the input device 126 may be a mouse, keyboard, touch screen device, or sensing device, among others. The output device 127 is in communication 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) CRYSTAL DISPLAY, a Light Emitting Diode (LED) display device, or the like.

Those skilled in the art will appreciate that the structure shown in fig. 12 is not limiting of the electronic device and may include more or fewer components than shown, or may combine certain components, or may employ a different arrangement of components.

The embodiment of the disclosure also provides electronic equipment. The electronic device may be a data insertion apparatus. The electronic device may vary considerably in configuration or performance and may include one or more processors and one or more memories. At least one instruction is stored in the memory, and the at least one instruction is loaded and executed by the processor to implement the data insertion method provided by each method embodiment. Of course, the electronic device may also have a wired or wireless network interface, a keyboard, an input/output interface, and other components for implementing the functions of the device, which are not described herein.

The present disclosure also provides a computer-readable storage medium including instructions stored thereon, which when executed by a processor of a computer device, enable the computer to perform the data insertion method provided by the above-described illustrated embodiments. For example, the computer readable storage medium may be a memory 123 including instructions executable by the processor 121 of the terminal to perform the above-described method. For another example, a computer-readable storage medium may be a memory comprising instructions executable by a processor of an electronic device to perform the method described above. Alternatively, the computer readable storage medium may be a non-transitory computer readable storage medium, for example, ROM, RAM, CD-ROM, magnetic tape, floppy disk, optical data storage device, and the like.

The present disclosure also provides a computer program product comprising computer instructions which, when run on an electronic device, cause the electronic device to perform the data insertion method shown in any of the above figures 1 to 10.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This disclosure is intended to cover any adaptations, uses, or adaptations of the disclosure following the general principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A method of data insertion, the method comprising:

Displaying a first form file when an instruction for inserting form data in the first form file into an online document is received;

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, the first table data reference relationship being used to associate the online document with the data range in the first table file;

And displaying first table data corresponding to the data range associated with the online document in the online document according to the first table data reference relation.

2. The data insertion method of claim 1, wherein the data range includes a start cell and a stop cell, wherein the generating the first table data reference relationship from the data range includes:

And assigning the 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 the first table data reference relation.

3. The data insertion method according to claim 2, wherein the table data reference variables include a first field, a second field, and a third field, and the assigning the table data reference variables corresponding to the online document according to the identification information of the start cell, the end cell, and the first table file to obtain the first table data reference relationship includes:

and 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.

4. A data insertion method according to any one of claims 1 to 3, wherein the insertion position of the first table data is an input position of the instruction.

5. The data insertion method of claim 4, wherein the first table data reference relationship has a relationship identification, the relationship identification of the first table data reference relationship corresponding to the insertion location.

6. The data insertion method of claim 5, further comprising:

Responsive to receiving an instruction for editing the first form data in the online document, determining a corresponding first form data reference relationship according to a relationship identifier corresponding to an insertion position of the first form data;

displaying the first table file according to the first table data reference relation, wherein the first table file displays a data range corresponding to the first table data;

And responding to the operation of modifying the data range, and updating the first table data in the online document according to the third table data corresponding to the modified data range.

7. The data insertion method of claim 6, wherein the method further comprises:

And in response to the operation of modifying the data scope, updating the first table data reference relation according to the modified data scope.

8. A data insertion method according to any one of claims 1-3, further comprising:

Adding the first form 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.

9. The data insertion method according to claim 1, wherein before receiving the instruction for inserting the form data into the online document, further comprising:

In response to receiving an instruction for displaying the online document, acquiring a document model corresponding to the online document from a server, wherein the document model comprises content information of the online document and a second table data reference relation, the content information of the online document comprises second table data which is inserted into the online document, and the second table data is acquired from a second table file by the server according to the second table data reference relation;

And displaying the online document according to the content information of the online document.

10. A data insertion method according to any of claims 1-3, wherein the online document further comprises a data update control, the method further comprising:

responding to the operation of the data updating control, and acquiring the latest first form data corresponding to the data range associated with the online document according to the first form data reference relation corresponding to the online document;

and updating the online document according to the latest first table data.

11. The data insertion method of claim 10, further comprising:

and 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 of claim 5, further comprising:

Responsive 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 updating information according to the first table data reference relation and the at least one modified cell data, wherein the table file updating information at least comprises identification information of a first table file, the at least one modified cell data and position information of the at least one cell data in the first table file;

and sending the table file updating information to a server so that the server updates the first table file according to the table file updating information.

13. The data insertion method according to claim 1, wherein the displaying the first table file when an instruction for inserting the table data in the first table file into the online document is received includes:

In response to the instruction, displaying a table list, wherein the table list comprises a plurality of table controls, and one table control corresponds to one table file;

And responding to the selection operation of the first form control, and displaying the first form file corresponding to the first form control.

14. A data insertion apparatus, comprising:

A form file display unit configured to display a first form file when an instruction for inserting form data in the first form file into an online document is received;

And a table data display unit, configured to generate a first table data reference relationship according to a data range in response to an operation of selecting the data range in the first table file, where the first table data reference relationship is used to associate the online document with the data range in the first table file, and display 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 insertion device according to claim 14, wherein the data range comprises a start cell and an end cell, the tabular data display unit being specifically configured to:

16. The data insertion device according to claim 15, wherein the table data reference variable comprises a first field, a second field and a third field, the table data display unit being specifically configured to:

17. The data insertion device according to any one of claims 14 to 16, wherein the insertion position of the first form data is an input position of the instruction.

18. The data insertion device of claim 17, wherein the first table data reference relationship has a relationship identification, the relationship identification of the first table data reference relationship corresponding to the insertion location.

19. The data insertion device of claim 18, wherein the tabular data display unit is further configured to:

20. The data insertion device of claim 19, wherein the tabular data display unit is further configured to update the first tabular data reference relationship according to the modified data range in response to an operation to modify the data range.

21. The data insertion device of any one of claims 14-16, wherein the tabular data display unit is further configured to add the first tabular data reference relationship to a document model corresponding to the online document, and synchronize the document model corresponding to the online document to a server.

22. The data insertion device according to claim 14, wherein the form data display unit is further configured to, prior to the receiving of the instruction for inserting form data into an online document

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

24. The data insertion device of claim 23, wherein the tabular data display unit is further configured to display the data update control in the online document in response to receiving an update prompt sent by a server.

25. The data insertion device of claim 18, wherein the tabular data display unit is further configured to:

26. The data insertion device of claim 14, wherein the form data display unit is further configured to display a form list in response to the instruction, wherein the form list includes a plurality of form controls, one form control corresponding to each form file, and display a first form file corresponding to a first form control in response to a selection operation of the first form control.

27. An electronic device comprising a processor, a memory for storing instructions executable by the processor, wherein the processor is configured to execute the instructions to implement the data insertion method of any one of claims 1 to 13.

28. A computer readable storage medium, characterized in that instructions in the computer readable storage medium, when executed by a processor, cause the processor to implement the data insertion method of any of claims 1 to 13.

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