1import openpyxl
2import io
3import boto3
4
5s3_file = s3.get_object(Bucket=bucket, Key=key)
6xlsx_file = openpyxl.load_workbook(io.BytesIO(s3_file['Body'].read()))
7
8#for more on how to use openpyxl follow this link https://www.pythonexcel.com/openpyxl.php