title: How to export dfs to excel with multiple sheets and different sheet names pandas
body: <p>I am trying to iterate through student ID's WITH A LOOP by printing a df to a sheet in excel and having the student ID be the tab name.</p>
  <p>In other words:</p>
  <p>df to excel and tab name is 1</p>
  <p>next df to new sheet and tab name is 2</p>
  <p>iterate through all student IDs</p>
  <pre><code>final=[dataframe,dataframe,dataframe]
  studentIDs=[1,2,3]
  
  
  writer = pd.ExcelWriter('Name.xlsx', engine='xlsxwriter')
  for df in final:
      df.to_excel(writer, sheet_name='%s' %studentIDs)
      writer.save()
  </code></pre>