dateframe保存到excel中的sheet页面

import numpy as np

#创建dateframe
a = np.random.randint(1, 6, (5, 3))
b = pd.DataFrame(a, columns=['A', 'B', 'C'])
 
#保存dateframe数据到新建的sheet页面
def create_excel(a):
    with pd.ExcelWriter(r'C:\Users\86159\Desktop\test.xlsx') as writer:
        b.to_excel(writer,sheet_name="托管部门人员信息",index=False)
        writer.close()
create_excel(a=b)

效果图：