title: Python - Excel adding custom column headings
body: <p>I am using the Coinmarketcap REST Api for having the latest cryptocurrency categories.<br />
  The code prints the JSON response into a DataFrame which is used for the transfer to excel (df.to_excel). Im using the &quot;for column in df&quot; for a bigger width in excel.<br />
  Now I would like to know how I can add costum column headings into the excel sheet.</p>
  <pre class="lang-py prettyprint-override"><code>def Cryptocurrencies():
      url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/categories'
      parameters = {
  
      }
      headers = {
          'Accept': 'application/json',
          'X-CMC_PRO_API_KEY': 'mypersonalapikey',
      }
  
      session = Session()
      session.headers.update(headers)
      data = session.get(url, params=parameters)
  
      response = session.get(url, params=parameters)
      f = (json.loads(response.text)['data'])
      df = pd.DataFrame(f)
      writer = pd.ExcelWriter(&quot;Workingpaper1D.xlsx&quot;,
                              engine='xlsxwriter',
                              datetime_format='mmm d yyyy hh:mm:ss',
                              date_format='mmmm dd yyyy')
      df.to_excel(writer, sheet_name='Sheet1',
                  startrow=1, header=False, index=False, )
      (max_row, max_col) = df.shape
      worksheet = writer.sheets['Sheet1']
      worksheet.autofilter(0, 0, max_row, max_col - 1)
      for column in df:
          column_length = max(df[column].astype(str).map(len).max(), len(column))
          col_idx = df.columns.get_loc(column)
          writer.sheets['Sheet1'].set_column(col_idx, col_idx, column_length)
      writer.save()
      print(df)
      return
  </code></pre>