title: Read Excel from S3 - AttributeError: 'StreamingBody' object has no attribute 'seek'
body: <p>I have a python script which reads an excel file from S3 but getting an error when it's triggered in AWS Batch. The code works fine on another Ubuntu box.</p>
  
  <pre><code>AttributeError: 'StreamingBody' object has no attribute 'seek'
  </code></pre>
  
  <p>Section of my code to read the excel is below</p>
  
  <pre><code>import boto3
  import pandas as pd    
  session = boto3.Session(aws_access_key_id = config.access_key_id, aws_secret_access_key = config.secret_access_key)
  client = session.client('s3') 
  obj = client.get_object(Bucket = s3_bucket, Key = s3_file)    
  df = pd.read_excel(obj['Body'],sheet_name=sheet_name, skiprows=1)
  </code></pre>
  
  <p>Any help is much appreciated.</p>