读取

指定sheet_name

import pandas as pd
df = pd.read_excel('test.xlsx',sheet_name = 'AAA')  #指定sheet名读取

写入

writer = pd.ExcelWriter('test_excel.xlsx')
A = np.array([[1,2,3],[4,5,6]])
B = np.array([[10, 20, 30], [40, 50, 60]])

df1 = pd.DataFrame(A)
df2 = pd.DataFrame(B)
df1.to_excel(writer,sheet_name='AAA')
df2.to_excel(writer,sheet_name='BBB')
writer.close()  # 或者writer.save()