xxxxxxxxxx
# Try this tested it's working fine.
df = pd.read_excel('path_to_file.xlsx',sheet_name='sheet10')
xxxxxxxxxx
xls = pd.ExcelFile('path_to_file.xls')
df1 = pd.read_excel(xls, 'Sheet1')
df2 = pd.read_excel(xls, 'Sheet2')
xxxxxxxxxx
writer2 = pd.ExcelWriter('mult_sheets_2.xlsx')
df_1.to_excel(writer2, sheet_name = 'df_1', index = False)
df_2.to_excel(writer2, sheet_name = 'df_2', index = False)
writer2.save()
xxxxxxxxxx
with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
df_2.to_excel(writer1, sheet_name = 'df_2', index = False)
xxxxxxxxxx
with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
df_2.to_excel(writer1, sheet_name = 'df_2', index = False)
xxxxxxxxxx
with pd.ExcelWriter('mult_sheets_1.xlsx') as writer1:
df_1.to_excel(writer1, sheet_name = 'df_1', index = False)
df_2.to_excel(writer1, sheet_name = 'df_2', index = False)