title: how to write into excel file without dataframe using xlsxwriter
body: <p>If my dataframe is empty then I simply need to create empty excel file and write in it <code>"There is no data for selected timeframe "</code></p>
  
  <pre><code>folder_list = ['San Diego', 'Vista']
  if not df.empty:
      # if daraframe is not empty then do this:
      for location, d in df.groupby('OfficeLocation'):
          for folder in folder_list:
              if folder == location: 
                  writer=pd.ExcelWriter(f'\\\\my\username\Documents\Python\Split DataFrame by Multiple dataframes\{folder}\{location}.xlsx',engine='xlsxwriter')                  
              else: 
                  print('df is empty')
              writer.save()
  # if dataframe is empty I need to create empty excel file and wirte in cell A1 "There is no data for seleted timeframe"
  else:
      for folder in folder_list:
          # this creates empty file with sheet name 'Sheet1'
          writer=pd.ExcelWriter(f'\\\\my\username\Documents\Python\Split DataFrame by Multiple dataframes\{folder}\{folder}.xlsx',engine='xlsxwriter') 
          wb = writer.book
          ws = writer.sheets['Sheet1'] # this gives me an error
          writer.save()
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <pre><code>Traceback (most recent call last):
    File "\\my\username\Documents\Python\Split DataFrame by Multiple dataframes\tempCodeRunnerFile.py", line 41, in &lt;module&gt;
      ws = writer.sheets['Sheet1'] # this gives me an error
  KeyError: 'Sheet1'
  </code></pre>