Boto3 read excel file from s3

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

Similar codes

5 votes139 views4 answers
Python save dictionary to file
Python
0 vote75 views3 answers
Django messages
Python
4 votes117 views3 answers
Gui python
Python
19 votes109 views1 answer
Python left string
Python
0 vote108 views1 answer
Convert ipynb to py
Python
1 vote116 views1 answer
Django filter text first character upper case
Python
1 vote127 views1 answer
Python list add if not present
Python
0 vote108 views1 answer
Django iterate over all objects
Python
2 votes111 views2 answers
Python check string for negative number
Python
2 votes131 views1 answer
Save pandas dataframe to parquet
Python