Data processing method, device, electronic device and storage medium

Abstract

The present application relates to a data processing method, device, electronic device and storage medium, and belongs to the field of computer technology. Through the technical solution provided by the embodiment of the present application, when a user wants to pivot the data in an online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

Description

Technical Field

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

[0002] With the development of Internet technology, more and more users manage data through online spreadsheets. In some cases, when users want to process the data in the online spreadsheet, for example, to perform data pivoting, the users cannot directly perform the operation in the online spreadsheet, but need to download the data in the online spreadsheet to the terminal, and the terminal performs data pivoting on the data in the online spreadsheet, which results in low efficiency of data pivoting. Summary of the invention

[0003] The present application provides a data processing method, device, electronic device and storage medium to improve the efficiency of data perspective. The technical solution of the present application is as follows:

[0004] In one aspect, a data processing method is provided, comprising:

[0005] Displaying an online editing page of an online form, wherein the online form includes at least one field and at least one table item, wherein one table item includes at least one sub-table item, and one sub-table item corresponds to one field;

[0006] In response to receiving a triggering operation on a pivot option in the online editing page, displaying at least one field of the online form in a first area of ​​the online editing page;

[0007] In response to receiving a selection operation on a first field of the at least one field, sending a data pivot request to a server, the data pivot request carrying the first field, the data pivot request being used to perform data processing based on a sub-table item corresponding to the first field to obtain a first data pivot table;

[0008] The first data pivot table generated by the server is obtained, and the first data pivot table is displayed in the online editing page.

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

[0010] In response to the row field being dragged to the row field selection sub-area, the column field being dragged to the column field selection sub-area, and the value field being dragged to the value field selection sub-area, the pivot request is sent to the server, and the pivot request carries the row field, column field, and value field of the first field.

[0011] In a possible implementation, after displaying the first data pivot table in the online editing page, the method further includes:

[0012] In response to receiving an update operation on the first pivot table, determining a second field corresponding to the update operation;

[0013] Sending an update request for the first pivot table to the server, the update request carrying the second field, the update request being used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table;

[0014] The second pivot table generated by the server is obtained, and the second pivot table is displayed in the online editing page.

[0015] In a possible implementation, after displaying the first pivot table in the online editing page, the method further includes:

[0016] In response to receiving a confirmation operation on the first pivot table, sending 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;

[0017] An identifier of the first pivot table is displayed in the online form.

[0018] In a possible implementation, the method further includes:

[0019] In response to receiving a chart calling operation in the online editing page, displaying at least one chart identifier in a chart type selection area of ​​the online editing page;

[0020] In response to receiving a selection operation on a first chart identifier among the at least one chart identifier, sending a first chart acquisition request to the server, wherein the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used to perform a query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier;

[0021] The first chart sent by the server is received, and the first chart is displayed in the online editing page, where the first chart includes a third field in the online form and a sub-table item corresponding to the third field.

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

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

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

[0025] In response to a selection operation of a target chart type among the at least one chart type, a chart selection area corresponding to the target chart type is displayed 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.

[0026] 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:

[0027] In response to receiving a selection operation of any one of the at least one chart type option, converting 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;

[0028] The second chart is displayed in the online editing page.

[0029] In a possible implementation, the method further includes:

[0030] 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;

[0031] 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, the target table including the fourth field and a sub-table item corresponding to the fourth field.

[0032] In a possible implementation, after displaying the target table in the online editing page, the method further includes:

[0033] In response to receiving a content adjustment operation on any first sub-item displayed in the target table, the first sub-item is updated based on a second sub-item corresponding to the content adjustment operation.

[0034] In a possible implementation, after displaying the first data pivot table in the online editing page, the method further includes:

[0035] In response to receiving a table name adjustment operation on the first pivot table, displaying a table name input box for the first pivot table in the online editing page;

[0036] The table name of the first pivot table is updated using the table name input in the table name input box.

[0037] In a possible implementation, after displaying the first data pivot table in the online editing page, the method further includes:

[0038] In response to the operation of adjusting the order of the sub-table items displayed in the first data pivot table, the display order of the sub-table items displayed in the first data pivot table is adjusted to obtain a third data pivot table.

[0039] In a possible implementation, after displaying the first data pivot table in the online editing page, the method further includes:

[0040] In response to the export operation on the first pivot table, a file corresponding to the first pivot table is obtained.

[0041] In one aspect, a data processing method is provided, comprising:

[0042] Obtaining a data pivot request, the data pivot request carrying a first field, the first field being a selected field in an online form, the online form comprising at least one field and at least one table item, one table item comprising at least one sub-table item, one sub-table item corresponding to one field, the data pivot request being sent in response to receiving a trigger operation for a data pivot option in an online editing page of the online form;

[0043] Perform data processing based on the sub-table item corresponding to the first field to obtain a first pivot table;

[0044] The first data pivot table is sent to a sending end of the data pivot request, so that the sending end of the data pivot request displays the first data pivot table in the online editing page.

[0045] In a possible implementation, the first field includes a row field, a column field, and a value field, and the performing data processing based on the sub-table item corresponding to the first field to obtain the first pivot table includes:

[0046] Data processing is performed based on the row field, column field and value field of the first field to obtain the first pivot table.

[0047] In a possible implementation manner, after performing data processing based on the sub-table item corresponding to the first field to obtain the first pivot table, the method further includes:

[0048] Acquire 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 the update operation on the first pivot table;

[0049] In response to the update request, the first pivot table is updated based on the sub-table item corresponding to the second field to obtain a second pivot table.

[0050] In a possible implementation manner, after performing data processing based on the sub-table item corresponding to the first field to obtain the first pivot table, the method further includes:

[0051] Obtaining a table storage request, where the table storage request carries an identifier of the first pivot table;

[0052] In response to the table storage request, storing the first pivot table in the online table;

[0053] An identifier of the first pivot table is generated in the online form.

[0054] In a possible implementation, the method further includes:

[0055] Obtaining a first chart acquisition request, the first chart acquisition request carrying a first chart identifier, the first chart identifier being a chart identifier selected from at least one chart identifier displayed in a chart type selection area of ​​the online editing page;

[0056] In response to the first chart acquisition request, query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier;

[0057] The first chart is sent to a sending end of the first chart acquisition request.

[0058] In one aspect, a data processing device is provided, comprising:

[0059] An online editing page display unit is configured to execute and display an online editing page of an online form, wherein the online form includes at least one field and at least one table item, wherein one table item includes at least one sub-table item, and one sub-table item corresponds to one field;

[0060] a field display unit configured to display at least one field of the online form in a first area of ​​the online editing page in response to receiving a trigger operation on a pivot option in the online editing page;

[0061] a data pivot request sending unit, configured to execute, in response to receiving a selection operation on a first field of the at least one field, sending a data pivot request to a server, the data pivot request carrying the first field, the data pivot request being used to perform data processing based on a sub-table item corresponding to the first field to obtain a first data pivot table;

[0062] The first pivot table display unit is configured to obtain the first pivot table generated by the server and display the first pivot table in the online editing page.

[0063] In a possible implementation, the first area also displays a row field selection subarea, a column field selection subarea, and a value field selection subarea of ​​the pivot table, the first field includes a row field, a column field, and a value field, and the pivot request sending unit is configured to execute, in response to the row field being dragged to the row field selection subarea, the column field being dragged to the column field selection subarea, and the value field being dragged to the value field selection subarea, sending the pivot request to the server, the pivot request carrying the row field, column field, and value field of the first field.

[0064] In a possible implementation, the device further includes:

[0065] The second pivot table display unit is configured to execute, in response to receiving an update operation on the first pivot table, determine a second field corresponding to the update operation; send an update request for the first pivot table to the server, the update request carries the second field, and the update request is used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table; obtain the second pivot table generated by the server, and display the second pivot table in the online editing page.

[0066] In a possible implementation, the device further includes:

[0067] The first pivot table display unit is further configured to execute, in response to receiving a confirmation operation on the first pivot table, sending 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; and displaying the identifier of the first pivot table in the online table.

[0068] In a possible implementation, the device further includes:

[0069] The first chart display unit is configured to execute, in response to receiving a chart call operation in the online editing page, display at least one chart identifier in the chart type selection area of ​​the online editing page; in response to receiving a selection operation on a first chart identifier among the at least one chart identifier, send a first chart acquisition request to the server, the first chart acquisition request carrying the first chart identifier, the first chart acquisition request being used to query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; receive the first chart sent by the server, and display the first chart in the online editing page, the first chart including a third field in the online form and a sub-table item corresponding to the third field.

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

[0071] In a possible implementation, the first chart display unit is configured to, in response to receiving a chart call operation in the online editing page, display a chart type selection area in the online editing page, wherein at least one chart type is displayed in the chart type selection area; in response to a selection operation of a target chart type among the at least one chart type, display 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.

[0072] In a possible implementation, the device further includes:

[0073] The second chart display unit is configured to execute, in response to receiving a selection operation of any chart type option among the at least one chart type option, convert the type of 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; and display the second chart in the online editing page.

[0074] In a possible implementation, the device further includes:

[0075] The target table display unit is configured to, in response to receiving a trigger operation for a table call option in the online editing page, display at least one field of the online table in the second area of ​​the online editing page; in response to receiving a selection operation for a fourth field among the at least one field, display a target table in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field.

[0076] In a possible implementation, the device further includes:

[0077] The sub-table item updating unit is configured to execute, in response to receiving a content adjustment operation on any first sub-table item displayed in the target table, updating the first sub-table item based on a second sub-table item corresponding to the content adjustment operation.

[0078] In a possible implementation, the device further includes:

[0079] The table name updating unit is configured to execute, in response to receiving a table name adjustment operation on the first pivot table, display a table name input box of the first pivot table in the online editing page; and update the table name of the first pivot table using the table name input in the table name input box.

[0080] In a possible implementation, the device further includes:

[0081] The display order adjustment unit is configured to execute, in response to the order adjustment operation on the sub-table items displayed in the first data pivot table, adjust the display order of the sub-table items displayed in the first data pivot table to obtain a third data pivot table.

[0082] In a possible implementation, the device further includes:

[0083] The file exporting unit is configured to execute an export operation on the first pivot table and obtain a file corresponding to the first pivot table in response to the export operation on the first pivot table.

[0084] In one aspect, a data processing device is provided, comprising:

[0085] a data pivot request acquisition unit, configured to execute and acquire a data pivot request, wherein the data pivot request carries a first field, the first field is a field selected in an online form, the online form includes at least one field and at least one table item, one of the table items includes at least one sub-table item, one of the sub-table items corresponds to one of the fields, and the data pivot request is sent in response to receiving a trigger operation for a data pivot option in an online editing page of the online form;

[0086] A first data pivot table generating unit is configured to perform data processing based on the sub-table item corresponding to the first field to obtain a first data pivot table;

[0087] The first pivot table sending unit is configured to send the first pivot table to the sending end of the pivot table request, so that the sending end of the pivot table request displays the first pivot table in the online editing page.

[0088] In a possible implementation, the first field includes a row field, a column field, and a value field, and the first pivot table generating unit is configured to perform data processing based on the row field, the column field, and the value field of the first field to obtain the first pivot table.

[0089] In a possible implementation, the device further includes:

[0090] The second pivot table generating unit is configured to execute and obtain 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; in response to the update request, based on the sub-table item corresponding to the second field, the first pivot table is updated to obtain a second pivot table.

[0091] In a possible implementation, the device further includes:

[0092] The second pivot table generating unit is configured to execute obtaining a table storage request, the table storage request carrying an identifier of the first pivot table; in response to the table storage request, storing the first pivot table in the online table; and generating the identifier of the first pivot table in the online table.

[0093] In a possible implementation, the device further includes:

[0094] The first chart sending unit is configured to execute a first chart acquisition request, wherein the first chart acquisition request carries a first chart identifier, and the first chart identifier is a chart identifier selected from at least one chart identifier displayed in the chart type selection area of ​​the online editing page; in response to the first chart acquisition request, query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; and send the first chart to a sending end of the first chart acquisition request.

[0095] In one aspect, an electronic device is provided, comprising:

[0096] processor;

[0097] a memory for storing instructions executable by the processor;

[0098] The processor is configured to execute the instructions to implement the above data processing method.

[0099] On the one hand, a computer-readable storage medium is provided. When instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device can perform the above-mentioned data processing method.

[0100] In one aspect, a computer program product is provided, comprising a computer program, wherein the computer program implements the above data processing method when executed by a processor.

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

[0102] Through the technical solution provided by the embodiment of the present application, when the user wants to pivot the data in the online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

[0103] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0105] Figure 1 It is a schematic diagram of an implementation environment of a data processing method according to an exemplary embodiment.

[0106] Figure 2 The invention is a flowchart of a data processing method according to an exemplary embodiment.

[0107] Figure 3 The invention is a flowchart of a data processing method according to an exemplary embodiment.

[0108] Figure 4 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0109] Figure 5 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0110] Figure 6 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0111] Figure 7 The invention is a flowchart of a data processing method according to an exemplary embodiment.

[0112] Figure 8 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0113] Fig. 9 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0114] Fig.10 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0115] Fig.11 The invention is a flowchart of a data processing method according to an exemplary embodiment.

[0116] Fig.12 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0117] Fig.13 The diagram is a schematic diagram of a page according to an exemplary embodiment.

[0118] Fig.14 It is a block diagram of a data processing device according to an exemplary embodiment.

[0119] Fig.15 It is a block diagram of a data processing device according to an exemplary embodiment.

[0120] Fig.16 It is a block diagram of a terminal according to an exemplary embodiment.

[0121] Fig.17 It is a block diagram of a server according to an exemplary embodiment. DETAILED DESCRIPTION

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

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

[0124] The data involved in this application may be data authorized by the user or fully authorized by all parties.

[0125] The following is an introduction to the nouns involved in this application:

[0126] Pivot Table: A Pivot Table is an interactive table that can perform certain calculations, such as sums and counts. The calculations performed are related to the arrangement of the data in the Pivot Table.

[0127] Online documents are documents that can be edited online, collaborated on by multiple users, and saved in real time in the cloud. They are displayed through Hypertext Markup Language (HTML) pages and rely on communication between the client and the server to synchronize user edits. The types of online documents can be online Word documents, online Excel documents, online PPT documents, and online drawing documents.

[0128] In response, it is used to indicate the conditions or states on which the executed operations depend. When the dependent conditions or states are met, one or more operations executed can be in real time or have a set delay. Unless otherwise specified, there is no restriction on the order of execution of the multiple operations executed.

[0129] Optionally, the electronic device provided in the embodiment of the present application is implemented as a terminal or a server. The implementation environment composed of the terminal and the server is introduced below.

[0130] Figure 1is a schematic diagram of an implementation environment of a data processing method provided in an embodiment of the present application, see Figure 1 , the implementation environment may include a terminal 101 and a server 102.

[0131] The terminal 101 may be at least one of a smart phone, a smart watch, a desktop computer, a laptop computer, etc. An application supporting browsing online forms may be installed and run on the terminal 101, and the user may process the data in the online form through the application.

[0132] The terminal 101 may generally refer to one of a plurality of terminals, and this embodiment is only illustrated by the terminal 101. Those skilled in the art will appreciate that the number of the above terminals may be more or less. For example, the above terminals 101 may be only a few, or the above terminals 101 may be dozens or hundreds, or more. The embodiment of the present application does not limit the number and device type of the terminal 101. The terminal 101 may be connected to the server 102 via a wireless network or a wired network.

[0133] The server 102 may be at least one of a single server, multiple servers, a cloud computing platform, and a virtualization center. The server 102 maintains a database corresponding to the server 102, and the database stores relevant data of the online form.

[0134] Optionally, the number of the above servers 102 may be more or less, which is not limited in the embodiment of the present application. Of course, the server 102 may also include other functional servers to provide more comprehensive and diversified services.

[0135] After introducing the implementation environment of the embodiment of the present application, the application scenario of the present application will be described below in combination with the above implementation environment. It should be noted that in the following description, the terminal is the terminal 101 in the above implementation environment, and the server is the server 102 in the above implementation environment.

[0136] The data processing method provided in the embodiment of the present application can be applied in any data statistics scenario, such as in the scenario of processing sales data, in the scenario of processing performance-based salary data, and in the scenario of processing multiple sports data.

[0137] In the scenario of processing sales data, the user can view the online table through the terminal. Multiple items are displayed in the online table, and one item is a piece of sales data. In some embodiments, a piece of sales data includes sales time, sales object, salesperson, sales amount, etc. When browsing the online table, the user may need to process the sales data in the online table, such as counting the total sales volume in a certain time period. In this case, the user can control the server to execute the data processing method provided in the embodiment of the present application through the terminal, and process the data in the online table into a pivot table, which can also show the total sales volume in a certain time period. The user can quickly know the total sales volume in a certain time period by viewing the pivot table, which is more efficient.

[0138] In the scenario of processing performance wage data, the user can view the online form through the terminal, and multiple table items are displayed in the online form, and one table item is a performance wage data. In some embodiments, a performance wage data includes the salary payment object, the performance acquisition time, the performance type, the performance amount, etc. When browsing the online form, the user may need to process the performance wage data in the online form, such as counting the total performance wage of an employee last month. In this case, the user can control the server to execute the data processing method provided in the embodiment of the present application through the terminal, and process the data in the online form into a pivot table, which can also show the total performance wage of an employee last month. The user can quickly know the total performance wage of an employee last month by viewing the pivot table, which is more efficient.

[0139] In the scenario of processing multiple sports data, the user can view the online table through the terminal, and multiple items are displayed in the online table, and one item is also a sports data. In some embodiments, a sports data includes the name of the athlete, sports performance, ranking, and the score obtained. When browsing the online table, the user may need to process the sports data in the online table, such as counting the total score of a certain athlete. 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, and process the data in the online table into a pivot table, which can also show the total score of a certain athlete. The user can quickly know the total score of a certain athlete by viewing the pivot table, which is more efficient.

[0140] Figure 2 is a flow chart of a data processing method according to an exemplary embodiment, the method is executed by an electronic device, such as Figure 2 As shown, the following steps are included.

[0141] In step S201, an online editing page of an online form is displayed. The online form includes at least one field and at least one table item. One table item includes at least one sub-table item, and one sub-table item corresponds to one field.

[0142] Among them, the online form is a form in which the user wants to process data, the online editing page is a page for editing the online form, the table item is a row of data in the table, the sub-table item is a single data in a row of data, and the field is used to indicate the type of the corresponding sub-table item, for example, the name is also a field.

[0143] In step S202, in response to receiving a triggering operation on a pivot 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.

[0144] The pivot option is an option for triggering the pivot function. When the pivot option is triggered, the electronic device can also execute the pivot function.

[0145] In step S203, in response to receiving a selection operation on a first field of the at least one field, a pivot table request is sent to the server, the pivot table request carries the first field, and the pivot table request is used to process data based on the sub-table item corresponding to the first field to obtain a first pivot table.

[0146] In step S204, the first pivot table generated by the server is obtained, and the first pivot table is displayed in the online editing page.

[0147] Through the technical solution provided by the embodiment of the present application, when the user wants to pivot the data in the online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

[0148] The above steps S201-S204 are a brief introduction of the present application. The following will combine some examples to more clearly illustrate the data processing method provided by the present application. The method is executed by an electronic device, and the electronic device is taken as a terminal as an example. Figure 3 , methods include:

[0149] In step S301, the terminal displays an online editing page of an online form, where the online form includes at least one field and at least one table item, where one table item includes at least one sub-table item, and one sub-table item corresponds to one field.

[0150] The online table is an online table selected by the user, and the table item is a row of data in the online table.

[0151] In a possible implementation, the terminal displays a content loading page of an online document, and a plurality of online forms are displayed in the content loading page. In response to a selection operation on any one of the plurality of online forms, the terminal displays an online editing page of the online form. The user can adjust the fields and items 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" through the online editing page. For the sub-item "Zhang San" corresponding to the field "name", the user can also modify the sub-item to "Li Si" or "Wang Wu" through the online editing page. In some embodiments, the content loading page of the online document is a page displayed by the application of the online document after the account is logged in, or is a display web page corresponding to the online document, which is not limited in the embodiments of the present application.

[0152] In some embodiments, in addition to being able to display multiple online forms, the content loading page of the online document can also display multiple online copywriting, or display a blank page, and the user can add data on the blank page by himself, which is not limited in the embodiments of the present application. In some embodiments, in order to facilitate distinction, different online forms can be stored in different folders, and the content loading page of the online document can provide the user with a function of creating a folder, and the user can use this function to create a folder. Of course, after creating the folder, the user can also drag and drop different online forms into different folders to achieve separate management of different online forms.

[0153] See also Figure 4 The terminal displays a content loading page 401 of the online document. The content loading page 401 displays multiple online form identifiers. In some embodiments, the identifier is the name of the online form. In response to a click operation on any of the multiple online form identifiers, the terminal displays an online editing page 402 of the online form corresponding to the identifier. The online editing page displays at least one field and multiple table items of the online form. Figure 4In the example, sub-item A-sub-item D constitute one item, and sub-item E-sub-item H constitute another item. In some embodiments, an edit control 403 is displayed on the online editing page 402. In response to a click operation on the edit control 403, the online editing page 402 becomes editable, and the user can adjust the fields or items displayed in the online editing page. By setting the edit control, it is possible to avoid the user from accidentally editing the online form, that is, when there is no need to edit the online form, the user can view the content of the online form through the online editing page; when there is a need to edit the online form, the user can trigger the function of editing the online form by clicking the edit control 403, thereby editing the online form.

[0154] It should be noted that in the above and subsequent descriptions, the click operation has different meanings for different types of terminals. For smart phones and tablet computers, the click operation is a click operation on the screen; for desktop computers and laptops, the click operation is a click operation to control the mouse pointer to a specific position. Of course, for some desktop computers and laptops with screen touch functions, the click operation can also be a click operation on the screen, and the embodiments of the present application are not limited to this.

[0155] In this implementation, the user can quickly select the online form to be viewed through the content loading page of the online document. When there is a need to edit the online form, the online form can also be edited through the online editing page of the online form, which is more efficient.

[0156] Taking the content loading page of an online document as the page displayed by the application of the online document after the account is logged in as an example, in response to the application startup instruction of the online document, the terminal displays the login interface of the online document, and the login interface includes an account input area, a password input area and a login control. In response to the click operation on the login control, the terminal sends a login request to the server, and the login request carries the account input in the account input area and the password input in the password input area. After receiving the login request, the server obtains the account and password from the login request and verifies the account and password. In response to the successful verification of the account and password, the server sends a successful verification message to the terminal, and the successful verification message carries the identifiers and addresses of multiple online forms corresponding to the account, wherein the multiple forms are online forms created by the account, or online forms shared by other accounts and the account, and the embodiment of the present application does not limit this. After receiving the successful verification message, the terminal obtains the identifiers and addresses of multiple online forms from the successful verification message, and displays the identifiers of multiple online documents in the content loading page, and each identifier is bound to a corresponding address. In response to the click operation on any identifier, the terminal obtains the corresponding online form based on the address corresponding to the identifier, and displays the online editing page of the online form.

[0157] In step S302, in response to receiving a triggering operation on a pivot 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.

[0158] In a possible implementation, a pivot option is displayed in the online editing page. In response to a click operation on the pivot option, the terminal sorts at least one field of the online form according to a target order and displays the sorted at least one field in the first area of ​​the online editing page.

[0159] Wherein, the target order is the order of arrangement of letters in the alphabetical list, and the terminal sorts at least one field according to the target order, that is, the terminal sorts at least one field according to the order of arrangement of the first letters of at least one field in the alphabetical list. Alternatively, the target order is the order of field length from short to long or from long to short, and the terminal sorts at least one field according to the target order, that is, the terminal sorts at least one field according to the order of field length from short to long or from long to short.

[0160] In this implementation, the terminal can sort the fields in the online table according to the target order to achieve the purpose of data sorting and facilitate user viewing.

[0161] For example, the pivot option is a pivot control, and the pivot control is displayed in the online editing page. In response to a click operation on the pivot control, the terminal sorts at least one field of the online table according to a target order, and displays the sorted at least one field in the first area of ​​the online editing page. In some embodiments, the first area of ​​the online editing page is located on the left side of the online editing page, and the at least one field displayed in the first area is arranged vertically according to the target arrangement order. For example, see Figure 5 A pivot control 502 is displayed on the online editing page 501. In response to a click operation on the pivot control 502, the terminal displays at least one field in the first area 503 of the online editing page 501. The user can select from the at least one displayed field to determine the field on which the pivot is desired to be performed.

[0162] In a possible implementation, in addition to controlling the terminal to display at least one field in the first area by clicking on the pivot 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 the 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 an 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 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 presses the "Ctrl" key and the "\" key on the keyboard at the same time, and 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 pivot option, which can play a role in reminding the user, and the user pressing the first target key or the first target key combination has the same effect as clicking the pivot option.

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

[0164] In a possible implementation, the first area also displays a row field selection sub-area, a column field selection sub-area, and a value field selection sub-area of ​​the pivot table, and the first field includes a row field, a column field, and a third field. In response to the row field being dragged to the row field selection sub-area, the column field being dragged to the column field selection sub-area, and the value field being dragged to the value field selection sub-area, the terminal sends the pivot request to the server, and the pivot request carries the row field, column field, and value field of the first field. The server obtains the pivot request, performs data processing based on the sub-table item corresponding to the first field, and obtains the first pivot table. The server sends the first pivot table to the sending end of the pivot request, that is, 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 method selection page of the value field on the first area, and the summary method selection page of the value field displays multiple summary methods, including sum, count, average, maximum, minimum, and product. The user can control the server to generate different types of first pivot tables by selecting different summary methods.

[0165] Among them, the row field selection sub-area is used to select row fields for the pivot table, the column field selection sub-area is used to select column fields for the pivot table, and the value field selection sub-area is used to select value fields for the pivot table. For example, for sales data, the user can select the row field "sales object" for the pivot table, select the column field "salesperson" for the pivot table, and select the value field "sales amount" for the pivot table. In this way, the generated pivot table can reflect the sales amount of different sales persons for different sales objects. In some embodiments, if the user selects sum for the value field through the summary method selection page of the value field, the generated pivot table can reflect the total sales amount of each sales person for each sales object; if the value field is selected as count through the summary method selection page of the value field, the generated pivot table can reflect the number of sales of each sales person for each sales object; if the value field is selected as the maximum value through the summary method selection page of the value field, the generated pivot table can reflect the maximum sales amount of each sales person for each sales object. That is, the user can actually select in the summary method selection page of the value field to obtain different pivot tables.

[0166] In this implementation, the terminal does not need to download the data in the online table, but directly generates a pivot table request based on the user's free selection of row fields, column fields and value fields for the first pivot table. The server can automatically generate the first pivot table based on the pivot table request, and the generation efficiency of the first pivot table is relatively high.

[0167] For example, the terminal displays at least one field of the online form in the first field display area of ​​the first area, and displays the row field selection sub-area, the column field selection sub-area, and the value field selection sub-area on the first area. In some embodiments, the first field display area is located on the left side of the first area, and the row field selection sub-area, the column field selection sub-area, and the value field selection sub-area are located on the right side of the first area. For example, see Figure 6 , the online editing page 601 displays a first field display area 602, a row field selection sub-area 603, a column field selection sub-area 604, and a value field selection sub-area 605. The user can select a row field, a column field, and a value field in the first field display area 602. The process of the user dragging the field displayed in the first field display 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 is the process of selecting a row field, a column field, and a value field for the pivot table.

[0168] In some embodiments, the user can drag the field displayed in the first field display area to the row field selection sub-area, the column field selection sub-area, and the value field selection sub-area to select 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-area, the column field being dragged to the column field selection sub-area, and the value field being dragged to the value field selection sub-area, the terminal can display the row field in the row field selection sub-area, the column field in the column field selection sub-area, and the value field in the value field selection sub-area, and the user can view the selected field in the row field selection sub-area, the column field selection sub-area, and the value field display sub-area. In response to the row field being dragged to the row field selection sub-area, the column field being dragged to the column field selection sub-area, and the value field being dragged to the value field selection sub-area, the terminal sends a pivot request to the server, and the pivot request carries the row field, the column field, and the value field. Of course, the pivot 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 pivot request, the server obtains the row field, column field and value field of the first field from the pivot request, performs data processing based on the row field, column field and value field of the first field, and obtains the first pivot table, that is, the server performs data processing based on the sub-table items corresponding to the row field, the sub-table items corresponding to the column field and the sub-table items corresponding to the value field to generate the first pivot table. The server can subsequently 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 RPC (Remote Procedure Call) technology. From the user's perspective, the terminal can directly display the first pivot table by simply dragging the row field to the row field selection sub-area, the column field to the column field selection sub-area and the value field to the value field selection sub-area, without copying the data in the online table to the data processing application running on the terminal for processing, thereby improving the efficiency of data processing.

[0169] In some embodiments, the terminal displays a field search box on the first area, and the field search box is used to quickly find the field that the user wants from at least one field displayed on the first area. The user enters a complete field or partial characters of a field in the field search box, and the terminal can display the corresponding field on the first area. The user can drag and drop the field to the row field selection subarea, the column field selection subarea, or the value field selection subarea. In this way, the efficiency of the user's search for fields is improved. For example, see Figure 6 A field search box 606 is displayed on the first area of ​​the online editing page 601 , and the user can perform a field search through the field search box 606 .

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

[0171] In a possible implementation, the online editing page further includes a preview area for the pivot table. After the terminal obtains the first pivot table generated by the server, the first pivot table is displayed in the preview area for the pivot table. Figure 6 , a preview area 607 of the pivot table is displayed on the online editing page 601 .

[0172] In some embodiments, in response to the export operation of the first pivot table, the terminal obtains the file corresponding to the first pivot table. The preview area of ​​the pivot table also provides a local zoom tool and an export tool. The user can use the local zoom tool to locally zoom the pivot table, and the user can use the export tool to export the pivot table to the hard disk for reference at any time.

[0173] In a possible implementation, the terminal displays the table name of the first pivot table above the first pivot table, and in response to receiving the table name adjustment operation for the first pivot table, the terminal displays a table name input box for the first pivot table in the online editing page. The terminal updates the table name of the first pivot table with the table name input in the table name input box.

[0174] In this implementation, the user can adjust the table name of the first pivot table, and the efficiency of human-computer interaction is relatively high.

[0175] Method 1: The terminal displays a table name adjustment control next to the table name of the first pivot table. In response to a click on the table name adjustment control, the terminal displays a table name input box, and the user can enter the table name to be adjusted in the table name input box to adjust the table name of the first pivot table.

[0176] 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 the position where the table name of the first pivot table is displayed. The table name input box displays the table name of the first pivot table, and the user can adjust the table name of the first pivot table in the table name input box.

[0177] In a possible implementation, in response to an operation of adjusting the order of the sub-table items displayed in the first data pivot table, the display order of the sub-table items displayed in the first data pivot table is adjusted to obtain a third data pivot table.

[0178] In this implementation, when the user wants to adjust the display order of the sub-table items in the first pivot table, it can be done directly through the order adjustment operation, which is highly efficient.

[0179] It should be noted that after step S304, the terminal can execute the following steps S305 and S306, and can also execute the following steps S307 and S308, which is not limited in the embodiment of the present application.

[0180] In step S305, in response to receiving an update operation on the first data pivot table, the terminal obtains an updated second data pivot table from the server.

[0181] In a possible implementation, in response to receiving an update operation on the first pivot table, a second field corresponding to the update operation is determined. An update request for the first pivot table is sent to the server, the update request carries the second field, and the update request is used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table. The second pivot table generated by the server is obtained.

[0182] The first field includes a row field, a column field, and a value field. An update operation on any field in the first field can be regarded as an update operation on the first pivot table.

[0183] In this implementation, when the user wants to update the first pivot table, he only needs to perform an update operation on the first pivot table on the terminal to obtain the second pivot table. The terminal does not need to perform additional data processing operations, which reduces the terminal's computing power and improves the update efficiency of the pivot table.

[0184] For example, the first area also displays the row field selection sub-area, column field selection sub-area and value field selection sub-area of ​​the pivot table, 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. In response to the row field displayed in the row field selection sub-area being dragged out and another field being dragged to the row field selection sub-area, the terminal sends an update request for the first pivot table to the server, 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 obtains an update request for the first pivot table, the update request carries the second field, and the second field is the field corresponding to the update operation of the first pivot table. In response to the update request, the server updates the first pivot table based on the sub-table item corresponding to the second field to obtain the second pivot table.

[0185] In addition, in addition to being able to drag the row field out of the row field selection sub-area, in some embodiments, in response to the row field being dragged to the row field selection sub-area, the terminal displays a removal control on the right side of the row field. In response to a click operation on the removal control, the terminal removes the row field from the row field selection sub-area. The user can drag another field to the row field selection sub-area. Alternatively, in some embodiments, a field clearing control is displayed in the row field selection sub-area. In response to a click operation on the field clearing control, the terminal clears the fields in the row field selection sub-area, thereby achieving the goal of removing the row field from the row field selection sub-area. The user can drag another field to the row field selection sub-area. Of course, the above is explained by taking the removal of the row field from the row field selection sub-area as an example. In other possible implementations, the above method can also be used to remove the fields in the column field selection sub-area or the value field selection sub-area, and the embodiments of the present application are not limited to this.

[0186] It should be noted that the above is explained by taking the updating of the row field to another field as an example. In other possible implementations, the column field or value field can also be updated to another field, or any two or three of the row field, column field and value field can be updated simultaneously. The embodiments of the present application are not limited to this.

[0187] In step S306, the terminal displays the second pivot table.

[0188] In a possible implementation, the terminal displays the second pivot table in the online editing page.

[0189] In some embodiments, if the online editing page includes a preview area for the pivot table, the terminal can display the second pivot table in the preview area for the pivot table.

[0190] In step S307, in response to receiving a confirmation operation on the first pivot table, the terminal sends a table storage request to the server, 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.

[0191] Storing the first data pivot table in the online form means that the first data pivot table is used as an appendix of the online form, or that the first data pivot table can be displayed at the same time as the online form is displayed on the terminal.

[0192] Through step S307, the user can control the server through the terminal to store the updated second pivot table in the online table, which saves the storage space of the terminal and facilitates the user's subsequent reference.

[0193] For example, after displaying the first pivot table, the terminal can display a confirmation control on the area where the first pivot table is displayed. In response to a click operation on the confirmation control, the terminal sends a table storage request to the server, and the table storage request carries the identifier of the first pivot table. The server obtains the table storage request, and the table storage request 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 table, the user can also consult the first pivot table at any time through the online form.

[0194] In some embodiments, in addition to storing the first pivot table in an online form, the server can also store the first pivot table in an online document. The first pivot table is then an online form parallel to the online form, and subsequent users can process the first pivot table.

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

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

[0197] Through the technical solution provided by the embodiment of the present application, when the user wants to pivot the data in the online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

[0198] In addition to the above steps S301-S308, the present application embodiment also provides a data processing method, see Figure 7 , methods include:

[0199] In step S701, the terminal displays an online editing page of an online form. The online form includes at least one field and multiple table items. One table item includes at least one sub-table item, and one sub-table item corresponds to one field.

[0200] The method for the terminal to display the online editing page of the online form is described in the above step S301 and will not be repeated here.

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

[0202] The chart types include line charts, bar charts, and pie charts. In some embodiments, the line chart includes a time trend line chart, and the bar chart includes a data split comparison bar chart. The online document stores at least one chart type, which is generated based on the fields in the online table and the sub-table items corresponding to the fields.

[0203] In a possible implementation, in response to a triggering operation on a 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.

[0204] In this implementation, the terminal can call different types of charts through the chart type selection area, and the efficiency of human-computer interaction is relatively high.

[0205] For example, see Figure 8 , the chart call option is a chart call control, and the terminal displays a 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, and at least one chart type is displayed in the chart type selection area 803.

[0206] In a possible implementation, 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.

[0207] Among them, the target character is a character set by the technician, such as the character “ / ” or the character “]”, etc., and this embodiment of the present application does not limit this.

[0208] In this implementation mode, the user can call the chart by directly inputting the target characters, which is highly efficient.

[0209] In step S703, in response to the selection operation of the target chart type in the at least one chart type, the terminal displays a chart selection area corresponding to the target chart type in the online editing page, and 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.

[0210] The type corresponding to the at least one chart identifier is the target chart type means that the type of the chart corresponding to the at least one chart identifier is the target chart type.

[0211] In a possible implementation, in response to a target chart type being selected in at least one chart type, the terminal displays a chart selection area corresponding to the target chart type in the online editing page, and multiple charts under the target chart type are displayed in the chart selection area. The user can select the chart they want to view in the chart selection area. In some embodiments, when the terminal displays at least one chart identifier under the target type in the chart selection area, it can be displayed in the form of a chart thumbnail, that is, the terminal displays thumbnails of multiple charts under the target type in the chart selection area, and the corresponding chart identifier is displayed on the thumbnail, so that the user can know the content of the chart in advance, which is convenient for the user to select the chart.

[0212] For example, see Fig. 9 In response to the target chart type being selected, the terminal displays a chart selection area 902 on the online editing page 901 , and the chart selection area 902 displays at least one chart identifier under the target chart type.

[0213] In step S704, in response to receiving a selection operation on a first chart identifier among the at least one chart identifier, the terminal sends a first chart acquisition request to the server, and the first chart acquisition request carries the first chart identifier. The first chart acquisition request is used to query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier.

[0214] In a possible implementation, in response to receiving a selection operation on a first chart identifier among the at least one chart identifier, the terminal sends a first chart acquisition request to the server. The server acquires the first chart acquisition request, and the first chart acquisition request carries the first chart identifier. In response to the first chart acquisition request, the server performs a query 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, that is, the terminal.

[0215] In step S705, the terminal receives the first chart sent by the server, and displays the first chart in the online editing page, where the first chart includes the third field in the online form and the sub-table item corresponding to the third field.

[0216] For example, see Fig. 9 In response to the first chart 903 being selected, the terminal displays the first chart 903 on the online editing page 901 .

[0217] In step S705, the terminal displays at least one chart type option in the online editing page. In response to receiving a selection operation on any one of the at least one chart type option, the terminal transforms the type of the first chart based on the chart type indicated by the chart type option to obtain a second chart, and the second chart has the same chart content as the first chart.

[0218] Among them, the chart type option corresponds to different chart types, and the user can adjust the chart type of the currently displayed chart by clicking the chart type option. For example, if the chart type of the currently displayed chart is a line chart, then if the user clicks the chart type option corresponding to the bar chart, the terminal can display a 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 means that the second chart and the first chart are generated based on the third target field in the online table and the sub-table item corresponding to the third target field.

[0219] In one possible implementation, see Fig.10 , the terminal displays at least one chart type option on the online editing page 1001, each chart type option corresponds to a chart type, and in some embodiments, the chart type option is a chart type control. In response to any chart type option being selected, that is, the chart type option being clicked, the terminal sends a chart type switching request to the server, and the chart type switching request carries the identifier of the first chart and the selected chart type option. After the server obtains the chart type switching request, it obtains the identifier of the first chart and the selected chart type option from the chart type switching request. Based on the chart type indicated by the chart type option, the server adjusts the type information of the first chart to obtain a second chart, and the chart type of the second chart is the chart type indicated by the chart type option. The server sends the second chart to the terminal, and the terminal switches the first chart to the second chart for display.

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

[0221] Through the above steps S701-S706, the user can generate the form he wants to view through the online editing page of the online form, without downloading the data in the online form to the terminal and then filtering the data, thereby improving the efficiency of data processing.

[0222] In addition to the above steps S301-S308 and steps S701-S706, the present application embodiment also provides a data processing method, see Fig.11 , methods include:

[0223] In step S1101, the terminal displays an online editing page of an online form, where the online form includes at least one field and multiple table items, one table item includes at least one sub-table item, and one sub-table item corresponds to one field.

[0224] The method for the terminal to display the online editing page of the online form is described in the above step S301 and will not be repeated here.

[0225] In step S1102, in response to a triggering operation on a form calling 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.

[0226] In a possible implementation, a table call option is displayed in the online editing page. In response to a click operation on the table call option, the terminal sorts at least one field of the online table according to a target order and displays the sorted at least one field in the second area of ​​the online editing page.

[0227] The target order is the order of letters in the alphabet, and the terminal sorts at least one field according to the target order, that is, the terminal sorts at least one field according to the order of the first characters of at least one field in the alphabet. Alternatively, the target order is the order of field length from short to long or from long to short, and the terminal sorts at least one field according to the target order, that is, the terminal sorts at least one field in the order of field length from short to long or from long to short.

[0228] For example, the table call option is a table call control, and the table call control is displayed in the online editing page. In response to a click operation on the table call control, the terminal sorts at least one field of the online table according to a target order, and displays the sorted at least one field in the second area of ​​the online editing page. In some embodiments, the second area of ​​the online editing page is located on the left side of the online editing page, and the at least one field displayed in the second area is arranged vertically according to the target arrangement order. For example, see Fig.12 A table calling control 1202 is displayed on the online editing page 1201. In response to a click operation on the table calling control 1202, the terminal displays at least one field in the second area 1203 of the online editing page 1201. The user can select from the at least one displayed field to determine the field for which the table call is desired.

[0229] In a possible implementation, in addition to controlling the terminal to display at least one field in the second area by clicking on the table call 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 an online editing page, the user presses the "~" key on the keyboard to control the terminal 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 an online editing page, the user presses the "Ctrl" key and the "~" key on the keyboard at the same time to control the terminal 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 table call option, which can serve to remind the user, and the user pressing the second target key or the second target key combination has the same effect as clicking the table call option.

[0230] In a possible implementation, the terminal can classify at least one field of the online form, for example, classifying the fields "employee number", "name", "birthday" and the like into a major category "employee information". When the terminal displays at least one field in the second area, it can first display multiple major categories of the at least one field, and in response to any major category of the multiple major categories being selected, the terminal displays at least one field under the major category.

[0231] 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, the target table including the fourth field and a sub-table item corresponding to the fourth field.

[0232] Among them, the fourth target field can be either one field or multiple fields, which is not limited in the embodiment of the present application.

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

[0234] For example, in response to a field confirmation control being clicked, the terminal sends a table acquisition request to the server, and the table acquisition request carries the selected fourth target field. After receiving the table acquisition request, the server acquires the fourth target field from the table acquisition request and generates a target table based on the fourth target field. The server sends the target table to the terminal, and the terminal displays the target table in the online editing page.

[0235] In some embodiments, the terminal displays a field search box on the second area, and the field search box is used to quickly find the field that the user wants from at least one field displayed on the second area. The user enters a complete field or partial characters of a field in the field search box, and the terminal can display the corresponding field on the second area. The user can drag the field to an item in the row field selection subarea, column field selection subarea, or value field selection subarea. In this way, the efficiency of the user's search for fields is improved. For example, see Fig.13 A field search box 1302 is displayed on the second area of ​​the online editing page 1301 , and the user can perform a field search through the field search box 1302 .

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

[0237] In a possible implementation, in response to a click operation on any first sub-item displayed in the target table, the terminal highlights the first sub-item to indicate that the first sub-item is selected and the sub-item is in an editable state. In response to adjusting the first sub-item to a second sub-item, the terminal displays the second sub-item. That is, the user can edit the content displayed in the online table in real time. Among them, highlighting means that the terminal adjusts the color of the first sub-item to the target color, or adjusts the background color of the first sub-item to the target color, which is not limited in the embodiments of the present application. The target color is set by the user, such as red or yellow.

[0238] Through the above steps S1101-S1104, the user can generate the chart he wants to view through the online editing page of the online form, without downloading the data in the online form to the terminal and then performing data screening and chart drawing, thereby improving the efficiency of data processing.

[0239] Fig.14 is a block diagram of a data processing device according to an exemplary embodiment. Fig.14 The device includes: an online editing page display unit 1401, a field display unit 1402, a data pivot request sending unit 1403 and a first data pivot table display unit 1404.

[0240] The online editing page display unit 1401 is configured to execute and display an online editing page of an online form, wherein the online form includes at least one field and at least one table item, wherein one table item includes at least one sub-table item, and one sub-table item corresponds to one field.

[0241] The field display unit 1402 is configured to display at least one field of the online form in a first area of ​​the online editing page in response to receiving a trigger operation on a pivot option in the online editing page.

[0242] The data pivot request sending unit 1403 is configured to execute a data pivot request to the server in response to receiving a selection operation on a first field of the at least one field, wherein the data pivot request carries the first field and is used to perform data processing based on a sub-table item corresponding to the first field to obtain a first data pivot table.

[0243] The first pivot table display unit 1404 is configured to obtain the first pivot table generated by the server and display the first pivot table in the online editing page.

[0244] In a possible implementation, the first area also displays a row field selection subarea, a column field selection subarea, and a value field selection subarea of ​​the pivot table, the first field includes a row field, a column field, and a value field, and the pivot request sending unit 1403 is configured to execute the pivot request to the server in response to the row field being dragged to the row field selection subarea, the column field being dragged to the column field selection subarea, and the value field being dragged to the value field selection subarea, and the pivot request carries the row field, column field, and value field of the first field.

[0245] In a possible implementation, the device further includes:

[0246] The second pivot table display unit is 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, the update request carrying the second field, the update request being used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table. Obtaining the second pivot table generated by the server, and displaying the second pivot table in the online editing page.

[0247] In a possible implementation, the device further includes:

[0248] The first pivot table display unit 1404 is further configured to execute, in response to receiving a confirmation operation on the first pivot table, sending 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, and displaying the identifier of the first pivot table in the online table.

[0249] In a possible implementation, the device further includes:

[0250] The first chart display unit is configured to execute, in response to a chart call operation received in the online editing page, display at least one chart identifier in a chart type selection area of ​​the online editing page. In response to receiving a selection operation of a first chart identifier among the at least one chart identifier, send a first chart acquisition request to the server, the first chart acquisition request carrying the first chart identifier, the first chart acquisition request being used to query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier. The first chart sent by the server is received, and the first chart is displayed in the online editing page, the first chart including a third field in the online form and a sub-table item corresponding to the third field.

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

[0252] In a possible implementation, the first chart display unit is configured to, in response to receiving a chart call operation in the online editing page, display a chart type selection area in the online editing page, wherein at least one chart type is displayed in the chart type selection area. In response to a selection operation of a target chart type in the at least one chart type, display 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.

[0253] In a possible implementation, the device further includes:

[0254] The second chart display unit is configured to, in response to receiving a selection operation of any one of the at least one chart type options, transform the first chart based on the chart type indicated by the chart type option to obtain a second chart, the second chart having the same chart content as the first chart, and display the second chart in the online editing page.

[0255] In a possible implementation, the device further includes:

[0256] The target table display unit is configured to execute, in response to receiving a trigger operation of calling a table option in the online editing page, display at least one field of the online table in the second area of ​​the online editing page. In response to receiving a selection operation of a fourth field in the at least one field, display a target table in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field.

[0257] In a possible implementation, the device further includes:

[0258] The sub-table item updating unit is configured to execute, in response to receiving a content adjustment operation on any first sub-table item displayed in the target table, updating the first sub-table item based on a second sub-table item corresponding to the content adjustment operation.

[0259] In a possible implementation, the device further includes:

[0260] The table name updating unit is configured to, in response to receiving a table name adjustment operation on the first pivot table, display a table name input box of the first pivot table in the online editing page, and update the table name of the first pivot table with the table name input in the table name input box.

[0261] In a possible implementation, the device further includes:

[0262] The display order adjustment unit is configured to perform a display order adjustment operation on the sub-table items displayed in the first pivot table in response to the order adjustment operation on the sub-table items displayed in the first pivot table, so as to obtain a third pivot table.

[0263] In a possible implementation, the device further includes:

[0264] The file exporting unit is configured to execute an exporting operation on the first pivot table and obtain a file corresponding to the first pivot table.

[0265] Regarding the device in the above embodiment, the specific manner in which each unit performs the operation has been described in detail in the embodiment of the method, and will not be elaborated here.

[0266] Through the technical solution provided by the embodiment of the present application, when the user wants to pivot the data in the online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

[0267] Fig.15 is a block diagram of a data processing device according to an exemplary embodiment. Fig.15The device includes: a data pivot request obtaining unit 1501, a first data pivot table generating unit 1502 and a first data pivot table sending unit 1503.

[0268] The data pivot request acquisition unit 1501 is configured to execute a data pivot request, the data pivot request carries a first field, the first field is a field selected in an online form, the online form includes at least one field and at least one table item, one of the table items includes at least one sub-table item, one of the sub-table items corresponds to one of the fields, and the data pivot request is sent in response to receiving a trigger operation on a data pivot option in an online editing page of the online form.

[0269] The first data pivot table generating unit 1502 is configured to perform data processing based on the sub-table item corresponding to the first field to obtain a first data pivot table.

[0270] The first pivot table sending unit 1503 is configured to send the first pivot table to the sending end of the pivot table request, so that the sending end of the pivot table request displays the first pivot table in the online editing page.

[0271] In a possible implementation, the first field includes a row field, a column field, and a value field, and the first pivot table generating unit 1502 is configured to perform data processing based on the row field, the column field, and the value field of the first field to obtain the first pivot table.

[0272] In a possible implementation, the device further includes:

[0273] The second pivot table generating unit is configured to execute and obtain an update request for the first pivot table, the update request carries a second field, and the second field is a field corresponding to the update operation of the first pivot table. In response to the update request, based on the sub-table item corresponding to the second field, the first pivot table is updated to obtain a second pivot table.

[0274] In a possible implementation, the device further includes:

[0275] The second data pivot table generating unit is configured to execute a table storage request, the table storage request carries the identifier of the first data pivot table, store the first data pivot table in the online table in response to the table storage request, and generate the identifier of the first data pivot table in the online table.

[0276] In a possible implementation, the device further includes:

[0277] The first chart sending unit is configured to execute a first chart acquisition request, the first chart acquisition request carries a first chart identifier, and the first chart identifier is a chart identifier selected from at least one chart identifier displayed in the chart type selection area of ​​the online editing page. In response to the first chart acquisition request, a query is performed based on the first chart identifier to obtain a first chart corresponding to the first chart identifier, and the first chart is sent to a sending end of the first chart acquisition request.

[0278] Regarding the device in the above embodiment, the specific manner in which each unit performs the operation has been described in detail in the embodiment of the method, and will not be elaborated here.

[0279] Through the technical solution provided by the embodiment of the present application, when the user wants to pivot the data in the online table, by triggering the pivot option in the online editing page, the electronic device can be controlled to display at least one field of the online table in the online editing page, and the user can select the first field required to generate the pivot table through the online editing page. The electronic device can directly display the first pivot table based on the first field. The user does not need to download the data in the online table to the terminal, and can directly pivot the data in the online table through the server, and the terminal directly displays the generated first pivot table, thereby improving the efficiency of pivoting.

[0280] In the embodiments of the present application, the electronic device may be implemented as a terminal or a server. First, the structure of the terminal is described:

[0281] Fig.16 1 is a block diagram of a terminal according to an exemplary embodiment. The terminal 1600 may be a terminal used by a user. The terminal 1600 may be at least one of a smart phone, a smart watch, a desktop computer, a laptop computer, and a portable computer. The terminal 1600 may also be called a user device, a portable terminal, a laptop terminal, a desktop terminal, and other names.

[0282] Typically, the terminal 1600 includes a processor 1601 and a memory 1602 .

[0283] The processor 1601 may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor 1601 may be implemented in at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). The processor 1601 may also include a main processor and a coprocessor. The main processor is a processor for processing data in the awake state, also known as a CPU (Central Processing Unit); the coprocessor is a low-power processor for processing data in the 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 to be displayed on the display screen. In some embodiments, the processor 1601 may also include an AI (Artificial Intelligence) processor, which is used to process computing operations related to machine learning.

[0284] The 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 and non-volatile memory, such as one or more disk storage devices and flash memory storage devices.

[0285] In some embodiments, the terminal 1600 may also optionally include: a peripheral device interface 1603 and at least one peripheral device. The processor 1601, the memory 1602 and the peripheral device interface 1603 may be connected via a bus or a signal line. Each peripheral device may be connected to the peripheral device interface 1603 via a bus, a signal line or a circuit board. Specifically, the peripheral device includes: at least one of a radio frequency circuit 1604, a display screen 1605, a camera assembly 1606, an audio circuit 1607, a positioning assembly 1608 and a power supply 16013.

[0286] The peripheral device interface 1603 may be used to connect at least one peripheral device related to I / O (Input / Output) to the processor 1601 and the memory 1602. In some embodiments, the processor 1601, the memory 1602, and the peripheral device 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 in this embodiment.

[0287] The radio frequency circuit 1604 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The radio frequency circuit 1604 communicates with the communication network and other communication devices through electromagnetic signals. The radio frequency circuit 1604 converts the electrical signal into an electromagnetic signal for transmission, or converts the received electromagnetic signal into an electrical signal. Optionally, the radio frequency 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 user identity module card, and the like. The radio frequency circuit 1604 can communicate with other terminals through at least one wireless communication protocol. The wireless communication protocol includes, but is not limited to: a metropolitan area network, various generations of mobile communication networks (2G, 3G, 4G and 5G), a wireless local area network and / or a WiFi (Wireless Fidelity) network. In some embodiments, the radio frequency circuit 1604 may also include circuits related to NFC (Near Field Communication), which is not limited in this application.

[0288] The display screen 1605 is used to display a UI (User Interface). The UI may include images, texts, 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 collect touch signals on the surface or above the surface of the display screen 1605. The touch signal can be input to the processor 1601 as a control signal for processing. At this time, the display screen 1605 can also be used to provide virtual buttons and / or virtual keyboards, also known as soft buttons and / or soft keyboards. In some embodiments, the display screen 1605 can be one, and the front panel of the terminal 1600 is set; in other embodiments, the display screen 1605 can be at least two, which are respectively set on different surfaces of the terminal 1600 or are folded; in some other embodiments, the display screen 1605 can be a flexible display screen, which is set on the curved surface or folded surface of the terminal 1600. Even, the display screen 1605 can also be set to a non-rectangular irregular image, that is, a special-shaped screen. The display screen 1605 can be made of materials such as LCD (Liquid Crystal Display) and OLED (Organic Light-Emitting Diode).

[0289] The camera assembly 1606 is used to capture images or videos. Optionally, the camera assembly 1606 includes a front camera and a rear camera. Typically, the front camera is arranged on the front panel of the terminal, and the rear camera is arranged on the back of the terminal. In some embodiments, there are at least two rear cameras, which are any one of a main camera, a depth of field camera, a wide-angle camera, and a telephoto camera, so as to realize the fusion of the main camera and the depth of field camera to realize the background blur function, the fusion of the main camera and the wide-angle camera to realize the panoramic shooting and VR (Virtual Reality) shooting function or other fusion shooting functions. In some embodiments, the camera assembly 1606 may also include a flash. The flash can be a monochrome temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm light flash and a cold light flash, which can be used for light compensation at different color temperatures.

[0290] The audio circuit 1607 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, and convert the sound waves into electrical signals and input them into the processor 1601 for processing, or input them into the radio frequency circuit 1604 to achieve voice communication. For the purpose of stereo acquisition or noise reduction, there may be multiple microphones, which are respectively arranged at different parts of the terminal 1600. The microphone may also be an array microphone or an omnidirectional acquisition microphone. The speaker is used to convert the electrical signal from the processor 1601 or the radio frequency circuit 1604 into sound waves. The speaker may be a traditional film speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can not only convert the electrical signal into sound waves audible to humans, but also convert the electrical signal into sound waves inaudible to humans for purposes such as ranging. In some embodiments, the audio circuit 1607 may also include a headphone jack.

[0291] The positioning component 1608 is used to locate the current geographical location of the terminal 1600 to implement navigation or LBS (Location Based Service). The positioning component 1608 can be a positioning component based on the US GPS (Global Positioning System), China's Beidou system, Russia's Grenas system or the European Union's Galileo system.

[0292] The power supply 1609 is used to power various components in the terminal 1600. The power supply 1609 can be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power supply 1609 includes a rechargeable battery, the rechargeable battery can support wired charging or wireless charging. The rechargeable battery can also be used to support fast charging technology.

[0293] In some embodiments, the terminal 1600 further includes one or more sensors 1610 , including but not limited to: an acceleration sensor 1611 , a gyroscope sensor 1612 , a pressure sensor 1613 , a fingerprint sensor 1614 , an optical sensor 1615 , and a proximity sensor 1616 .

[0294] The acceleration sensor 1611 can detect the magnitude of acceleration on the three coordinate axes of the coordinate system established by the terminal 1600. For example, the acceleration sensor 1611 can be used to detect the components of gravity acceleration on the three coordinate axes. The processor 1601 can control the display screen 1605 to display the user interface in a horizontal view or a vertical view according to the gravity acceleration signal collected by the acceleration sensor 1611. The acceleration sensor 1611 can also be used for collecting game or user motion data.

[0295] The gyro sensor 1612 can detect the body direction and rotation angle of the terminal 1600, and the gyro sensor 1612 can cooperate with the acceleration sensor 1611 to collect the user's 3D actions on the terminal 1600. The processor 1601 can implement the following functions based on the data collected by the gyro sensor 1612: motion sensing (such as changing the UI according to the user's tilt operation), image stabilization during shooting, game control, and inertial navigation.

[0296] The pressure sensor 1613 can be set on the side frame of the terminal 1600 and / or the lower layer of the display screen 1605. When the pressure sensor 1613 is set on the side frame of the terminal 1600, it can detect the user's holding signal of the terminal 1600, and the processor 1601 performs left and right hand recognition or shortcut operation according to the holding signal collected by the pressure sensor 1613. When the pressure sensor 1613 is set on the lower layer of the display screen 1605, the processor 1601 controls the operability controls on the UI interface according to the user's pressure operation on the display screen 1605. The operability controls include at least one of a button control, a scroll bar control, an icon control, and a menu control.

[0297] The fingerprint sensor 1614 is used to collect the user's fingerprint, and the processor 1601 identifies the user's identity based on the fingerprint collected by the fingerprint sensor 1614, or the fingerprint sensor 1614 identifies the user's identity based on the collected fingerprint. When the user's identity is identified as a trusted identity, the processor 1601 authorizes the user to perform relevant sensitive operations, which include unlocking the screen, viewing encrypted information, downloading software, paying, and changing settings. The fingerprint sensor 1614 can be set on the front, back, or side of the terminal 1600. When a physical button or a manufacturer logo is set on the terminal 1600, the fingerprint sensor 1614 can be integrated with the physical button or the manufacturer logo.

[0298] The optical sensor 1615 is used to collect the ambient light intensity. In one embodiment, the processor 1601 can control the display brightness of the display screen 1605 according to the ambient light intensity collected by the optical sensor 1615. Specifically, when the ambient light intensity is high, the display brightness of the display screen 1605 is increased; when the ambient light intensity is low, the display brightness of the display screen 1605 is reduced. In another embodiment, the processor 1601 can also dynamically adjust the shooting parameters of the camera component 1606 according to the ambient light intensity collected by the optical sensor 1615.

[0299] The proximity sensor 1616, also called a distance sensor, is usually arranged on the front panel of the terminal 1600. The proximity sensor 1616 is used to collect the distance between the user and the front of the terminal 1600. In one embodiment, when the proximity sensor 1616 detects that the distance between the user and the front of the terminal 1600 is gradually decreasing, the processor 1601 controls the display screen 1605 to switch from the screen-on state to the screen-off state; when the proximity sensor 1616 detects that the distance between the user and the front of the terminal 1600 is gradually increasing, the processor 1601 controls the display screen 1605 to switch from the screen-off state to the screen-on state.

[0300] Those skilled in the art will understand that Fig.16 The structure shown in the figure does not constitute a limitation on the terminal 1600, and the terminal 1600 may include more or less components than those shown in the figure, or combine some components, or adopt a different component arrangement.

[0301] In the embodiment of the present application, the electronic device can be implemented as a server. The structure of the server is described below:

[0302] Fig.17 1 is a block diagram of a server 1700 according to an exemplary embodiment. The server 1700 may have relatively large differences due to different configurations or performances, and may include one or more processors (Central Processing Units, CPU) 1701 and one or more memories 1702. The memory 1702 stores at least one instruction, which is loaded and executed by the processor 1701 to implement the above data processing method.

[0303] In an exemplary embodiment, a storage medium including instructions is also provided, such as a memory 1702 including instructions, and the instructions can be executed by a processor 1701 of a server 1700 to complete the above data processing method. Optionally, the storage medium can be a non-temporary storage medium, for example, the non-temporary storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, etc.

[0304] In an exemplary embodiment, a computer program product is also provided, including a computer program, which can be executed by a processor of an electronic device to implement the above data processing method.

[0305] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary techniques in the art that are not disclosed in the present application. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present application are indicated by the following claims.

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

Claims

1. A data processing method, characterized in that: include: Displaying an online editing page of an online form, wherein the online form includes at least one field and at least one table item, wherein one table item includes at least one sub-table item, and one sub-table item corresponds to one field; In response to receiving a triggering operation on a pivot option in the online editing page, sorting at least one field of the online form according to a target order, and displaying the sorted at least one field of the online form in a first area of ​​the online editing page; In response to receiving a selection operation on a first field of the at least one field, sending a data pivot request to a server, the data pivot request carrying the first field, the data pivot request being used to perform data processing based on a sub-table item corresponding to the first field to obtain a first data pivot table; Obtaining the first data pivot table generated by the server, and displaying the first data pivot table in the online editing page; In response to the operation of adjusting the order of the sub-table items displayed in the first data pivot table, adjusting the display order of the sub-table items displayed in the first data pivot table to obtain a third data pivot table; In response to receiving a trigger operation for a form call option in the online editing page, displaying multiple categories of at least one field of the online form in a second area of ​​the online editing page, and in response to any one of the multiple categories being selected, displaying at least one field under the any one of the categories; In response to receiving a selection operation on a fourth field in the at least one field, a target table is displayed in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field; the fourth target field includes one or more fields.

2. The data processing method according to claim 1, characterized in that: The first area also displays a row field selection sub-area, a column field selection sub-area, and a value field selection sub-area of ​​the pivot table, the first field includes a row field, a column field, and a value field, and in response to receiving a selection operation on a first field in the at least one field, sending a pivot request to the server includes: In response to the row field being dragged to the row field selection sub-area, the column field being dragged to the column field selection sub-area, and the value field being dragged to the value field selection sub-area, the pivot request is sent to the server, and the pivot request carries the row field, column field, and value field of the first field.

3. The data processing method according to claim 1, characterized in that: After 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, the update request carrying the second field, the update request being used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table; The second pivot table generated by the server is obtained, and the second pivot table is displayed in the online editing page.

4. The data processing method according to claim 1, characterized in that: 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, 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; An identifier of the first pivot table is displayed in the online form.

5. The data processing method according to claim 1, characterized in that: The method further comprises: In response to receiving a chart calling operation in the online editing page, displaying at least one chart identifier in a chart type selection area of ​​the online editing page; In response to receiving a selection operation on a first chart identifier among the at least one chart identifier, sending a first chart acquisition request to the server, wherein the first chart acquisition request carries the first chart identifier, and the first chart acquisition request is used to perform a query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; The first chart sent by the server is received, and the first chart is displayed in the online editing page, where the first chart includes a third field in the online form and a sub-table item corresponding to the third field.

6. The data processing method according to claim 5, characterized in that: The chart calling operation includes any one of a triggering operation on a chart calling option in the online editing page and a target character input operation in the online editing page.

7. The data processing method according to claim 5, characterized in that: In response to receiving a chart calling operation in the online editing page, displaying at least one chart identifier in a chart type selection area of ​​the online editing page comprises: In response to receiving a chart calling operation in the online editing page, displaying a chart type selection area in the online editing page, wherein at least one chart type is displayed in the chart type selection area; In response to a selection operation of a target chart type among the at least one chart type, a chart selection area corresponding to the target chart type is displayed in the online editing page, and 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.

8. The data processing method according to claim 5, characterized in that: At least one chart type option corresponding to the first chart is displayed in the online editing page. After the first chart is displayed in the online editing page, the method further includes: In response to receiving a selection operation of any one of the at least one chart type option, converting 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; The second chart is displayed in the online editing page.

9. The data processing method according to claim 1, characterized in that: After displaying the target table in the online editing page, the method further includes: In response to receiving a content adjustment operation on any first sub-item displayed in the target table, the first sub-item is updated based on a second sub-item corresponding to the content adjustment operation.

10. The data processing method according to any one of claims 1 to 8, characterized in that: After displaying the first pivot table in the online editing page, the method further includes: In response to receiving a table name adjustment operation on the first pivot table, displaying a table name input box for the first pivot table in the online editing page; The table name of the first pivot table is updated using the table name input in the table name input box.

11. The data processing method according to any one of claims 1 to 8, characterized in that: After displaying the first pivot table in the online editing page, the method further includes: In response to the export operation on the first pivot table, a file corresponding to the first pivot table is obtained.

12. A data processing method, characterized in that: include: Obtaining a data pivot request, the data pivot request carrying a first field, the first field being a field selected after at least one field in an online form is sorted according to a target order, the online form comprising at least one field and at least one table item, one table item comprising at least one sub-table item, one sub-table item corresponding to one field, the data pivot request being sent in response to receiving a trigger operation for a data pivot option in an online editing page of the online form; Perform data processing based on the sub-table item corresponding to the first field to obtain a first pivot table; The first pivot table is sent to the sending end of the pivot table request, so that the sending end of the pivot table request displays the first pivot table in the online editing page; the sending end of the pivot table request is also used to adjust the display order of the sub-table items displayed in the first pivot table in response to the order adjustment operation of the sub-table items displayed in the first pivot table, so as to obtain a third pivot table; The sending end of the data pivot request is also used to, in response to receiving a trigger operation for calling a table option in the online editing page, display multiple categories of at least one field of the online table in the second area of ​​the online editing page, and in response to any one of the multiple categories being selected, display at least one field under the any one of the categories; in response to receiving a selection operation for a fourth field in the at least one field, display a target table in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field; the fourth target field includes one or more fields.

13. The data processing method according to claim 12, characterized in that: The first field includes a row field, a column field and a value field, and the data processing is performed based on the sub-table item corresponding to the first field to obtain the first pivot table including: Data processing is performed based on the row field, column field and value field of the first field to obtain the first pivot table.

14. The data processing method according to claim 12, characterized in that: After performing data processing based on the sub-table item corresponding to the first field to obtain a first pivot table, the method further includes: Acquire 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 the update operation on the first pivot table; In response to the update request, the first pivot table is updated based on the sub-table item corresponding to the second field to obtain a second pivot table.

15. The data processing method according to claim 12, characterized in that: After performing data processing based on the sub-table item corresponding to the first field to obtain a first pivot table, the method further includes: Obtaining a table storage request, where the table storage request carries an identifier of the first pivot table; In response to the table storage request, storing the first pivot table in the online table; An identifier of the first pivot table is generated in the online form.

16. The data processing method according to claim 12, characterized in that: The method further comprises: Obtaining a first chart acquisition request, the first chart acquisition request carrying a first chart identifier, the first chart identifier being a chart identifier selected from at least one chart identifier displayed in a chart type selection area of ​​the online editing page; In response to the first chart acquisition request, query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; The first chart is sent to a sending end of the first chart acquisition request.

17. A data processing device, characterized in that: include: An online editing page display unit is configured to execute and display an online editing page of an online form, wherein the online form includes at least one field and at least one table item, wherein one table item includes at least one sub-table item, and one sub-table item corresponds to one field; a field display unit, configured to, in response to receiving a trigger operation on a pivot option in the online editing page, sort the at least one field of the online form according to a target order, and display the sorted at least one field of the online form in a first area of ​​the online editing page; a data pivot request sending unit, configured to execute, in response to receiving a selection operation on a first field of the at least one field, sending a data pivot request to a server, the data pivot request carrying the first field, the data pivot request being used to perform data processing based on a sub-table item corresponding to the first field to obtain a first data pivot table; A first pivot table display unit is configured to obtain the first pivot table generated by the server and display the first pivot table in the online editing page; a display order adjustment unit configured to perform, in response to an order adjustment operation on the sub-table items displayed in the first pivot table, an adjustment of the display order of the sub-table items displayed in the first pivot table to obtain a third pivot table; The target table display unit is configured to execute, in response to receiving a trigger operation for a table call option in the online editing page, display multiple categories of at least one field of the online table in the second area of ​​the online editing page, and in response to any one of the multiple categories being selected, display at least one field under the any one of the categories; in response to receiving a selection operation for a fourth field in the at least one field, display a target table in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field; the fourth target field includes one or more fields.

18. The data processing device according to claim 17, characterized in that: The first area also displays a row field selection subarea, a column field selection subarea, and a value field selection subarea of ​​the pivot table. The first field includes a row field, a column field, and a value field. The pivot request sending unit is configured to execute, in response to the row field being dragged to the row field selection subarea, the column field being dragged to the column field selection subarea, and the value field being dragged to the value field selection subarea, sending the pivot request to the server, the pivot request carrying the row field, column field, and value field of the first field.

19. The data processing device according to claim 17, characterized in that: The device also includes: The second pivot table display unit is configured to execute, in response to receiving an update operation on the first pivot table, determine a second field corresponding to the update operation; send an update request for the first pivot table to the server, the update request carries the second field, and the update request is used to update the first pivot table based on the sub-table item corresponding to the second field to obtain a second pivot table; obtain the second pivot table generated by the server, and display the second pivot table in the online editing page.

20. The data processing device according to claim 17, characterized in that: The device also includes: The first pivot table display unit is further configured to execute, in response to receiving a confirmation operation on the first pivot table, sending 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; and displaying the identifier of the first pivot table in the online table.

21. The data processing device according to claim 17, characterized in that: The device also includes: The first chart display unit is configured to execute, in response to receiving a chart call operation in the online editing page, display at least one chart identifier in the chart type selection area of ​​the online editing page; in response to receiving a selection operation on a first chart identifier among the at least one chart identifier, send a first chart acquisition request to the server, the first chart acquisition request carrying the first chart identifier, the first chart acquisition request being used to query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; receive the first chart sent by the server, and display the first chart in the online editing page, the first chart including a third field in the online form and a sub-table item corresponding to the third field.

22. The data processing device according to claim 21, characterized in that: The chart calling operation includes any one of a triggering operation on a chart calling option in the online editing page and a target character input operation in the online editing page.

23. The data processing device according to claim 21, characterized in that: The first chart display unit is configured to display a chart type selection area in the online editing page in response to receiving a chart call operation in the online editing page, wherein at least one chart type is displayed in the chart type selection area; In response to a selection operation of a target chart type among the at least one chart type, a chart selection area corresponding to the target chart type is displayed 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.

24. The data processing device according to claim 21, characterized in that: The device also includes: The second chart display unit is configured to execute, in response to receiving a selection operation of any chart type option among the at least one chart type option, convert the type of 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; and display the second chart in the online editing page.

25. The data processing device according to claim 17, characterized in that: The device also includes: The sub-table item updating unit is configured to execute, in response to receiving a content adjustment operation on any first sub-table item displayed in the target table, updating the first sub-table item based on a second sub-table item corresponding to the content adjustment operation.

26. The data processing device according to any one of claims 17 to 24, characterized in that: The device also includes: The table name updating unit is configured to execute, in response to receiving a table name adjustment operation on the first pivot table, display a table name input box of the first pivot table in the online editing page; and update the table name of the first pivot table using the table name input in the table name input box.

27. The data processing device according to any one of claims 17 to 24, characterized in that: The device also includes: The file exporting unit is configured to execute an export operation on the first pivot table and obtain a file corresponding to the first pivot table in response to the export operation on the first pivot table.

28. A data processing device, characterized in that: include: a data pivot request acquisition unit, configured to execute and acquire a data pivot request, the data pivot request carrying a first field, the first field being a field selected after at least one field in an online form is sorted according to a target order, the online form comprising at least one field and at least one table item, one table item comprising at least one sub-table item, one sub-table item corresponding to one field, the data pivot request being sent in response to receiving a trigger operation for a data pivot option in an online editing page of the online form; A first data pivot table generating unit is configured to perform data processing based on the sub-table item corresponding to the first field to obtain a first data pivot table; The first pivot table sending unit is configured to send the first pivot table to the sending end of the pivot table request, so that the sending end of the pivot table request displays the first pivot table in the online editing page; the sending end of the pivot table request is also used to adjust the display order of the sub-table items displayed in the first pivot table in response to the order adjustment operation of the sub-table items displayed in the first pivot table, so as to obtain a third pivot table; The sending end of the data pivot request is also used to, in response to receiving a trigger operation for calling a table option in the online editing page, display multiple categories of at least one field of the online table in the second area of ​​the online editing page, and in response to any one of the multiple categories being selected, display at least one field under the any one of the categories; in response to receiving a selection operation for a fourth field in the at least one field, display a target table in the online editing page, the target table including the fourth field and a sub-table item corresponding to the fourth field; the fourth target field includes one or more fields.

29. The data processing device according to claim 28, characterized in that The first field includes a row field, a column field and a value field. The first pivot table generating unit is configured to perform data processing based on the row field, the column field and the value field of the first field to obtain the first pivot table.

30. The data processing device according to claim 28, characterized in that The device also includes: The second pivot table generating unit is configured to execute and obtain 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; in response to the update request, based on the sub-table item corresponding to the second field, the first pivot table is updated to obtain a second pivot table.

31. The data processing device according to claim 28, characterized in that: The device also includes: The second pivot table generating unit is configured to execute obtaining a table storage request, the table storage request carrying the identifier of the first pivot table; in response to the table storage request, storing the first pivot table in the online table; and generating the identifier of the first pivot table in the online table.

32. The data processing device according to claim 28, characterized in that: The device also includes: The first chart sending unit is configured to execute a first chart acquisition request, wherein the first chart acquisition request carries a first chart identifier, and the first chart identifier is a chart identifier selected from at least one chart identifier displayed in the chart type selection area of ​​the online editing page; in response to the first chart acquisition request, query based on the first chart identifier to obtain a first chart corresponding to the first chart identifier; and send the first chart to a sending end of the first chart acquisition request.

33. An electronic device, characterized in that: include: processor; a memory for storing instructions executable by the processor; The processor is configured to execute the instructions to implement the data processing method according to any one of claims 1 to 16.

34. A computer-readable storage medium, when instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the data processing method according to any one of claims 1 to 16.

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

Images