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.