xlwings在批量Excel文件数据加工中的应用——以医师肿瘤药品权限申请汇总为例  

Application of xlwings in batch Excel file data processing——Taking the summary of doctor’s tumor drug authorization application as an example

作　　者：杜志超 许中 冉静[1] 黄碧珍[1] 林跃艺 Du Zhichao;Xu Zhong;Ran Jing;Huang Bizhen;Lin Yueyi(The First Affiliated Hospital of Xiamen University,Xiamen,Fujian 361003,China)

机构地区：[1]厦门大学附属第一医院,福建厦门361003

出　　处：《计算机时代》2022年第10期127-129,135,共4页Computer Era

摘　　要：xlwings是Python操作Excel读写操作的第三方库。通过介绍xlwings功能,并以医师肿瘤药品权限申请汇总为例,展示其在Excel报表操作中的应用。xlwings可以高效地读取批量医师肿瘤药品权限申请表,经过对数据加工处理后,输出特定格式和样式的Excel报表。xlwings可以高效地读取批量Excel文件,同时也能对指定的行、列、单元格设置特定样式,可有效地提高批量文件汇总工作的效率。Xlwings is a third-party library for Python to perform Excel read and write operations. By introducing the function of xlwings, and taking the summary of the doctor’s tumor drug permission application as an example, it demonstrates its application in Excel report operation. Xlwings can efficiently read batch doctors’ tumor drug permission application forms, and output Excel reports in specific formats and styles after data processing. Xlwings can efficiently read batch Excel files, and can also set designated rows, columns, cells to specific styles, which can effectively improve the efficiency of batch file summarization.

关 键 词：xlwings EXCEL PYTHON 批量 自动化办公 

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