title: Blob file (password protected) to Pandas Dataframe
body: <p>So I want to put the contents of my <strong>blob file</strong> (which is of type application/octet-stream file) to a <strong>Pandas dataframe</strong>.
  My blob file was uploaded as a <strong>password protected excel file</strong> so I wanted to know how can I use the pd.read_csv or pd.read_excel using <strong>my blob file which is password protected</strong>.</p>
  <pre><code>from azure.storage.blob import ContainerClient
  from io import StringIO
  import pandas as pd
  from io import BytesIO
  from azure.storage.blob import BlobClient
  import xlrd
  from azure.storage.blob import BlobServiceClient
  import logging
  import msoffcrypto
  
  conn_str = &quot;&quot;
  container = &quot;&quot;
  blob_name = &quot;&quot;
  
  container_client = ContainerClient.from_connection_string(
      conn_str=conn_str, 
      container_name=container
      )
  downloaded_blob = container_client.download_blob(blob_name)
  
  # Blob service client
  
  blob_service_client = BlobServiceClient.from_connection_string(conn_str=conn_str)
  
  # Het ContainerClient
  
  container_client = blob_service_client.get_container_client(container)
  
  # Get BlobClient
  
  logging.info('Blob exists')
  
  blob_list = container_client.list_blobs()
  
  for blob in blob_list:
  
      logging.info(&quot;\t&quot; + blob.name)
  
      blob_client = container_client.get_blob_client(blob.name)
  
  # Download Blob Data
  
      blob_data = None
  
      blob_data = blob_client.download_blob()
  
      passwd = '1234'
  
  
  
      with open(pd.read_excel(BytesIO(blob_data.readall())), 'rb') as file:
          office_file = msoffcrypto.OfficeFile(file)
          office_file.load_key(password=passwd)
          office_file.decrypt(decrypted_workbook)
  </code></pre>
  <blockquote>
  <p>XLRDError: Can't find workbook in OLE2 compound document</p>
  </blockquote>