title: Adding a pandas.DataFrame to Existing Excel File
body: <p>I have a web scraper which creates an excel file for this month's scrapes. I want to add today's scrape and every scrape for that month into that file as a new sheet every time it is run. My issue, however, has been that it only overwrites the existing sheet with a new sheet instead of adding it as a separate new sheet. I've tried to do it with xlrd, xlwt, pandas, and openpyxl.</p>
  
  <p>Still brand new to Python so simplicity is appreciated!</p>
  
  <p>Below is just the code dealing with writing the excel file.</p>
  
  <pre><code># My relevant time variables
  ts = time.time()
  date_time = datetime.datetime.fromtimestamp(ts).strftime('%y-%m-%d %H_%M_%S')
  HourMinuteSecond = datetime.datetime.fromtimestamp(ts).strftime('%H_%M_%S')
  month = datetime.datetime.now().strftime('%m-%y')
  
  # Creates a writer for this month and year
  writer = pd.ExcelWriter(
      'C:\\Users\\G\\Desktop\\KickstarterLinks(%s).xlsx' % (month), 
      engine='xlsxwriter')
  
  # Creates dataframe from my data, d
  df = pd.DataFrame(d)
  
  # Writes to the excel file
  df.to_excel(writer, sheet_name='%s' % (HourMinuteSecond))
  writer.save()
  </code></pre>