from datetime import datetime stri = 'The related Name' + datetime.now().strftime("-%Y%m%d-%H%M%S") + '.xlsx' writer = pd.ExcelWriter(stri) pstg.to_excel(writer , sheet_name = 'Percetage') writer.save()