CN114139510B - Excel table-based process operation method and device, electronic equipment and storage medium - Google Patents
Excel table-based process operation method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114139510B CN114139510B CN202111310853.1A CN202111310853A CN114139510B CN 114139510 B CN114139510 B CN 114139510B CN 202111310853 A CN202111310853 A CN 202111310853A CN 114139510 B CN114139510 B CN 114139510B
- Authority
- CN
- China
- Prior art keywords
- data
- parameters
- cell
- data parameters
- classified
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
- G06F9/4482—Procedural
Abstract
The application discloses a process operation method and device based on excel forms, electronic equipment and a storage medium. The method comprises the following steps: collecting flow data and reading data parameters; classifying the data parameters according to three categories of process names, condition lists and execution steps; converting the classified data parameters into cell data and combining the cell data into a process version; all process versions are arranged in a table in order. The method and the device solve the technical problems that when a large number of processes are implemented, each process needs to be drawn, the implementation consumes time and labor, and the readability of the whole flow chart is very poor when the branch conditions are very many.
Description
Technical Field
The application relates to the field of front-end development, in particular to a flow operation method based on an excel table.
Background
In the current market, the flow operation is usually executed according to the mode of drawing the flow chart, and when a large number of flows are implemented, each flow is drawn, so that the implementation consumes time and labor, and when the branch conditions are very many, the readability of the whole flow chart is very poor. Therefore, a more intuitive and easily implemented batch method is needed to improve the productivity of the whole implementation process.
At present, the prior art on the market has the following defects:
when a large number of processes are implemented, each process needs to be drawn, and the implementation is time-consuming and labor-consuming;
when the branch condition is very much, the legibility of the whole flow chart is very poor.
In the related art, when a large number of processes are implemented, time and labor are consumed, and the whole flow chart is very poor in readability, an effective solution is not provided at present.
Disclosure of Invention
The main objective of the present application is to provide a method for running a process based on an excel table, so as to solve the above problem.
In order to achieve the above object, according to one aspect of the present application, a method for running a process based on an excel table is provided.
The excel table-based process operation method comprises the following steps:
collecting flow data and reading data parameters;
classifying the data parameters according to three categories of process names, condition lists and execution steps;
converting the classified data parameters into cell data and combining the cell data into a process version;
all process versions are arranged in a table in sequence.
Further, the acquiring process data and reading data parameters includes:
reading data parameters according to set keywords, taking punctuation marks as sentence segmentation boundaries, and reading segments with the keywords in the data information as the data parameters.
Further, the classifying the data parameters according to three categories of the process name, the condition column, and the executing step includes:
classifying data parameters with a keyword 'name' into a process name; classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise yes, no, more than and less than; the data parameters of the keyword "person in charge" are classified as the execution steps.
Further, converting the classified data parameters into cell data and combining the cell data into a flow version includes:
s302, identifying the data parameters classified into the process names as process classifications, wherein the cells set under the process classifications comprise process names, process short names and process numbers;
s304, identifying the data parameters classified into the condition columns as branches, wherein the cells arranged under the branches comprise branch names and branch conditions;
s306, identifying the data parameters classified as the execution steps as the steps, wherein the cells set in the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, forming a flow version by the generated cell data according to the sequence of S302, S304 and S306;
and S310, marking the sequence number of the flow version.
Further, converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as process cell data for short;
and taking the unified letter plus number serial number as the data of the flow number cell for the data parameter of the same flow.
Further, converting the data parameters classified into the conditional columns into the cell data includes:
directly taking the data parameters as branch description cell data;
and converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data.
Further, converting the data parameters classified as the performing step into the cell data includes:
the data parameters of the partial execution steps contain operating parameters, the operating parameters existing in the data parameters are identified through a condition engine, and different operational characters are set by different operating parameters to serve as cell data;
corresponding the data parameters with all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
Further, the generated cell data form a flow version according to the sequence of S302, S304, and S306:
the process versions are marked with sequence numbers according to the arrangement sequence.
An excel table-based process operation device comprises:
the data acquisition module is used for acquiring flow data and reading data parameters;
the data classification module is used for classifying the data parameters according to three categories of process names, condition lists and execution steps;
the data conversion module is used for converting the classified data parameters into cell data and combining the cell data into a process version;
and the data output module is used for arranging all the process versions into a table in sequence.
Furthermore, the data acquisition module reads data parameters according to set keywords, takes punctuation marks as sentence segmentation boundaries, and reads segments with the keywords in the data information as the data parameters.
Further, the data classification module classifies the data parameter with the keyword name as a process name;
classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise but are not limited to yes, no, more than and less than;
the data parameters of the keyword "person in charge" are classified as the execution steps.
Further, the conversion method of the data conversion module comprises the following steps:
s302, the data conversion module identifies the data parameters classified as the process names as process classifications, and the cells set under the process classifications comprise process names, process short names and process numbers;
s304, the data conversion module identifies the data parameters classified into the condition columns as branches, and the cells arranged under the branches comprise branch names and branch conditions;
s306, the data conversion module identifies the data parameters classified as the execution steps as the steps, the set cells under the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, the data conversion module makes the generated cell data into a flow version according to the sequence of S302, S304 and S306;
and S310, the data conversion module marks the serial number of the flow version.
Further, the converting the data parameter classified as the process name into the cell data by the data converting module includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as process cell data for short;
the data parameter for the same flow is the unified letter plus number serial number, and the serial number is used as the flow number cell data.
Further, the data conversion module converting the data parameters classified into the conditional columns into the cell data includes:
directly taking the data parameters as branch description cell data;
and converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data.
Further, the converting the data parameters classified as the executing step into the cell data by the data converting module includes:
the data parameters of the partial execution steps contain operating parameters, the operating parameters existing in the data parameters are identified through a condition engine, and different operational characters are set by different operating parameters to serve as cell data;
corresponding the data parameters with all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
An electronic device comprising a memory and a processor, the memory storing a computer program which executes in the processor a method which may implement any of the above methods.
A storage medium storing a computer program, the computer program being executable in the storage medium to implement any of the methods described above.
In the embodiment of the application, the implementation efficiency of the whole process is greatly improved in a mode of running data tables in batches by an engine, the mode that the traditional process diagram is drawn one by one is changed, the processes are presented in a row and column mode in a table form, the processes are very easy to understand, retrieve and adjust, the technical effect of converting the processes into the tables in batches is realized, and the technical problems that the time and the labor are very high and the readability of the whole process diagram is very poor when a large number of processes are implemented in the prior art are solved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, are included to provide a further understanding of the application and to enable other features, objects, and advantages of the application to be more apparent. The drawings and the description of the exemplary embodiments of the present application are provided for explaining the present application and do not constitute an undue limitation on the present application. In the drawings:
fig. 1 is a flowchart of an excel form-based process operation method according to an embodiment of the present application;
FIG. 2 is a flow chart of a method of converting categorized data parameters into cell data and combining into a flow version according to an embodiment of the present application;
FIG. 3 is a table diagram of approval process data generation according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the application described herein may be used. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In this application, the terms "upper", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal", and the like indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings. These terms are used primarily to better describe the invention and its embodiments and are not intended to limit the indicated devices, elements or components to a particular orientation or to be constructed and operated in a particular orientation.
Moreover, some of the above terms may be used to indicate other meanings besides the orientation or positional relationship, for example, the term "on" may also be used to indicate some kind of attachment or connection relationship in some cases. The specific meanings of these terms in the present invention can be understood by those skilled in the art as appropriate.
Furthermore, the terms "mounted," "disposed," "provided," "connected," and "coupled" are to be construed broadly. For example, it may be a fixed connection, a removable connection, or a unitary construction; can be a mechanical connection, or an electrical connection; may be directly connected, or indirectly connected through intervening media, or may be in internal communication between two devices, elements or components. The specific meanings of the above terms in the present invention can be understood according to specific situations by those of ordinary skill in the art.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
According to an embodiment of the present invention, as shown in fig. 1, there is provided a process operation method based on an excel form, including the steps of:
s100, collecting flow data and reading data parameters, reading the data parameters according to set keywords, taking punctuation marks as sentence segmentation boundaries, and reading segments with the keywords in the data information as the data parameters.
S200, classifying the data parameters according to three categories of process names, condition columns and execution steps:
classifying the data parameter with the keyword 'name' as a process name;
classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise but are not limited to yes, no, more than and less than;
the data parameters of the keyword "person in charge" are classified as the execution steps.
And S300, converting the classified data parameters into cell data and combining the cell data into a process version.
And S400, arranging all process versions into a table in sequence.
In this embodiment, as shown in fig. 2, S300, converting the classified data parameters into cell data and combining into a flow version includes:
s302, identifying the data parameters classified as the process names as the process classifications, wherein the cells set under the process classifications comprise the process names, the process abbreviations and the process numbers;
s304, identifying the data parameters classified into the condition columns as branches, wherein the cells arranged under the branches comprise branch names and branch conditions;
s306, identifying the data parameters classified as the execution steps as the steps, wherein the cells set in the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, forming a flow version by the generated cell data according to the sequence of S302, S304 and S306;
and S310, marking the serial number of the flow version.
In this embodiment, the step S302 of converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as process cell data for short;
and taking the unified letter plus number serial number as the data of the flow number cell for the data parameter of the same flow.
In this embodiment, the step S304 of converting the data parameters classified into the conditional columns into the cell data includes:
directly taking the data parameters as branch description cell data;
and converting parameters corresponding to the conditional formats in the data parameters into regular expressions through a conditional engine to serve as branch condition cell data.
In this embodiment, the converting the data parameter classified as the execution step into the cell data S306 includes:
the data parameters of part of the execution steps contain operation parameters, the operation parameters existing in the data parameters are identified through a condition engine, and different operation parameters are set as unit grid data;
corresponding the data parameters to all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
From the above description, it can be seen that the present invention achieves the following technical effects:
in the embodiment of the application, the implementation efficiency of the whole process is greatly improved in a mode that the data tables are operated in batches by the engine, and the traditional mode that the traditional flow chart is drawn one by one is changed. The flow presentation is carried out in a form of a table in rows and columns, and the table is very easy to understand, search and adjust.
An embodiment is also included, as shown in fig. 3, the business trip examination and approval process data is used as the process data of the test, and one of the input business trip examination and approval data is:
and in the name testing process, the number of days on business trips is less than 5 days, the regional administrative responsible person examines and approves, the regional personnel responsible person examines and approves, and the regional cost responsible person examines and approves and copies.
The method is operated by the following steps:
s100, collecting flow data and reading data parameters, reading the data parameters according to set keywords, taking punctuation marks as sentence segmentation boundaries, and reading segments with the keywords in the data information as the data parameters.
In this embodiment, the method reads the data parameters obtained from this data: the method comprises the following steps of 'name testing process', 'business trip days are less than 5 days', 'regional administrative responsible person examination and approval', 'regional personnel responsible person examination and approval' and 'regional cost responsible person examination and approval and copying'.
S200, classifying the data parameters according to three categories of process names, condition columns and execution steps:
classifying the data parameter with the keyword 'name' as a process name;
classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise but are not limited to yes, no, more than and less than;
the data parameters of the keyword "person in charge" are classified as the execution steps.
In this embodiment, the method identifies keywords in the data parameters.
In the identification of the keyword 'name', a data parameter 'name test flow' is obtained and classified into a flow name;
in the identification of the keywords 'greater than' and 'less than', a data parameter 'the number of days on business trips is less than 5 days' is obtained, and the data parameter is classified into a condition column;
in the recognition of the keyword "principal", data parameters "approval by regional administrative principal", "approval by regional personnel principal", "approval by regional cost principal and copying" are obtained, and they are classified into execution steps.
And S300, converting the classified data parameters into cell data and combining the cell data into a process version.
S400, arranging all process versions into a table in sequence.
In this embodiment, S300, converting the classified data parameters into cell data and combining into a flow version includes:
s302, identifying the data parameters classified into the process names as process classifications, wherein the cells set under the process classifications comprise process names, process short names and process numbers;
s304, identifying the data parameters classified into the condition columns as branches, wherein the cells arranged under the branches comprise branch names and branch conditions;
s306, identifying the data parameters classified as the execution steps as the steps, wherein the cells set in the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, forming a flow version by the generated cell data according to the sequence of S302, S304 and S306;
and S310, marking the serial number of the flow version.
In this embodiment, the step S302 of converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as process cell data for short;
the data parameter for the same flow is the unified letter plus number serial number, and the serial number is used as the flow number cell data.
In a further embodiment, the method deletes the keyword 'name' in the data parameter 'name test flow', adds a mark ordinal number 0518 when data information is recorded at the tail bit thereof, obtains a 'test flow 0518', and takes the 'test flow 0518' as flow name cell data;
deleting a keyword name in a data parameter name test flow to obtain a test flow which is used as cell data for short;
the data parameter "test flow" for the same flow is obtained by adding a number 001 to a unified letter P to obtain P001, and the P001 is used as flow number cell data.
In this embodiment, the step S304 of converting the data parameters classified into the conditional columns into the cell data includes:
directly taking the data parameters as branch description cell data;
and converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data.
In a further such embodiment, the method directly uses the data parameter "days on business trip less than 5 days" as the branch description cell data;
converting parameters corresponding to the condition format in the data parameter that the business trip days are less than 5 days into regular expressions through a condition engine to obtain [ @: business trip days ] <5 "as branch condition cell data.
In this embodiment, the converting the data parameter classified as the execution step into the cell data S306 includes:
the data parameters of part of the execution steps contain operation parameters, the operation parameters existing in the data parameters are identified through a condition engine, and different operation parameters are set as unit grid data;
corresponding the data parameters with all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
In a further embodiment, the method sets the leader cell by the data parameter category of the executing step: a regional administrative responsible person, a regional personnel responsible person, a regional legal responsible person, a regional marketing responsible person, a regional cost responsible person and a regional engineering responsible person;
the operation parameters set by the method comprise: "approval", "countersigning", "parallel signing", "approval with copying", "finish copying";
in the method, the operation parameter is not approved and has no correspondingly set operational character, the operation parameter can be signed and has a correspondingly set operational character of "#", the operation parameter is signed and has a correspondingly set operational character of "%", the operation parameter is approved and copied and has a correspondingly set operational character of "C", and the operation parameter is finished and has a correspondingly set operational character of "CC";
the method comprises the steps of identifying operating parameters existing in data parameters through a condition engine, enabling the data parameters to correspond to all responsible person cells, enabling regional administrative responsible person examination and approval to correspond to the regional administrative responsible person cells, inputting cell data of 1, enabling regional personnel responsible person examination and approval to correspond to the regional personnel responsible person cells, inputting cell data of 2, enabling regional cost responsible person examination and approval to be copied, enabling the regional cost responsible person examination and approval to correspond to the regional cost responsible person cells, and inputting cell data of C3.
The method also comprises an embodiment, wherein the work proposal flow data is used as the flow data of the test, and one of the input work proposal data is as follows:
and the name testing process is a work plan, the work plan principal is established, the business principal is audited, and the master principal is audited and finished.
The method is operated by the following steps:
s100, collecting flow data and reading data parameters, reading the data parameters according to set keywords, taking punctuation marks as sentence segmentation boundaries, and reading segments with the keywords in the data information as the data parameters.
In this embodiment, the method reads the data parameters obtained from this data: the "name test flow", "is work plan", "work plan principal creation", "business principal audit", and "master principal audit and end".
S200, classifying the data parameters according to three categories of process names, condition columns and execution steps:
classifying the data parameter with the keyword 'name' as a process name;
classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise but are not limited to yes, no, more than and less than;
the data parameters of the keyword "person in charge" are classified as the execution steps.
In this embodiment, the method identifies keywords in the data parameters.
In the identification of the keyword 'name', a data parameter 'name test flow' is obtained and classified into a flow name;
in the recognition of the keywords "yes" and "no", the data parameter "yes work proposal" is obtained, and is classified into a condition column;
in the recognition of the keyword "principal", data parameters "creation of work plan principal", "audit of business principal", "audit of supervisor principal and end" are obtained, and they are classified into execution steps.
And S300, converting the classified data parameters into cell data and combining the cell data into a process version.
And S400, arranging all process versions into a table in sequence.
In this embodiment, S300, converting the classified data parameters into cell data and combining into a flow version includes:
s302, identifying the data parameters classified into the process names as process classifications, wherein the cells set under the process classifications comprise process names, process short names and process numbers;
s304, identifying the data parameters classified into the condition columns as branches, wherein the cells arranged under the branches comprise branch names and branch conditions;
s306, identifying the data parameters classified as the execution steps as the steps, wherein the cells set in the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, forming a flow version by the generated cell data according to the sequence of S302, S304 and S306;
and S310, marking the sequence number of the flow version.
In this embodiment, the step S302 of converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as the process, namely cell data for short;
the data parameter for the same flow is the unified letter plus number serial number, and the serial number is used as the flow number cell data.
In a further embodiment, the method deletes the keyword "name" in the data parameter "name test flow", and adds a tag ordinal number 0400 when data information is recorded at the end thereof to obtain a "test flow 0400", which is used as flow name cell data;
deleting the keyword name in the data parameter name test flow to obtain a test flow which is used as cell data for short;
the data parameter "test flow" for the same flow is obtained by adding a number 001 to a unified letter P to obtain P001, and the P001 is used as flow number cell data.
In this embodiment, the step S304 of converting the data parameters classified into the conditional columns into the cell data includes:
directly taking the data parameters as branch description cell data;
and converting parameters corresponding to the conditional formats in the data parameters into branch condition cell data through a conditional engine.
In a further such embodiment, the method describes the data parameter "is a work proposal" directly as a branch to describe the cell data;
and converting the parameter corresponding to the condition format in the data parameter 'is work proposal' into 'yes' through the condition engine to be used as the branch condition cell data.
In this embodiment, the step S306 of converting the data parameter classified as the execution step into the cell data includes:
the data parameters of part of the execution steps contain operation parameters, the operation parameters existing in the data parameters are identified through a condition engine, and different operation parameters are set as unit grid data;
corresponding the data parameters to all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
In a further such embodiment, the method sets the leader cell by the data parameter category of the executing step: establishing a work plan principal, auditing a business principal, auditing a master principal and finishing;
the operation parameters set by the method comprise: "create", "audit and end";
in the method, the operational parameter "create" is set corresponding to an operator of "! "the operation parameter" audit "has no correspondingly set operator, and the operation parameter" audit and end "the correspondingly set operator is" +;
the method identifies the operation parameters in the data parameters through a condition engine, corresponds the data parameters to all the cells of the responsible persons, establishes the working plan responsible persons and corresponds to the cells of the working plan responsible persons, and inputs cell data! 1, the business responsible person audit corresponds to the cell of the business responsible person, the cell data 2 is input, the main responsible person audit and finish corresponds to the cell of the main responsible person, and the cell data 3 is input.
Still include an embodiment, a flow operating device based on excel form includes:
the data acquisition module is used for acquiring flow data and reading data parameters;
the module reads data parameters according to set keywords, takes punctuation marks as sentence segmentation boundaries, and reads segments with the keywords in the data information as the data parameters.
The data classification module is used for classifying the data parameters according to three categories of process names, condition columns and execution steps;
the module classifies the data parameter with the keyword 'name' as a process name;
classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise but are not limited to yes, no, more than and less than;
the data parameters of the keyword "person in charge" are classified as the execution steps.
The data conversion module is used for converting the classified data parameters into cell data and combining the cell data into a process version;
and the data output module is used for arranging all the process versions into a table in sequence.
In this embodiment, the conversion method of the data conversion module:
s302, the data conversion module identifies the data parameters classified as the process names as the process classifications, and the cells set under the process classifications comprise the process names, the process shortages and the process numbers;
s304, the data conversion module identifies the data parameters classified into the condition columns as branches, and the cells arranged under the branches comprise branch names and branch conditions;
s306, the data conversion module identifies the data parameters classified as the execution steps as the steps, the set cells under the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, the data conversion module forms the generated cell data into a flow version according to the sequence of S302, S304 and S306;
and S310, the data conversion module marks the serial number of the process version.
In this embodiment, the converting the data parameter classified as the flow name into the cell data by the data converting module includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as the process, namely cell data for short;
and taking the unified letter plus number serial number as the data of the flow number cell for the data parameter of the same flow.
In this embodiment, the data conversion module converting the data parameters classified into the conditional columns into the cell data includes:
directly using the data parameters as branch description cell data;
and converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data.
In this embodiment, the data conversion module converting the data parameters classified as the execution steps into the cell data includes:
the data parameters of part of the execution steps contain operation parameters, the operation parameters existing in the data parameters are identified through a condition engine, and different operation parameters are set as unit grid data;
corresponding the data parameters to all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
Also included is an embodiment, an electronic device comprising a memory and a processor, the memory storing a computer program, the computer program executing in the processor to implement any of the methods described above.
Also included is an embodiment, a storage medium storing a computer program, the computer program executing in the storage medium any of the methods described above.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowcharts, in some cases, the steps illustrated or described may be performed in an order different than presented herein.
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 they may alternatively 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, or fabricated separately as individual integrated circuit modules, or fabricated as a single integrated circuit module from multiple modules or steps. 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 application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (6)
1. A process operation method based on excel tables is characterized by comprising the following steps:
collecting flow data and reading data parameters;
classifying the data parameters according to three categories of process names, condition lists and execution steps;
converting the classified data parameters into cell data and combining the cell data into a process version;
arranging all process versions into a table in sequence;
converting the classified data parameters into cell data and combining the cell data into a flow version comprises:
s302, identifying the data parameters classified into the process names as process classifications, wherein the cells set under the process classifications comprise process names, process short names and process numbers;
s304, identifying the data parameters classified into the condition columns as branches, wherein the cells arranged under the branches comprise branch names and branch conditions;
s306, identifying the data parameters classified as the execution steps as the steps, wherein the cells set in the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, forming a flow version by the generated cell data according to the sequence of S302, S304 and S306;
s310, marking the serial number of the flow version;
converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as the process, namely cell data for short;
taking a uniform letter plus number serial number for the data parameters of the same process for short, and taking the uniform letter plus number serial number as process number cell data;
converting the data parameters classified into the conditional columns into cell data includes:
directly using the data parameters as branch description cell data;
converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data;
converting the data parameters classified as the execution steps into cell data includes:
the data parameters of the partial execution steps contain operating parameters, the operating parameters existing in the data parameters are identified through a condition engine, and different operational characters are set by different operating parameters to serve as cell data;
corresponding the data parameters with all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data; when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
2. The excel form-based process operation method according to claim 1, wherein the acquiring process data and reading data parameters comprises:
reading data parameters according to set keywords, taking punctuation marks as sentence segmentation boundaries, and reading segments with the keywords in the data information as the data parameters.
3. The excel form-based process running method according to claim 1, wherein the classifying the data parameters according to three categories of process name, condition column, and execution step comprises:
classifying the data parameter with the keyword 'name' as a process name; classifying data parameters with condition description keywords into condition columns, wherein the condition description keywords comprise yes, no, more than and less than; the data parameters of the keyword "person in charge" are classified as the execution steps.
4. A process running device based on excel forms is characterized by comprising the following steps:
the data acquisition module is used for acquiring flow data and reading data parameters;
the data classification module is used for classifying the data parameters according to three categories of process names, condition lists and execution steps;
the data conversion module is used for converting the classified data parameters into cell data and combining the cell data into a process version;
the data output module is used for arranging all the process versions into a table in sequence;
the conversion method of the data conversion module comprises the following steps:
s302, the data conversion module identifies the data parameters classified as the process names as process classifications, and the cells set under the process classifications comprise process names, process short names and process numbers;
s304, the data conversion module identifies the data parameters classified into the condition columns as branches, and the cells arranged under the branches comprise branch names and branch conditions;
s306, the data conversion module identifies the data parameters classified as the execution steps as the steps, the set cells under the steps comprise different types of responsible person cells, and the types of the responsible person cells are set according to the types of the data parameters of the execution steps;
s308, the data conversion module forms the generated cell data into a flow version according to the sequence of S302, S304 and S306;
s310, the data conversion module marks the serial number of the process version;
the data conversion module converting the data parameter classified as the process name into the cell data includes:
adding a mark ordinal number when data information is recorded at the last bit of the data parameter, and taking the mark ordinal number as flow name cell data;
directly taking the data parameters as the process, namely cell data for short;
taking a uniform letter plus number serial number for the data parameters of the same process for short, and taking the uniform letter plus number serial number as process number cell data;
the data conversion module converting the data parameters classified into the condition columns into the cell data includes:
directly using the data parameters as branch description cell data;
converting parameters corresponding to the condition formats in the data parameters into regular expressions through a condition engine to serve as branch condition cell data;
the data conversion module converting the data parameters classified as the execution steps into the cell data includes:
the data parameters of part of the execution steps contain operation parameters, the operation parameters existing in the data parameters are identified through a condition engine, and different operation parameters are set as unit grid data;
corresponding the data parameters with all the cells of the responsible person, and when the data parameters do not correspond, not converting the cell data;
when the data parameter has a corresponding data parameter containing an operation parameter, the sequence number is added after the operation parameter as the cell data.
5. An electronic device comprising a memory and a processor, the memory storing a computer program, wherein the computer program is executed in the processor to perform the method of any of claims 1-3.
6. A storage medium storing a computer program, characterized in that the computer program is executed on the storage medium to implement the method of any of claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111310853.1A CN114139510B (en) | 2021-11-08 | 2021-11-08 | Excel table-based process operation method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111310853.1A CN114139510B (en) | 2021-11-08 | 2021-11-08 | Excel table-based process operation method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114139510A CN114139510A (en) | 2022-03-04 |
| CN114139510B true CN114139510B (en) | 2022-11-25 |
Family
ID=80393095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111310853.1A Active CN114139510B (en) | 2021-11-08 | 2021-11-08 | Excel table-based process operation method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114139510B (en) |
Family Cites Families (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020073110A1 (en) * | 2000-12-12 | 2002-06-13 | Edouard Duvillier | Version collection technique implemented on an intrinsic versioning information storage and retrieval system |
| US9137739B2 (en) * | 2009-01-28 | 2015-09-15 | Headwater Partners I Llc | Network based service policy implementation with network neutrality and user privacy |
| CN106326425B (en) * | 2016-08-24 | 2019-11-05 | 明算科技（北京）股份有限公司 | Data classification treating method and apparatus |
| CN106408435A (en) * | 2016-09-05 | 2017-02-15 | 南京简睿捷软件开发有限公司 | Process compiling system and process compiling method |
| US11023669B2 (en) * | 2018-06-29 | 2021-06-01 | Microsoft Technology Licensing, Llc | Rendering lambda functions in spreadsheet applications |
| CN110096688B (en) * | 2019-04-28 | 2020-09-15 | 浙江明度智控科技有限公司 | Production process recording method and device based on flow chart and table |
| JP2021033831A (en) * | 2019-08-28 | 2021-03-01 | 富士ゼロックス株式会社 | Workflow support device, workflow support system, and program |
| CN112416472A (en) * | 2020-11-13 | 2021-02-26 | 京东数字科技控股股份有限公司 | Customer service distribution method and device, electronic equipment and medium |
| CN112558934B (en) * | 2020-12-10 | 2024-01-05 | 中盈优创资讯科技有限公司 | Control subtask engine device based on arranging control flow business opening |
| CN112632249A (en) * | 2020-12-22 | 2021-04-09 | 平安普惠企业管理有限公司 | Method and device for displaying different versions of information of product, computer equipment and medium |
| CN112785263A (en) * | 2021-01-22 | 2021-05-11 | 山西青峰软件股份有限公司 | Method and system for dynamically generating flow model by workflow engine |
| CN112990769A (en) * | 2021-04-21 | 2021-06-18 | 北京宇信科技集团股份有限公司 | Service processing method and device, electronic equipment and storage medium |
-
2021
- 2021-11-08 CN CN202111310853.1A patent/CN114139510B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN114139510A (en) | 2022-03-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102662930B (en) | Corpus tagging method and corpus tagging device | |
| Siddiqui et al. | Rethinking semantic segmentation for table structure recognition in documents | |
| CN113434674A (en) | Data analysis method and device, electronic equipment and readable storage medium | |
| CN101482897B (en) | Intelligent skirt style and pattern design system | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| CN114139510B (en) | Excel table-based process operation method and device, electronic equipment and storage medium | |
| CN113032544B (en) | Case automatic processing method and device based on big data and terminal equipment | |
| CN113077147B (en) | Intelligent student course pushing method and system and terminal equipment | |
| CN117236624A (en) | Issue repairer recommendation method and apparatus based on dynamic graph | |
| CN117076692A (en) | File online management method and system | |
| CN109711799A (en) | Guide the teaching software and its operation method of the standardization office of administration hilllock | |
| CN104794236B (en) | A kind of map making rule structure and its structured organization method and system | |
| CN112686013A (en) | Cable number head compiling system and method | |
| CN112800219A (en) | Method and system for feeding back customer service log to return database | |
| CN110147406A (en) | A kind of visual numeric simulation system and its framework method towards cloud computing | |
| CN109683884A (en) | A kind of cloud application modular assembly method | |
| CN109165265A (en) | A method of it realizes and quickly shows report | |
| Cuellar | Understanding Minority Aging: Perspectives and Sources. | |
| CN114253960B (en) | Electronic invoice reimbursement and posting and filing integrated service center platform system | |
| CN115202542B (en) | Automatic link and skip method for circuit ports in electronic drawing based on OCR technology | |
| CN112486992B (en) | Data storage method and system | |
| CN114138938A (en) | Case distribution method and system based on situational concept analysis | |
| CN111552718B (en) | Interactive intelligent power auditing method containing process information | |
| CN106484835A (en) | Approving electronic document handling method and device | |
| CN117807072A (en) | Power grid data management method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |