R语言在定制Excel报表中的应用  

Application of R software in customizing the Excel Table

作　　者：叶韵韶 黄雪欢[2] 韩栋 Ye Yunshao;Huang Xuehuan;Han Dong(Guangzhou Health Information Center, Guangzhou 510080, China;Dongguan People′s Hospital, Dongguan 523018, China;The Third Affiliated Hospital of Southern Medical University, Guangzhou 511400, China)

机构地区：[1]广州市卫生信息中心,广东广州510080 [2]东莞市人民医院,广东东莞523018 [3]南方医科大学第三附属医院,广东广州511400

出　　处：《中国医院统计》2020年第2期184-187,192,共5页Chinese Journal of Hospital Statistics

基　　金：广东省医学科学技术研究基金项目(A2019304)。

摘　　要：目的解决基于R语言输出Excel报表的精细化处理,提高日常统计工作效率。方法通过介绍openxlsx软件包的功能,并以编写复合表头“三线表”函数为例,展示其在Excel报表操作中的应用。结果R语言中openxlsx软件包可精细化处理Excel报表格式,能够解决报表输出后需手动调整表格样式等问题。结论使用openxlsx软件包编写报表程序,可有效提高重复性统计工作的效率。Objective To solve the fine processing of Excel report based on R language,and to improve the efficiency of daily statistics.Methods This paper introduces the functions of openxlsx software package and shows its application in Excel report operation by writing the function of compound header"trilinear table".Results Openxlsx package in R language can refine the output format of Excel file automatically,which can deal with the problem of manual adjustment of form style of reports.Conclusion Using openxlsx software package to write report program can effectively improve the efficiency of repetitive statistical work.

关 键 词：R语言 统计报表 openxlsx软件包 复合表头 

分 类 号：R195.1[医药卫生—卫生统计学]