Monitoring report automatic generation method and system based on Python and Excel VBA

A monitoring report and automatic generation technology, applied in the field of data processing, can solve the problems that the quality of output reports is greatly interfered by personal quality, missing monitoring reports, errors, etc., to improve output timeliness, ensure quality, and save human resources Effect

Pending Publication Date: 2022-05-13
曹递
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] (1) The workload is huge, it consumes a lot of human resources, and there are many repetitive and complicated tasks;
[0004] (2) Due to the manual operation, the quality of the output report is greatly affected by personal quality, and repetitive

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Monitoring report automatic generation method and system based on Python and Excel VBA
  • Monitoring report automatic generation method and system based on Python and Excel VBA
  • Monitoring report automatic generation method and system based on Python and Excel VBA

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] Such as figure 1 As shown, the embodiment of the present invention provides a kind of monitoring report automatic generation method based on Python and Excel VBA, comprises the following steps:

[0039] S1, obtaining a data source and storing it in a data source file; the data source includes an original report and an original report data source;

[0040] Specifically, use Python to simulate manual operations from various systems of the company to complete the download of the required original reports (the general code has been solidified, and only needs to be fine-tuned or simply customized according to different systems);

[0041] Obtain the required attachments directly from the mailbox through Python as the original report data source.

[0042] S2, preprocessing the data source file, importing the preprocessed data source file into a preset Excel template, operating the Excel template, and generating pictures and / or attachments of the monitoring report;

[0043] S...

Embodiment 2

[0064] Such as figure 2 A kind of monitoring report automatic generation system based on Python and Excel VBA provided by the present embodiment shown includes:

[0065] An acquisition module, configured to acquire a data source and store it in a data source file; the data source includes an original report and an original report data source;

[0066] The data processing module is used to preprocess the data source file, import the preprocessed data source file into a preset Excel template, operate the Excel template, and generate pictures and / or attachments of the monitoring report;

[0067] The report generation module is used to generate the email content of the monitoring report according to the HTML language based on the pictures and / or attachments;

[0068] The report distribution module is configured to call Outlook, and send the email content and the picture and / or attachments to the target group according to preset email configuration information.

[0069] It is wo...

Embodiment 3

[0072] Such as image 3 As shown, this embodiment provides an electronic device, including a memory and a processor, the memory stores a computer program, the computer program is configured to be executed by the processor, and the computer program includes a method for executing the above implementation Instructions for any of the methods described in the examples.

[0073] It should be understood that in the embodiment of the present invention, the processor may be a central processing unit (Central Processing Unit, CPU), and the processor may also be other general-purpose processors, digital signal processors (Digital Signal Processor, DSP), dedicated integrated Circuit (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor, or the processor...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a Python and Excel VBA-based monitoring report automatic generation method, system and device and a medium, and particularly relates to the technical field of data processing, the method comprises the following steps: S1, obtaining a data source and storing the data source in a data source file; the data source comprises an original report and an original report data source; s2, preprocessing the data source file, importing the preprocessed data source file into a preset Excel template, operating the Excel template, and generating a picture and/or an attachment of a monitoring report; s3, on the basis of the picture and/or the attachment, mail content of the monitoring report is generated according to an HTML (Hypertext Markup Language); and S4, calling Outlook, configuring a mail of a monitoring report according to the mail configuration information based on the mail content and the picture and/or the attachment, and sending the mail to a target crowd.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method and system for automatically generating monitoring reports based on Python and Excel VBA. Background technique [0002] The monitoring report is a high-frequency and a lot of repetitive work. At present, the company's employees generally perform manual operations regularly, including manual acquisition of raw data from the system or customized emails, manual operation of Excel templates to process data, and manual writing of monitoring and analysis. Report and send manually. If it involves multi-department distribution, it is necessary to manually disassemble the report and then manually send it to each department. The existing methods have the following disadvantages: [0003] (1) The workload is huge, it consumes a lot of human resources, and there are many repetitive and complicated tasks; [0004] (2) Due to the manual operation, the quality of the output re...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F11/30G06F40/18H04L51/08
CPCG06F40/18G06F11/3068H04L51/08
Inventor 曹递
Owner 曹递
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap