代码如下:
import numpy as np
import os
import pandas as pd
data_dir = 'G:\\ImageData\\Dense_Spine_Axial\\Nerve\\Result'
data = dict()
data['case'] = np.linspace(1, 10, 10)
data['L4'] = np.random.randn(10)
data['L5'] = np.random.randn(10)
data['Disc'] = np.random.randn(10)
df1 = pd.DataFrame(data)
df2 = df1.copy()
df3 = df1.copy()
writer = pd.ExcelWriter(os.path.join(data_dir, 'test.xlsx'))
df1.to_excel(writer, sheet_name='df1', index=False)
df2.to_excel(writer, sheet_name='df2', index=False)
df3.to_excel(writer, sheet_name='df3', index=False)
writer.save()