Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

python code to save data with multiple sheet in excel

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)
Source by pythoninoffice.com #
 
PREVIOUS NEXT
Tagged: #python #code #save #data #multiple #sheet #excel
ADD COMMENT
Topic
Name
7+6 =