Application of R software in customizing the Excel Table
Ye Yunshao1, Huang Xuehuan2, Han Dong3.
1.Guangzhou Health Information Center, Guangzhou 510080, China;
2.Dongguan People′s Hospital, Dongguan 523018, China;
3.The Third Affiliated Hospital of Southern Medical University, Guangzhou 511400, China
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语言在定制Excel报表中的应用[J]. 中国医院统计, 2020, 27(2): 184-187.
Ye Yunshao, Huang Xuehuan, Han Dong. . Application of R software in customizing the Excel Table. journal1, 2020, 27(2): 184-187.
［5］Dragulescu A A, Arendt C. xlsx: Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files［CP/OL］. （2018-06-11）［2019-11-13］.https://cran.rproject.org/web/packages/xlsx/.
［6］Walker A.openxlsx: Read, Write and Edit XLSX Files［CP/OL］. （2019-11-07）［2019-11-13］. https://cran.rproject.org/web/packages/openxlsx/.
