xxxxxxxxxx
import io
import pandas as pd
s3 = boto3.client('s3')
obj = s3.get_object(Bucket='bucket_name', Key='key_name')
df = pd.read_excel(io.BytesIO(obj['Body'].read()))
xxxxxxxxxx
import openpyxl
import io
import boto3
s3_file = s3.get_object(Bucket=bucket, Key=key)
xlsx_file = openpyxl.load_workbook(io.BytesIO(s3_file['Body'].read()))
#for more on how to use openpyxl follow this link https://www.pythonexcel.com/openpyxl.php