CN111368520A

CN111368520A - Editing method and device for electronic forms

Info

Publication number: CN111368520A
Application number: CN202010127705.5A
Authority: CN
Inventors: 石晓腾
Original assignee: Ping An Life Insurance Company of China Ltd
Current assignee: Ping An Life Insurance Company of China Ltd
Priority date: 2020-02-28
Filing date: 2020-02-28
Publication date: 2020-07-03

Abstract

The invention is suitable for the technical field of data processing, and provides a spreadsheet editing method and equipment, wherein the spreadsheet editing method comprises the following steps: if an editing request of the electronic form is received, calling an online editing server to construct a form frame corresponding to the electronic form; determining a target database according to the editing request, and downloading table data corresponding to the electronic table from the target database; importing the form data into the form frame, generating and displaying the electronic form, and performing editing operation on the displayed electronic form; updating the form data of the spreadsheet based on a user-initiated editing instruction; and uploading the updated table data to the target database at preset updating time intervals. The invention improves the editing efficiency of the electronic form, realizes the purpose of multi-person online form editing and reduces the time consumption of editing operation.

Description

Editing method and device for electronic forms

Technical Field

The invention belongs to the technical field of data processing, and particularly relates to a spreadsheet editing method and spreadsheet editing equipment.

Background

With the continuous progress of the electronic process, more and more data processing processes can be completed through the electronic forms, for example, the data is sorted and counted through the electronic forms, and the form electronic process greatly improves the efficiency of analyzing the data by a user. When the field related to the product to be analyzed is wider or the product is continuously developed, the data to be analyzed is increased, and at the moment, the editing operation on the spreadsheet is often finished by cooperation of a plurality of users and even different personnel of a plurality of departments, and the subsequent data analysis operation is performed based on the edited spreadsheet. The existing spreadsheet technology needs a certain user to complete editing when dealing with the situation of simultaneous editing of multiple users, and then forwards the spreadsheet to other users for editing in a line, thereby prolonging the editing time of the spreadsheet and further reducing the efficiency of data analysis.

Disclosure of Invention

In view of this, embodiments of the present invention provide a method and an apparatus for editing a spreadsheet, so as to solve the problem that, in the existing spreadsheet technology, when a scene edited by multiple users at the same time needs to be dealt with, after editing by a certain user is completed, the spreadsheet is forwarded to other users to be edited offline, so that the editing time of the spreadsheet is increased, and then the efficiency of data analysis is reduced.

A first aspect of an embodiment of the present invention provides a method for editing an electronic form, including:

if an editing request of the electronic form is received, calling an online editing server to construct a form frame corresponding to the electronic form;

determining a target database according to the editing request, and downloading table data corresponding to the electronic table from the target database;

importing the form data into the form frame, generating and displaying the electronic form, and performing editing operation on the displayed electronic form;

updating the form data of the spreadsheet based on a user-initiated editing instruction;

and uploading the updated table data to the target database at preset updating time intervals.

A second aspect of an embodiment of the present invention provides an editing apparatus for an electronic form, including:

the spreadsheet framework building unit is used for calling an online editing server to build a spreadsheet framework corresponding to the spreadsheet if an editing request of the spreadsheet is received;

the table data downloading unit is used for determining a target database according to the editing request and downloading table data corresponding to the electronic table from the target database;

the spreadsheet display unit is used for importing the spreadsheet data into the spreadsheet frame, generating and displaying the spreadsheet, and executing editing operation on the displayed spreadsheet;

the form data updating unit is used for updating the form data of the electronic form based on an editing instruction initiated by a user;

and the table data uploading unit is used for uploading the updated table data to the target database at a preset updating time interval.

A third aspect of embodiments of the present invention provides a terminal device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the steps of the first aspect when executing the computer program.

A fourth aspect of embodiments of the present invention provides a computer-readable storage medium storing a computer program which, when executed by a processor, performs the steps of the first aspect.

The method and the equipment for editing the electronic form provided by the embodiment of the invention have the following beneficial effects:

according to the embodiment of the invention, when the electronic form needs to be edited, the online editing server is called to build the form frame, the form data corresponding to the electronic form is downloaded from the target database corresponding to the editing instruction, and as the form data is stored in the cloud database, after the editing is finished, each user can automatically upload the data to the cloud server, the form data which is edited and downloaded from the target database is the latest form data, and the downloaded form data is led into the preset form frame to generate the electronic form, so that the user can edit the displayed electronic form, and the purposes of online generation and editing of the electronic form are realized. Compared with the prior spreadsheet technology, the spreadsheet is not required to be transmitted offline in a scene that multiple users edit the same spreadsheet, the spreadsheet data are stored in the cloud server, and the spreadsheet data downloaded from the cloud server are imported into the spreadsheet frame to generate the spreadsheet when the users edit the spreadsheet data.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.

Fig. 1 is a flowchart of an implementation of a method for editing a spreadsheet according to a first embodiment of the present invention;

fig. 2 is a flowchart illustrating an implementation details of an editing method S101 for an electronic form according to a second embodiment of the present invention;

FIG. 3 is a flowchart illustrating an embodiment of a method for editing a spreadsheet according to a third embodiment of the present invention;

FIG. 4 is a flowchart illustrating an embodiment of a method for editing a spreadsheet according to a fourth embodiment of the present invention;

fig. 5 is a flowchart illustrating an implementation details of an editing method S102 for an electronic form according to a fifth embodiment of the present invention;

fig. 6 is a flowchart illustrating an implementation details of an editing method S102 for an electronic form according to a sixth embodiment of the present invention;

fig. 7 is a flowchart illustrating an implementation details of an editing method S102 for an electronic form according to a seventh embodiment of the present invention;

fig. 8 is a block diagram illustrating an editing apparatus for an electronic form according to an embodiment of the present invention;

fig. 9 is a schematic diagram of a terminal device according to another embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

The embodiment of the invention calls the online editing server to build a table frame when the electronic table needs to be edited, and downloads the table data corresponding to the electronic table from the target database corresponding to the editing instruction, and because the table data is stored in the cloud database, each user can automatically upload the data to the cloud server after the editing is finished, the table data edited for the electronic table and downloaded from the target database is the latest table data, and the downloaded table data is led into the preset table frame to generate the electronic table, so that the user can edit the displayed electronic table, the purposes of online generation and editing of the electronic table are realized, the existing electronic table technology is solved, and when a scene edited by a plurality of users is dealt with, the electronic table is transferred to other users to be edited after the editing is finished by a certain user, therefore, the editing time of the spreadsheet is prolonged, and the efficiency of data analysis is reduced.

In the embodiment of the invention, the execution subject of the process is the terminal equipment. The terminal devices include but are not limited to: devices such as servers, computers, smartphones, and tablets that can perform spreadsheet editing tasks. Fig. 1 shows a flowchart of an implementation of the method for editing a spreadsheet according to the first embodiment of the present invention, which is detailed as follows:

in S101, if an edit request of the spreadsheet is received, an online edit server is invoked to construct a form frame corresponding to the spreadsheet.

In this embodiment, when a user needs to edit an electronic form, the user may send an edit request to the terminal device, where the edit request carries a document identifier of the electronic form to be edited. The terminal device may be a user terminal operated by a user. The user can manually input the document identification of the electronic form to generate the editing request, the terminal device can also store the quick access links of each electronic form, and when the user activates the quick access links by double-clicking or clicking and the like, the terminal device can automatically generate the editing request about the electronic form. For example, the terminal device may be provided with an icon of the spreadsheet on a preset interface, such as a folder or a system main interface, and a user may open the icon by a touch manner, such as clicking or double-clicking, and at this time, the terminal device may identify that the user needs to edit the spreadsheet, and generate an editing request regarding a document identifier corresponding to the icon.

Optionally, in this embodiment, the terminal device may receive login information of the user, log in to a user account corresponding to the user, query all electronic forms associated with the user account, and generate the document list based on all electronic forms obtained through the query. The user can select at least one electronic form as a target form to be edited by touch instructions such as pointing, clicking and the like in the document list, and the terminal device generates a corresponding editing request according to the touch instructions of the user. When the terminal device detects the edit request, the terminal device performs the operation of S101.

In the embodiment, in the process of editing the same electronic form by multiple people, in order to improve the editing efficiency, shortcuts, form editing plug-ins and the like associated with the electronic form can be associated with the electronic form and correspond to different electronic forms, and parameter items contained in the header of the form also have differences. In the existing spreadsheet technology, the above-mentioned customization operation requires manual equipment on the editing application of the spreadsheet of each user terminal, and the sharing of the customization operation cannot be realized, so that the editing efficiency of the user is affected, and the setting difficulty of the customization operation is increased. In order to solve the above problem, the present embodiment enables not only sharing of table data of a spreadsheet but also online sharing of an editing application. The terminal equipment does not need to install editing application of the spreadsheet locally, but can be in communication connection with the online editing server, a spreadsheet frame is built by calling the online editing server deployed at the cloud end, the spreadsheet frame comprises parameter items which are not as high as the header of the spreadsheet, and related editing plug-ins and the like can be configured and downloaded according to shortcuts of operation interfaces preset by users, so that online synchronization of the user-defined operation is realized, the setting difficulty of the user-defined operation is reduced, the editing behaviors of all users are unified, and the consistency of compiling operations of the spreadsheet by a plurality of different users is ensured. The form frame may include the size, data format, check rule, font size, and the like of each cell of the spreadsheet, and standardizes the generated spreadsheet.

Optionally, in this embodiment, the online editing server may be a server built based on a handson table technology, in this case, the terminal device may add a calling statement of the handson table server in the compiling page, configure an API interface of the handson table server for the calling operation, and when the editing page of the electronic form is constructed, that is, when an editing request of the electronic form is received and a form frame is built, the terminal device may download source code data of the handson table from the handson table server, and generate a form frame supporting online editing based on the source code data and the API calling interface.

In S102, a target database is determined according to the edit request, and table data corresponding to the electronic table is downloaded from the target database.

In this embodiment, the edit request may carry a database identifier of the target database, and in this case, the terminal device may query an access address of the target server according to the data table identifier, and download table data corresponding to the electronic table from the target database based on the access address. If the editing request does not carry the database identifier of the target database but records the document identifier of the electronic form, the target data can be determined based on the document identifier, and the form data of the electronic form can be downloaded from the target database. Specifically, the terminal device may determine product information corresponding to the electronic document according to a document identifier of the electronic form, and different products may set corresponding databases to store product purchase records corresponding to the products, and form a database of the products based on all the product purchase records. Therefore, the terminal device can determine the product information to which the electronic document belongs according to the document identifier, and query the database corresponding to the stored product information, namely the target database of the electronic form.

In this embodiment, the terminal device may extract the table data from the target database according to the parameter items defined in the table frame, and download the table data to the local cache area. Optionally, if the target database is in a distributed storage manner, that is, different parameter items are stored by different distributed nodes, in this case, the terminal device may create multiple data downloading threads, control each data downloading thread to establish a communication connection with each distributed node, download data corresponding to each parameter item from each distributed node in parallel according to a data index table corresponding to table data, and package all downloaded data to obtain table data.

Alternatively, the terminal device may identify and detect the display size of the display module and the resolution of the current display, determine the maximum display line number based on the display size and the resolution, and acquire table data corresponding to the maximum display line number from the target database based on the maximum display line number. By downloading the form data in the mode, the situation that a large amount of form data is obtained but the data which can be displayed most on one screen is obtained when the electronic form is generated can be avoided, and the form data which is not downloaded can be obtained continuously from the target database after the electronic form is generated, so that the rendering efficiency of the electronic form can be improved.

In S103, the form data is imported into the form frame, the electronic form is generated and displayed, and an editing operation is performed on the displayed electronic form.

In this embodiment, after the terminal device downloads the form data of the electronic form, the form data may be imported into the form frame to generate the electronic form. The introduction mode is specifically as follows: and identifying a display area corresponding to each parameter item in the form frame according to the parameter item related to each data in the form data, and sequentially importing the corresponding display areas according to the object number of each data to generate the electronic form.

In this embodiment, the terminal device outputs the electronic form through the display module, for example, displays the electronic form through an external display or a local touch screen. The user may perform editing operations on the displayed spreadsheet. Because the electronic form is built and generated based on the form frame framework provided by the online editing server, and the form frame supports editing operations, such as data changing, merging, copying, format changing, embedding related functions and other functions, a user can execute corresponding editing operations in the generated electronic form, and after the editing is completed, the terminal equipment can synchronously upload the form data acquired at this time to the target database to update the data of the target database, so that the real-time performance and the effectiveness of cloud data are ensured.

In this embodiment, after the terminal device receives an editing completion instruction initiated by a user, in addition to uploading the collected form data this time, occupied resources of the form frame may be released, for example, the frame data of the form frame and the plug-in files of the relevant plug-ins are deleted, and when the electronic form is edited next time, the form frame is constructed by the online editing server, so that the utilization rate of local resources is improved.

In S104, the form data of the electronic form is updated based on an editing instruction initiated by a user.

In this embodiment, a user may input an editing instruction to the terminal device during editing the spreadsheet, and the terminal device may adjust data in a corresponding cell according to the editing instruction of the user and update the currently displayed spreadsheet.

In S105, uploading the updated table data to the target database at a preset update time interval.

In this embodiment, in order to ensure real-time property of the table data in the cloud database, the terminal device uploads the currently acquired table data to the target database at preset time intervals, and updates the corresponding table data in the target database, for example, replaces the failure data, or adds the newly added table data. Optionally, the target database may issue the updated table data to each associated user terminal, so that real-time synchronization of the table data at multiple user terminals can be achieved, and multi-user synchronous editing of the same electronic table is supported.

In the embodiment of the invention, the table data in the target database is updated at preset time intervals, so that the real-time performance of the table data in the target database can be improved, multiple users are supported to synchronously edit the same spreadsheet, and the editing efficiency of the spreadsheet is improved.

As can be seen from the above, in the editing method for the electronic form provided in the embodiment of the present invention, when the electronic form needs to be edited, the online editing server is invoked to build a form frame, and form data corresponding to the electronic form is downloaded from the target database corresponding to the editing instruction, and because the form data is stored in the cloud database, after the editing is completed, each user automatically uploads the data to the cloud server, the form data that is edited and downloaded from the target database is the latest form data, and the downloaded form data is imported into the preset form frame to generate the electronic form, and the user can edit the displayed electronic form, thereby achieving the purpose of online generating and editing the electronic form. Compared with the prior spreadsheet technology, the spreadsheet is not required to be transmitted offline in a scene that multiple users edit the same spreadsheet, the spreadsheet data are stored in the cloud server, and the spreadsheet data downloaded from the cloud server are imported into the spreadsheet frame to generate the spreadsheet when the users edit the spreadsheet data.

Fig. 2 shows a flowchart of a specific implementation of an editing method S101 for a spreadsheet according to a second embodiment of the present invention. Referring to fig. 2, with respect to the embodiment described in fig. 1, in the editing method for a spreadsheet provided by this embodiment, S101 includes: s1011 to S1014 are specifically described as follows:

further, if an edit request of the electronic form is received, the method for constructing the form frame corresponding to the electronic form by calling the online edit server includes:

in S1011, sending a frame query instruction to the online editing server, and receiving a frame query result returned by the online editing server based on the frame query instruction; the frame query result contains a frame data amount of the table frame.

In this embodiment, the terminal device may adopt different rendering modes according to the actual data amount of the form frame, where the rendering modes include a front-end rendering mode and a back-end rendering mode. The front-end rendering mode is suitable for scenes with large data volumes of the form frame, and the front-end display mode specifically comprises the following steps: all data required for building the form frame are sent to the terminal equipment, the form frame is reconstructed on the terminal equipment, and the online editing server is mainly used for issuing the form data frame and does not build the form frame on the server side; and the back-end rendering mode is suitable for scenes with small data volume, and the editing frame is constructed at the back end, namely the server side, and then the whole editing frame is sent to the user terminal for display, so that before the rendering mode is determined, the data volume of the form frame of the online editing server needs to be acquired, the data volume of the form frame is compared with a preset data volume threshold, and the rendering mode is determined based on the comparison result.

In this embodiment, when determining the data size of the form frame, the terminal device may send a frame query instruction to the online editing server to obtain the frame information of the form frame, where the obtained frame information includes the data size of the form frame. After receiving the frame query instruction, the online editing server may collect frame information of the table frame, generate a query result, and send the query result to the terminal device, after receiving the query result, the terminal device may extract a data amount of the table frame in the query result, compare the data amount with a preset data amount threshold, and if it is detected that the data amount is greater than the data amount threshold, execute the operation of S1012.

In S1012, if the frame data amount is greater than a preset data amount threshold, a front-end construction instruction is sent to the online editing server.

In this embodiment, because the frame data amount of the form frame is greater than the preset data amount threshold, it indicates that the data amount of the form frame is large, if the form frame is built by the online editing server and the network page with the form frame built is fed back to the terminal device for display, the loading time of the network page may be increased, and the frame attribute of the form frame may need to be configured and adjusted in the subsequent editing operation process, at this time, because the data amount of the form frame is large, interaction with the online editing server is frequently required during the change operation, so that the response rate of the frame configuration may be reduced and the re-rendering duration of the form frame may be increased. Based on this, when the frame data volume obtained by identification is larger than the preset data volume threshold, the terminal device may send a front-end construction instruction to the online editing server to construct the table frame in a front-end construction manner.

In S1013, an online editing plug-in sent by the online editing server based on the front-end building instruction is received.

In this embodiment, after receiving the front-end construction instruction, the online editing server sends the online editing plug-in corresponding to the form frame to the terminal device. Optionally, the form framework includes other plug-ins related to the editing operation, the online editing server may add an API interface to the form framework, and after the terminal device generates the form framework according to the online editing plug-in, the terminal device may online load other plug-ins related to the editing operation, which need to be called, through the API interface built in the form framework; of course, the online editing server may also encapsulate plug-in data of other plug-ins in the online editing plug-in, so as to be constructed on the terminal device together.

In S1014, the online editing plug-in is run, and the form framework is built locally.

In this embodiment, after receiving the online editing plug-in, the terminal device may locally run the online editing plug-in, so as to generate a table frame, thereby achieving the purpose of front-end construction.

In the embodiment of the invention, the frame data volume of the table frame is identified, and when the frame data volume is larger than the preset data volume threshold, the table frame is generated by adopting a front-end construction mode, so that the stability and the response speed of the table frame can be improved, and the editing efficiency of a user is improved.

Fig. 3 is a flowchart illustrating a specific implementation of a method for editing a spreadsheet according to a third embodiment of the present invention. Referring to fig. 3, with respect to the embodiment described in fig. 2, after the sending a frame query instruction to the online editing server and receiving a frame query result returned by the online editing server based on the frame query instruction, the method for editing a spreadsheet provided by this embodiment further includes: S1015-S1016, detailed as follows:

further, after the sending a frame query instruction to the online editing server and receiving a frame query result returned by the online editing server based on the frame query instruction, the method further includes:

in S1015, if the frame data amount is less than or equal to the data amount threshold, a back-end construction instruction is sent to the online editing server, so as to construct a web page including the form frame through the online editing server.

In this embodiment, since the frame data amount of the table frame is less than or equal to the preset data amount threshold, it indicates that the data amount of the table frame is small, and at this time, the editing request for the table frame may be responded by the way of building the table frame at the back end. The method for constructing the back end is that the network page containing the table frame is generated through the online editing server, and data required for constructing the table frame does not need to be transmitted to the terminal equipment, so that the local resource occupation of the terminal equipment is reduced, certain time is consumed for decompression and installation when the data packet of the frame is locally operated, for the table frame with small data volume, the cost is high when the table frame is displayed through a front-end constructing method, and the constructing efficiency is lower than that of the back-end constructing method, so that the back-end constructing method can be adopted when the frame data volume obtained through identification is small, and the rendering efficiency of the table frame is improved.

In this embodiment, when detecting that the frame data amount is less than or equal to the data amount threshold, the terminal device sends a back-end construction instruction to the online editing server, and when receiving the back-end construction instruction, the online editing server may construct a web page embedded with a form frame on the server side, and feed back a jump link corresponding to the web page to the terminal device.

In S1016, a jump link regarding the web page fed back by the online editing server is received, and the web page is accessed based on the jump link to load the form frame.

In this embodiment, after receiving the jump link, the terminal device may import the jump link to a preset browser application, and access the web page through the browser application, where the web page is embedded with the form frame, that is, the form frame is already built on the server side, and the terminal device only needs to download the page data of the web page and locally generate the web page, and thus, locally load the form frame, and execute subsequent editing operations based on the locally built form frame.

In the embodiment of the invention, when the frame data volume is detected to be less, the form frame is loaded in a back-end construction mode, so that the loading speed of the form frame is increased, and the editing efficiency of the electronic form is improved.

Fig. 4 is a flowchart illustrating a specific implementation of a method for editing a spreadsheet according to a fourth embodiment of the present invention. Referring to fig. 4, with respect to the embodiment shown in fig. 2, after the sending a frame query instruction to the online editing server and receiving a frame query result returned by the online editing server based on the frame query instruction, the method for editing a spreadsheet provided by this embodiment further includes: s401 to S404 are specifically detailed as follows:

in S401, the current network parameter of the network and the load value of the online editing server are obtained.

In this embodiment, the terminal device may dynamically adjust the loading mode according to the current network state and the load condition of the online editing server. The mode of dynamically adjusting the loading mode is mainly completed by changing a data volume threshold, and different construction modes can be adopted for the same form frame according to different network states by setting the data volume threshold matched with the current state.

In this embodiment, the terminal device may send a ping packet to a preset correspondent node through the gateway interface via the network where the terminal device is located, and determine the network parameter of the network where the terminal device is located at the current time based on a response packet fed back by the correspondent node. For the load value of the online editing server, the terminal device may send a status query request to the online editing server, and then the online editing server may feed back a status query result to the terminal device, and determine the current load value of the online editing server based on the status query result.

In S402, a first weighting factor is obtained according to the network parameter and the maximum value of the network parameter of the network where the first weighting factor is located.

In this embodiment, after acquiring the current network parameter, the terminal device may calculate a ratio between the current network parameter and a maximum value of the network parameter of the network where the terminal device is located, so as to normalize the network parameter, and identify the normalized network parameter as the first weighting factor. The maximum value of the network parameter is an upper limit value of each network parameter, such as an upper limit value of an uplink rate, a lower limit value of a downlink rate, a maximum available network bandwidth, and the like. If the network parameter includes a plurality of different parameter items, the first weighting factor can be obtained by averaging the normalized values corresponding to the parameter items.

It should be noted that the first weighting factor is in positive correlation with the data amount threshold, that is, the larger the value of the first weighting factor is, the faster the rate at which the terminal device loads the table frame through the web page is, that is, in the case of constructing the web page by the back end, when the table data is subjected to parameter change, the smaller the time delay is, that is, the faster the rate at which the table is rendered online is, and at this time, the application range of the back end construction can be expanded.

In S403, historical response records of the online editing server are obtained, and a second weighting factor is calculated based on the historical load values of the historical response records and the current load value.

In this embodiment, the terminal device obtains history response records corresponding to the history editing requests initiated by the online editing server in response to the terminal device, where each history response record includes a history load value corresponding to the history editing request initiated by the terminal device, and the terminal device may calculate an average load value according to the history load values of all the history response records, determine whether a current load value is higher than the average load value, and determine the second weighting factor based on a difference between the current load value and the average load value.

It should be noted that the second weighting factor is negatively correlated with the data size threshold, that is, the larger the difference between the current load value and the average load value is, the larger the load pressure of the current online editing server is, at this time, the load of the server will be continuously increased by performing the backend framework construction by the online editing server, and at this time, the application range of the backend construction should be reduced, so that the data size threshold may be reduced.

In S404, the data amount threshold is calculated based on the first weighting factor, the second weighting factor, and a reference data threshold.

In this embodiment, after the terminal device calculates the first weighting factor and the second weighting factor, the two parameters may be superimposed with the reference data threshold, so as to calculate the data amount threshold matching the current environment. For example, assuming that the first weighting factor is a, the second weighting factor is B, and the reference data volume threshold is StdNum, the current data volume threshold is NumThreshold ═ a × StdNum/B.

In the embodiment of the invention, the corresponding data volume threshold is calculated by acquiring the network parameters and the load value of the current environment, so that the aim of dynamically adjusting the data volume threshold is fulfilled, and the matching of the current construction mode and the network environment is ensured.

Fig. 5 is a flowchart illustrating a specific implementation of the method S102 for editing a spreadsheet according to the fifth embodiment of the present invention. Referring to fig. 5, with respect to any one of the embodiments shown in fig. 1 to 4, the method S102 for editing a spreadsheet provided by this embodiment includes: s1021 to S1024 are described in detail as follows:

further, the determining a target database according to the editing request, and downloading form data corresponding to the electronic form from the target database includes:

in S1021, the parameter items contained by the form frame are identified.

In this embodiment, when data analysis is performed on a certain product for the first time, that is, when the cloud database does not store original data of the item, or when a newly added product record exists in the cloud database, the terminal device may automatically acquire the product record from the association database, and convert the product record into table data, thereby achieving the purpose of automatically pulling and updating the table data, and avoiding the need for manual entry again by the user.

In this embodiment, since the product record contains a plurality of candidates, and not each candidate needs to be entered into the target database, in order to determine the data to be entered, the terminal device may parse the locally constructed form frame, determine the parameter items contained in the form frame, and thereby determine the data to be used in the data analysis.

In S1022, a plurality of product records of the target product corresponding to the editing request are extracted from the target database.

In this embodiment, the terminal device may extract a product record associated with the target product of the editing request in the target database. The editing request may carry a product identifier of the target product, and the terminal device may extract a product record matching the product identifier from the target database according to the product identifier.

In S1023, parameter values corresponding to all the parameter items are extracted from each product record, and product data corresponding to the product record is generated.

In this embodiment, the terminal device may respectively query the parameter values corresponding to the parameter items in the product records according to the parameter items in the table frame, so as to generate product data associated with the product records, thereby achieving the purpose of automatically converting the product records into the product data. It should be noted that the product data may specifically be a parameter matrix, where the position of each element in the parameter matrix is matched with the display position of the associated parameter item in the form frame, so that the product data can be sequentially imported into the corresponding display area of the form frame during subsequent import.

In S1024, the product data of all the product records are encapsulated to obtain the table data.

In this embodiment, after the terminal device extracts the product data of each product record, the terminal device may sequentially combine the product data according to the record number of each product record, thereby generating the form data, thereby implementing conversion from the product record to the form data, and improving the automation degree of the electronic form generation.

In the embodiment of the invention, the parameter values of the associated parameter items are extracted from the product records by determining the parameter items contained in the form frame, so that the product records are automatically converted into the form data, and the editing efficiency of the electronic forms is improved.

Fig. 6 shows a flowchart of a specific implementation of the method S102 for editing a spreadsheet according to the sixth embodiment of the present invention. Referring to fig. 6, with respect to any one of the embodiments in fig. 1 to 4, in the method for editing a spreadsheet provided by this embodiment, S102 includes: s1025 to S1027 are specifically described as follows:

in S1025, the edit request is parsed to determine a start line number.

In this embodiment, the editing request may record a target line number to be edited, or may determine a user account of the currently operating user based on the editing request, obtain a history editing record of the user account, determine a line number that last stayed in the last editing operation, and use the line number obtained by the identification as an initial line number corresponding to the current editing operation. Of course, in the default configuration mode, the start line number may be identified as 1 by default, i.e. the first line in the product data list of the target product in the target database is used as the start line number.

In S1026, the target line number segment downloaded this time is determined according to the start line number and the table rendering range.

In this embodiment, the terminal device may be preset with a side rendering range, and the side rendering range may be set by a user, or may be dynamically adjusted according to the current network operation parameter. According to the table rendering range and the starting line number, it can be determined that the spreadsheet is the table segment to be displayed for the first time, i.e. the target line number segment mentioned above.

In S1027, the table data corresponding to the target row number segment is downloaded from the target database.

In this embodiment, the terminal device may download corresponding data from the target database according to the identified target row number segment as table data to be displayed.

In the embodiment of the invention, the table data corresponding to the starting line number and the table rendering range are downloaded by determining the starting line number and the table rendering range, so that the data volume required to be downloaded during the first downloading can be reduced, the time required for rendering the electronic table is reduced, the electronic table displaying efficiency is improved, and the user experience is improved.

Fig. 7 is a flowchart illustrating a specific implementation of the method S102 for editing a spreadsheet according to the seventh embodiment of the present invention. Referring to fig. 7, with respect to any one of the embodiments of fig. 1 to 4, in the method for editing a spreadsheet provided by this embodiment, S1023 includes: S701-S702, detailed as follows:

in S701, acquiring an edit record of the user; the editing record comprises corresponding editing coordinates when editing operation is executed.

In this embodiment, the terminal device may query, according to a user account of a user who needs to perform an editing operation, all operation records associated with the user account corresponding to the user from the target database, acquire an operation record with the latest operation time and the editing type as the editing record, and extract an editing coordinate of the last editing operation from the editing record. The editing coordinates are table position information formed by row numbers and column numbers of cells corresponding to the editing operation in the electronic table.

In S702, the table data is determined according to the mark coordinates and the maximum display line number, and the table data is downloaded from the target database.

In this embodiment, the table data downloaded this time is determined according to the editing coordinates and the determined maximum display line number, so that the user can jump to the last editing position according to the editing history of the user, and load the table data corresponding to the position to generate the spreadsheet.

In the embodiment of the application, the user can conveniently continue to edit the last operation area, and the convenience of editing operation is improved.

It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.

Fig. 8 is a block diagram illustrating a structure of an editing apparatus for a spreadsheet according to an embodiment of the present invention, where the editing apparatus for a spreadsheet comprises units for executing steps in the corresponding embodiment of fig. 1. Please refer to fig. 1 and fig. 1 for the corresponding description of the embodiment. For convenience of explanation, only the portions related to the present embodiment are shown.

Referring to fig. 8, the apparatus for editing a spreadsheet comprises:

a form frame construction unit 81, configured to, if an edit request of an electronic form is received, invoke an online editing server to construct a form frame corresponding to the electronic form;

a table data downloading unit 82, configured to determine a target database according to the editing request, and download table data corresponding to the electronic table from the target database;

an electronic form display unit 83, configured to import the form data into the form frame, generate and display the electronic form, and perform an editing operation on the displayed electronic form;

a table data updating unit 84, configured to update the table data of the electronic table based on an editing instruction initiated by a user;

a table data uploading unit 85, configured to upload the updated table data to the target database at preset update time intervals.

Optionally, the form frame building unit 81 includes:

the frame data volume acquisition unit is used for sending a frame query instruction to the online editing server and receiving a frame query result returned by the online editing server based on the frame query instruction; the frame query result comprises a frame data amount of the table frame;

the front-end construction instruction sending unit is used for sending a front-end construction instruction to the online editing server if the frame data volume is larger than a preset data volume threshold;

the online editing plug-in receiving unit is used for receiving an online editing plug-in sent by the online editing server based on the front-end construction instruction;

and the online editing plug-in running unit is used for running the online editing plug-in and building the form frame locally.

Optionally, the spreadsheet editing apparatus further comprises:

a back-end construction instruction sending unit, configured to send a back-end construction instruction to the online editing server if the frame data amount is less than or equal to the data amount threshold, so as to construct a web page including the form frame through the online editing server;

and the back-end construction execution unit is used for receiving the jump link which is fed back by the online editing server and is related to the network page, and accessing the network page based on the jump link so as to load the form frame.

Optionally, the spreadsheet editing apparatus further comprises:

the environment parameter acquisition unit is used for acquiring the current network parameters of the network and the load value of the online editing server;

the first weighting factor calculation unit is used for obtaining a first weighting factor according to the network parameter and the maximum value of the network parameter of the network;

the second weighting factor calculation unit is used for acquiring historical response records of the online editing server and calculating a second weighting factor based on historical load values of the historical response records and the current load value;

a data amount threshold calculation unit configured to calculate the data amount threshold based on the first weighting factor, the second weighting factor, and a reference data threshold.

Optionally, the table data downloading unit 82 includes:

a parameter item identification unit for identifying the parameter items contained in the form frame;

a product record obtaining unit, configured to extract, from the target database, a plurality of product records of a target product corresponding to the editing request;

the product data extraction unit is used for respectively extracting parameter values corresponding to all the parameter items from the product records and generating product data corresponding to the product records;

and the product data packaging unit is used for packaging the product data of all the product records to obtain the table data.

Optionally, the table data downloading unit 82 includes:

the initial line number identification unit is used for analyzing the editing request and determining an initial line number;

the target line number segment determining unit is used for determining the target line number segment downloaded at the time according to the initial line number and the table rendering range;

and the table data extraction unit is used for downloading the table data corresponding to the target row number segment from the target database.

Optionally, the spreadsheet editing apparatus further comprises:

Therefore, in the editing device for the electronic form provided by the embodiment of the invention, under the scene that multiple users edit the same electronic form, the electronic form does not need to be transmitted offline, the data of the electronic form is stored in the cloud server, and when the users need to edit, the form data downloaded from the cloud server is led into the form frame to generate the electronic form.

Fig. 9 is a schematic diagram of a terminal device according to another embodiment of the present invention. As shown in fig. 9, the terminal device 9 of this embodiment includes: a processor 90, a memory 91 and a computer program 92, such as a spreadsheet editor, stored in said memory 91 and operable on said processor 90. The processor 90, when executing the computer program 92, implements the steps in the above-described embodiments of the method for editing a spreadsheet, such as S101 to S105 shown in fig. 1. Alternatively, the processor 90, when executing the computer program 92, implements the functions of the units in the device embodiments, such as the functions of the modules 81 to 85 shown in fig. 8.

Illustratively, the computer program 92 may be divided into one or more units, which are stored in the memory 91 and executed by the processor 90 to carry out the invention. The one or more units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution process of the computer program 92 in the terminal device 9. For example, the computer program 92 may be divided into a table frame construction unit, a table data download unit, an electronic table display unit, a table data update unit, and a table data upload unit, each of which functions as described above.

The terminal device 9 may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The terminal device may include, but is not limited to, a processor 90, a memory 91. Those skilled in the art will appreciate that fig. 9 is only an example of a terminal device 9, and does not constitute a limitation to the terminal device 9, and may include more or less components than those shown, or combine some components, or different components, for example, the terminal device may also include an input-output device, a network access device, a bus, etc.

The Processor 90 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field-Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 91 may be an internal storage unit of the terminal device 9, such as a hard disk or a memory of the terminal device 9. The memory 91 may also be an external storage device of the terminal device 9, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the terminal device 9. Further, the memory 91 may also include both an internal storage unit and an external storage device of the terminal device 9. The memory 91 is used for storing the computer program and other programs and data required by the terminal device. The memory 91 may also be used to temporarily store data that has been output or is to be output.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.

Claims

1. A method for editing a spreadsheet, comprising:

determining a target database according to the editing request, and downloading table data corresponding to the electronic table from the target database; the target database specifically comprises: the database is deployed at the cloud end and used for receiving table data sent by each user;

2. The editing method according to claim 1, wherein if an editing request of the spreadsheet is received, invoking an online editing server to construct a form frame corresponding to the spreadsheet comprises:

sending a frame query instruction to the online editing server, and receiving a frame query result returned by the online editing server based on the frame query instruction; the frame query result comprises a frame data amount of the table frame;

if the frame data volume is larger than a preset data volume threshold value, sending a front-end construction instruction to the online editing server;

receiving an online editing plug-in sent by the online editing server based on the front-end construction instruction;

and operating the online editing plug-in to build the form frame locally.

3. The editing method according to claim 2, after said sending a framework query instruction to the online editing server and receiving a framework query result returned by the online editing server based on the framework query instruction, further comprising:

if the frame data volume is less than or equal to the data volume threshold value, sending a back-end construction instruction to the online editing server so as to construct a network page containing the form frame through the online editing server;

and receiving a jump link which is fed back by the online editing server and is about the network page, and accessing the network page based on the jump link to load the form frame.

4. The editing method according to claim 2, after said sending a framework query instruction to the online editing server and receiving a framework query result returned by the online editing server based on the framework query instruction, further comprising:

acquiring the current network parameters of the network and the load value of the online editing server;

obtaining a first weighting factor according to the network parameter and the maximum value of the network parameter of the network;

acquiring historical response records of the online editing server, and calculating a second weighting factor based on historical load values of the historical response records and the current load value;

and calculating the data volume threshold according to the first weighting factor, the second weighting factor and a reference data threshold.

5. The editing method according to any one of claims 1 to 4, wherein the determining a target database according to the editing request, and downloading table data corresponding to the electronic table from the target database, includes:

identifying parameter items contained by the form framework;

extracting a plurality of product records of a target product corresponding to the editing request from the target database;

extracting parameter values corresponding to all the parameter items from the product records respectively to generate product data corresponding to the product records;

and packaging the product data of all the product records to obtain the table data.

6. The editing method according to any one of claims 1 to 4, wherein the determining a target database according to the editing request, and downloading table data corresponding to the electronic table from the target database, includes:

analyzing the editing request and determining the number of the initial line;

determining a target line number segment downloaded at the time according to the initial line number and the table rendering range;

and downloading the table data corresponding to the target row number segment from the target database.

7. The editing method according to any one of claims 1 to 4, wherein the determining a target database according to the editing request, and downloading the table data corresponding to the electronic table from the target database, includes:

acquiring the editing record of the user; the editing record comprises corresponding editing coordinates when editing operation is executed;

and determining the table data according to the editing coordinate and the maximum display line number, and downloading the table data from the target database.

8. An apparatus for editing a spreadsheet, comprising:

9. A terminal device, characterized in that the terminal device comprises a memory, a processor and a computer program stored in the memory and executable on the processor, the processor executing the computer program with the steps of the method according to any of claims 1 to 7.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.