pandas read and save excel with multiple sheets

export multiple python pandas dataframe to single excel file

#1. Create a pandas excel writer instance and name the excel file
xlwriter = pd.ExcelWriter('Customer_Details.xlsx')
#NB: If you don't include a file path like 'C:UsersRonDesktopFile_Name.xlsx'
# It will save to your default folder, that is,
#where the file you're reading from is located.

#2. Write each dataframe to a worksheet with a name
dfName.to_excel(xlwriter, sheet_name = 'Name', index = False)
dfAddress.to_excel(xlwriter, sheet_name = 'Address', index = False)
dfContact.to_excel(xlwriter, sheet_name = 'Contact', index = False)

#3. Close the instance
xlwriter.close()

Posted by: Guest on June-25-2021

Source

# Write multiple DataFrames to Excel files with pd.ExcelWriter('pandas_to_excel.xlsx') as writer: df.to_excel(writer, sheet_name='sheet1') df2.to_excel(writer, sheet_name='sheet2') # Append to an existing Excel file path = 'pandas_to_excel.xlsx' with pd.ExcelWriter(path) as writer: writer.book = openpyxl.load_workbook(path) df.to_excel(writer, sheet_name='new_sheet1') df2.to_excel(writer, sheet_name='new_sheet2')

Code answers related to "pandas read and save excel with multiple sheets"

Code answers related to "Python"

Browse Popular Code Answers by Language

Answers for "pandas read and save excel with multiple sheets"

Code answers related to "pandas read and save excel with multiple sheets"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us