title: Using current date as file name when exporting dataframe
body: <p>I am using Pandas built in to_excel function to create an excel sheet using a data frame I created.  </p>
  
  <pre><code>DataSet.to_excel("July24th.xlsx", sheet_name='sheet1', index=False)
  </code></pre>
  
  <p>I am wondering if I can name my excel sheet using the current date. I want this code to automatically take on the date. I am trying to run my python code on a scheduled basis. so every day I run my code, it will create an excel sheet for that day. I want to keep all the excel sheets generated. </p>
  
  <p>I tried using something like this:</p>
  
  <pre><code>import time
  TodaysDate = time.strftime("%d/%m/%Y")
  excelfilename = TodaysDate +".xlsx"
  
  DataSet.to_excel(excelfilename, sheet_name='sheet1', index=False).
  </code></pre>
  
  <p>But the above gives an error. In what other ways can I get such an output. </p>