CN111368520A - A method and device for editing a spreadsheet - Google Patents

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

A method and device for editing a spreadsheet

technical field

The invention belongs to the technical field of data processing, and in particular relates to a method and device for editing an electronic form.

Background technique

With the continuous advancement of the electronic process, more and more data processing processes can be completed through electronic forms, such as data sorting and statistics through electronic forms, and electronic forms greatly improve the efficiency of users' data analysis. When the product to be analyzed involves a wide range of fields or the product continues to develop, the data to be analyzed will also increase. At this time, the editing operation of the spreadsheet often requires the collaboration of multiple users or even different personnel from multiple departments. Complete, and follow-up data analysis operations based on the edited spreadsheet. The existing spreadsheet technology, when dealing with multiple users editing at the same time, needs to forward the spreadsheet offline to other users for editing after completion of editing by a user, thereby increasing the editing time of the spreadsheet and reducing the time required for editing. Efficiency of data analysis.

SUMMARY OF THE INVENTION

In view of this, the embodiments of the present invention provide a method and device for editing an electronic form, so as to solve the problem of the existing electronic form technology. The table is forwarded offline to other users for editing, which increases the editing time of the spreadsheet and reduces the efficiency of data analysis.

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

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

Determine a target database according to the editing request, and download form data corresponding to the electronic form from the target database;

importing the table data into the table frame, generating and displaying the spreadsheet, and performing editing operations on the displayed spreadsheet;

updating the form data of the electronic form based on user-initiated editing instructions;

The updated table data is uploaded to the target database at a preset update time interval.

A second aspect of the embodiments of the present invention provides an electronic form editing device, including:

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

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

a spreadsheet display unit, configured to import the table data into the table frame, generate and display the spreadsheet, and perform editing operations on the displayed spreadsheet;

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

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

A third aspect of the embodiments of the present invention provides a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, when the processor executes the computer program Implement the steps of the first aspect.

A fourth aspect of the embodiments of the present invention provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, implements each step of the first aspect.

Implementing the method and device for editing an electronic form provided by the embodiment of the present invention has the following beneficial effects:

In the embodiment of the present invention, when the electronic form needs to be edited, the online editing server is called to build the form frame, and the form data corresponding to the electronic form is downloaded from the target database corresponding to the editing instruction, and since the form data is stored in the cloud database, each After editing, the user will automatically upload the data to the cloud server. After editing the spreadsheet and downloading the table data from the target database, it is the latest table data, and the downloaded table data will be imported into the preset table. Within the framework, a spreadsheet is generated, and the user can edit the displayed spreadsheet, thereby realizing the purpose of generating and editing the spreadsheet online. Compared with the existing spreadsheet technology, in the scenario where multiple users edit the same spreadsheet, there is no need to transmit the spreadsheet offline. The spreadsheet data is stored in the cloud server. The table data downloaded by the cloud server is imported into the table frame to generate a spreadsheet. While ensuring the sharing of the table data across the network, the table data can also be imported into the table frame, which is convenient for users to edit operations and improves the editing of the spreadsheet. efficiency, and achieves the purpose of multi-person online form editing, reducing the time-consuming of editing operations.

Description of drawings

In order to illustrate the technical solutions in the embodiments of the present invention more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the drawings in the following description are only for the present invention. In some embodiments, for those of ordinary skill in the art, other drawings can also be obtained according to these drawings without any creative effort.

Fig. 1 is the realization flow chart of a kind of electronic form editing method provided by the first embodiment of the present invention;

FIG. 2 is a flowchart of a specific implementation of a method S101 for editing an electronic form provided by the second embodiment of the present invention;

Fig. 3 is a specific implementation flowchart of a method for editing an electronic form provided by a third embodiment of the present invention;

Fig. 4 is a specific implementation flowchart of a method for editing an electronic form provided by a fourth embodiment of the present invention;

FIG. 5 is a flowchart of a specific implementation of a method S102 for editing an electronic form provided by the fifth embodiment of the present invention;

FIG. 6 is a flowchart of a specific implementation of a method S102 for editing an electronic form provided by the sixth embodiment of the present invention;

FIG. 7 is a flowchart of a specific implementation of a method S102 for editing an electronic form provided by the seventh embodiment of the present invention;

8 is a structural block diagram of a device for editing an electronic form provided by 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 ways

In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

In the embodiment of the present invention, when the electronic form needs to be edited, the online editing server is called to build the form frame, and the form data corresponding to the electronic form is downloaded from the target database corresponding to the editing instruction, and since the form data is stored in the cloud database, each After editing, the user will automatically upload the data to the cloud server. After editing the spreadsheet and downloading the table data from the target database, it is the latest table data, and the downloaded table data will be imported into the preset table. Within the framework, a spreadsheet is generated, and the user can edit the displayed spreadsheet, realizing the purpose of online generation and editing of the spreadsheet, and solving the existing spreadsheet technology. After a user completes editing, the spreadsheet is forwarded offline to other users for editing, which increases the editing time of the spreadsheet and reduces the efficiency of data analysis.

In the embodiment of the present invention, the execution subject of the process is a terminal device. The terminal device includes, but is not limited to: a server, a computer, a smart phone, a tablet computer, and other devices that can perform editing tasks of spreadsheets. Fig. 1 shows the realization flow chart of the editing method of the electronic form provided by the first embodiment of the present invention, and the details are as follows:

In S101, if an editing request for the electronic form is received, the online editing server is invoked to construct a form frame corresponding to the electronic form.

In this embodiment, when the user needs to edit the electronic form, he can send an editing request to the terminal device, and the editing request carries the 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 ID of the spreadsheet to generate an editing request, and the terminal device can store the quick access link of each spreadsheet. When the user activates the quick access link by double-clicking or clicking, the terminal device will automatically generate a Edit request for this spreadsheet. For example, the terminal device may be set with an icon of a spreadsheet on a preset interface, such as a folder or the main interface of the system, and the user can open the icon by clicking or double-clicking, and the terminal device will recognize the user. The spreadsheet needs to be edited and an edit request is generated for the document ID corresponding to the icon.

Optionally, in this embodiment, the terminal device may receive the user's login information, log in to the user account corresponding to the user, query all spreadsheets associated with the user account, and generate a document list based on all the spreadsheets obtained by the query. The user can select at least one spreadsheet as the target table to be edited by touch commands such as tick, click, etc. in the document list, and the terminal device generates a corresponding editing request according to the touch command of the user. When the terminal device detects the editing request, the operation of S101 is performed.

In this embodiment, in the process of multiple people editing the same spreadsheet, in order to improve the editing efficiency, a shortcut associated with the spreadsheet, a table editing plug-in, etc. can be associated with the spreadsheet, and correspond to different spreadsheets, There are also differences in the parameter items included in the header of the table. In particular, the user can customize the filtering method of the spreadsheet, so that the target data in the spreadsheet can be quickly queried. In the existing spreadsheet technology, the above-mentioned custom operation requires manual equipment on the spreadsheet editing application of each user terminal, and the sharing of custom operations cannot be realized, thereby affecting the user's editing efficiency, and increasing the customization The difficulty of setting the operation. In order to solve the above problem, the present embodiment not only realizes the sharing of the table data of the electronic form, but also realizes the online sharing of the editing application. The terminal device does not need to install the editing application of the spreadsheet locally, but can communicate with the online editing server, and construct the table frame by calling the online editing server deployed in the cloud. The table frame contains less than the header of the spreadsheet. Parameter items, you can also configure the shortcuts of the operation interface and download the associated editing plug-ins according to the user's preset settings, which realizes the online synchronization of custom operations, thereby reducing the difficulty of setting custom operations and reducing the editing behavior of each user. Unification ensures the consistency of compilation operations of spreadsheets by multiple different users. It should be noted that the table frame may include the size, data format, verification rule, font size, etc. of each cell of the spreadsheet, which realizes the standardization of the generated spreadsheet.

Optionally, in this embodiment, the online editing server may be a server built based on the handsontable technology. In this case, the terminal device may add a calling statement of the handsontable server to the compilation page, and configure handsontable for the calling operation. The API interface of the server, when building the editing page of the spreadsheet, that is, when receiving the editing request of the spreadsheet and building the table frame, the terminal device can download the handsontable source data from the handsontable server, and call the interface based on the source data and API Generate table frames that support online editing.

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

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

In this embodiment, the terminal device can 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 adopts a distributed storage method, that is, different parameter items are stored through different distributed nodes, in this case, the terminal device can create multiple data download threads, and control each data download thread and Each distributed node establishes a communication connection, and downloads data corresponding to each parameter item from each distributed node in parallel according to the data index table corresponding to the table data, and encapsulates all the downloaded data to obtain table data.

Optionally, the terminal device can 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 resolution, and obtain from the target database based on the maximum display line number corresponding to the maximum display line number. form data. Downloading the table data in the above way can avoid obtaining a large amount of table data when generating the spreadsheet, but obtain the data that can be displayed on one screen at most. After the spreadsheet is generated, it can continue to obtain the undownloaded table data from the target database. Thus, the rendering efficiency of the spreadsheet can be improved.

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

In this embodiment, after downloading the form data of the electronic form, the terminal device can import the form data into the form frame to generate the electronic form. Among them, the import method is as follows: according to the parameter item associated with each data in the table data, identify the display area corresponding to the parameter item in the table frame, import the corresponding display area in turn according to the object number to which each data belongs, and generate electronic sheet.

In this embodiment, the terminal device outputs the spreadsheet through the display module, for example, displays the spreadsheet through an external display or a local touch screen. The user can perform editing operations on the displayed spreadsheet. Since the spreadsheet is built and generated based on the table frame provided by the online editing server, and the table frame supports editing operations, such as data change, merge, copy, format change, and embedded related functions, users can perform corresponding functions in the generated spreadsheet. After the editing operation is completed, the terminal device can upload the table data collected this time to the target database synchronously, and update the target database, thus ensuring the real-time and validity of the cloud data.

In this embodiment, after the terminal device receives the editing completion instruction initiated by the user, in addition to uploading the table data collected this time, it can also release the resources occupied by the table frame, for example, delete the frame data of the table frame and the related plug-ins. For the plug-in file, when the spreadsheet is edited next time, the table frame is constructed through the online editing server, thereby improving the utilization rate of local resources.

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

In this embodiment, during the process of editing the electronic form, the user will input an editing instruction to the terminal device, and the terminal device can adjust the data in the corresponding cell according to the user's editing instruction, and update the currently displayed electronic form. sheet.

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

In this embodiment, in order to ensure the real-time performance of the table data in the cloud database, the terminal device will upload the currently collected table data to the target database at preset time intervals, and update the corresponding table data in the target database, for example Replace the invalid data, or add the newly added table data. Optionally, the target database can be delivered to each associated user terminal according to the updated table data, thereby realizing real-time synchronization of table data on the side of multiple user terminals, and supporting simultaneous editing of the same spreadsheet by multiple users.

In the embodiment of the present invention, by updating the table data in the target database at preset time intervals, the real-time performance of the table data in the target database can be improved, multiple users can be supported to edit the same spreadsheet synchronously, and the electronic Table editing efficiency.

It can be seen from the above that the method for editing an electronic form provided by the embodiment of the present invention calls an online editing server to build a form frame when the electronic form needs to be edited, and downloads the corresponding data of the electronic form from the target database corresponding to the editing instruction. Tabular data, and since tabular data is stored in the cloud database, each user will automatically upload the data to the cloud server after editing, and the tabular data downloaded from the target database after editing the spreadsheet is the latest tabular data , and import the downloaded table data into the preset table frame to generate a spreadsheet, and the user can edit the displayed spreadsheet, thereby realizing the purpose of online generation and editing of the spreadsheet. Compared with the existing spreadsheet technology, in the scenario where multiple users edit the same spreadsheet, there is no need to transmit the spreadsheet offline. The spreadsheet data is stored in the cloud server. The table data downloaded by the cloud server is imported into the table frame to generate a spreadsheet. While ensuring the sharing of the table data across the network, the table data can also be imported into the table frame, which is convenient for users to edit operations and improves the editing of the spreadsheet. efficiency, and achieves the purpose of multi-person online form editing, reducing the time-consuming of editing operations.

FIG. 2 shows a specific implementation flowchart of a method S101 for editing an electronic form provided by the second embodiment of the present invention. Referring to FIG. 2 , with respect to the embodiment shown in FIG. 1 , in a method for editing a spreadsheet provided in this embodiment, S101 includes: S1011 to S1014 , which are described in detail as follows:

Further, if the editing request of the electronic form is received, the online editing server is called to construct the form frame corresponding to the electronic form, including:

In S1011, a frame query instruction is sent to the online editing server, and a frame query result returned by the online editing server based on the frame query instruction is received; the frame query result includes the frame data volume of the table frame.

In this embodiment, the terminal device may adopt different rendering modes according to the actual data volume of the table frame, and the rendering modes include a front-end rendering mode and a back-end rendering mode. Among them, the front-end rendering method is suitable for scenes with a large amount of data in the table frame. The front-end display method is specifically: send all the data required for building the table frame to the terminal device, reconstruct the table frame on the terminal device, and edit the server online. It is mainly used to distribute the table data frame, but not to build the table frame on the server side; while the back-end rendering method is suitable for scenarios with a small amount of data. The frame is sent to the user terminal for display. Therefore, before determining the rendering method, it is necessary to obtain the data volume of the table frame of the online editing server, compare the data volume of the table frame with the preset data volume threshold, and determine based on the comparison result. Rendering method.

In this embodiment, when determining the data volume of the table frame, the terminal device can obtain the frame information of the table frame by sending a frame query instruction to the online editing server, and the frame information obtained by the query includes the data volume of the table frame. After receiving the frame query instruction, the online editing server can collect the frame information of the table frame, generate the query result, and send the query result to the terminal device. After receiving the query result, the terminal device can extract the data of the table frame in the query result. The data amount is compared with the preset data amount threshold, and if it is detected that the data amount is greater than the data amount threshold, the operation of S1012 is performed.

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

In this embodiment, since the frame data volume of the table frame is greater than the preset data volume threshold, it means that the data volume of the table frame is relatively large. Displaying on the terminal device will increase the loading time of the web page, and the frame properties of the table frame may need to be configured and adjusted during subsequent editing operations. Interacting with the online editing server, which reduces frame configuration responsiveness and increases table frame re-render times. Based on this, when it is identified that the amount of frame data is greater than the preset data amount threshold, the terminal device can send a front-end construction instruction to the online editing server to construct the table frame by means of front-end construction.

In S1013, an online editing plug-in sent by the online editing server based on the front-end construction 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 table frame to the terminal device. Optionally, if the table frame contains other plug-ins related to editing operations, the online editing server may add an API interface to the table frame. Load other plug-ins related to editing operations that need to be called; of course, the online editing server can also encapsulate the plug-in data of other plug-ins in the online editing plug-in, so as to build on the terminal device concurrently.

In S1014, the online editing plug-in is run to build the table frame locally.

In this embodiment, after receiving the online editing plug-in, the terminal device can run the online editing plug-in locally, thereby generating a table frame and realizing the purpose of front-end construction.

In the embodiment of the present invention, by identifying the frame data volume of the table frame, when the frame data volume is greater than the preset data volume threshold, the front-end construction method is used to generate the table frame, which can improve the stability and response speed of the table frame, and improve the The editing efficiency of users is improved.

FIG. 3 shows a specific implementation flowchart of a method for editing an electronic form provided by the third embodiment of the present invention. Referring to FIG. 3 , with respect to the embodiment described in FIG. 2 , in a method for editing an electronic form provided in this embodiment, the frame query instruction is sent to the online editing server, and the online editing server receives a After the frame query result returned by the frame query command, it also includes: S1015~S1016, the details are as follows:

Further, after the frame query instruction is sent to the online editing server and the frame query result returned by the online editing server based on the frame query instruction is received, the method further includes:

In S1015, if the frame data amount is less than or equal to the data amount threshold, a backend construction instruction is sent to the online editing server, so as to construct a web page including the table frame through the online editing server.

In this embodiment, since the frame data volume of the table frame is less than or equal to the preset data volume threshold, it means that the data volume of the table frame is small, and at this time, the backend can construct the table frame to respond to the editing request for . Since the back-end construction method is to generate the web page containing the table frame through the online editing server, there is no need to transmit the data required to construct the table frame to the terminal device, thereby reducing the local resource occupation of the terminal device, and running the framework locally. When the data package is decompressed and installed, it also takes a certain amount of time. For a table frame with a small amount of data, it will be expensive to display it through the front-end construction method, and its construction efficiency will be lower than the back-end construction method. Therefore, in the When it is recognized that the amount of frame data is small, the back-end construction method can be used to improve the rendering efficiency of the table frame.

In this embodiment, when the terminal device detects that the amount of frame data is less than or equal to the data amount threshold, it will send a back-end construction instruction to the online editing server, and when the online editing server receives the back-end construction instruction, it can Build a web page embedded with a table frame, and feed back the jump link corresponding to the web page to the terminal device.

In S1016, a jump link about 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 can import the jump link into a preset browser application, and access the web page through the browser application. Since the web page is embedded with a form frame, that is, the form frame The construction has been completed on the server side. The terminal device only needs to download the page data of the web page, and when the web page is generated locally, the table frame can be loaded locally, and the subsequent editing operations can be performed based on the locally constructed table frame.

In the embodiment of the present invention, when it is detected that the amount of frame data is small, the table frame is loaded by means of back-end construction, thereby improving the loading speed of the table frame and the editing efficiency of the spreadsheet.

FIG. 4 shows a specific implementation flowchart of a method for editing an electronic form provided by the fourth embodiment of the present invention. Referring to FIG. 4, compared to the embodiment shown in FIG. 2, a method for editing an electronic form provided by this embodiment sends a frame query instruction to the online editing server, and receives the online editing server based on the frame After the frame query result returned by the query instruction, it also includes: S401 to S404, the details are as follows:

Further, after the frame query instruction is sent to the online editing server and the frame query result returned by the online editing server based on the frame query instruction is received, the method further includes:

In S401, the current network parameters of the network where the network is located and the load value of the online editing server are acquired.

In this embodiment, the terminal device can dynamically adjust the loading mode according to the current network state and the load of the online editing server. The method of dynamically adjusting the loading mode is mainly accomplished by changing the data volume threshold. By setting the data volume threshold matching the current state, different construction methods can be adopted for the same table frame according to different network states.

In this embodiment, the terminal device can send a ping data packet to the preset communication peer through the network where it is located through the gateway interface, and determine the network parameters of the network at the current moment based on the response data packet fed back by the communication peer. For the load value of the online editing server, the terminal device can send a status query request to the online editing server, and then the online editing server will 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 network parameter is located.

In this embodiment, after acquiring the current network parameters, the terminal device can calculate the ratio between the current network parameters and the maximum value of the network parameters of the network where it is located, so that the network parameters can be normalized, and the normalized network parameters can be normalized. The normalized network parameter is identified as the first weighting factor. The maximum value of the network parameter is the upper limit of each network parameter, such as the upper limit of the online rate, the lower limit of the downlink rate, and the maximum available network bandwidth. If the network parameter includes a plurality of different parameter items, the first weighting factor can be obtained by taking an average value according to the corresponding normalized value of each parameter item.

It should be noted that the first weighting factor is positively correlated with the data volume threshold, that is, the larger the value of the first weighting factor, the faster the terminal device loads the table frame through the web page, that is, when the backend builds a web page. , when the parameters of table data are changed, the delay is also smaller, that is, the rate of online rendering of the table is also faster. At this time, the scope of application of back-end construction can be expanded.

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

In this embodiment, the terminal device obtains the historical response records corresponding to the online editing server in response to the historical editing request initiated by the terminal device, and each historical response record includes the historical load value corresponding to the historical editing request initiated by the terminal device. The average load value can be calculated according to the historical load values of all historical response records, and whether the current load value is higher than the average load value can be determined, and the second weighting factor can be determined based on the difference between the two.

It should be noted that the second weighting factor is negatively correlated with the data volume threshold, that is, the greater the difference between the current load value and the average load value, the greater the load pressure of the current online editing server, and the online editing The server's back-end framework construction will continue to increase the server's load. At this time, the scope of application of the back-end construction should be narrowed, so the data volume threshold can be reduced.

In S404, the data amount threshold is calculated according to the first weighting factor, the second weighting factor and the reference data threshold.

In this embodiment, after calculating the first weighting factor and the second weighting factor, the terminal device may superimpose the above two parameters with the reference data threshold, thereby calculating the data volume 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 present invention, the corresponding data volume threshold is calculated by acquiring the network parameters and load value of the current environment, realizing the purpose of dynamically adjusting the data volume threshold and ensuring that the current construction method matches the network environment.

FIG. 5 shows a specific implementation flowchart of a method S102 for editing an electronic form provided by the fifth embodiment of the present invention. Referring to FIG. 5 , with respect to any of the embodiments described in FIGS. 1 to 4 , a method S102 for editing a spreadsheet provided in this embodiment includes: S1021 to S1024 , which are described in detail as follows:

Further, determining the target database according to the editing request, and downloading the table data corresponding to the electronic form from the target database, including:

In S1021, the parameter items contained in the table frame are identified.

In this embodiment, when data analysis is performed on a certain product for the first time, that is, the original data of the item is not stored in the cloud database, or there is a newly added product record in the cloud database, the terminal device can automatically download the data from the associated database. Obtain product records and convert product records into table data, so as to achieve the purpose of automatically pulling and updating table data, without the need for users to manually enter it again.

In this embodiment, since the product record contains multiple candidate items, and not every candidate item needs to be entered into the target database, therefore, in order to determine the data to be entered, the terminal device can perform the locally constructed form frame Parse, determine the parameter items contained in the table frame, so as to determine the data to be used in data analysis.

In S1022, multiple 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 product records associated with the target product requested for editing in the target database. The edit request may carry the product identifier of the target product, and the terminal device may extract the product record matching the product identifier from the target database according to the product identifier.

In S1023, the parameter values corresponding to all the parameter items are respectively extracted from each of the product records to generate product data corresponding to the product records.

In this embodiment, the terminal device can separately query the parameter values corresponding to each parameter item in each product record according to the parameter items in the table frame, thereby generating product data associated with the product record, and realizing the automatic conversion of the product record into Purpose of Product Data. It should be noted that the product data can be specifically a parameter matrix, in which the positions of each element in the parameter matrix match the display positions of the associated parameter items in the table frame, so that the data can be imported into the table in sequence during subsequent import. within the corresponding display area of the frame.

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

In this embodiment, after the terminal device extracts the product data of each product record, it can combine the various product data in sequence according to the record number of each product record, so as to generate table data, thereby realizing the conversion from product records to table data, improving the The degree of automation of spreadsheet generation.

In the embodiment of the present invention, by determining the parameter items contained in the table frame, and extracting the parameter values of the associated parameter items from the product record, the automatic conversion of the product record into table data is realized, and the editing efficiency of the electronic form is improved.

FIG. 6 shows a specific implementation flowchart of a method S102 for editing an electronic form provided by the sixth embodiment of the present invention. Referring to FIG. 6 , with respect to any of the embodiments described in FIG. 1 to FIG. 4 , in a method for editing a spreadsheet provided in this embodiment, S102 includes: S1025 to S1027 , which are described in detail as follows:

Further, determining the target database according to the editing request, and downloading the table data corresponding to the electronic form from the target database, including:

In S1025, the editing request is parsed to determine the starting line number.

In this embodiment, the edit request may record the number of the target row to be edited, or the user account of the current operating user may be determined based on the edit request, and the historical edit records of the user account may be obtained to determine the last edit operation of the latest edit operation. For the line number of the stay, the line number obtained by the above identification is used as the starting line number corresponding to this editing operation. Of course, in the default configuration mode, the starting row number can be identified as 1 by default, that is, the first row in the product data list of the target product in the target database is used as the starting row number.

In S1026, the target row number segment for this download is determined according to the starting row number and the table rendering range.

In this embodiment, the terminal device may have preset rendering ranges, and the rendering ranges may be set by the user, and may also be dynamically adjusted according to current network operating parameters. According to the table rendering range and the starting row number, it can be determined that the first display of the spreadsheet is the table paragraph to be displayed, that is, the above-mentioned target row number segment.

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

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

In the embodiment of the present invention, by determining the starting row number and the table rendering range, and downloading the corresponding table data, the amount of data that needs to be downloaded for the first download can be reduced, thereby reducing the time required for rendering the spreadsheet, Improves the efficiency of displaying spreadsheets and improves user experience.

FIG. 7 shows a specific implementation flowchart of a method S102 for editing an electronic form provided by the seventh embodiment of the present invention. Referring to FIG. 7 , with respect to any of the embodiments described in FIG. 1 to FIG. 4 , in a method for editing a spreadsheet provided in this embodiment, S1023 includes: S701-S702, which are described in detail as follows:

In S701, an edit record of the user is acquired; the edit record includes the edit coordinates corresponding to the edit operation.

In this embodiment, the terminal device can query all operation records associated with the user account corresponding to the user from the target database according to the user account of the user who performs the editing operation as required, and obtain the latest operation time and the operation type as the editing type The operation record of is as the above edit record, and the edit coordinates of the last edit operation will be extracted from the edit record. The editing coordinates are specifically the table position information formed by the row number and column number of the cell corresponding to the editing operation in the spreadsheet.

In S702, the table data is determined according to the mark coordinates and the maximum number of displayed rows, 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 maximum number of displayed rows determined above, so that the user can jump to the last edited position according to the user's editing history, and load the corresponding position of the position. form data to generate a spreadsheet.

In the embodiment of the present application, it is convenient for the user to continue editing operations on the area of the previous operation, which improves the convenience of editing operations.

It should be understood that the size of the sequence numbers of the steps in the above embodiments does not mean the sequence of execution, and the execution sequence of each process should be determined by its functions and internal logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.

FIG. 8 shows a structural block diagram of a device for editing an electronic form according to an embodiment of the present invention, and each unit included in the device for editing an electronic form is used to execute each step in the embodiment corresponding to FIG. 1 . For details, please refer to the relevant descriptions in FIG. 1 and the embodiment corresponding to FIG. 1 . For convenience of explanation, only the parts related to this embodiment are shown.

Referring to Fig. 8, the editing device of the electronic form includes:

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

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

A spreadsheet display unit 83, configured to import the table data into the table frame, generate and display the spreadsheet, and perform editing operations on the displayed spreadsheet;

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;

The table data uploading unit 85 is configured to upload the updated table data to the target database at a preset update time interval.

Optionally, the table frame construction unit 81 includes:

A frame data volume acquisition unit, configured to send a frame query instruction to the online editing server, and receive a frame query result returned by the online editing server based on the frame query instruction; the frame query result includes the frame of the table frame The amount of data;

a front-end construction instruction sending unit, configured to send a front-end construction instruction to the online editing server if the frame data volume is greater than a preset data volume threshold;

an online editing plug-in receiving unit, configured to receive an online editing plug-in sent by the online editing server based on the front-end construction instruction;

The online editing plug-in running unit is used for running the online editing plug-in and constructing the table frame locally.

Optionally, the editing device for the electronic form further includes:

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 frame including the table through the online editing server web page;

A back-end construction execution unit is configured to receive a jump link about the web page fed back by the online editing server, and access the web page based on the jump link to load the form frame.

Optionally, the editing device for the electronic form further includes:

an environmental parameter obtaining unit, used to obtain the current network parameters of the network where it is located and the load value of the online editing server;

a first weighting factor calculation unit, configured to obtain a first weighting factor according to the network parameter and the maximum value of the network parameter of the network where it is located;

a second weighting factor calculation unit, configured to obtain the historical response records of the online editing server, and calculate the second weighting factor based on the historical load value of each historical response record and the current load value;

A data volume threshold calculation unit, configured to calculate the data volume threshold according to the first weighting factor, the second weighting factor and the reference data threshold.

Optionally, the table data downloading unit 82 includes:

a parameter item identification unit, used to identify the parameter items included in the table frame;

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

a product data extraction unit, configured to extract parameter values corresponding to all the parameter items from each of the product records, and generate product data corresponding to the product records;

A product data encapsulation unit, configured to encapsulate the product data of all the product records to obtain the table data.

Optionally, the table data downloading unit 82 includes:

a starting line number identification unit, used to parse the editing request and determine the starting line number;

The target row number segment determination unit is used to determine the target row number segment of this download according to the starting row number and the table rendering range;

A table data extraction unit, configured to download the table data corresponding to the target row number segment from the target database.

Optionally, the editing device for the electronic form further includes:

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

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

Therefore, in the electronic form editing device provided by the embodiment of the present invention, in the scenario where multiple users edit the same electronic form, it is not necessary to transmit the electronic form offline, and the data of the electronic form is stored in the cloud server. When editing, the table data downloaded from the cloud server is imported into the table frame to generate a spreadsheet. While ensuring the entire network sharing of the table data, the table data can also be imported into the table frame, which is convenient for users to edit and improve. The editing efficiency of the electronic form is improved, the purpose of online form editing by multiple people is realized, and the time-consuming of editing operation is reduced.

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 stored in the memory 91 and executable on the processor 90 , such as a spreadsheet editing program . When the processor 90 executes the computer program 92 , the steps in each of the above-mentioned embodiments of the method for editing a spreadsheet are implemented, for example, S101 to S105 shown in FIG. 1 . Alternatively, when the processor 90 executes the computer program 92, the functions of the units in the above-mentioned device embodiments, for example, the functions of the modules 81 to 85 shown in FIG. 8 are implemented.

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

The terminal device 9 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The terminal device may include, but is not limited to, a processor 90 and a memory 91 . Those skilled in the art can understand that FIG. 9 is only an example of the terminal device 9, and does not constitute a limitation on the terminal device 9, and may include more or less components than the one shown, or combine some components, or different components For example, the terminal device may further include an input and output device, a network access device, a bus, and the like.

The so-called processor 90 may be a central processing unit (Central Processing Unit, CPU), and may also be other general-purpose processors, digital signal processors (Digital Signal Processors, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), Off-the-shelf programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and the like. 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 memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) equipped on the terminal device 9. card, flash card (Flash Card) and so on. Further, the memory 91 may also include both an internal storage unit of the terminal device 9 and an external storage device. The memory 91 is used to store the computer program and other programs and data required by the terminal device. The memory 91 can also be used to temporarily store data that has been output or will be output.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units may be implemented in the form of hardware, or may be implemented in the form of software functional units.

The above-mentioned embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: it is still possible to implement the foregoing implementations. The technical solutions described in the examples are modified, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention, and should be included in the within the protection scope of the present invention.

Claims (10)

1. a kind of editing method of electronic form, is characterized in that, comprises: If an editing request of the electronic form is received, the online editing server is called to construct a form frame corresponding to the electronic form; Determine a target database according to the editing request, and download the form data corresponding to the electronic form from the target database; the target database is specifically: a database deployed in the cloud for receiving form data sent by each user; importing the table data into the table frame, generating and displaying the spreadsheet, and performing editing operations on the displayed spreadsheet; updating the form data of the electronic form based on user-initiated editing instructions; The updated table data is uploaded to the target database at a preset update time interval. 2. The editing method according to claim 1, wherein, if an editing request of an electronic form is received, an online editing server is called to construct a form frame corresponding to the electronic form, comprising: Send a frame query instruction to the online editing server, and receive a frame query result returned by the online editing server based on the frame query instruction; the frame query result includes the frame data volume of the table frame; If the frame data volume is greater than a preset data volume threshold, send 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; Run the online editing plug-in to build the table frame locally. 3. The editing method according to claim 2, wherein after the frame query instruction is sent to the online editing server and the frame query result returned by the online editing server based on the frame query instruction is received, Also includes: If the frame data volume is less than or equal to the data volume threshold, sending a backend construction instruction to the online editing server to construct a web page including the table frame through the online editing server; A jump link about 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. 4. The editing method according to claim 2, wherein after the frame query instruction is sent to the online editing server and the frame query result returned by the online editing server based on the frame query instruction is received, Also includes: Obtain the current network parameters of the network where it is located and the load value of the online editing server; Obtain the first weighting factor according to the network parameter and the maximum value of the network parameter of the network where it is located; Obtain the historical response records of the online editing server, and calculate the second weighting factor based on the historical load value of each historical response record and the current load value; The data volume threshold is calculated according to the first weighting factor, the second weighting factor and the reference data threshold. 5. The editing method according to any one of claims 1-4, wherein, determining a target database according to the editing request, and downloading form data corresponding to an electronic form from the target database, comprising: identifying the parameter items contained in the table frame; Extracting a plurality of product records of the target product corresponding to the editing request from the target database; Extracting parameter values corresponding to all the parameter items from each of the product records respectively, and generating product data corresponding to the product records; The product data of all the product records is encapsulated to obtain the table data. 6. The editing method according to any one of claims 1-4, wherein, determining a target database according to the editing request, and downloading form data corresponding to an electronic form from the target database, comprising: Parse the edit request to determine the starting line number; Determine the target row number segment of this download according to the starting row number and the table rendering range; The table data corresponding to the target row number segment is downloaded from the target database. 7. The editing method according to any one of claims 1-4, wherein the determining a target database according to the editing request, and downloading form data corresponding to the electronic form from the target database, comprises: Acquiring the editing record of the user; the editing record includes the corresponding editing coordinates when the editing operation is performed; The table data is determined according to the editing coordinates and the maximum number of displayed rows, and the table data is downloaded from the target database. 8. A device for editing an electronic form, comprising: a form frame construction unit, configured to call an online editing server to construct a form frame corresponding to the electronic form if an editing request of the electronic form is received; a table data downloading unit, configured to determine a target database according to the editing request, and download table data corresponding to the electronic form from the target database; a spreadsheet display unit, configured to import the table data into the table frame, generate and display the spreadsheet, and perform editing operations on the displayed spreadsheet; a table data updating unit, configured to update the table data of the electronic table based on an editing instruction initiated by a user; A table data uploading unit, configured to upload the updated table data to the target database at a preset update time interval. 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, when the processor executes the computer program The steps of the method as claimed in any one of claims 1 to 7. 10. A computer-readable storage medium storing a computer program, characterized in that, when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented .

Images