CN114327674A

CN114327674A - Data processing method and device, electronic equipment and storage medium

Info

Publication number: CN114327674A
Application number: CN202111561482.4A
Authority: CN
Inventors: 赵翔; 朱军行
Original assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd; Wuhan Kingsoft Office Software Co Ltd
Current assignee: Beijing Kingsoft Office Software Inc; Zhuhai Kingsoft Office Software Co Ltd; Wuhan Kingsoft Office Software Co Ltd
Priority date: 2021-12-20
Filing date: 2021-12-20
Publication date: 2022-04-12

Abstract

The invention discloses a data processing method and device, electronic equipment and a storage medium, and relates to the technical field of data processing, wherein the data processing method comprises the following steps: receiving a trigger instruction for a program component; acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to process a data processing task of a data cooperation document; and displaying the data processing result in the data cooperation document. The data processing operation is triggered and completed by one-time operation, the complex artificial data processing operation is replaced, the complex data processing steps are simplified, the reusability of complex data processing is realized, and the error of artificial manual processing is avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

Description

Data processing method and device, electronic equipment and storage medium

Technical Field

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

Background

In daily life and work, a user cannot keep relevant operations on data processing. Illustratively, along with business development of enterprises, the use requirements of standard data in different business scenes are more and more strong, and users tend to use data collaboration documents in order to meet diversified data processing requirements. The data collaboration document can be used for editing and saving data, and the data in the data collaboration document can be displayed in a form of a multi-dimensional grid table, a form of a billboard view and a form of a picture. That is, a data collaboration document is a data table that may display data in multiple views (e.g., billboard view, grid list, album). And the data cooperation document is utilized to realize the multidimensional display of the data, so that various processing operations can be conveniently carried out on the data.

In the related art, processing data of a data collaboration document is generally performed by a user manually performing a plurality of operation processes to acquire necessary data. However, since different users need to perform multiple operations on required data, the complexity of data processing is greatly increased in the process of manually performing multiple operations on data, the reusability requirements of other users cannot be met, and the efficiency of data processing is reduced, and therefore a data processing method is urgently needed to solve the above problems.

Disclosure of Invention

In view of the above, the present invention provides a data processing method and apparatus, an electronic device, and a storage medium, and mainly aims to solve the technical problems of complex operation and low efficiency of the existing data processing.

According to an aspect of the present invention, there is provided a data processing method, including:

receiving a trigger instruction for a program component;

acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to process a data processing task of a data cooperation document;

and displaying the data processing result in the data cooperation document.

Further, the acquiring a data processing result matched with the trigger instruction includes:

taking data of a fixed area of the data collaboration document as the data processing result; or the like, or, alternatively,

and taking the data of the recombination region of the data collaboration document as the data processing result.

Further, before receiving a triggering instruction for a program component, the method further includes:

acquiring a configuration interface;

and setting a program component with a processing task on the configuration interface according to the demand data.

Further, the setting a program component with a processing task on the configuration interface according to the demand data includes:

determining subtask operation steps of the processing task based on the demand data;

and generating a processing subtask set according to the subtask operation steps, and configuring a program component for the processing subtask set, wherein the processing subtask set comprises processing subtasks matched with the subtask operation steps.

Further, the generating a processing subtask set according to the subtask operation step and configuring a program component for the processing subtask set includes:

receiving the processing subtask set based on the configuration interface, and storing the processing subtask set as a configuration item in the program component; or the like, or, alternatively,

and starting screen recording for performing the subtask operation step on the data, analyzing the video image data obtained by screen recording into the processing subtask set, and storing the analyzed processing subtask set as a configuration item in the program component.

Further, the method further comprises:

and under the condition that the data collaboration document is in multi-user team collaboration, performing sharing operation on the program component to enable team members of the data collaboration document to view and/or trigger the program component.

Further, the method further comprises:

in the event that the team member has a first operating privilege, the processing tasks for the program component can be modified.

According to an aspect of the present invention, there is provided another data processing method, including:

receiving a trigger instruction, and determining a program component operated by the trigger instruction;

acquiring a processing task of the program component;

analyzing the processing task, restoring a processing subtask of the processing task, and executing the processing subtask on data to obtain a data processing result;

and outputting the data processing result.

Further, the executing the processing subtask on the data to obtain a data processing result includes:

determining a processing sequence identifier matched with a processing subtask of the processing task;

setting the sequence of the processing sequence identifiers according to the task steps to be executed of the processing tasks, and executing the processing subtasks matched with the processing sequence identifiers to the data in an iterative manner according to the sequence of the processing sequence identifiers;

and after the processing subtasks which are sequenced to be the last bit and matched with the processing sequence identifiers are executed, taking the obtained data as the data processing result.

Further, before the processing subtask is executed on the data and a data processing result is obtained, the method further includes:

all data of the current version of the data collaboration document is obtained.

According to another aspect of the present invention, there is provided a data processing apparatus, including:

the receiving module is used for receiving a trigger instruction of the program component;

the acquisition module is used for acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction so as to process a data processing task on the data of the data cooperation document;

and the display module is used for displaying the data processing result on the data cooperation document.

According to an aspect of the present invention, there is provided an electronic apparatus including: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the processing method of the data or the processing method of the other data.

According to an aspect of the present invention, there is provided a computer-readable storage medium, in which at least one executable instruction is stored, and the executable instruction causes a processor to execute an operation corresponding to the above-mentioned one data processing method or the above-mentioned another data processing method.

By the technical scheme, the technical scheme provided by the embodiment of the invention at least has the following advantages:

the invention provides a data processing method and device, electronic equipment and a storage medium, wherein the embodiment of the invention receives a trigger instruction of a program component through a client; acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to perform a processing task on data of the data collaboration document; and displaying the data processing result in the data collaboration document. The data processing operation is triggered and completed by one-time operation, the complex artificial data processing operation is replaced, the complex data processing steps are simplified, the reusability of complex data processing is realized, and the error of artificial manual processing is avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.

Drawings

Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:

fig. 1 is a flowchart illustrating a first data processing method according to an embodiment of the present invention;

FIG. 2 is a flow chart of a second data processing method according to an embodiment of the present invention;

FIG. 3 is a schematic diagram illustrating a configuration interface trigger control according to an embodiment of the present invention;

FIG. 4 is a schematic diagram illustrating a manually created configuration interface according to an embodiment of the present invention;

fig. 5 is a schematic diagram illustrating a screen recording creation configuration interface according to an embodiment of the present invention;

fig. 6 is a schematic diagram illustrating a sub-task operation step screen recording according to an embodiment of the present invention;

FIG. 7 is a flow chart of a third data processing method according to an embodiment of the present invention;

FIG. 8 illustrates a trigger diagram for the undelivered order program component of customer 1 according to an embodiment of the present invention;

FIG. 9 is a schematic diagram illustrating the result of processing data of an undelivered order of customer 1 according to an embodiment of the present invention;

FIG. 10 is a flowchart illustrating a fourth data processing method according to an embodiment of the present invention;

FIG. 11 is a flow chart of a fifth data processing method according to an embodiment of the present invention;

FIG. 12 is a schematic diagram of a data processing apparatus according to an embodiment of the present invention;

fig. 13 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

In order to satisfy the requirement of a user for simple and direct acquisition of required data and omit redundant operations, an embodiment of the present invention provides a data processing method, which is applied to a client, and as shown in fig. 1, the method includes:

step 101, receiving a trigger instruction for a program component.

And 102, acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to process a data processing task of the data collaboration document.

103. And displaying the data processing result in the data collaboration document.

The display style of the program component includes, but is not limited to, a control, a plug-in, a logo, an icon, and the like, and the program component may be disposed in a toolbar, such as a menu bar, of the data collaboration document application (i.e., the data collaboration document), or may be separately disposed on a display interface of the client. The display interface of the client can be displayed in the form of an applet icon. The data of the data collaboration document may be automatically processed by launching a program component. The program component is a tool/function for processing data of the data collaboration document, and the processing may be screening, sorting, and the like of the data collaboration document. The trigger instruction is an instruction for starting the program component, and the trigger instruction may be a click and selection operation of the user on the program component by using a mouse, a keyboard, or the like, or may also be a click and selection operation of the user on the program component by using a finger, or the like, on a touch display screen of the client. When the user triggers the program component by, for example, clicking, the client as the current execution subject receives a clicking operation on the program component, thereby starting the program component to process the data of the data collaboration document.

The client refers to a mobile phone, a computer, a tablet computer, a mobile phone with a touch display screen, a computer and the like with a display interface.

The client obtains a data processing result matched with the trigger instruction based on the program component, namely the processed data processing result is a response to the trigger instruction. Wherein, a configured program component corresponds to a data processing result, that is, for example, if a user starts the program component a, the data processing result a corresponding to the program component a is obtained; and if the user starts the program component B, the data processing result B corresponding to the program component B is obtained. Therefore, when the user triggers, the corresponding program component can be triggered according to different processing requirements, and the current client receives a trigger instruction of the required program component. And the data processing result is obtained by performing one-time operation on the trigger instruction to process the data of the data cooperation document. The one-time operation refers to selecting and clicking the trigger instruction once. The data processing result is data obtained by processing the data of the data collaboration document. The processing task includes a plurality of processing sub-tasks, which may be manipulation steps for processing data of the data collaboration document. That is, the processing task includes a plurality of operation steps for processing data of the data cooperation document, for example, a filtering processing task, an ascending processing task, and the like. By one-time operation of the trigger instruction, execution of a plurality of operation steps can be automatically realized, and time for manually executing the steps one by one is saved. Through the one-time operation, the finally determined data processing result can be directly displayed on the display interface of the client, corresponding data display is not needed according to each operation step, and the efficiency of acquiring required data by a user is improved.

In the embodiment of the invention, the client of the current execution main body is an operation end for loading the data cooperation document so as to process the data by combining the data cooperation document. The data to be displayed can be displayed in the data collaboration document, that is, the data to be displayed can be defined in the data collaboration document according to the row ID or the column ID, wherein the data displayed in the data collaboration document is stored in each storage space in a manner of a data entry set, so that when the data processing is required, the data is displayed in rows or columns according to different data row IDs or column IDs, and at this time, the data row ID or column ID required for displaying the data in the data collaboration document is used for representing the identity ID corresponding to each data, so that the data is displayed in each data row ID or column ID in the data collaboration document.

It should be noted that, in order to satisfy the requirement that a user selects different program components to implement different processing modes for data, the program component includes a plurality of processing subtasks, each processing subtask can be understood as an operation step, and the operation step includes, but is not limited to, screening, sorting, summing, maximum value solving, minimum value solving, and the like, so that after the program component is triggered, the data is automatically processed according to the processing subtasks in the program component to obtain a data processing result.

In the embodiment of the present invention, after receiving a trigger instruction for a program component, an obtained data processing result is obtained by performing one operation on the trigger instruction, that is, after completing only one trigger operation, performing all processing subtasks on data, where a processing task includes a plurality of processing subtasks, and each processing subtask is a data processing operation for executing one processing step, such as a screening processing subtask, a sorting processing subtask, and the like. The one-time operation on the trigger instruction can be one-time clicking, one-time double-clicking or one-time dragging and the like, so that after the one-time operation on the trigger instruction is reflected, the processing operation of a plurality of processing subtasks is automatically carried out on the data in the data collaboration document, and the automatically completed data processing result is obtained. At this time, the data processing result is different according to the difference of a plurality of processing subtasks in different processing tasks, and the obtained data processing result is one data processing result obtained after the data processing is completed by aiming at the plurality of processing subtasks, so that a plurality of processing steps are manually operated in the data processing process. In addition, each processing subtask of each processing task is provided with a processing sequence identifier, and when each processing subtask is executed, the processing subtasks are executed in sequence according to the sequence of the processing sequence identifier of each processing subtask, and each time one processing subtask is executed, corresponding processing operation is performed on the data of the data collaboration document.

It should be noted that, since the data in the data collaboration document may be stored or updated by the server, after receiving the trigger instruction, the obtained data processing result is a data processing result obtained after data processing is performed according to a plurality of processing subtasks in the server, and is directly displayed in the current client.

In the embodiment of the invention, after the data processing result is obtained, the data processing result is displayed in the data cooperation document in the current client, at this time, because the data has the data ID (namely, the row ID or the column ID), correspondingly, the displayed data processing result is also displayed with the data ID in the row or the column in the data cooperation document, and therefore, the high-efficiency practicability of the data processing result in the data cooperation document is realized.

In an embodiment of the present invention, for further limitation and description, the obtaining of the data processing result matched with the trigger instruction includes: taking data of a fixed area of the data collaboration document as a data processing result; or, the data of the reorganization area of the data collaboration document is used as the data processing result.

In the embodiment of the invention, the processed data can be the data of a fixed area of a certain part of the data cooperation document; alternatively, the processed data may be data of a recombined region of a row and/or column subgroup of the data collaboration document. Therefore, after the processing task is executed on the data, the data of the fixed area or the reorganization requirement is used as the data processing result. The fixed area may be partial data of original rows and columns of the data collaboration document, for example, the data collaboration document is a transverse document, and the number of rows is taken as a reference, for example, 5 rows are included, and the fixed area may be partial data intercepted from the 5 rows of data collaboration document under the condition that the display interface of the 5 rows of data collaboration document is not changed, for example, may be all data of the 2 nd row to the 3 rd row; alternatively, all the data of the 2 nd row to the 4 th row, and the like may be possible. For example, if the data collaboration document is a vertical document, the number of columns is taken as a reference, for example, 8 columns are included, and the fixed area may be a part of data intercepted from the 8 columns of data collaboration document under the condition that the display interface of the data collaboration document is not changed, for example, all data in the 4 th column to the 6 th column; alternatively, all the data in the 1 st to 3 rd columns may be used. The data in the fixed area is not changed in data content or data amount until data processing is not performed.

It should be noted that "horizontal direction" and "horizontal direction" refer to a direction parallel to the upper and lower boundary lines of a page of a paper document or an electronic document, and it is understood that the direction is a direction in which a user normally browses. The terms "vertical direction" and "longitudinal direction" in the present invention refer to a direction parallel to the left and right boundary lines of a paper document or an electronic document page, corresponding to the "horizontal direction". It is to be understood that the "vertical direction" is perpendicular to the "horizontal direction" in the present invention. The horizontal document is a document in which data is listed in a horizontal direction, that is, the attributes to which the data in the respective cells in the horizontal direction depend are different, and the attributes may be determined according to, for example, a title; the vertical document is a document in which data is listed in a vertical direction, that is, the attribute to which the data in each cell in the vertical direction is subordinate is different, and the attribute may be determined according to, for example, a title.

When a processing task of data is executed, the data is processed according to processing subtasks such as sorting, screening, maximum value, minimum value, etc., and the obtained data processing result is the data of a certain part of the fixed area of the data collaboration document, so after the execution of the processing subtask is completed, the data in the fixed area is taken as the data processing result.

The restructuring region may be data obtained by adjusting original rows and columns of the data collaboration document, for example, if the data collaboration document is a horizontal document, based on the row number, for example, 5 rows are included, the restructuring region may be a display interface of the 5 rows of data collaboration document, where the 1 st row and the 4 th row are spliced to two adjacent rows, and the 2 nd row to the 3 rd row and the 5 th row are hidden and not displayed, or the 2 nd row and the 5 th row are spliced to two adjacent rows, and the 1 st row and the 3 rd row to the 4 th row are hidden and not displayed, and the like. For example, if the data cooperation document is a vertical document, the number of columns is taken as a reference, and the data cooperation document includes, for example, 8 columns, and the recombination region may be, for example, a display interface of the data cooperation document of the 8 columns, the 2 nd column and the 5 th column are spliced to two adjacent columns, and the 1 st column, the 3 rd to 4 th columns, and the 6 th to 8 th columns are hidden and not displayed.

The rows and columns identify the rows with row IDs and the columns with column IDs. And after the execution of the processing subtask is finished, taking the data in the recombination region as a data processing result.

For further definition and explanation, in an embodiment of the present invention, as shown in fig. 2, before receiving a trigger instruction for a program component, a method provided by the present invention further includes:

step 201, obtaining a configuration interface;

step 202, setting a program component with a processing task on a configuration interface according to the required data.

In order to meet the use requirements of different data and simplify the complexity of processing data so as to meet the reusability requirements of different data processing, before a trigger instruction for a program component is received, the program component needs to be configured, that is, a plurality of triggerable program components are provided, so that a user can select and pertinently select a proper program component at one time according to the respective use requirements.

Specifically, there are two ways to configure program components. One way is that: the current client acquires a configuration interface to display the configuration interface to a user, so that an operator (namely the user) inputs the required data. And the configuration interface correspondingly adapts the processing task capable of obtaining the demand data according to the acquired demand data input by the user, and sets the processing task for the program component. The other mode is as follows: and selecting an adaptive processing task on the configuration interface, obtaining the required data through the processing task, and setting the processing task to the program component. Wherein: the configuration interface is an interface used for instructing a user to set the program component, and the interface can comprise condition contents such as data attributes, data fields, data logic and the like of a plurality of processing subtasks expected to be executed on data, so that the program component with the processing tasks can be set on the configuration interface according to different required data. The demand data is data that the user desires to be finally presented on the display interface.

Different configuration modes can be shown in the configuration interface, so that a user can create program components based on different configuration modes, for example, by triggering a configuration interface trigger control shown in fig. 3, such as "+ add an shortcut tool", a data collaboration document in the current client displays a manual creation configuration interface shown in fig. 4, the user creates program components based on entering or selecting configuration items, and sets program components with processing tasks in the configuration interface based on processing tasks of corresponding required data. For another example, as shown in fig. 5, a configuration interface is created by screen recording, and a user sets a program component with a processing task on the configuration interface based on screen recording operation records, as shown in the screen recording schematic diagram of the subtask operation steps in fig. 6.

For further definition and explanation, in an embodiment of the present invention, as shown in fig. 7, step 202 is to set a program component with a processing task in a configuration interface according to the requirement data, including:

2011, determining subtask operation steps of the processing task based on the demand data;

2012, generating a processing subtask set according to the subtask operation steps, and configuring a program component for the processing subtask set, where the processing subtask set includes a plurality of processing subtasks matched with the subtask operation steps.

In order to automatically execute the processing tasks of the plurality of processing subtasks included in the program component, thereby simplifying the operation steps for data processing and realizing the reusability of data operation, the program component with the processing tasks is set, and specifically, the subtask operation steps of the processing tasks can be determined based on the required data, so as to generate a processing subtask set according to the subtask operation steps. The subtask operation steps are step contents expected to operate on original data of the data cooperation document in the execution data processing process and an execution sequence of each subtask operation step, and the original data of the data cooperation document refers to data to be operated, and may be all original data of the data cooperation document, for example. Each subtask operation step is determined based on an acquisition process from raw data of the data collaboration document to the demand data. And generating a processing subtask set according to the content of the subtask operation steps and the execution sequence of the subtask operation steps, and configuring a program component for the processing subtask set. Specifically, the subtask operation steps are matched with the corresponding processing subtasks, so that the processing subtasks are added to the processing subtask set. For example, if there are 8 subtask operation steps, 8 processing subtasks are generated in a one-to-one correspondence. And 5 subtask operation steps are performed, so that 5 processing subtasks are generated in a one-to-one correspondence manner. Each processing task comprises a plurality of processing sub-tasks.

Each processing subtask is executed according to the execution sequence of the corresponding subtask operation steps, for example, taking fig. 3 as an example, if the demand data is sorted according to the quantity of the non-shipped orders of the buyer 1, the corresponding subtask operation step may be the first step (the first subtask operation step): screening the order line with buyer name buyer 1 from all data, the second step (second subtask operation step): screening undelivered order lines from the order lines with all buyer names for buyer 1, a third step (third subtask operation step): the undelivered order lines of buyer 1 are sorted by quantity. And setting a first screening processing subtask according to the first subtask operation step, setting a second screening processing subtask according to the second subtask operation step, setting a sorting processing subtask according to the third subtask operation step, and generating the first screening processing subtask, the second screening processing subtask and the sorting processing subtask into a processing subtask set. The subtask operation steps are used to characterize a specific operation step corresponding to the demand data. The processing subtask set is a summary of each processing subtask corresponding to the acquired demand data. The processing subtask set comprises a plurality of processing subtasks matched with a plurality of different subtask operation steps, wherein the number of the plurality of subtask operation steps is consistent with the number of the processing subtasks, and the plurality of the processing subtasks and the processing subtasks are in one-to-one correspondence, namely one subtask operation step is provided, and one processing subtask is matched correspondingly; and if three subtask operation steps exist, correspondingly matching three processing subtasks. If the number of the subtask operation steps included in the obtained requirement data is multiple, the processing subtask set includes multiple processing subtasks corresponding to the multiple subtask operation steps, for example, the subtask operation step determined by the requirement data 1 is step a, step b, or step d, and the generated processing task subset 1 includes processing subtask a, processing subtask b, and processing subtask d; for example, if the subtask operation steps determined by the requirement data 2 are step a, step c, and step w, the generated processing task subset 2 includes the processing subtask a, the processing subtask c, and the processing subtask w.

It should be noted that, for the purpose of achieving reusability of data processing, after a processing subtask set is generated, a program component is configured for the processing subtask set, that is, a plurality of processing subtasks are combined according to required data to obtain a processing subtask set, and a corresponding program component is configured for the processing subtask set. For example, the processing subtask a, the processing subtask b, and the processing subtask d corresponding to the requirement data 1 are generated as a processing subtask set 1, and the program component 1 is configured for the processing subtask set 1. The plurality of processing subtasks included in the program component 1 are a plurality of processing subtasks that have been sorted and combined in the order of the subtask operation steps. In this way, after receiving the trigger instruction of the program component, data processing is performed based on the plurality of processing subtasks corresponding to the program component. The subtask operation step pointer indicates a specific operation step corresponding to the required data.

In an embodiment of the present invention, for further definition and explanation, generating a processing subtask set according to the subtask operation steps, and configuring program components for the processing subtask set, includes:

receiving a processing subtask set based on a configuration interface, and storing the processing subtask set as a configuration item in a program component; or the like, or, alternatively,

and starting screen recording for performing a subtask operation step on the data, analyzing the video image data obtained by screen recording into a processing subtask set, and storing the analyzed processing subtask set as a configuration item in a program component.

Specifically, since the user can set the program component through the configuration interface, in order to meet configuration requirements of different users, thereby realizing reusability of the program component and simplifying setting operation of the program component, the processing subtask set may be received based on the configuration interface, so that the processing subtask set is stored in the program component as a configuration item, thereby obtaining the program component including a plurality of processing subtasks. Or, a subtask operation step of recording user operation based on screen recording may be further performed, where video image data obtained based on screen recording is analyzed into a processing subtask set, and the analyzed processing subtask set is stored in the program component as a configuration item. The processing subtask set comprises a plurality of processing subtasks corresponding to the plurality of subtask operation steps, so that the current client can directly receive the processing subtask set based on the configuration interface and store the processing subtask set in the program component as a configuration item, so that the processing is performed according to each processing subtask stored in the program component when the program component is triggered.

In the embodiment of the present invention, for the screen recording (i.e., screen recording) process shown in fig. 6, a requirement identifier is configured for at least one configuration item, where the requirement identifier is used to mark a selected configuration item at a video frame in the obtained video image data, so as to analyze a processing subtask set matched with the configuration item in combination with an image data processing technology.

In order to realize that a processing subtask set in video image data obtained based on screen recording is stored in a program component as a configuration item, before recording, a requirement identifier is configured for at least one configuration item so as to analyze each processing subtask in the processing subtask set selected in screen operation recording. Each processing subtask in the processing subtask set includes, but is not limited to, operations such as screening, sorting, grouping, and the like, and configures a requirement identifier for different configuration items, so that in the screen recording process, a requirement identifier is marked at a position of a corresponding video frame in video image data, and it is determined that a user selects the corresponding processing subtask as a configuration item of the processing subtask set in the recording process. Different requirement identifiers can be configured for different configuration items, so that the processing subtask set corresponding to the configuration items is further identified after the configuration items are determined, for example, the configuration items corresponding to the names of buyers are configured with a default requirement identifier of 0, and when the user selects the configuration item, the requirement mark is marked as 1, so that the user is determined to select the configuration item.

For example, as shown in the screen recording process diagram of fig. 6, the requirement identifiers a and b may be configured for configuration items such as names and states of buyers, respectively, so that when recording a video image, a mark is made at a video frame in the obtained video image data to select a configuration item, and after the user determines that recording is completed, a processing subtask set is determined based on the video frame marked by the requirement identifier and the configuration item corresponding to the requirement identifier.

In an embodiment of the present invention, for further limitation and description, the set of video image data parsing and processing subtasks recorded based on screen operations includes: identifying at least one requirement identification and a video frame for processing data from video image data obtained by completing screen operation recording, determining a configuration item corresponding to the requirement identification, and determining a processing subtask set corresponding to the configuration item based on an image identification technology; or if the requirement identification is detected in the screen operation recording process, recording the configuration item matched with the requirement identification, and selecting the processing subtask set matched with the configuration item.

In the embodiment of the invention, the analysis of the conditional contents of the screen recording can be performed based on the obtained video image data after the screen operation recording is completed, or based on the real-time detection requirement identification in the screen operation recording process.

Specifically, if the analysis is performed based on the obtained video image data after the screen operation recording is completed, at least one requirement identifier and a video frame for processing the data are identified from the video image data obtained by completing the screen operation recording, that is, when the requirement identifier is determined to be detected, the video frame at the moment when the user selects the configuration item is determined, so that the processing subtask set is determined based on the image recognition technology. At this time, the content of the recognition condition based on the image recognition technology is the content which is determined from the video frame image and selected from the configuration items by the user, and the comparison recognition can be carried out according to the preset appointed image of each processing subtask in the recognition process, so as to determine the processing subtask set.

Specifically, if the analysis is performed based on the real-time detection of the requirement identifier in the screen operation recording process, the configuration items matched with the requirement identifier are recorded, and the processing subtask set matched with the configuration items is selected, that is, when the requirement identifier is determined to be detected, the configuration items matched with the requirement identifier at this moment are recorded, and the processing subtask set corresponding to the configuration items selected by the user at this moment is recorded at the same time, so that the processing subtask set is determined in a manner of recording the user behavior after the requirement identifier is detected in real time, and the processing subtask set is stored in the program component as the configuration items.

In the embodiment of the invention, the user can be instructed to input the operation codes of the subtask operation steps while the configuration interface is displayed in the current client. And generating a processing subtask set comprising a plurality of processing subtasks based on the operation codes, and directly storing each operation code in a configuration item of the program component when the program component is configured so as to execute the code script to realize the execution of the processing subtasks.

In an embodiment of the present invention, for further definition and explanation, the method further includes: in the case of a data collaboration document in multi-user team collaboration, a sharing operation is performed on the program component to enable team members of the data collaboration document to view and/or trigger the program component.

In order to meet reusability of the program components, expand use effectiveness of the program components and improve convenience of data processing, a plurality of user teams can share the program components in a state of collaborating the data collaboration document, and the program components are used for collaborating data displayed by the data collaboration document. When the data collaboration document is in multi-user team collaboration, the program components are shared, namely the program components are shared to the client side of one or more users in the team, so that the one or more users in the team can view the program components and/or trigger the program components of the data collaboration document.

It should be noted that, the sharing operation of the program components may be to distribute the program components configured in the current server to the clients belonging to other users in a team, or to instruct the server to display all the program components in the data collaboration document in the client belonging to a team after storing the configured program components, so that the user can view or trigger the program components.

In an embodiment of the present invention, for further definition and explanation, the method further includes: in the case where the team member has the first operation authority, the processing task of the program component can be modified.

In order to meet the processing requirements of different users on data and simplify the operation complexity of data processing, under the condition that team members have a first operation authority, the processing tasks of the program components can be modified. The first operation authority is used for representing that the team user has the authority of modifying the program component. The modification authority of the team user on the program component can be configured for each member according to actual needs. Since the program component includes a plurality of processing subtasks, the modification of the program component is a modification of the processing subtasks.

In a specific real-time scenario, all data are displayed in the data collaboration document, after the user configures the program component of "buyer 1 does not ship order" based on the configuration interface, as shown in fig. 8, the user wants to click on the control of "buyer 1 does not ship order", and the current client receives the trigger instruction of "buyer 1 does not ship order", at this time, the data processing result executed by each processing sub-task in the program component of "buyer 1 does not ship order" is directly obtained based on one operation of the trigger instruction on the program component, and the data processing result (i.e. the data of the buyer 1 does not ship order) is displayed in the data collaboration document, as shown in fig. 9. Therefore, a plurality of manual operation steps can be converted into one step, operation steps are reduced, required data can be efficiently acquired, and data processing efficiency is improved. And completing the execution of a plurality of processing subtasks by one-key triggering.

The embodiment of the invention provides a data processing method, which comprises the steps of receiving a trigger instruction of a program component through a client; acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to perform a processing task on data of the data collaboration document; the data processing result is displayed in the data cooperation document, the data processing operation is triggered and completed by one-time operation, the complex artificial data processing operation is replaced, the complex data processing steps are simplified, the reusability of complex data processing is realized, and the error of artificial manual processing is avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

An embodiment of the present invention provides another data processing method, which is applied to a server, and as shown in fig. 10, the method includes:

step 301, receiving a trigger instruction, and determining a program component for triggering instruction operation.

In the embodiment of the invention, the server receives the trigger instruction sent by the user through the client. The server stores each generated program component, and determines the program component operated by the trigger instruction under the condition of receiving the trigger instruction. Processing tasks are configured in the program components, one processing task comprising a plurality of processing sub-tasks. And after receiving a trigger instruction for the program component, performing data processing based on the processing task of the program component. The received trigger instruction is determined based on one operation of the program component by the client, for example, one click operation is performed on the program component.

The display form of the program component includes but is not limited to a control, a plug-in, a mark, an icon and the like, and the program component can be arranged in a tool bar of the data collaboration document in the client, such as a menu bar; or may be a tool icon or the like separately configured for display on the client interface. In this way, the user may be facilitated to view the program components.

The current execution end is a server end, and stores various generated program components and a plurality of processing subtasks configured in the program components.

Step 302, acquiring a processing task of the program component.

In an embodiment of the present invention, the processing task includes a plurality of processing sub-tasks, and each processing sub-task performs a data processing operation of a processing function, such as a screening processing sub-task, a sorting processing sub-task, and the like. Because the current server stores processing tasks corresponding to various configured program components, the processing tasks corresponding to the program components can be acquired after the program components for triggering the instruction operation are determined.

And 303, analyzing the processing task, restoring the processing subtask of the processing task, and executing the processing subtask on the data to obtain a data processing result.

In the embodiment of the invention, after the processing task is obtained, the processing task is analyzed, and a plurality of processing subtasks in the processing task are restored to execute each processing subtask on the data, so that a data processing result is obtained. Each processing subtask is a data processing operation for executing a processing step, such as a screening processing subtask, a sorting processing subtask, and the like, and therefore, when the processing task is analyzed, the processing subtask is restored according to each processing subtask, that is, the processing sequence including the restored processing subtask is included, so that corresponding processing is executed on the data according to the processing subtask obtained by restoration, and a processing result is obtained, for example, when 2 processing subtasks are included in the program component, the processing subtask 2 is analyzed and restored, so that the sorting processing subtask and the screening processing subtask are obtained, and the data is processed based on the sorting processing subtask and the screening processing subtask. The restoring means determining and acquiring each processing subtask and corresponding sequencing of the processing tasks.

It should be noted that the data in the embodiment of the present invention is data that can be displayed in the data collaboration document, and at this time, the data carries different data IDs, so that the data that needs to be displayed can be defined in the data collaboration document according to the row ID or the column ID.

And step 304, outputting a data processing result.

And after the current server side obtains the data processing result, outputting the data processing result to the client side so as to display the data processing result in the data collaboration document in the client side.

For further limitation and description, as shown in fig. 11, in an embodiment of the present invention, the performing a processing sub-task on data to obtain a data processing result includes:

3031. determining a processing sequence identifier matched with a processing subtask of a processing task;

3032. setting the sequence of the processing sequence identifiers according to the task steps to be executed of the processing tasks, and performing iterative execution on the data according to the sequence of the processing sequence identifiers to process the processing subtasks matched with the processing sequence identifiers;

3033. and after the processing subtasks which are sequenced to be the last bit and matched with the processing sequence identifiers are executed, taking the obtained data as a data processing result.

In the embodiment of the invention, the processing task of the program component comprises a plurality of processing subtasks, and each processing subtask is provided with a processing sequence identifier. And setting the sequencing of the processing sequence identifiers according to the task steps to be executed of the processing tasks, so as to iteratively execute each processing subtask on the data according to the sequencing. Since the subtask operation steps are characterized as specific operation steps corresponding to the required data, the task step to be executed is an operation step confirmed by the user in the current client, so as to process the data in anticipation of the user according to the task step to be executed. Therefore, when the reduction processing subtask performs data processing, the processing sequence identifier matching with the processing subtask is determined first to set the ordering of the processing sequence identifier. The processing sequence identifier is an identity identifier of each processing subtask, and is used for uniquely determining the processing subtask, and setting the sequence of the processing sequence identifier in combination with a task step to be executed, which is an operation step confirmed by a user in the current client, namely determining the sequence of each processing subtask according to the operation step confirmed by the user, and iteratively executing each processing subtask according to the sequence.

It should be noted that the task step to be executed in the embodiment of the present invention is an operation step of a processing task selected by a user, and is a known and confirmed step. The iterative execution is to execute each processing sub-task in the order identified by the processing sequence. Specifically, after the processing task is completed by the processing subtask in the previous sequence, a data processing result is obtained, and the obtained data processing result is used as a data processing object of the processing subtask in the next sequence, so that the previous data processing result is sequentially used as a next data processing target, and all the processing subtasks are executed one by one according to the sequence identified by the processing sequence. And after the processing subtasks which are matched with the processing sequence identifier and are sequenced as the last bit are executed, the obtained data is used as a data processing result and is output to the client, and at the moment, the processing sequence identifier of the last bit is the sequencing of the sequence identifier of the last executed processing subtask, so that all the processing subtasks with the execution sequence are completed.

It should be noted that the processing sequence identifier matched with the processing subtask of the processing task is to establish a corresponding relationship between the processing subtask and the processing sequence identifier, where the processing sequence identifier may represent the processing subtask, and the processing subtask may also be marked with the processing sequence identifier. The process sequence identifiers can be numbers, letters, words, and the like, and each process sequence identifier has uniqueness. The sequence refers to a processing sequence identified by a processing sequence set according to an execution sequence of task steps to be executed of the processing task.

In an embodiment of the present invention, for further limitation and description, before performing a processing sub-task on data and obtaining a data processing result, the method provided by the present invention further includes: all data of the current version of the data collaboration document is obtained.

In order to meet the timeliness requirement of data processing, all data of the data collaboration document of the current version is acquired before the processing subtask is executed on the data. In order to ensure the accuracy of the obtained data processing result, when acquiring data, all data of the current latest version of the data collaboration document needs to be acquired as a processing target of the to-be-executed processing subtask. The current version refers to the latest version of the data collaboration document. And the current client acquires all data for display based on the current version, so that all data are processed firstly according to the sequence of the task steps to be executed when each processing subtask is executed.

The embodiment of the invention provides another data processing method, which is applied to a server, and the embodiment of the invention receives a trigger instruction through the server and determines a program component for triggering the instruction operation; acquiring a processing task of a program component; analyzing the processing task, restoring a processing sub-task of the processing task, and executing the processing sub-task on the data to obtain a data processing result; the data processing result is output, simplified data processing operation is realized, complicated manual data processing operation is replaced, reusability of complicated data processing is realized, and errors of manual processing are avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

Further, as an implementation of the method shown in fig. 1, an embodiment of the present invention provides an apparatus for processing data, as shown in fig. 12, the apparatus includes:

a receiving module 41, configured to receive a trigger instruction for a program component;

the obtaining module 42 is configured to obtain a data processing result matched with the trigger instruction, where the data processing result is obtained by performing one operation on the trigger instruction to perform a processing task on data of the data collaboration document;

and a display module 43 for displaying the data processing result in the data collaboration document.

Further, the air conditioner is provided with a fan,

the acquisition module is specifically used for taking data of a fixed area of the data collaboration document as a data processing result; or the like, or, alternatively,

and the acquisition module is specifically used for taking the data of the recombination region of the data cooperation document as a data processing result.

Further, the apparatus further comprises: a module is set up, and the module is used for setting up the module,

the acquisition module is used for acquiring a configuration interface;

and the setting module is used for setting a program component with a processing task on the configuration interface according to the demand data.

Further, the setting module includes:

a determination unit configured to determine a subtask operation step of the processing task based on the demand data;

and the generating unit is used for generating a processing subtask set according to the subtask operation steps and configuring a program component for the processing subtask set, wherein the processing subtask set comprises processing subtasks matched with the subtask operation steps.

Further, the generation unit includes:

the storage subunit is used for receiving the processing subtask set based on the configuration interface and storing the processing subtask set as a configuration item in the program component; or the like, or, alternatively,

and the screen recording module is used for starting the subtask operation step on the data, analyzing the video image data obtained by screen recording into a processing subtask set, and storing the analyzed processing subtask set as a configuration item in the program component.

Further, the apparatus further comprises:

and the operation module is used for carrying out sharing operation on the program component under the condition that the data cooperation document is in multi-user team cooperation so as to enable team members of the data cooperation document to view and/or trigger the program component.

Further, the apparatus further comprises:

and the modification module is used for modifying the processing task of the program component under the condition that the team member has the first operation authority.

The embodiment of the invention provides a data processing device, which receives a trigger instruction of a program component through a client; acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to perform a processing task on data of the data collaboration document; and displaying the data processing result in the data collaboration document. The data processing operation is triggered and completed by one-time operation, the complex artificial data processing operation is replaced, the complex data processing steps are simplified, the reusability of complex data processing is realized, and the error of artificial manual processing is avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

Further, as an implementation of the method shown in fig. 10, an embodiment of the present invention provides a data processing apparatus, including:

the other receiving module is used for receiving the triggering instruction and determining a program component for triggering the instruction operation;

another obtaining module, which is used for obtaining the processing task of the program component;

the other analysis module is used for analyzing the processing task, restoring the processing subtask of the processing task, and executing the processing subtask on the data to obtain a data processing result;

and the other output module is used for outputting the data processing result.

Further, another parsing module includes:

a first determining unit, configured to determine a processing sequence identifier matching a processing sub-task of a processing task;

the setting unit is used for setting the sequencing of the processing sequence identifiers according to the task steps to be executed of the processing tasks and iteratively executing the processing subtasks matched with the processing sequence identifiers on the data according to the sequencing of the processing sequence identifiers;

and the second determining unit is used for taking the obtained data as a data processing result after the processing subtasks which are sequenced into the last bit and matched with the processing sequence identifiers are executed.

Further, another obtaining module is further configured to obtain all data of the data collaboration document of the current version.

According to an aspect of the present invention, there is provided an electronic apparatus including: the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the data processing method.

The embodiment of the invention provides another data processing device, and the embodiment of the invention receives a trigger instruction through a server and determines a program component for triggering the instruction operation; acquiring a processing task of a program component; analyzing the processing task, restoring a processing sub-task of the processing task, and executing the processing sub-task on the data to obtain a data processing result; the data processing result is output, the operation of data processing is executed by the program component, the complex manual data processing operation is simplified, the reusability of the data processing operation is realized, and the error of manual processing is avoided, so that the data processing efficiency is improved, and the data processing is more convenient and flexible.

Fig. 13 is a schematic structural diagram of an electronic device according to an embodiment of the present invention, and the specific embodiment of the present invention does not limit the specific implementation of the terminal.

As shown in fig. 13, the terminal may include: a processor (processor)602, a communication Interface 604, a memory 606, and a communication bus 608.

Wherein: the processor 602, communication interface 604, and memory 606 communicate with one another via a communication bus 608.

The memory is used for storing at least one executable instruction, and the executable instruction enables the processor to execute the operation corresponding to the data processing method provided by the invention or the operation corresponding to the other data processing method provided by the invention.

A communication interface 604 for communicating with network elements of other devices, such as clients or other servers.

The processor 602 is configured to execute the program 610, and may specifically perform relevant steps in the above-described query method embodiment of the service data.

In particular, program 610 may include program code comprising computer operating instructions.

The processor 602 may be a central processing unit CPU or an application Specific Integrated circuit asic or one or more Integrated circuits configured to implement embodiments of the present invention. The terminal comprises one or more processors, which can be the same type of processor, such as one or more CPUs; or may be different types of processors such as one or more CPUs and one or more ASICs.

And a memory 606 for storing a program 610. Memory 606 may comprise high-speed RAM memory, and may also include non-volatile memory (non-volatile memory), such as at least one disk memory.

The program 610 may specifically be configured to cause the processor 602 to perform the following operations:

receiving a trigger instruction for a program component;

acquiring a data processing result matched with the trigger instruction, wherein the data processing result is obtained by performing one-time operation on the trigger instruction to perform a processing task on data of the data collaboration document;

and displaying the data processing result in the data collaboration document.

According to an embodiment of the present invention, there is provided a computer-readable storage medium storing at least one executable instruction, the executable instruction causing a processor to execute the method for processing data in any of the above-mentioned method embodiments.

According to an embodiment of the present invention, another computer-readable storage medium is provided, wherein at least one executable instruction is stored in the storage medium, and the computer-executable instruction can execute the data processing method in any method embodiment.

It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.

The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for processing data, comprising:

receiving a trigger instruction for a program component;

and displaying the data processing result in the data cooperation document.

2. The method of claim 1, wherein the obtaining the data processing result matched with the trigger instruction comprises:

3. The method according to claim 1 or 2, wherein before receiving the trigger instruction for the program component, the method further comprises:

acquiring a configuration interface;

4. The method according to claim 3, wherein the setting a program component with a processing task in the configuration interface according to the demand data comprises:

5. The method of claim 4, wherein generating a set of processing subtasks from the subtask operation steps and configuring program components for the set of processing subtasks comprises:

6. The method of claim 1, further comprising:

7. The method of claim 6, further comprising:

8. A method for processing data, comprising:

acquiring a processing task of the program component;

and outputting the data processing result.

9. The method of claim 8, wherein said performing the processing subtasks on the data to obtain a data processing result comprises:

10. The method of claim 8, wherein before the performing the processing subtask on the data results in a data processing result, the method further comprises:

all data of the current version of the data collaboration document is obtained.

11. An apparatus for processing data, comprising:

12. An electronic device, comprising: the system comprises a processor, a memory, a communication interface and a communication bus, wherein the processor, the memory and the communication interface complete mutual communication through the communication bus;

the memory is used for storing at least one executable instruction, and the executable instruction causes the processor to execute the operation corresponding to the data processing method of any one of claims 1-7 or claims 8-10.

13. A computer-readable storage medium having stored therein at least one executable instruction for causing a processor to perform operations corresponding to the method of processing data according to any one of claims 1-7 or claims 8-10.