How to upload excel file to AWS S3 using an AWS lambda function in python

Question

I have an excel file in generated from a Lamba function, stored in the /tmp/ folder, I want to store it in a S3 bucket, I have setup the permisions and the bucket, but when I complete the function it creates an damaged excel file in the bucket, which cannot be opened.

The code I used:

import boto3

def uploadtoS3(filename=str):
    s3 = boto3.client('s3')
    bucket = 'aws-day-ahead-estimations'
    DirName = '/tmp/' + filename
    s3.put_object(Bucket=bucket,Body=DirName,Key=filename)
    print('put complete')

Taron Qalashyan · Accepted Answer · 2023-01-18 11:36:24Z

1

When you use the put_object() method, the Body parameter expects the actual content of the file, not the file path.

You can fix this:

def uploadtoS3(filename=str):
    s3 = boto3.client('s3')
    bucket = 'aws-day-ahead-estimations'
    file_path = '/tmp/' + filename
    try:
        with open(file_path, 'rb') as f:
            s3.put_object(Bucket=bucket, Body=f, Key=filename)
            print('put complete')
    except Exception as e:
        print(f"An error occurred: {e}")

Another approach is to use the upload_file() method of the S3 client instead of the put_object() method.

answered Jan 18, 2023 at 11:36

Taron Qalashyan

7214 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Renzins Pukis Over a year ago

Thank you! This was precisely what I needed, for future endeavors, if I had used the upload_file() method, then the file path would have been sufficient?

Taron Qalashyan Over a year ago

Yes file path would have been enough.

Collectives™ on Stack Overflow

How to upload excel file to AWS S3 using an AWS lambda function in python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related