Process information processing method and device based on Office platform

Abstract

The invention discloses a process information processing method and device for an Office platform, electronic equipment and a storage medium, and the method comprises the steps: obtaining an Office file containing a plurality of pieces of process information, and defining each piece of process information as an object; constructing a regular expression of the feature identification code of the object; screening all the objects in the Office file according to the regular expression to form an object set; matching the objects in the object set with preset objects; and if the matching is successful, processing the successfully matched object, and if the matching is not successful, ending. According to the method, the process information in the office file is matched and processed through the regular expression of the feature identification code, the compiling efficiency of the process information in the process manufacturing process is improved, and the reliability of the process information conversion process is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of information technology and engineering manufacturing, in particular to a process information processing method and device based on Office platform. BACKGROUND

[0002] Process information is a key content of engineering manufacturing industry, which specifies the parameters to be used in production, quality assurance and quality control process. These parameters will directly affect the stability of engineering manufacturing process and the quality state of products. These information is usually recorded in CAD (Computer Aided Design) model. These models need the support of professional software, but at the same time, these professional software need expensive authorization fee, and the operation is complex, which is not suitable for wide range of use. Therefore, in many cases, Office software is used for process making and process information marking. In addition, the process information required by processing and detection personnel is different, and the CAD model needs to be analyzed again to meet the different needs of production and detection. In these processes, process information provides an important guide for processing (detection) personnel.

[0003] In the traditional process making process, process information is manually entered and operated. This way is time-consuming and laborious. Especially when a large amount of information needs to be entered, there is a great possibility of information entry error. At the same time, due to the large amount of information, it will also cause great obstacles in the checking process. SUMMARY

[0004] In view of the above problems existing in the prior art, the purpose of the present application is to provide a process information processing method and device based on Office platform, which can solve the problem of time-consuming and laborious manual entry and operation.

[0005] In order to achieve the above purpose, the present application provides the following technical scheme:

[0006] On the one hand, the present application provides a process information processing method based on Office platform, comprising: obtaining an Office file containing a plurality of process information, defining each process information as an object; constructing a regular expression of the feature identification code of the object; screening all objects in the Office file according to the regular expression to form an object set; matching the objects in the object set with a preset object; if the matching is successful, processing the matched object, if the matching is unsuccessful, ending.

[0007] Preferably, the obtaining of the Office file containing a plurality of process information further comprises the following steps: establishing a process information database corresponding to the Office file.

[0008] Preferably, the obtaining the Office file containing the plurality of process information further comprises the step of: uniformly processing the format of the Office file.

[0009] Optionally, the processing comprises content replacement, format adjustment and display attribute modification.

[0010] In another aspect, the present application provides an Office platform-based process information processing device, comprising: an obtaining module, configured to obtain an Office file containing a plurality of process information, and define each of the process information as an object; a regular expression constructing module, configured to construct a regular expression of a feature identification code of the object; a set forming module, configured to filter all the objects in the Office file according to the regular expression to form an object set; a matching module, configured to match the object in the object set with a preset object; and a processing module, configured to process the matched object when the matching module matches successfully.

[0011] Preferably, the obtaining module further comprises: a database establishing unit, configured to establish a process information database corresponding to the Office file.

[0012] Preferably, the obtaining module further comprises: a formatting processing unit, configured to uniformly process the format of the Office file.

[0013] Optionally, the processing comprises content replacement, format adjustment and display attribute modification.

[0014] In another aspect, the present application provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the steps of any of the above-mentioned Office platform-based process information processing methods.

[0015] In another aspect, the present application provides an electronic device, comprising a processor, wherein the processor is configured to execute the above-mentioned any Office platform-based process information processing device stored in the memory.

[0016] Compared with the prior art, the present application has the following advantages and beneficial effects:

[0017] 1、The Office platform-based process information processing method provided by the present application uses the regular expression of the feature identification code to match and process the process information in the Office file, thereby improving the compiling efficiency of the process information in the process manufacturing process and improving the reliability of the process information conversion process.

[0018] 2. The process information processing method based on the Office platform provided by the application unifies the format of Office files before matching and processing process information, thereby improving the execution efficiency of the matching and processing process. BRIEF DESCRIPTION OF DRAWINGS

[0019] In order to more clearly illustrate the technical solutions in the embodiments of the application, the drawings needed to be used in the embodiments will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the application, and other drawings can be obtained by those skilled in the art without creative labor under the premise of the drawings.

[0020] Figure 1 The flowchart of the process information processing method based on the Office platform of the application;

[0021] Figure 2 The flowchart of step S100 in the embodiment; Figure 1

[0022] The structural schematic diagram of the process information processing device based on the Office platform of the application; Figure 3

[0023] The structural schematic diagram of module 20 in the embodiment; Figure 4 Figure 3 The structural schematic diagram of the electronic device provided by the application;

[0024] Figure 5 Among them:

[0025]

[0026] 1. The process information processing method based on the Office platform;

[0027] 2. The process information processing device based on the Office platform;

[0028] 20. The acquisition module;

[0029] 200. The database establishing unit;

[0030] 201. The formatting processing unit;

[0031] 21. The regular expression construction module;

[0032] 22. The set module;

[0033] 23. The matching module;

[0034] 24. The processing module;

[0035] 3. The electronic device;

[0036] 30. The memory;​​

[0037] 31-Processor. Detailed Implementation

[0038] The technical solution of the present invention will be described in detail below with reference to the accompanying drawings and specific embodiments to further understand the purpose, solution and effect of the present invention, but it is not intended to limit the scope of protection of the appended claims.

[0039] Certain terms are used in the specification and claims to refer to specific components or parts. Those skilled in the art will understand that users or manufacturers may use different names or terms to refer to the same component or part. This specification and claims do not distinguish components or parts by differences in name, but rather by differences in function. The term "comprising" throughout the specification and claims is an open-ended term and should be interpreted as "including but not limited to." Furthermore, the term "connection" here includes any direct and indirect electrical connection means. Indirect electrical connection means include connections made through other means.

[0040] This invention provides a process information processing method based on the Office platform, which solves the problems of time-consuming, labor-intensive, and error-prone manual input and processing of process information in the prior art.

[0041] The technical method of the present invention is to solve the above problems. The general idea is as follows: establish a regular expression for feature identification code, filter objects that conform to the regular expression in a pre-compiled office process document to form an object set, and then match and process the objects in the set.

[0042] Figure 1 The flowchart shown is a process information processing method 1 based on the Office platform according to an embodiment of the present invention. Method 1 includes the following steps:

[0043] S100: Obtain an Office file containing multiple process information items, and define each of the process information items as an object.

[0044] like Figure 2 As shown, step S100 further includes the following step:

[0045] S101: Establish a process information database corresponding to the Office file.

[0046] S102: Standardize the format of the Office files.

[0047] Specifically, first, a file containing multiple process information, such as an office file, is acquired, and a database of process information corresponding to the office file is established, that is, a related process file containing a feature identification code conforming to an encoding mode needs to be prepared in advance, the location of the process information is located, and a related process information database containing a feature identification code conforming to the encoding mode is acquired and prepared in advance.

[0048] Then, the office file is preprocessed, such as formatting the process information, so that the format of the process information in the office file is uniform, thereby improving the execution efficiency of the subsequent processing process.

[0049] S110: Construct a regular expression of the feature identification code of the object.

[0050] In this step, the constructed regular expression conforms to the above-mentioned encoding mode.

[0051] S120: Filter all the objects in the office file according to the regular expression to form an object set.

[0052] S130: Match the objects in the object set with a preset object.

[0053] Specifically, each object in the object set is matched with a preset object, and the preset object refers to a process information that needs to be matched.

[0054] S140: If the matching is successful, the object with the successful matching is processed, and if the matching is unsuccessful, the process is ended.

[0055] Specifically, the processing includes content replacement, format adjustment, display attribute modification, etc., but is not limited thereto.

[0056] In order to facilitate the understanding of the above-mentioned embodiments, the following will take one specific application scenario of the above-mentioned embodiments as an example for description:

[0057] Now, 8000 connection technologies of a vehicle body need to be checked for quality, and the engineers have completed the preparation of the preliminary process file (i.e., the office file), which has determined the location of the connection technology and encoded the feature identification code of the connection point, such as 000_abc1234. At the same time, the engineers have prepared the process information database that needs to be added, as shown in Table 1 below:

[0058] Table 1

[0059] Line number Process information content 1 Example text_000_aaa0001_Example text_Example text 2 Example text_000_aaa0002_Example text_Example text_Example text 3 Example text_000_aaa0003_Example text_Important_Example text 4 (Omitting other connection point information)

[0060] According to the analysis, the regular expression of the feature identification code is.* (\d{3}_[a-zA-Z]{3}\d{4}). *.

[0061] Firstly, all objects containing.* (\d{3}_[a-zA-Z]\d{4}). * in the prepared process file are extracted to form an object set. (For example, text boxes / graphics in PowerPoint).

[0062] Then, starting from the first object in the object set (for example, a text box containing 000_aaa0001), the process information content containing 000_a0001 is matched in the process information database. The process information content is found to be: "example text_000_aaa0001_example text_example text";

[0063] Finally, the process information content found is replaced in the original object.

[0064] Alternatively, if you want to specially set the connection point containing the keyword "important", extract all objects containing *(important).* in the prepared process file, and when the match is successful, set the matched object, for example, set the fill color / font color.

[0065] Through actual calculation, it takes 3 minutes to manually enter a single process information (including querying process information, entering process information, and setting related formats). This case requires 400 hours. If the method of the present application is used for batch entry, the execution time is not more than 3 minutes.

[0066] Compared with the original manual entry of each process information, the method of the present application effectively improves the process production and checking efficiency. At the same time, the accuracy and timeliness of the process information are guaranteed.

[0067] The following is a device embodiment corresponding to the above method embodiment. The present embodiment can be implemented in cooperation with the above-mentioned embodiments. The related technical details mentioned in the above-mentioned embodiments are still valid in the present embodiment. In order to reduce repetition, they will not be repeated here. Correspondingly, the related technical details mentioned in the present embodiment can also be applied in the above-mentioned embodiments.

[0068] Figure 3 Another embodiment provides an Office platform-based process information processing device 2, which comprises: an acquisition module 20, a regular expression construction module 21, a set formation module 22, a matching module 23 and a processing module 24 connected in sequence.

[0069] The acquisition module 20 is configured to acquire an Office file containing a plurality of process information, and define each of the process information as an object; the regular expression construction module 21 is configured to construct a regular expression of a feature identification code of the object; the set forming module 22 is configured to filter all the objects in the Office file according to the regular expression to form an object set; the matching module 23 is configured to match the object in the object set with a preset object; and the processing module 24 is configured to process the matched object when the matching module matches successfully.

[0070] In the embodiment, as shown in Figure 4 The acquisition module 20 further includes a database establishing unit 200 and a format processing unit 201, wherein the database establishing unit 200 is configured to establish a process information database corresponding to the Office file; and the format processing unit 201 is configured to uniformly process the format of the Office file.

[0071] The processing includes content replacement, format adjustment, display attribute modification, etc. However, the present application is not limited thereto.

[0072] Another embodiment of the present application further provides a computer readable storage medium storing a computer program, wherein the computer program is executed by a processor to implement the steps of any one of the process information processing methods based on the Office platform. Figure 1

[0073] Figure 5 As shown in the structure schematic diagram of the electronic device 3, the electronic device 3 includes a memory 30, a processor 31, and the process information processing device 2 based on the Office platform as shown in Figure 3 stored in the memory 30 and executable on the processor 31.

[0074] In summary, the method of the present application matches and processes the process information in the Office file by using the regular expression of the feature identification code, improves the compiling efficiency of the process information in the process manufacturing process, and improves the reliability of the process information conversion process.

[0075] The method of the present application uniformly processes the format of the Office file before matching and processing the process information, and improves the execution efficiency of the matching and processing process.

[0076] ​The above merely describes preferred embodiments of the present application, but is not intended to limit the present application to other forms, any person skilled in the art can make changes or modifications to the above disclosed technical contents into equivalent embodiments with equivalent changes, and apply to other fields, but any simple modification, equivalent change and modification made to the above embodiments according to the technical essence of the present application without departing from the technical solution content of the present application still belongs to the protection scope of the present application technical solution.

Claims

1. An Office platform-based process information processing method, characterized by, The method comprises the following steps: an Office file containing a plurality of process information is acquired, and each of the process information is defined as an object; a regular expression of a feature identification code of the object is constructed; all the objects in the Office file are filtered according to the regular expression to form an object set; the objects in the object set are matched with preset objects; if the matching is successful, the matched objects are processed, and if the matching is unsuccessful, the process is ended.

2. The Office platform-based process information processing method according to claim 1, characterized by, The step of acquiring the Office file containing a plurality of process information further comprises the following steps: a process information database corresponding to the Office file is established.

3. The Office platform-based process information processing method according to claim 1, characterized by, The step of acquiring the Office file containing a plurality of process information further comprises the following steps: the format of the Office file is uniformly processed.

4. The Office platform-based process information processing method according to claim 1, characterized by, The processing comprises content replacement, format adjustment and display attribute modification.

5. An office platform-based process information processing apparatus characterized by comprising: The method comprises the following steps: an acquisition module is configured to acquire an Office file containing a plurality of process information, and each of the process information is defined as an object; a regular expression construction module is configured to construct a regular expression of a feature identification code of the object; a set forming module is configured to filter all the objects in the Office file according to the regular expression to form an object set; a matching module is configured to match the objects in the object set with preset objects; a processing module is configured to process the matched objects when the matching is successful.

6. The Office platform-based process information processing apparatus according to claim 5, characterized by, The acquisition module further comprises: a database establishing unit configured to establish a process information database corresponding to the Office file.

7. The Office platform-based process information processing apparatus according to claim 5, characterized by, The acquisition module further comprises: a formatting processing unit configured to uniformly process the format of the Office file.

8. The Office platform-based process information processing apparatus according to claim 5, characterized by, The processing comprises content replacement, format adjustment and display attribute modification.

9. A computer readable storage medium storing a computer program, characterized in that, The computer program is executed by a processor to implement the steps of the process information processing method based on an Office platform according to any one of claims 1 to 4.

10. An electronic device comprising a processor, characterized in that The processor is configured to execute the process information processing device based on an Office platform according to any one of claims 5 to 8 stored in the memory.

Images