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()
