title: Writing pandas dataframe as xlsx file to an azure blob storage without creating a local file
body: <p>I have the following solution using a local file, but I would like to skip that. Is there a possibility?</p>
  <pre><code>blob_service_client = BlobServiceClient(account_url = url, credential = token)
  write_blob_client = blob_service_client.get_blob_client(container=container_name, blob=blob_name)
  filename = &quot;example.xlsx&quot;
  df.to_excel(filename ,index = False)
  with open(filename, &quot;rb&quot;) as df:
  write_blob_client.upload_blob(df, overwrite = True)
  </code></pre>
  <p>Instead of the last three rows I have tried</p>
  <pre><code>teststream = BytesIO(df.to_records(index = False).tostring())
  write_blob_client.upload_blob(teststream, overwrite = True)
  </code></pre>
  <p>This writes an excel file to the blob storage, but when trying to open it I get an error that the file extention doesn't match the format of the file.</p>