基于Python的生产报表自动生成发送系统的开发及应用  

Development and Application of Automatic Generation and Sending System for Production Report Based on Python

作　　者：朱明星 石建明 胡应权 ZHU Mingxing;SHI Jianming;HU Yingquan(Guizhou Wujiang Hydropower Development Co.,Ltd.,Guiyang 550002,China)

机构地区：[1]贵州乌江水电开发有限责任公司,贵州贵阳550002

出　　处：《红水河》2022年第3期139-142,共4页Hongshui River

摘　　要：针对传统生产报表制作费时费力、数据易出错等情况,采用Python语言开发了生产报表自动生成发送系统。通过调用db2、Oracle数据库获取数据,使用pandas库批量处理数据,操作Excel制作报表,采用模块化设计,利用Windows计划任务程序和自动化脚本实现自动发送工作簿。应用结果表明,该系统实现了生产报表自动生成和发送,减轻了工作量,提高了工作效率,为其他类型的报表制作实现自动化提供借鉴。In view of the time-consuming and laborious production report making and the error-prone data,Python language is used to develop the automatic generation and sending system of production reports.The data are obtained by calling db2 and Oracle databases,and the data are processed in batches by using pandas database.Excel is used to make reports,and the modularization design is adopted.The automatic sending of workbook is realized by using Windows planning task program and automation script.The application results show that the system realizes the automatic generation and sending of production reports,reduces the workload,improves work efficiency,and provides reference for the automation of other types of report making.

关 键 词：PYTHON 生产报表 自动化 

分 类 号：TP311.5[自动化与计算机技术—计算机软件与理论]