boto3 read excel file from s3

Solutions on MaxInterview for boto3 read excel file from s3 by the best coders in the world

showing results for - "boto3 read excel file from s3"
Chantal
13 Aug 2019
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
similar questions
queries leading to this page
boto3 read excel file from s3