r - How to convert raw format of an excel file into dataframe

Question

I'm using R to get an object from an AWS S3 bucket. Using the function below returns a 'raw' object. I'm wondering how to convert this into something that is usable within R

library(aws.s3)

test <- get_object("s3://my_bucket/my_excel_file.xlsx")

I am aware of the s3read_using function which could be used like so:

test <- s3read_using(read_excel, object = "my_excel_file", bucket = "my_bucket")

However, I want to know how to obtain the same result but using the get_object function

Any ideas?

question from:https://stackoverflow.com/questions/65937007/how-to-convert-raw-format-of-an-excel-file-into-dataframe

Answer 1

Waitting for answers