CN113947065A

CN113947065A - Data processing method, data processing device, electronic equipment and storage medium

Info

Publication number: CN113947065A
Application number: CN202111199912.2A
Authority: CN
Inventors: 曾祁霖; 闵昊; 刘超然
Original assignee: Beijing Dajia Internet Information Technology Co Ltd
Current assignee: Beijing Dajia Internet Information Technology Co Ltd
Priority date: 2021-10-14
Filing date: 2021-10-14
Publication date: 2022-01-18

Abstract

The application relates to a data processing method, a data processing device, electronic equipment and a storage medium, and belongs to the technical field of computers. According to the technical scheme provided by the embodiment of the application, when a user wants to perform data perspective on data in the online form, the data perspective option in the online editing page is triggered, so that the electronic equipment can be controlled to display at least one field of the online form in the online editing page, and the user can select the first field required by generating the data perspective form through the online editing page. The electronic device is capable of directly exposing the first pivot table based on the first field. The user does not need to download the data in the online form to the terminal, the data in the online form can be directly subjected to data perspective through the server, and the terminal directly displays the generated first data perspective form, so that the data perspective efficiency is improved.

Description

Data processing method, data processing device, electronic equipment and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data processing method and apparatus, an electronic device, and a storage medium.

Background

With the development of internet technology, more and more users perform data management through online forms. In some cases, when a user wants to process data in an online form, for example, to perform data perspective, the user cannot directly perform operations on the online form, but needs to download the data in the online form to a terminal, and the terminal performs data perspective on the data in the online form, so that the efficiency of data perspective is low.

Disclosure of Invention

The application provides a data processing method, a data processing device, an electronic device and a storage medium, so as to improve the data perspective efficiency. The technical scheme of the application is as follows:

in one aspect, a data processing method is provided, including:

displaying an online editing page of an online form, the online form comprising at least one field and at least one entry, one of the entries comprising at least one sub-entry, one of the sub-entries corresponding to one of the fields;

in response to receiving a triggering operation on a data perspective option in the online editing page, displaying at least one field of the online form in a first area of the online editing page;

responding to the received selection operation of a first field in the at least one field, and sending a data perspective request to a server, wherein the data perspective request carries the first field, and the data perspective request is used for performing data processing based on a sub-table entry corresponding to the first field to obtain a first pivot table;

and acquiring the first pivot table generated by the server, and displaying the first pivot table in the online editing page.

In a possible implementation, the first region further displays thereon a row field selection sub-region, a column field selection sub-region, and a value field selection sub-region of the pivot table, the first field includes a row field, a column field, and a value field, and the sending the pivot request to the server in response to receiving a selection operation on a first field of the at least one field includes:

and sending the data perspective request to the server in response to the row field being dragged to the row field selection sub-region, the column field being dragged to the column field selection sub-region, and the value field being dragged to the value field selection sub-region, wherein the data perspective request carries the row field, the column field, and the value field of the first field.

In one possible implementation, after the displaying the first pivot table in the online editing page, the method further includes:

in response to receiving an update operation on the first pivot table, determining a second field corresponding to the update operation;

sending an update request for the first pivot table to the server, wherein the update request carries the second field, and the update request is used for updating the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table;

and acquiring the second pivot table generated by the server, and displaying the second pivot table in the online editing page.

In one possible implementation, after displaying the first pivot table in the online editing page, the method further includes:

in response to receiving a confirmation operation on the first pivot table, sending a table storage request to the server, where the table storage request carries an identifier of the first pivot table, and the table storage request is used to store the first pivot table in the online table;

displaying an identification of the first pivot table in the online table.

In one possible embodiment, the method further comprises:

displaying at least one chart identifier in a chart type selection area of the online editing page in response to receiving a chart calling operation in the online editing page;

sending a first chart acquisition request to the server in response to receiving a selection operation of a first chart identifier in the at least one chart identifier, wherein the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used for querying based on the first chart identifier to obtain a first chart corresponding to the first chart identifier;

and receiving the first chart sent by the server, and displaying the first chart in the online editing page, wherein the first chart comprises a third field in the online form and a sub-table item corresponding to the third field.

In one possible implementation, the chart calling operation includes any one of a trigger operation on a chart calling option in the online editing page and a target character input operation in the online editing page.

In one possible implementation, the displaying at least one chart identifier in a chart type selection area of the online editing page in response to receiving the chart calling operation in the online editing page includes:

displaying a chart type selection area in the online editing page in response to receiving a chart calling operation in the online editing page, wherein at least one chart type is displayed in the chart type selection area;

and responding to the selection operation of a target chart type in the at least one chart type, and displaying a chart selection area corresponding to the target chart type in the online editing page, wherein at least one chart identifier is displayed in the chart selection area, and the type corresponding to the at least one chart identifier is the target chart type.

In a possible implementation manner, at least one chart type option corresponding to the first chart is displayed in the online editing page, and after the first chart is displayed in the online editing page, the method further includes:

in response to receiving a selection operation of any chart type option in the at least one chart type option, performing type conversion on the first chart based on the chart type indicated by the chart type option to obtain a second chart, wherein the second chart and the first chart have the same chart content;

displaying the second chart in the online editing page.

In one possible embodiment, the method further comprises:

in response to receiving a trigger operation for a form call option in the online editing page, displaying at least one field of the online form in a second area of the online editing page;

in response to receiving a selection operation of a fourth field of the at least one field, displaying a target table in the online editing page, wherein the target table comprises the fourth field and a sub-table item corresponding to the fourth field.

In one possible implementation, after the target form is displayed in the online editing page, the method further includes:

in response to receiving a content adjustment operation on any first sub-table entry displayed in the target table, updating the first sub-table entry based on a second sub-table entry corresponding to the content adjustment operation.

in response to receiving a table name adjustment operation on the first pivot table, displaying a table name input box of the first pivot table in the online editing page;

and updating the table name of the first pivot table by adopting the table name input in the table name input box.

and responding to the sequence adjustment operation of the sub-table items displayed in the first pivot table, and adjusting the display sequence of the sub-table items displayed in the first pivot table to obtain a third pivot table.

and responding to the export operation of the first pivot table, and acquiring a file corresponding to the first pivot table.

In one aspect, a data processing method is provided, including:

obtaining a data perspective request, wherein the data perspective request carries a first field, the first field is a selected field in an online form, the online form comprises at least one field and at least one table entry, one table entry comprises at least one sub-table entry, one sub-table entry corresponds to one field, and the data perspective request is sent in response to receiving a trigger operation on a data perspective option in an online editing page of the online form;

performing data processing based on the sub-table items corresponding to the first field to obtain a first pivot table;

and sending the first data perspective table to a sending end of the data perspective request so that the sending end of the data perspective request displays the first data perspective table in the online editing page.

In a possible implementation manner, the first field includes a row field, a column field, and a value field, and the performing data processing based on the sub-table entry corresponding to the first field to obtain the first perspective data table includes:

and performing data processing based on the row field, the column field and the value field of the first field to obtain the first pivot table.

In a possible implementation manner, after the data processing is performed based on the sub-table entry corresponding to the first field to obtain the first pivot table, the method further includes:

acquiring an update request for the first pivot table, wherein the update request carries a second field, and the second field is a field corresponding to the update operation for the first pivot table;

and responding to the updating request, and updating the first pivot table based on the sub-table entry corresponding to the second field to obtain a second pivot table.

acquiring a table storage request, wherein the table storage request carries an identifier of the first pivot table;

storing the first pivot table in the online table in response to the table storage request;

generating an identification of the first pivot table in the online table.

In one possible embodiment, the method further comprises:

acquiring a first chart acquisition request, wherein the first chart acquisition request carries a first chart identifier, and the first chart identifier is a selected chart identifier in at least one chart identifier displayed in a chart type selection area of the online editing page;

responding to the first chart acquisition request, and inquiring based on the first chart identification to obtain a first chart corresponding to the first chart identification;

and sending the first chart to a sending end of the first chart acquisition request.

In one aspect, a data processing apparatus is provided, including:

an online editing page display unit configured to execute an online editing page displaying an online form, the online form including at least one field and at least one entry, one of the entries including at least one sub-entry, one of the sub-entries corresponding to one of the fields;

a field display unit configured to perform displaying at least one field of the online form in a first area of the online editing page in response to receiving a trigger operation for a data perspective option in the online editing page;

a data perspective request sending unit, configured to execute, in response to receiving a selection operation on a first field in the at least one field, sending a data perspective request to a server, where the data perspective request carries the first field, and the data perspective request is used to perform data processing based on a sub-table entry corresponding to the first field to obtain a first pivot table;

a first pivot table display unit configured to perform acquiring the first pivot table generated by the server, and display the first pivot table in the online editing page.

In a possible implementation manner, a row field selection sub-region, a column field selection sub-region, and a value field selection sub-region of a pivot table are further displayed on the first region, where the first field includes a row field, a column field, and a value field, the data pivot request sending unit is configured to send the data pivot request to the server in response to the row field being dragged to the row field selection sub-region, the column field being dragged to the column field selection sub-region, and the value field being dragged to the value field selection sub-region, where the data pivot request carries the row field, the column field, and the value field of the first field.

In a possible embodiment, the apparatus further comprises:

a second pivot table display unit configured to execute, in response to receiving an update operation on the first pivot table, determining a second field corresponding to the update operation; sending an update request for the first pivot table to the server, wherein the update request carries the second field, and the update request is used for updating the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table; and acquiring the second pivot table generated by the server, and displaying the second pivot table in the online editing page.

In a possible embodiment, the apparatus further comprises:

a first pivot table display unit, further configured to execute sending, in response to receiving a confirmation operation on the first pivot table, a table storage request to the server, the table storage request carrying an identifier of the first pivot table, the table storage request being used to store the first pivot table in the online table; displaying an identification of the first pivot table in the online table.

In a possible embodiment, the apparatus further comprises:

a first chart display unit configured to perform displaying at least one chart identifier in a chart type selection area of the online editing page in response to receiving a chart calling operation in the online editing page; sending a first chart acquisition request to the server in response to receiving a selection operation of a first chart identifier in the at least one chart identifier, wherein the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used for querying based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; and receiving the first chart sent by the server, and displaying the first chart in the online editing page, wherein the first chart comprises a third field in the online form and a sub-table item corresponding to the third field.

In one possible implementation, the first chart displaying unit is configured to perform a chart calling operation in response to receiving a chart in the online editing page, and a chart type selecting area is displayed in the online editing page, wherein at least one chart type is displayed in the chart type selecting area; and responding to the selection operation of a target chart type in the at least one chart type, and displaying a chart selection area corresponding to the target chart type in the online editing page, wherein at least one chart identifier is displayed in the chart selection area, and the type corresponding to the at least one chart identifier is the target chart type.

In a possible embodiment, the apparatus further comprises:

a second chart display unit configured to perform, in response to receiving a selection operation on any one of the at least one chart type option, type conversion on the first chart based on the chart type indicated by the chart type option to obtain a second chart, wherein the second chart has the same chart content as the first chart; displaying the second chart in the online editing page.

In a possible embodiment, the apparatus further comprises:

a target form display unit configured to perform, in response to receiving a trigger operation for a form call option in the online editing page, displaying at least one field of the online form in a second area of the online editing page; in response to receiving a selection operation of a fourth field of the at least one field, displaying a target table in the online editing page, wherein the target table comprises the fourth field and a sub-table item corresponding to the fourth field.

In a possible embodiment, the apparatus further comprises:

a sub-table entry updating unit configured to, in response to receiving a content adjustment operation on any first sub-table entry displayed in the target table, update the first sub-table entry based on a second sub-table entry corresponding to the content adjustment operation.

In a possible embodiment, the apparatus further comprises:

a table name updating unit configured to perform displaying a table name input box of the first pivot table in the online editing page in response to receiving a table name adjustment operation for the first pivot table; and updating the table name of the first pivot table by adopting the table name input in the table name input box.

In a possible embodiment, the apparatus further comprises:

a display order adjusting unit configured to perform adjustment of a display order of sub-entries displayed in the first pivot table in response to an order adjusting operation on the sub-entries displayed in the first pivot table, resulting in a third pivot table.

In a possible embodiment, the apparatus further comprises:

and the file export unit is configured to execute the export operation of the first pivot table, and acquire the file corresponding to the first pivot table.

In one aspect, a data processing apparatus is provided, including:

a data perspective request obtaining unit configured to execute a data perspective request, where the data perspective request carries a first field, the first field is a selected field in an online form, the online form includes at least one field and at least one entry, one entry includes at least one sub-entry, one sub-entry corresponds to one field, and the data perspective request is sent in response to receiving a trigger operation on a data perspective option in an online editing page of the online form;

the first data perspective table generating unit is configured to execute data processing based on the sub-table items corresponding to the first field to obtain a first data perspective table;

a first pivot table sending unit configured to execute sending the first pivot table to the sender of the pivot request, so that the sender of the pivot request displays the first pivot table in the online editing page.

In a possible implementation manner, the first field includes a row field, a column field, and a value field, and the first pivot table generation unit is configured to perform data processing based on the row field, the column field, and the value field of the first field, so as to obtain the first pivot table.

In a possible embodiment, the apparatus further comprises:

a second pivot table generation unit, configured to execute obtaining an update request for the first pivot table, where the update request carries a second field, and the second field is a field corresponding to an update operation for the first pivot table; and responding to the updating request, and updating the first pivot table based on the sub-table entry corresponding to the second field to obtain a second pivot table.

In a possible embodiment, the apparatus further comprises:

the second pivot table generation unit is configured to execute a table storage request carrying an identifier of the first pivot table; storing the first pivot table in the online table in response to the table storage request; generating an identification of the first pivot table in the online table.

In a possible embodiment, the apparatus further comprises:

a first chart sending unit, configured to execute a first chart obtaining request, where the first chart obtaining request carries a first chart identifier, and the first chart identifier is a selected chart identifier in at least one chart identifier displayed in a chart type selection area of the online editing page; responding to the first chart acquisition request, and inquiring based on the first chart identification to obtain a first chart corresponding to the first chart identification; and sending the first chart to a sending end of the first chart acquisition request.

In one aspect, an electronic device is provided, including:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the data processing method described above.

In one aspect, a computer-readable storage medium is provided, in which instructions, when executed by a processor of an electronic device, enable the electronic device to perform the above-described data processing method.

In an aspect, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the above-described data processing method.

The technical scheme provided by the embodiment of the application at least has the following beneficial effects:

according to the technical scheme provided by the embodiment of the application, when a user wants to perform data perspective on data in the online form, the data perspective option in the online editing page is triggered, so that the electronic equipment can be controlled to display at least one field of the online form in the online editing page, and the user can select the first field required by generating the data perspective form through the online editing page. The electronic device is capable of directly exposing the first pivot table based on the first field. The user does not need to download the data in the online form to the terminal, the data in the online form can be directly subjected to data perspective through the server, and the terminal directly displays the generated first data perspective form, so that the data perspective efficiency is improved.

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

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the application and are not to be construed as limiting the application.

FIG. 1 is a schematic diagram of an implementation environment of a data processing method according to an example embodiment.

FIG. 2 is a flow chart illustrating a method of data processing according to an exemplary embodiment.

FIG. 3 is a flow chart illustrating a method of data processing according to an exemplary embodiment.

FIG. 4 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 5 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 6 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 7 is a flow chart illustrating a method of data processing according to an exemplary embodiment.

FIG. 8 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 9 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 10 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 11 is a flow chart illustrating a method of data processing according to an exemplary embodiment.

FIG. 12 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 13 is a schematic diagram of a page shown in accordance with an exemplary embodiment.

FIG. 14 is a block diagram illustrating a data processing apparatus according to an example embodiment.

FIG. 15 is a block diagram illustrating a data processing apparatus according to an example embodiment.

Fig. 16 is a block diagram illustrating a terminal according to an example embodiment.

FIG. 17 is a block diagram illustrating a server in accordance with an example embodiment.

Detailed Description

In order to make the technical solutions of the present application better understood by those of ordinary skill in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.

The data referred to in the present application may be data authorized by the user or sufficiently authorized by the parties.

The following is a description of the terms referred to in this application:

data pivot table: (Pivot Table) is an interactive Table that allows certain calculations to be performed, such as summing and counting. The calculations performed are related to the arrangement of the data in the pivot table.

The online document is used for users to edit online, collaborate with multiple users and store in a cloud in real time, document display is carried out through a Hyper Text Markup Language (HTML) page, synchronization of user editing contents is realized depending on communication between a client and a server, and the types of the online document can be an online Word document, an online Excel document, an online PPT document and an online drawing document.

In response to the condition or state on which the performed operation depends, one or more of the performed operations may be in real-time or may have a set delay when the dependent condition or state is satisfied; there is no restriction on the order of execution of the operations performed unless otherwise specified.

Optionally, the electronic device provided in this embodiment of the present application is implemented as a terminal or a server, and an implementation environment formed by the terminal and the server is described below.

Fig. 1 is a schematic diagram of an implementation environment of a data processing method according to an embodiment of the present application, and referring to fig. 1, the implementation environment may include a terminal 101 and a server 102.

The terminal 101 may be at least one of a smartphone, a smart watch, a desktop computer, a laptop portable computer, and the like. The terminal 101 may be installed and run with an application program supporting browsing of an online form, and a user may process data in the online form through the application program.

The terminal 101 may be generally referred to as one of a plurality of terminals, and the embodiment is only illustrated by the terminal 101. Those skilled in the art will appreciate that the number of terminals described above may be greater or fewer. For example, the number of the terminals 101 may be only a few, or the number of the terminals 101 may be tens or hundreds, or more, and the number of the terminals 101 and the type of the device are not limited in the embodiment of the present application. The terminal 101 may be connected to the server 102 through a wireless network or a wired network.

The server 102 may be at least one of a server, a plurality of servers, a cloud computing platform, and a virtualization center. The server 102 correspondingly maintains a database, and the database stores relevant data of the online table.

Alternatively, the number of the servers 102 may be more or less, and the embodiment of the present application is not limited thereto. Of course, the server 102 may also include other functional servers to provide more comprehensive and diverse services.

After the description of the implementation environment of the embodiment of the present application, an application scenario of the present application will be described below with reference to the implementation environment. In the following description, the terminal is the terminal 101 in the implementation environment, and the server is the server 102 in the implementation environment.

The data processing method provided by the embodiment of the application can be applied to any data statistics scene, such as the scene of processing sales data, the scene of processing performance wage data and the scene of processing multiple items of motion data.

In the scenario of processing the sales data, the user can view the online form through the terminal, and a plurality of entries are displayed in the online form, and one entry is also a piece of sales data. In some embodiments, a piece of sales data includes time of sale, sales subject, sales person, sales amount, and the like. When a user browses an online form, sales data in the online form may need to be processed, for example, the total sales amount in a certain time period is counted, in this case, the user can control the server to execute the data processing method provided by the embodiment of the present application through the terminal, data in the online form is processed into a pivot table, the pivot table can also display the total sales amount in the certain time period, and the user can quickly know the total sales amount in the certain time period by looking up the pivot table, which is high in efficiency.

Under the scene of processing performance wage data, a user can view an online form through a terminal, wherein a plurality of entries are displayed in the online form, and one entry is also one piece of performance wage data. In some embodiments, a piece of performance payroll data includes payroll object, performance acquisition time, performance type, performance amount, and the like. When a user browses an online form, performance wage data in the online form may need to be processed, for example, the total performance wage of a certain employee in the last month is counted, in this case, the user can control the server to execute the data processing method provided by the embodiment of the present application through the terminal, data in the online form is processed into a pivot table, the pivot table can also show the total performance wage of the certain employee in the last month, and the user can quickly know the total performance wage of the certain employee in the last month by looking up the pivot table, so that the efficiency is high.

In a scenario of processing multiple items of motion data, a user can view an online form through a terminal, wherein multiple entries are displayed in the online form, and one entry is also one item of motion data. In some embodiments, an athletic data item includes athlete's name, athletic performance, ranking, score earned, and the like. When a user browses the online form, the user may need to process the exercise data in the online form, for example, to count the total score of a certain athlete, in this case, the user may control the server through the terminal to execute the data processing method provided in the embodiment of the present application, and process the data in the online form into a pivot table, which may also show the total score of the certain athlete, so that the user may quickly know the total score of the certain athlete by looking up the pivot table, which is highly efficient.

Fig. 2 is a flow chart illustrating a data processing method according to an exemplary embodiment, the method being performed by an electronic device, as shown in fig. 2, including the following steps.

In step S201, an online edit page of an online form is displayed, where the online form includes at least one field and at least one entry, and one entry includes at least one sub-entry, and one sub-entry corresponds to one field.

The online table is a table that a user wants to perform data processing, the online editing page is a page for editing the online table, the table entry is a row of data in the table, the sub-table entry is a single datum in the row of data, and the field is used for indicating the type of the corresponding sub-table entry, for example, the name is a field.

In step S202, in response to receiving a trigger operation for a data perspective option in the online editing page, at least one field of the online form is displayed in a first area of the online editing page.

The data perspective option is an option for triggering the data perspective function, but when the data perspective option is triggered, the electronic device can perform the data perspective function.

In step S203, in response to receiving a selection operation on a first field of the at least one field, a data perspective request is sent to the server, where the data perspective request carries the first field, and the data perspective request is used to perform data processing based on a sub-table entry corresponding to the first field, so as to obtain a first pivot table.

In step S204, the first pivot table generated by the server is acquired, and the first pivot table is displayed in the online editing page.

The foregoing steps S201 to S204 are simply introduced in the present application, and the following will describe, in combination with some examples, a data processing method provided in the present application more clearly, where the method is executed by an electronic device, and taking the electronic device as a terminal as an example, referring to fig. 3, the method includes:

in step S301, the terminal displays an online edit page of an online form, where the online form includes at least one field and at least one entry, and one entry includes at least one sub-entry, and one sub-entry corresponds to one field.

The online form is selected by the user, and the list item is a row of data in the online form.

In one possible implementation mode, the terminal displays a content loading page of the online document, and a plurality of online forms are displayed in the content loading page. In response to a selection operation for any one of the plurality of online forms, the terminal displays an online edit page of the online form. The user can adjust the fields and the entries in the online form through the online editing page of the online form. For example, for a field "name", the user can modify the field to "athlete name" or "volunteer name" etc. via the online edit page. For the sub-entry "zhang san" corresponding to the field "name", the user can also modify the sub-entry to "lie four" or "wang wu" through the online editing page. In some embodiments, the content loading page of the online document is a page displayed by an application program of the online document after an account is logged in, or is a display webpage corresponding to the online document, which is not limited in this application embodiment.

In some embodiments, the content loading page of the online document may also display a plurality of online documents, in addition to a plurality of online forms, or display a blank page on which the user can add data by himself, which is not limited by the embodiment of the present application. In some embodiments, for ease of distinction, different online forms can be stored in different folders, and the content loading page of the online document can provide the user with the functionality to create a folder through which the user can effect the creation of a folder. Of course, after creating the folder, the user can also drag different online forms into different folders to achieve separate management of different online forms.

Referring to fig. 4, the terminal displays a content loading page 401 of the online document, and identifiers of a plurality of online forms, i.e., names of the online forms, are displayed on the content loading page 401. In response to the click operation on any one of the identifiers of the online forms, the terminal displays an online edit page 402 of the online form corresponding to the identifier, where at least one field and a plurality of entries of the online form are displayed in the online edit page, and in fig. 4, sub-entry a-sub-entry D form one entry, and sub-entry E-sub-entry H form another entry. In some embodiments, an editing control 403 is displayed on the online editing page 402, and in response to a click operation on the editing control 403, the online editing page 402 becomes editable, and a user can adjust a field or an entry displayed in the online editing page. By setting the editing control, the error editing of the online form by the user can be avoided, namely, when the online form is not required to be edited, the user can check the content of the online form through the online editing page; when there is a need for editing the online form, the user can trigger the function of editing the online form by clicking the editing control 403, so as to edit the online form.

It should be noted that, in the above and following descriptions, the click operation has different meanings for different types of terminals, and for smartphones and tablet computers, the click operation is a click operation on a screen; for desktop computers and notebook computers, the click operation is a click operation for controlling a mouse pointer to a specific position, and certainly, for some desktop computers and notebook computers with a screen touch function, the click operation may also be a click operation for a screen, which is not limited in the embodiments of the present application.

In the implementation mode, a user can quickly select the online form which is required to be viewed through the content loading page of the online document, and when the online form needs to be edited, the online form can be edited through the online editing page of the online form, so that the efficiency is high.

Taking the content loading page of the online document as the page displayed after the account login of the application program of the online document as an example, responding to the application program starting instruction of the online document, and displaying the login interface of the online document by the terminal, wherein the login interface comprises an account input area, a password input area and a login control. And responding to the click operation of the login control, the terminal sends a login request to the server, wherein the login request carries the account input in the account input area and the password input in the password input area. And after receiving the login request, the server acquires the account and the password from the login request and verifies the account and the password. In response to the account and the password being successfully verified, the server sends a message of successful verification to the terminal, where the message of successful verification carries the identifiers and addresses of the multiple online tables corresponding to the account, where the multiple tables are online tables created for the account or online tables shared by other accounts and the account, which is not limited in the embodiment of the present application. And after receiving the message of successful verification, the terminal acquires the identifiers and the addresses of the multiple online forms from the message of successful verification, displays the identifiers of the multiple online documents in the content loading page, and binds each identifier with a corresponding address. And responding to the click operation of any identifier, acquiring a corresponding online form by the terminal based on the address corresponding to the identifier, and displaying an online editing page of the online form.

In step S302, in response to receiving a trigger operation for a data perspective option in the online editing page, the terminal displays at least one field of the online form in a first area of the online editing page.

In a possible implementation manner, a data perspective option is displayed in the online editing page, in response to a click operation on the data perspective option, the terminal sorts at least one field of the online form according to a target sequence, and displays the sorted at least one field in a first area of the online editing page.

The terminal sorts at least one field according to the target sequence, namely, the terminal sorts at least one field according to the sorting sequence of the first letter of at least one field in the alphabet. Or, the target sequence is the sequence of field lengths from short to long or from long to short, and the terminal sorts at least one field according to the target sequence, that is, the terminal sorts at least one field according to the sequence of fields from short to long or from long to short.

In the implementation mode, the terminal can sort the fields in the online form according to the target sequence so as to fulfill the aim of data sorting and facilitate the user to check.

For example, the data perspective option is a data perspective control, and the data perspective control is displayed in the online editing page. And responding to the clicking operation of the data perspective control, sequencing at least one field of the online form according to the target sequence by the terminal, and displaying the sequenced at least one field in a first area of the online editing page. In some embodiments, a first region of the online editing page is located on a left side of the online editing page, and at least one field displayed in the first region is arranged vertically in the target arrangement order. For example, referring to fig. 5, a data perspective control 502 is displayed on an online editing page 501, in response to a click operation on the data perspective control 502, the terminal displays at least one field in a first area 503 of the online editing page 501, and a user can select at least one field that is displayed to determine a field that is desired to be subjected to data perspective.

In one possible embodiment, in addition to controlling the terminal to display at least one field in the first area by clicking on the data perspective option, the user can also control the terminal to display at least one field in the first area by pressing the first target key or the first target key combination. That is, in response to detecting a click operation on the first target key or the first target key combination, the terminal displays at least one field in the first area. For example, when the terminal displays the online editing page, the user presses a "\" key on the keyboard, and the terminal can be controlled to display at least one field in the first area, that is, in response to detecting that the key "\" is pressed, the terminal displays at least one field in the first area of the online editing page. Or when the terminal displays the online editing page, the user simultaneously presses a Ctrl key and a \ "key on the keyboard, so that the terminal can be controlled to display at least one field in the first area. In some embodiments, the terminal can display the first target key or the first target key combination below the data perspective option, in such a way as to play a role in reminding the user that the user pressing the first target key or the first target key combination has the same role as clicking the data perspective option.

In step S303, in response to receiving a selection operation on a first field of the at least one field, the terminal sends a data perspective request to the server, where the data perspective request carries the first field, and the data perspective request is used to perform data processing based on a sub-table entry corresponding to the first field, so as to obtain a first pivot table.

In a possible embodiment, a row field selection sub-area, a column field selection sub-area and a value field selection sub-area of the pivot table are also displayed on the first area, and the first field includes a row field, a column field and a third field. And in response to the fact that the row field is dragged to the row field selection sub-region, the column field is dragged to the column field selection sub-region, and the value field is dragged to the value field selection sub-region, the terminal sends the data perspective request to the server, wherein the data perspective request carries the row field, the column field and the value field of the first field. And the server acquires the data perspective request, and performs data processing based on the sub-table item corresponding to the first field to obtain a first data perspective table. The server sends the first data perspective table to a sending end of the data perspective request, namely the terminal. In some embodiments, in response to the value field being dragged to the value field selection sub-area, the terminal displays a summary mode selection page of the value field on the first area, and the summary mode selection page of the value field displays a plurality of summary modes, including summation, counting, average, maximum, minimum and product. The user can control the server to generate different types of first pivot tables by selecting different summarizing modes.

For example, for sales data, a user can select a row field "sales object" for the data perspective table, select a column field "sales person" for the data perspective table, and select a value field "sales amount" for the data perspective table, so that the generated data perspective table can reflect sales amounts of different sales persons for different sales objects. In some embodiments, if the user selects the page by the summary mode of the value field to select the summation for the value field, the generated pivot table can reflect the total sum of the sales amount of each sales person for each sales object; if the page is selected to select the counting for the value field in a summarizing mode of the value field, the generated data perspective table can reflect the sales frequency of each salesman for each sales object; if the maximum value is selected for the value field by selecting the page in a summarizing mode of the value field, the generated data perspective table can reflect the maximum sales amount of each salesperson for each sales object. That is, the user can actually select from the summary page of the value fields to obtain different pivot tables.

In the embodiment, the terminal does not need to download data in the online form, the data perspective request is generated directly based on the free selection of the row field, the column field and the value field for the first data perspective table by the user, the first data perspective table can be automatically generated by the server based on the data perspective request, and the generation efficiency of the first data perspective table is high.

For example, the terminal displays at least one field of the online form on a first field display area of the first area, and displays a row field selection sub-area, a column field selection sub-area, and a value field selection sub-area on the first area, respectively. In some embodiments, the first field show region is located on the left side of the first region, and the row field select sub-region, the column field select sub-region, and the value field select sub-region are located on the right side of the first region. For example, referring to fig. 6, a first field presentation area 602, a row field selection sub-area 603, a column field selection sub-area 604, and a value field selection sub-area 605 are displayed on the online editing page 601. The user can select a row field, a column field and a value field in the first field presentation area 602, and the user drags the fields displayed in the first field presentation area 602 to the row field selection sub-area 603, the column field selection sub-area 604 and the value field selection sub-area 605, that is, the process of selecting the row field, the column field and the value field for the pivot table.

In some embodiments, the user can drag the fields presented in the first field presentation area into the row field selection sub-area, the column field selection sub-area, and the value field selection sub-area to enable selection of the row field, the column field, and the value field for the pivot table. In some embodiments, in response to the row field being dragged to the row field selection sub-region, the column field being dragged to the column field selection sub-region, and the value field being dragged to the value field selection sub-region, the terminal is capable of displaying the row field in the row field selection sub-region, displaying the column field in the column field selection sub-region, displaying the value field in the value field selection sub-region, and the user is capable of viewing the field selected by the user in the row field selection sub-region, the column field selection sub-region, and the value field display sub-region. In response to that the row field is dragged to the row field selection sub-region, the column field is dragged to the column field selection sub-region, and the value field is dragged to the value field selection sub-region, the terminal sends a data perspective request to the server, where the data perspective request carries the row field, the column field, and the value field, and certainly the data perspective request also carries the type of the row field as the row field, the type of the column field as the column field, and the type of the value field as the value field. In response to receiving the data perspective request, the server acquires a row field, a column field and a value field of a first field from the data perspective request, and performs data processing based on the row field, the column field and the value field of the first field to obtain the first pivot table, that is, the server performs data processing based on a sub-table item corresponding to the row field, a sub-table item corresponding to the column field and a sub-table item corresponding to the value field to generate the first pivot table. The subsequent server can send the first pivot table to the terminal, and the terminal displays the first pivot table in the online editing page. In some embodiments, the terminal can implement data interaction with the server based on an RPC (Remote Procedure Call) technology. From the perspective of a user, the terminal can directly display the first pivot table only by dragging the row field to the row field selection sub-region, dragging the column field to the column field selection sub-region and dragging the value field to the value field selection sub-region, without copying the data in the online table to the data processing application running on the terminal for processing, so that the data processing efficiency is improved.

In some embodiments, the terminal displays a field search box on the first area, the field search box being used to quickly find a field desired by the user from at least one field displayed on the first area. The terminal can display the corresponding field on the first area by the user inputting the complete field or a partial character of the field in the field search box. The user can drag the field to a row field selection sub-region, a column field selection sub-region, or a value field selection sub-region. In such a way, the efficiency of searching fields by the user is improved. For example, referring to fig. 6, a field search box 606 is displayed on a first area of the online editing page 601, and a user can perform a field search through the field search box 606.

In step S304, the terminal obtains the first pivot table generated by the server, and displays the first pivot table in the online editing page.

In a possible implementation manner, the online editing page further includes a preview area of the pivot table, and after the terminal acquires the first pivot table generated by the server, the first pivot table is displayed in the preview area of the pivot table. Referring to fig. 6, a preview area 607 of the pivot table is displayed on the online editing page 601.

In some embodiments, in response to the export operation of the first pivot table, the terminal acquires a file corresponding to the first pivot table. The preview area of the pivot table is also provided with a local scaling tool and an export tool, a user can realize local scaling of the pivot table through the local scaling tool, and the user can export the pivot table to the hard disk through the export tool so as to be consulted at any time.

In one possible implementation, the terminal displays a table name of the first pivot table above the first pivot table, and in response to receiving a table name adjustment operation for the first pivot table, the terminal displays a table name input box of the first pivot table in the online editing page. And the terminal updates the table name of the first pivot table by adopting the table name input in the table name input box.

In the embodiment, the user can adjust the table name of the first pivot table, and the efficiency of man-machine interaction is high.

In the method 1, the terminal displays a table name adjusting control beside the table name of the first pivot table, and in response to the click operation on the table name adjusting control, the terminal displays a table name input box, so that a user can input the table name to be adjusted in the table name input box, thereby realizing the adjustment of the table name of the first pivot table.

In the method 2, in response to a click operation on the table name of the first pivot table, the terminal displays a table name input box at a position where the table name of the first pivot table is displayed, the table name of the first pivot table is displayed in the table name input box, and the user can adjust the table name of the first pivot table in the table name input box.

In one possible implementation, in response to the order adjustment operation on the sub-table entries displayed in the first pivot table, the display order of the sub-table entries displayed in the first pivot table is adjusted to obtain a third pivot table.

In this embodiment, when the user wants to adjust the display order of the sub-entries in the first pivot table, the user can directly complete the adjustment operation through the order, and the efficiency is high.

After step S304, the terminal can perform both steps S305 and S306 described below and steps S307 and S308 described below, which is not limited in the embodiment of the present application.

In step S305, in response to receiving the update operation on the first pivot table, the terminal acquires an updated second pivot table from the server.

In one possible implementation, in response to receiving an update operation to the first pivot table, a second field corresponding to the update operation is determined. And sending an update request for the first pivot table to the server, wherein the update request carries the second field, and the update request is used for updating the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table. And acquiring the second pivot table generated by the server.

The first field comprises a row field, a column field and a value field, and the updating operation on any field in the first field can be regarded as the updating operation on the first pivot table.

In this embodiment, when a user wants to update the first pivot table, the second pivot table can be obtained only by performing the update operation on the first pivot table on the terminal, and the terminal does not need to perform additional data processing operations, so that the calculation amount of the terminal is reduced, and the update efficiency of the pivot table is improved.

For example, a row field selection sub-area, a column field selection sub-area and a value field selection sub-area of the pivot table are also displayed on the first area, the row field is displayed in the row field selection sub-area, the column field is displayed in the column field selection sub-area, and the value field is displayed in the value field selection sub-area. And in response to the fact that the row field displayed in the row field selection sub-area is dragged out, dragging another field to the row field selection sub-area, sending an update request for the first pivot table to the server by the terminal, wherein the update request carries the second field, the row field of the second field is another field dragged to the row field selection sub-area, the column field is the same as the first field, and the value field is also the same as the first field. The server acquires an update request for the first pivot table, wherein the update request carries a second field, and the second field is a field corresponding to the update operation of the first pivot table. And responding to the updating request, and updating the first pivot table by the server based on the sub-table entry corresponding to the second field to obtain a second pivot table.

Additionally, in addition to the user being able to drag the row field out of the row field selection sub-region, in some embodiments, the terminal displays a removal control to the right of the row field in response to the row field being dragged to the row field selection sub-region. And in response to the clicking operation on the removal control, the terminal removes the row field from the row field selection subarea. The user can drag another field to the row field selection sub-region. Or in some embodiments, a field clearing control is displayed in the row field selection sub-area, and in response to a click operation on the field clearing control, the terminal clears a field in the row field selection sub-area, so that a target of removing a row field from the row field selection sub-area can be achieved. The user can drag another field to the row field selection sub-region. Of course, the above description is given by taking the example of removing the row field from the row field selection sub-region, and in other possible embodiments, the field in the column field selection sub-region or the value field selection sub-region may also be removed in the above manner, which is not limited in the embodiment of the present application.

It should be noted that, the above description is given by taking the example of updating the row field to another field, and in other possible embodiments, the column field or the value field may be updated to another field, or any two or three of the row field, the column field, and the value field may be updated at the same time, which is not limited in the embodiment of the present application.

In step S306, the terminal displays the second pivot table.

In one possible implementation, the terminal displays the second pivot table in the online editing page.

In some embodiments, if the online editing page includes a preview region of a pivot table, the terminal can display the second pivot table in the preview region of the pivot table.

In step S307, in response to receiving the confirmation operation on the first pivot table, the terminal sends a table storage request to the server, where the table storage request carries an identifier of the first pivot table, and the table storage request is used to store the first pivot table in the online table.

The storing of the first pivot table in the online form means that the first pivot table is an attached table of the online form, or that the first pivot table can be displayed while the online form is displayed at the terminal.

Through the step S307, the user can store the updated second pivot table in the online table through the terminal control server, so that the storage space of the terminal is saved, and the user can conveniently look up the updated second pivot table.

For example, the terminal can display a confirmation control on the area where the first pivot table is displayed after the first pivot table is displayed. And responding to the click operation of the confirmation control, and sending a table storage request to the server by the terminal, wherein the table storage request carries the identifier of the first pivot table. And the server acquires a table storage request which carries the identifier of the first pivot table. In response to the table storage request, the server stores the first pivot table in the online table, that is, in response to receiving the table storage request, the server obtains the identifier of the first pivot table from the table storage request and stores the first pivot table in the online table. After the server stores the first pivot table in the online form, the user can look up the first pivot table through the online form at any time.

In some embodiments, the server can store the first pivot table in the online document in addition to storing the first pivot table in the online form, i.e., as an online form juxtaposed to the online form, and subsequent users can process the first pivot table.

In step S308, the terminal displays the identifier of the first pivot table in the online form.

In a possible implementation manner, the server generates an identifier of the first pivot table in the online form, the terminal displays the identifier of the first pivot table in the online form, and the identifier is also a table name of the first pivot table, and the user can determine the corresponding first pivot table by the table name.

In addition to the above steps S301 to S308, an embodiment of the present application further provides a data processing method, and referring to fig. 7, the method includes:

in step S701, the terminal displays an online edit page of an online form, where the online form includes at least one field and a plurality of entries, and one entry includes at least one sub-entry, and one sub-entry corresponds to one field.

The method for displaying the online editing page of the online form by the terminal is described in step S301, and is not described herein again.

In step S702, in response to receiving the chart calling operation in the online editing page, the terminal displays a chart type selection area in which at least one chart type is displayed in the online editing page.

The chart types include a line chart, a bar chart, a sector chart and the like. In some embodiments, the line graph comprises a time trend line graph and the bar graph comprises a bar graph of data split contrasts. The online document stores at least one chart of a chart type, and the charts are generated based on fields in the online table and sub-table items corresponding to the fields.

In one possible implementation mode, in response to the triggering operation of the chart calling option in the online editing page, the terminal displays at least one chart type in a chart type selection area of the online editing page.

In the embodiment, the terminal can call different types of charts through the chart type selection area, and the efficiency of man-machine interaction is high.

For example, referring to fig. 8, the chart call option is a chart call control, and the terminal displays the chart call control 802 on the online editing page 801. In response to a click operation on the chart call control 802, the terminal displays a chart type selection area 803 on the online editing page 801, in which at least one chart type is displayed in the chart type selection area 803.

In one possible embodiment, in response to detecting that the target character is input, the terminal displays at least one chart type in a chart type selection area of the online editing page.

The target character is a character set by a technician, such as a character "/" or a character "]", and this is not limited in the embodiment of the present application.

In the embodiment, the user can call the chart by directly inputting the target character, so that the efficiency is high.

In step S703, in response to a selection operation on a target chart type of the at least one chart type, the terminal displays a chart selection area corresponding to the target chart type in the online editing page, where at least one chart identifier is displayed in the chart selection area, and a type corresponding to the at least one chart identifier is the target chart type.

The type corresponding to the at least one chart identifier is the target chart type, which means that the type of the chart corresponding to the at least one chart identifier is the target chart type.

In one possible implementation mode, in response to that a target chart type in at least one chart type is selected, the terminal displays a chart selection area corresponding to the target chart type in the online editing page, and a plurality of charts in the target chart type are displayed in the chart selection area. The user can select a chart desired to be viewed in the chart selection area. In some embodiments, when the terminal displays at least one chart identifier in the target type on the chart selection area, the terminal can display the chart identifier in a form of a chart thumbnail, that is, the terminal displays thumbnails of a plurality of charts in the target type on the chart selection area, and the thumbnail displays the corresponding chart identifier, so that a user can know the content of the chart in advance, and the user can conveniently select the chart.

For example, referring to fig. 9, in response to the selection of the target chart type, the terminal displays a chart selection area 902 on the online edit page 901, and at least one chart identifier under the target chart type is displayed on the chart selection area 902.

In step S704, in response to receiving a selection operation on a first chart identifier of the at least one chart identifier, the terminal sends a first chart acquisition request to the server, where the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used for performing a query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier.

In one possible implementation, in response to receiving a selection operation of a first chart identifier of the at least one chart identifier, the terminal sends a first chart acquisition request to the server. The server acquires a first chart acquisition request, wherein the first chart acquisition request carries a first chart identifier. In response to the first chart acquisition request, the server queries based on the first chart identifier to obtain a first chart corresponding to the first chart identifier. The server sends the first chart to a sending end of the first chart acquisition request, namely the terminal.

In step S705, the terminal receives the first graph sent by the server, and displays the first graph in the online editing page, where the first graph includes a third field in the online form and a sub-entry corresponding to the third field.

For example, referring to fig. 9, in response to the first chart 903 being selected, the terminal displays the first chart 903 on the online edit page 901.

In step S705, the terminal displays at least one chart type option in the online editing page, and in response to receiving a selection operation on any one of the at least one chart type option, the terminal performs type conversion on the first chart based on the chart type indicated by the chart type option to obtain a second chart, where the second chart and the first chart have the same chart content.

The chart type options correspond to different chart types, and a user can adjust the chart type of the currently displayed chart by clicking the chart type options. For example, if the type of the currently displayed chart is a line chart, if the user clicks a chart type option corresponding to the bar chart, the terminal can display the bar chart, and the content of the bar chart is the same as that of the line chart, but the chart type is adjusted. The second chart and the first chart have the same chart content, that is, the second chart and the first chart are generated based on the third target field in the online table and the sub-table entry corresponding to the third target field.

In one possible implementation, referring to fig. 10, the terminal displays at least one chart type option on the online editing page 1001, each chart type option corresponding to one chart type, which in some embodiments is a chart type control. And responding to the fact that any chart type option is selected, namely the chart type option is clicked, the terminal sends a chart type switching request to the server, and the chart type switching request carries the identification of the first chart and the selected chart type option. After the server acquires the chart type switching request, the identifier of the first chart and the selected chart type option are acquired from the chart type switching request. The server adjusts the type information of the first chart based on the chart type indicated by the chart type option to obtain a second chart, wherein the chart type of the second chart is also the chart type indicated by the chart type option. And the server sends the second chart to the terminal, and the terminal switches the first chart into the second chart for displaying.

In step S706, the terminal displays the second chart in the online editing page.

Through the steps S701-S706, the user can generate the form to be checked through the online editing page of the online form, and the data in the online form does not need to be downloaded to the terminal and then screened, so that the efficiency of data processing is improved.

In addition to the above steps S301 to S308 and steps S701 to S706, the embodiment of the present application further provides a data processing method, and referring to fig. 11, the method includes:

in step S1101, the terminal displays an online edit page of an online form, the online form including at least one field and a plurality of entries, one entry including at least one sub-entry, one sub-entry corresponding to one field.

In step S1102, in response to a trigger operation to the form call option in the online editing page, the terminal displays at least one field of the online form in a second area of the online editing page.

In a possible implementation manner, a form calling option is displayed in the online editing page, in response to a click operation on the form calling option, the terminal sorts at least one field of the online form according to a target sequence, and displays the sorted at least one field in a second area of the online editing page.

The terminal sorts at least one field according to the target sequence, namely, the terminal sorts the first character of at least one field in the arrangement sequence of the alphabet. At least one field is ordered. Or, the target sequence is the sequence of field lengths from short to long or from long to short, and the terminal sorts at least one field according to the target sequence, that is, the terminal sorts at least one field according to the sequence of fields from short to long or from long to short.

For example, the form call option is a form call control, which is displayed in the online editing page. And responding to the clicking operation on the form calling control, sequencing at least one field of the online form according to the target sequence by the terminal, and displaying the sequenced at least one field in a second area of the online editing page. In some embodiments, a second region of the online editing page is located on a left side of the online editing page, and at least one field displayed in the second region is arranged vertically in the target arrangement order. For example, referring to fig. 12, a form call control 1202 is displayed on the online editing page 1201, and in response to a click operation on the form call control 1202, the terminal displays at least one field in the second area 1203 of the online editing page 1201, and the user selects at least one field that can be displayed to determine a field that is desired to be called.

In a possible embodiment, in addition to controlling the terminal to display at least one field in the second area by clicking on the form calling option, the user can also control the terminal to display at least one field in the second area by pressing a second target key or a second target key combination. For example, when the terminal displays the online editing page, the user presses the "-" key on the keyboard, and the terminal can be controlled to display at least one field in the second area, that is, in response to detecting that the "-" key is pressed, the terminal displays at least one field in the second area of the online editing page. Or when the terminal displays the online editing page, the user simultaneously presses a Ctrl key and a-' key on the keyboard, so that the terminal can be controlled to display at least one field in the second area. In some embodiments, the terminal can display a second target key or a second target key combination below the form calling option, in such a way as to be able to play a role in reminding the user that the user pressing the second target key or the second target key combination has the same role as clicking the form calling option.

In one possible implementation, the terminal can classify at least one field of the online form, for example, the fields of the field "job number", the field "name", the field "birthday", and the like, into a broad category of "employee information". When the terminal displays at least one field in the second area, the terminal can display a plurality of large classes of the at least one field first, and in response to any one of the large classes being selected, the terminal displays at least one field under the large class.

In step S1103, in response to receiving a selection operation on a fourth field of the at least one field, the terminal displays a target table in the online editing page, where the target table includes the fourth field and a sub-table entry corresponding to the fourth field.

The fourth target field may be one field or a plurality of fields, which is not limited in this embodiment of the application.

In one possible implementation, a field confirmation control is displayed in the online editing page, and in response to a fourth target field of the at least one field displayed in the second area being selected and the field confirmation control being clicked, the terminal displays the target form in the online editing page.

For example, in response to the field confirmation control being clicked, the terminal sends a form acquisition request to the server, where the form acquisition request carries the selected fourth target field. And after receiving the form acquisition request, the server acquires a fourth target field from the form acquisition request and generates a target form based on the fourth target field. And the server sends the target form to the terminal, and the terminal displays the target form in an online editing page.

In some embodiments, the terminal displays a field search box on the second area, the field search box being used to quickly find a field desired by the user from at least one field displayed on the second area. The user inputs a complete field or a partial character of the field in the field search box, the terminal can display the corresponding field on the second area, and the user can drag the field to one of the row field selection sub-area, the column field selection sub-area or the value field selection sub-area. In such a way, the efficiency of searching fields by the user is improved. For example, referring to fig. 13, a field search box 1302 is displayed on the second area of the online editing page 1301, and the user can perform field search through the field search box 1302.

In step S1104, in response to receiving a content adjustment operation on any first sub-entry displayed in the target table, the terminal updates the first sub-entry based on a second sub-entry corresponding to the content adjustment operation.

In one possible implementation manner, in response to clicking operation on any first sub-table item displayed in the target table, the terminal highlights the first sub-table item to indicate that the first sub-table item is selected and the sub-table item is in an editable state. In response to adjusting the first sub-entry to a second sub-entry, the terminal displays the second sub-entry. That is, the user can edit the contents displayed in the online form in real time. The highlighting refers to that the terminal adjusts the color of the first sub-entry to be the target color, or adjusts the background color of the first sub-entry to be the target color, which is not limited in this embodiment of the application. The target color is set by the user, for example, set to red or yellow.

Through the steps S1101-S1104, the user can generate the chart to be viewed through the online editing page of the online form, and the data screening and chart drawing are not required to be performed after the data in the online form is downloaded to the terminal, so that the data processing efficiency is improved.

FIG. 14 is a block diagram illustrating a data processing apparatus according to an example embodiment. Referring to fig. 14, the apparatus includes: an online editing page display unit 1401, a field display unit 1402, a data perspective request transmission unit 1403, and a first data perspective table display unit 1404.

An online editing page display unit 1401 configured to execute an online editing page displaying an online form, the online form including at least one field and at least one entry, one of the entries including at least one sub-entry, one of the sub-entries corresponding to one of the fields.

A field display unit 1402 configured to perform displaying at least one field of the online form in a first area of the online editing page in response to receiving a trigger operation for a data perspective option in the online editing page.

A data perspective request sending unit 1403, configured to execute, in response to receiving a selection operation on a first field in the at least one field, sending a data perspective request to the server, where the data perspective request carries the first field, and the data perspective request is used to perform data processing based on a sub-table entry corresponding to the first field, so as to obtain a first pivot table.

A first pivot table display unit 1404 configured to perform acquiring the first pivot table generated by the server, and displaying the first pivot table in the online editing page.

In a possible implementation manner, a row field selection sub-region, a column field selection sub-region, and a value field selection sub-region of a pivot table are also displayed on the first region, where the first field includes a row field, a column field, and a value field, the data pivot request sending unit 1403 is configured to perform sending the data pivot request to the server in response to the row field being dragged to the row field selection sub-region, the column field being dragged to the column field selection sub-region, and the value field being dragged to the value field selection sub-region, where the data pivot request carries the row field, the column field, and the value field of the first field.

In one possible embodiment, the apparatus further comprises:

and the second pivot table display unit is configured to execute the second field corresponding to the update operation determined in response to receiving the update operation of the first pivot table. And sending an update request for the first pivot table to the server, wherein the update request carries the second field, and the update request is used for updating the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table. And acquiring the second pivot table generated by the server, and displaying the second pivot table in the online editing page.

In one possible embodiment, the apparatus further comprises:

the first pivot table display unit 1404 is further configured to perform sending, in response to receiving the confirmation operation for the first pivot table, a table storage request to the server, the table storage request carrying an identification of the first pivot table, the table storage request being used to store the first pivot table in the online table. An identification of the first pivot table is displayed in the online form.

In one possible embodiment, the apparatus further comprises:

and the first chart display unit is configured to execute the operation of responding to the received chart call in the online editing page, and at least one chart identifier is displayed in the chart type selection area of the online editing page. And sending a first chart acquisition request to the server in response to receiving a selection operation on a first chart identifier in the at least one chart identifier, wherein the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used for querying based on the first chart identifier to obtain a first chart corresponding to the first chart identifier. And receiving the first chart sent by the server, and displaying the first chart in the online editing page, wherein the first chart comprises a third field in the online form and a sub-table item corresponding to the third field.

In one possible embodiment, the first chart displaying unit is configured to perform a chart calling operation in response to receiving a chart in the online editing page, and a chart type selecting area in which at least one chart type is displayed in the online editing page. And responding to the selection operation of a target chart type in the at least one chart type, and displaying a chart selection area corresponding to the target chart type in the online editing page, wherein at least one chart identifier is displayed in the chart selection area, and the type corresponding to the at least one chart identifier is the target chart type.

In one possible embodiment, the apparatus further comprises:

and the second chart display unit is configured to execute type conversion on the first chart based on the chart type indicated by the chart type option to obtain a second chart, and the second chart and the first chart have the same chart content in response to receiving selection operation on any one of the at least one chart type option. Displaying the second chart in the online editing page.

In one possible embodiment, the apparatus further comprises:

and the target form display unit is configured to execute the triggering operation responding to the received form calling option in the online editing page, and at least one field of the online form is displayed in the second area of the online editing page. In response to receiving a selection operation on a fourth field of the at least one field, a target table is displayed in the online editing page, wherein the target table comprises the fourth field and a sub-table item corresponding to the fourth field.

In one possible embodiment, the apparatus further comprises:

and the sub-table item updating unit is configured to execute updating of any first sub-table item displayed in the target table based on a second sub-table item corresponding to the content adjusting operation in response to receiving the content adjusting operation.

In one possible embodiment, the apparatus further comprises:

and a table name updating unit configured to execute displaying a table name input box of the first pivot table in the online editing page in response to receiving a table name adjustment operation for the first pivot table. And updating the table name of the first pivot table by using the table name input in the table name input box.

In one possible embodiment, the apparatus further comprises:

and the display sequence adjusting unit is configured to execute the sequence adjustment operation of the sub-table items displayed in the first pivot table, and adjust the display sequence of the sub-table items displayed in the first pivot table to obtain a third pivot table.

In one possible embodiment, the apparatus further comprises:

With regard to the apparatus in the above-described embodiment, the specific manner in which each unit performs the operation has been described in detail in the embodiment related to the method, and will not be described in detail here.

FIG. 15 is a block diagram illustrating a data processing apparatus according to an example embodiment. Referring to fig. 15, the apparatus includes: a data perspective request acquisition unit 1501, a first data perspective table generation unit 1502, and a first data perspective table transmission unit 1503.

A data perspective request obtaining unit 1501 configured to execute a data perspective request, where the data perspective request carries a first field, the first field is a selected field in an online table, the online table includes at least one field and at least one entry, one entry includes at least one sub-entry, one sub-entry corresponds to one field, and the data perspective request is sent in response to receiving a trigger operation on a data perspective option in an online editing page of the online table.

The first pivot table generating unit 1502 is configured to perform data processing based on the sub-table entry corresponding to the first field, so as to obtain a first pivot table.

A first pivot table sending unit 1503 configured to execute sending of the first pivot table to the sender of the pivot request, so that the sender of the pivot request displays the first pivot table in the online editing page.

In a possible implementation manner, the first field includes a row field, a column field, and a value field, and the first pivot table generation unit 1502 is configured to perform data processing based on the row field, the column field, and the value field of the first field, so as to obtain the first pivot table.

In one possible embodiment, the apparatus further comprises:

and the second pivot table generation unit is configured to execute acquisition of an update request for the first pivot table, wherein the update request carries a second field, and the second field is a field corresponding to an update operation for the first pivot table. And responding to the updating request, updating the first pivot table based on the sub-table entry corresponding to the second field, and obtaining a second pivot table.

In one possible embodiment, the apparatus further comprises:

the second pivot table generation unit is configured to execute a table storage request carrying the identifier of the first pivot table. In response to the table storage request, the first pivot table is stored in the online table. An identification of the first pivot table is generated in the online form.

In one possible embodiment, the apparatus further comprises:

the first chart sending unit is configured to execute a first chart obtaining request, wherein the first chart obtaining request carries a first chart identifier, and the first chart identifier is a selected chart identifier in at least one chart identifier displayed in a chart type selection area of the online editing page. And responding to the first chart acquisition request, and inquiring based on the first chart identification to obtain a first chart corresponding to the first chart identification. And sending the first chart to a sending end of the first chart acquisition request.

In this embodiment, the electronic device may be implemented as a terminal or a server, and first, a structure of the terminal is described:

fig. 16 is a block diagram illustrating a terminal, which terminal 1600 may be a terminal used by a user, according to an example embodiment. The terminal 1600 may be: at least one of a smartphone, a smartwatch, a desktop computer, a laptop portable computer, and the like. Terminal 1600 may also be referred to by other names such as user equipment, portable terminal, laptop terminal, desktop terminal, etc.

Generally, terminal 1600 includes: a processor 1601, and a memory 1602.

Processor 1601 may include one or more processing cores, such as a 4-core processor, an 8-core processor, and so on. The processor 1601 may be implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). Processor 1601 may also include a main processor and a coprocessor, where the main processor is a processor for Processing data in an awake state, and is also referred to as a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 1601 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content that the display screen needs to display. In some embodiments, the processor 1601 may further include an AI (Artificial Intelligence) processor for processing computing operations related to machine learning.

Memory 1602 may include one or more storage media, which may be non-transitory. The memory 1602 may also include high-speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices.

In some embodiments, the terminal 1600 may also optionally include: peripheral interface 1603 and at least one peripheral. Processor 1601, memory 1602 and peripheral interface 1603 may be connected by buses or signal lines. Various peripheral devices may be connected to peripheral interface 1603 via buses, signal lines, or circuit boards. Specifically, the peripheral device includes: at least one of a radio frequency circuit 1604, a display 1605, a camera assembly 1606, audio circuitry 1607, a positioning assembly 1608, and a power supply 16013.

Peripheral interface 1603 can be used to connect at least one I/O (Input/Output) related peripheral to processor 1601 and memory 1602. In some embodiments, processor 1601, memory 1602, and peripheral interface 1603 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 1601, the memory 1602 and the peripheral device interface 1603 may be implemented on a separate chip or circuit board, which is not limited by this embodiment.

The Radio Frequency circuit 1604 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 1604 communicates with communication networks and other communication devices via electromagnetic signals. The rf circuit 1604 converts the electrical signal into an electromagnetic signal to be transmitted, or converts a received electromagnetic signal into an electrical signal. Optionally, the rf circuit 1604 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. The radio frequency circuit 1604 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: metropolitan area networks, various generation mobile communication networks (2G, 3G, 4G, and 5G), Wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the rf circuit 1604 may also include NFC (Near Field Communication) related circuits, which are not limited in this application.

The display 1605 is used to display a UI (User Interface). The UI may include images, text, icons, videos, and any combination thereof. When the display screen 1605 is a touch display screen, the display screen 1605 also has the ability to capture touch signals on or over the surface of the display screen 1605. The touch signal may be input to the processor 1601 as a control signal for processing. At this point, the display 1605 may also be used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the display 1605 may be one, providing the front panel of the terminal 1600; in other embodiments, the display screens 1605 can be at least two, respectively disposed on different surfaces of the terminal 1600 or in a folded design; in still other embodiments, display 1605 can be a flexible display disposed on a curved surface or a folded surface of terminal 1600. Even further, the display 1605 may be configured as a non-rectangular irregular image, i.e., a shaped screen. The Display 1605 may be made of LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), or other materials.

The camera assembly 1606 is used to capture images or video. Optionally, camera assembly 1606 includes a front camera and a rear camera. Generally, a front camera is disposed at a front panel of the terminal, and a rear camera is disposed at a rear surface of the terminal. In some embodiments, the number of the rear cameras is at least two, and each rear camera is any one of a main camera, a depth-of-field camera, a wide-angle camera and a telephoto camera, so that the main camera and the depth-of-field camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize panoramic shooting and VR (Virtual Reality) shooting functions or other fusion shooting functions. In some embodiments, camera assembly 1606 can also include a flash. The flash lamp can be a monochrome temperature flash lamp or a bicolor temperature flash lamp. The double-color-temperature flash lamp is a combination of a warm-light flash lamp and a cold-light flash lamp, and can be used for light compensation at different color temperatures.

The audio circuitry 1607 may include a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals to the processor 1601 for processing or inputting the electric signals to the radio frequency circuit 1604 to achieve voice communication. For stereo sound acquisition or noise reduction purposes, the microphones may be multiple and disposed at different locations of terminal 1600. The microphone may also be an array microphone or an omni-directional pick-up microphone. The speaker is used to convert electrical signals from the processor 1601 or the radio frequency circuit 1604 into sound waves. The loudspeaker can be a traditional film loudspeaker or a piezoelectric ceramic loudspeaker. When the speaker is a piezoelectric ceramic speaker, the speaker can be used for purposes such as converting an electric signal into a sound wave audible to a human being, or converting an electric signal into a sound wave inaudible to a human being to measure a distance. In some embodiments, the audio circuit 1607 may also include a headphone jack.

The positioning component 1608 is configured to locate a current geographic Location of the terminal 1600 for purposes of navigation or LBS (Location Based Service). The Positioning component 1608 may be a Positioning component based on the united states GPS (Global Positioning System), the chinese beidou System, the russian graves System, or the european union galileo System.

Power supply 1609 is used to provide power to the various components of terminal 1600. Power supply 1609 may be alternating current, direct current, disposable or rechargeable. When power supply 1609 includes a rechargeable battery, the rechargeable battery may support wired or wireless charging. The rechargeable battery may also be used to support fast charge technology.

In some embodiments, terminal 1600 also includes one or more sensors 1610. The one or more sensors 1610 include, but are not limited to: acceleration sensor 1611, gyro sensor 1612, pressure sensor 1613, fingerprint sensor 1614, optical sensor 1615, and proximity sensor 1616.

Acceleration sensor 1611 may detect acceleration in three coordinate axes of a coordinate system established with terminal 1600. For example, the acceleration sensor 1611 may be used to detect components of the gravitational acceleration in three coordinate axes. The processor 1601 may control the display screen 1605 to display the user interface in a landscape view or a portrait view according to the gravitational acceleration signal collected by the acceleration sensor 1611. The acceleration sensor 1611 may also be used for acquisition of motion data of a game or a user.

Gyroscope sensor 1612 can detect the organism direction and the turned angle of terminal 1600, and gyroscope sensor 1612 can gather the 3D action of user to terminal 1600 with acceleration sensor 1611 in coordination. From the data collected by the gyro sensor 1612, the processor 1601 may perform the following functions: motion sensing (such as changing the UI according to a user's tilting operation), image stabilization at the time of photographing, game control, and inertial navigation.

Pressure sensors 1613 may be disposed on the side frames of terminal 1600 and/or underlying display 1605. When the pressure sensor 1613 is disposed on the side frame of the terminal 1600, a user's holding signal of the terminal 1600 can be detected, and the processor 1601 performs left-right hand recognition or shortcut operation according to the holding signal collected by the pressure sensor 1613. When the pressure sensor 1613 is disposed at the lower layer of the display 1605, the processor 1601 controls the operability control on the UI interface according to the pressure operation of the user on the display 1605. The operability control comprises at least one of a button control, a scroll bar control, an icon control and a menu control.

The fingerprint sensor 1614 is configured to collect a fingerprint of the user, and the processor 1601 is configured to identify the user based on the fingerprint collected by the fingerprint sensor 1614, or the fingerprint sensor 1614 is configured to identify the user based on the collected fingerprint. Upon recognizing that the user's identity is a trusted identity, the processor 1601 authorizes the user to perform relevant sensitive operations including unlocking a screen, viewing encrypted information, downloading software, paying for and changing settings, etc. The fingerprint sensor 1614 may be disposed on the front, back, or side of the terminal 1600. When a physical key or vendor Logo is provided on the terminal 1600, the fingerprint sensor 1614 may be integrated with the physical key or vendor Logo.

The optical sensor 1615 is used to collect ambient light intensity. In one embodiment, the processor 1601 may control the display brightness of the display screen 1605 based on the ambient light intensity collected by the optical sensor 1615. Specifically, when the ambient light intensity is high, the display luminance of the display screen 1605 is increased; when the ambient light intensity is low, the display brightness of the display screen 1605 is adjusted down. In another embodiment, the processor 1601 may also dynamically adjust the shooting parameters of the camera assembly 1606 based on the ambient light intensity collected by the optical sensor 1615.

A proximity sensor 1616, also referred to as a distance sensor, is typically disposed on the front panel of terminal 1600. The proximity sensor 1616 is used to collect the distance between the user and the front surface of the terminal 1600. In one embodiment, the processor 1601 controls the display 1605 to switch from the light screen state to the clear screen state when the proximity sensor 1616 detects that the distance between the user and the front surface of the terminal 1600 is gradually decreased; when the proximity sensor 1616 detects that the distance between the user and the front surface of the terminal 1600 is gradually increased, the display 1605 is controlled by the processor 1601 to switch from the breath-screen state to the bright-screen state.

Those skilled in the art will appreciate that the configuration shown in fig. 16 is not intended to be limiting of terminal 1600, and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components may be employed.

In this embodiment, the electronic device may be implemented as a server, and the following describes a structure of the server:

fig. 17 is a block diagram illustrating a server 1700, according to an example embodiment, where the server 1700 may have a large difference due to different configurations or performance, and may include one or more processors (CPUs) 1701 and one or more memories 1702. The memory 1702 stores therein at least one instruction that is loaded into and executed by the processor 1701 to implement the data processing method described above.

In an exemplary embodiment, there is also provided a storage medium comprising instructions, such as the memory 1702 comprising instructions, executable by the processor 1701 of the server 1700 to perform the data processing method described above. Alternatively, the storage medium may be a non-transitory storage medium, such as a ROM, a Random Access Memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.

In an exemplary embodiment, a computer program product is also provided, comprising a computer program executable by a processor of an electronic device to implement the above-mentioned data processing method.

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

It will be understood that the present application is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.

Claims

1. A data processing method, comprising:

2. The data processing method of claim 1, wherein a row field selection sub-area, a column field selection sub-area, and a value field selection sub-area of the pivot table are further displayed on the first area, wherein the first field comprises a row field, a column field, and a value field, and wherein sending the pivot request to the server in response to receiving a selection operation on a first field of the at least one field comprises:

3. The data processing method of claim 1, wherein after displaying the first pivot table in the online editing page, the method further comprises:

4. The data processing method of claim 1, wherein after displaying the first pivot table in the online editing page, the method further comprises:

displaying an identification of the first pivot table in the online table.

5. A data processing method, comprising:

6. A data processing apparatus, comprising:

7. A data processing apparatus, comprising:

8. An electronic device, comprising:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the data processing method of any one of claims 1 to 5.

9. A computer-readable storage medium whose instructions, when executed by a processor of an electronic device, enable the electronic device to perform the data processing method of any of claims 1 to 5.

10. A computer program product comprising a computer program, characterized in that the computer program realizes the data processing method of any of claims 1-5 when executed by a processor.