使用python pandas在excel中的多个工作表中写入数据。

pip install pandas

import pandas as pd

excel_writer = pd.ExcelWriter('output.xlsx')

data1 = {'Col1': [1, 2, 3, 4], 'Col2': ['A', 'B', 'C', 'D']}
df1 = pd.DataFrame(data1)

data2 = {'Col1': [5, 6, 7, 8], 'Col2': ['E', 'F', 'G', 'H']}
df2 = pd.DataFrame(data2)

df1.to_excel(excel_writer, sheet_name='Sheet1', index=False)
df2.to_excel(excel_writer, sheet_name='Sheet2', index=False)

excel_writer.save()

import pandas as pd

excel_writer = pd.ExcelWriter('output.xlsx')

data1 = {'Col1': [1, 2, 3, 4], 'Col2': ['A', 'B', 'C', 'D']}
df1 = pd.DataFrame(data1)

data2 = {'Col1': [5, 6, 7, 8], 'Col2': ['E', 'F', 'G', 'H']}
df2 = pd.DataFrame(data2)

df1.to_excel(excel_writer, sheet_name='Sheet1', index=False)
df2.to_excel(excel_writer, sheet_name='Sheet2', index=False)

excel_writer.save()