CN112395154A - Data report generation method, storage medium and generation system - Google Patents
Data report generation method, storage medium and generation system Download PDFInfo
- Publication number
- CN112395154A CN112395154A CN202011173408.0A CN202011173408A CN112395154A CN 112395154 A CN112395154 A CN 112395154A CN 202011173408 A CN202011173408 A CN 202011173408A CN 112395154 A CN112395154 A CN 112395154A
- Authority
- CN
- China
- Prior art keywords
- monitoring system
- file
- output
- output file
- object model
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 42
- 238000012544 monitoring process Methods 0.000 claims abstract description 82
- 238000001514 detection method Methods 0.000 claims abstract description 46
- 230000003213 activating effect Effects 0.000 claims abstract description 5
- 238000004891 communication Methods 0.000 claims description 12
- 239000011159 matrix material Substances 0.000 claims description 9
- 230000006870 function Effects 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 3
- 230000006872 improvement Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000011087 paperboard Substances 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000001681 protective effect Effects 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
- G06F11/3072—Monitoring arrangements determined by the means or processing involved in reporting the monitored data where the reporting involves data filtering, e.g. pattern matching, time or event triggered, adaptive or policy-based reporting
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Testing And Monitoring For Control Systems (AREA)
Abstract
The invention discloses a generation method, a storage medium and a generation system of a data report, wherein the generation method of the data report comprises the following steps: the method comprises the steps that a monitoring system appoints file attributes of output files, wherein the file attributes comprise file storage paths and file names; the monitoring system creates an object model of an output file; the monitoring system creates an object model of an output form; the monitoring system associates the object model of the output file with the object model of the output form; the monitoring system sets the object attribute of the output form; the monitoring system judges whether an output file with the file attribute consistent with the specified file attribute exists or not, and if the output file does not exist, the output file is established and activated; if yes, activating an output file; the monitoring system acquires the detection data stored by the controller and writes the detection data into an output file; the method for generating the data report can automatically establish the output file to record the detection data, improve the recording efficiency and reduce the recording error rate.
Description
Technical Field
The present invention relates to the field of data processing methods and systems, and in particular, to a method, a storage medium, and a system for generating a data report.
Background
After the printing machine finishes the printing task of the corrugated board, the performance index of each paper board needs to be measured and recorded, so that the performance of the machine is convenient to verify, and data support is provided for subsequent product improvement and machine improvement; the performance indexes of the existing corrugated board can be automatically detected through a machine, but the detection data is generally recorded manually by quality personnel, so that the problems of low recording efficiency, high recording error rate and the like exist.
It is seen that improvements and enhancements to the prior art are needed.
Disclosure of Invention
In view of the above-mentioned shortcomings in the prior art, the present invention provides a method for generating a data report, which can automatically create an output file to record detection data, thereby improving recording efficiency and reducing recording error rate.
In order to achieve the purpose, the invention adopts the following technical scheme:
a method for generating a data report comprises the following steps:
the method comprises the steps that a monitoring system appoints file attributes of output files, wherein the file attributes comprise file storage paths and file names;
the monitoring system creates an object model of an output file;
the monitoring system creates an object model of an output form;
the monitoring system associates the object model of the output file with the object model of the output form;
the monitoring system sets the object attribute of the output form;
the monitoring system judges whether an output file with the file attribute consistent with the specified file attribute exists or not, and if the output file does not exist, the output file is established and activated; if yes, activating an output file;
the monitoring system acquires the detection data stored by the controller and writes the detection data into an output file.
In the method for generating the data report, the monitoring system obtains the detection data stored in the controller and writes the detection data into the output file, and then the method further comprises the following steps:
the monitoring system judges whether the file attribute of the output file written with the detection data is stored in the monitoring system, if so, the output file is stored; otherwise, the file is saved as an output file.
In the method for generating the data report, the object attribute of the output table includes the visibility of the output table.
In the method for generating a data report, the monitoring system creates an object model of an output file, and the method specifically includes the following steps:
the monitoring system creates an object model of an output file with specified file attributes through a creatObject function;
the CreatObject function returns a reference to the object model of the output file.
In the method for generating a data report, the monitoring system associates the object model of the output file with the object model of the output form, and the method specifically includes the following steps:
the monitoring system associates the reference of the object model of the returned output file with the object model of the output form by means of a set statement.
In the method for generating a data report, before the monitoring system designates the file attribute of the output file, the method further comprises the following steps:
the controller acquires the detection data and stores the detection data in the corresponding data matrix.
In the method for generating the data report, the data matrix is an address matrix for storing the detection data by the controller.
The present invention also provides a computer readable storage medium, which stores one or more programs that can be executed by a monitoring system to implement the steps in the data report generation method as described in any above.
The invention also correspondingly provides a system for generating the data report, which comprises a controller, a memory, a monitoring system and a communication bus;
the controller is used for collecting and storing detection data;
the memory is for storing a computer readable program executable by the monitoring system;
the monitoring system realizes the steps of the data report generation method when executing the computer program;
the communication bus is used for realizing the connection communication between the controller and the monitoring system and the connection communication between the memory and the monitoring system.
Has the advantages that:
the invention provides a method for generating a data report, which has the following advantages:
(1) the monitoring system can automatically establish an output file and record the detection data in the output file, so that the recording efficiency is improved, and the recording error rate is reduced;
(2) before the detection data is written, the monitoring system judges whether the output file exists once, so that the repeated establishment of the output file is avoided, the output file is ensured to really exist in the monitoring system, and the detection data is effectively recorded in the output file.
Drawings
FIG. 1 is a control flow chart of a method for generating a data report according to the present invention;
FIG. 2 is a control flow diagram of a generation method according to another embodiment of the present invention;
FIG. 3 is a control flowchart of another embodiment of steps S200 to S400 provided in the present invention;
fig. 4 is a system structure diagram of the data report generation system provided by the present invention.
Detailed Description
The invention provides a method, a storage medium and a system for generating a data report, and in order to make the purpose, technical scheme and effect of the invention clearer and clearer, the invention is further described in detail below by referring to the accompanying drawings and embodiments.
In the description of the present invention, it is to be understood that the terms "mounted," "connected," and the like are to be interpreted broadly, and those skilled in the art can understand the specific meanings of the above terms in the present invention according to specific situations.
In consideration of the popularity of Excel in the production industry, the data report in the Excel format is generated by the monitoring system, the problems of low recording efficiency and high recording error rate of manual filling can be solved, the detection data displayed by the generated Excel form is clear and intuitive, and the secondary processing of the detection data by workers is facilitated, such as bar graph or pie graph establishment according to the detection data.
Referring to fig. 1, the present invention provides a method for generating a data report, including the steps of:
s100, a monitoring system appoints file attributes of an output file, wherein the file attributes comprise a file storage path and a file name; in one embodiment, the file name may include a creation time and a table name of the output file, for example, a file name of one output file is: year-month-day-sheet 1; the monitoring system may obtain real-time to specify file attributes.
S200, the monitoring system creates an object model of an output file;
s300, the monitoring system creates an object model of an output form, wherein the object model of the output form is an instantiated data form;
s400, the monitoring system associates the object model of the output file with the object model of the output form;
s500, the monitoring system sets the object attribute of the output form;
s600, judging whether an output file with the file attribute consistent with the specified file attribute exists by the monitoring system;
s601, if the file does not exist, establishing an output file and activating the output file;
s602, if the file exists, activating an output file;
s700, the monitoring system obtains the detection data stored by the controller and writes the detection data into an output file.
According to the method for generating the data report, the monitoring system can automatically establish the output file and record the detection data in the output file, so that the recording efficiency is improved, the recording error rate is reduced, and the labor cost is saved; in addition, before the detection data is written, the monitoring system judges whether the output file exists once, so that the repeated establishment of the output file is avoided, the output file is ensured to really exist in the monitoring system, and the detection data is effectively recorded in the output file.
Further, referring to fig. 2, the monitoring system obtains the detection data stored in the controller and writes the detection data into the output file, and then further includes the following steps:
s800, judging whether the file attribute of the output file written with the detection data is stored in the monitoring system by the monitoring system;
s801, if yes, saving the output file;
s802, otherwise, saving the file as an output file.
After the write-in of the detection data is completed, the output file needs to be saved, and before the output file is saved, whether the file attribute of the output file is stored in the monitoring system is further confirmed, so that the output file is further ensured to be really stored in the monitoring system, and the detection data is effectively stored in the output file.
Further, the object properties of the output table include visibility of the output table; the visibility of the output form refers to an open object of the output form, namely, setting specific personnel to view the detection data recorded in the output file.
Further, referring to fig. 3, the monitoring system creates an object model of an output file, and specifically includes the steps of:
s201, the monitoring system creates an object model of an output file with specified file attributes through a CreatObject function;
s202, the CreateObject function returns a reference of the object model of the output file.
Further, referring to fig. 3, the monitoring system associates the object model of the output file with the object model of the output form, and specifically includes the steps of:
s401, the monitoring system associates the reference of the object model of the returned output file with the object model of the output form through a set statement.
The object model established by the monitoring system is stored in the monitoring system, and cannot be directly operated, that is, the detection data cannot be directly written, and the access of the object model of the output file can be performed only by linking the returned reference with the object model of the output table, that is, the access of the object model of the output file can be performed only by linking the returned reference with a certain variable.
Further, referring to fig. 2, before the monitoring system specifies the file attribute of the output file, the method further includes the steps of:
and S001, the controller acquires the detection data and stores the detection data in the corresponding data matrix.
Further, the data matrix is an address matrix for storing the detection data by the controller.
The present invention also provides a computer readable storage medium, which stores one or more programs that can be executed by a monitoring system to implement the steps in the data report generation method as described in any above.
The logic instructions in the memory may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product; the memory, which is a computer-readable storage medium, may be configured to store a software program, a computer-executable program, such as program instructions or modules corresponding to the methods in the embodiments of the present disclosure.
The memory may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal device, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory. For example, a variety of media that can store program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, may also be transient storage media.
Referring to fig. 4, the present invention further provides a system for generating a data report, which includes a controller, a memory, a monitoring system and a communication bus;
the controller is used for collecting and storing detection data, after the printing machine finishes a printing task of the corrugated board, the performance indexes of the corrugated board are generally detected and collected by the conventional image processing system, the image processing system is electrically connected with the controller, and the controller acquires and stores the detection data;
the memory is for storing a computer readable program executable by the monitoring system;
the monitoring system realizes the steps of the data report generation method when executing the computer program;
the communication bus is used for realizing the connection communication between the controller and the monitoring system and the connection communication between the memory and the monitoring system.
It should be understood that equivalents and modifications of the technical solution and inventive concept thereof may occur to those skilled in the art, and all such modifications and alterations should fall within the protective scope of the present invention.
Claims (9)
1. A method for generating a data report is characterized by comprising the following steps:
the method comprises the steps that a monitoring system appoints file attributes of output files, wherein the file attributes comprise file storage paths and file names;
the monitoring system creates an object model of an output file;
the monitoring system creates an object model of an output form;
the monitoring system associates the object model of the output file with the object model of the output form;
the monitoring system sets the object attribute of the output form;
the monitoring system judges whether an output file with the file attribute consistent with the specified file attribute exists or not, and if the output file does not exist, the output file is established and activated; if yes, activating an output file;
the monitoring system acquires the detection data stored by the controller and writes the detection data into an output file.
2. A method for generating a data report according to claim 1, wherein said monitoring system obtains the detection data stored in the controller and writes the detection data into an output file, and then further comprising the steps of:
the monitoring system judges whether the file attribute of the output file written with the detection data is stored in the monitoring system, if so, the output file is stored; otherwise, the file is saved as an output file.
3. A data report generation method as claimed in claim 1, characterized in that said object properties of the output form include the visibility of the output form.
4. The method for generating a data report according to claim 1, wherein the monitoring system creates an object model of the output file, and specifically comprises the steps of:
the monitoring system creates an object model of an output file with specified file attributes through a creatObject function;
the CreatObject function returns a reference to the object model of the output file.
5. The method for generating a data report according to claim 4, wherein said monitoring system associates an object model of said output file with an object model of said output form, and specifically comprises the steps of:
the monitoring system associates the reference of the object model of the returned output file with the object model of the output form by means of a set statement.
6. A method for generating a data report according to claim 1, wherein before said monitoring system specifies the file attributes of the output file, it further comprises the steps of:
the controller acquires the detection data and stores the detection data in the corresponding data matrix.
7. A method as claimed in claim 6, wherein the data matrix is an address matrix for storing the detection data in the controller.
8. A computer-readable storage medium, characterized in that the computer-readable storage medium stores one or more programs which are executable by a monitoring system to implement the steps in the data report generation method according to any one of claims 1 to 5.
9. A generation system of a data report is characterized by comprising a controller, a memory, a monitoring system and a communication bus;
the controller is used for collecting and storing detection data;
the memory is for storing a computer readable program executable by the monitoring system;
the monitoring system implements the steps in the data report generation method according to any one of claims 1-5 when executing the computer program;
the communication bus is used for realizing the connection communication between the controller and the monitoring system and the connection communication between the memory and the monitoring system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011173408.0A CN112395154A (en) | 2020-10-28 | 2020-10-28 | Data report generation method, storage medium and generation system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011173408.0A CN112395154A (en) | 2020-10-28 | 2020-10-28 | Data report generation method, storage medium and generation system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112395154A true CN112395154A (en) | 2021-02-23 |
Family
ID=74598361
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011173408.0A Pending CN112395154A (en) | 2020-10-28 | 2020-10-28 | Data report generation method, storage medium and generation system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112395154A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| CN101694649A (en) * | 2009-08-28 | 2010-04-14 | 曙光信息产业(北京)有限公司 | Report generating system and method of cluster monitoring |
| CN103019910A (en) * | 2011-09-26 | 2013-04-03 | 北京新媒传信科技有限公司 | Method and system for monitoring resources in Linux server |
| CN109117469A (en) * | 2018-09-03 | 2019-01-01 | 平安科技（深圳）有限公司 | Excel report file generation method, device, computer equipment and storage medium |
| CN110874324A (en) * | 2019-10-14 | 2020-03-10 | 平安普惠企业管理有限公司 | Test result data storage method and device, terminal equipment and storage medium |
-
2020
- 2020-10-28 CN CN202011173408.0A patent/CN112395154A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| CN101694649A (en) * | 2009-08-28 | 2010-04-14 | 曙光信息产业(北京)有限公司 | Report generating system and method of cluster monitoring |
| CN103019910A (en) * | 2011-09-26 | 2013-04-03 | 北京新媒传信科技有限公司 | Method and system for monitoring resources in Linux server |
| CN109117469A (en) * | 2018-09-03 | 2019-01-01 | 平安科技（深圳）有限公司 | Excel report file generation method, device, computer equipment and storage medium |
| CN110874324A (en) * | 2019-10-14 | 2020-03-10 | 平安普惠企业管理有限公司 | Test result data storage method and device, terminal equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 梦在深巷: ""使用CreateObject创建Excel实例代码"", 《卡饭网》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2019095424A1 (en) | Data acquisition method and device, storage medium and terminal | |
| CN105653508A (en) | Document template management method, document calling method and related device | |
| JP2006172473A5 (en) | ||
| JP7209306B2 (en) | Online work system for Excel documents based on templates | |
| CN111309687A (en) | Object storage small file processing method, device, equipment and storage medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN111143290A (en) | Memory management method, system, equipment and computer readable storage medium | |
| CN102004790A (en) | Method for exporting high-throughput data report | |
| CN110851206A (en) | Vehicle type configuration file expanding method, device, equipment and readable storage medium | |
| CN109492276A (en) | The method for calculating air-conditioning duct processing technology based on VBA module in Excel | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN112395154A (en) | Data report generation method, storage medium and generation system | |
| KR102490941B1 (en) | An online report creation system using Excel tool | |
| CN110390082A (en) | A kind of communication matrix control methods and system | |
| US20030222916A1 (en) | Object-oriented processing of tab text | |
| CN105549830A (en) | Intelligent display method and device | |
| JP2968523B1 (en) | INFORMATION PROCESSING DEVICE, INFORMATION PROCESSING METHOD, AND COMPUTER-READABLE RECORDING MEDIUM RECORDING PROGRAM FOR CAUSING COMPUTER TO EXECUTE THE METHOD | |
| CN102467353B (en) | Document printing method and computer | |
| WO2024130890A1 (en) | Solid state drive garbage collection method, solid state drive garbage collection acceleration apparatus, and device and computer medium | |
| CN103177019B (en) | Usb storage device and driving method thereof | |
| JP5803511B2 (en) | Electronic device and program | |
| EP2966558A1 (en) | Multi-channel touch control method, device and computer storage media for integration machine | |
| CN103049231A (en) | Printing parameter setting method and printing method of dynamically adjusting printing parameters | |
| CN103034730A (en) | Data processing method and system based on Android platform | |
| CN101794217A (en) | Method and system for implementing interaction between application and extended module of document library 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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210223 |