Read sheets from S3 Objects / Excel — s3_excel_sheets • grabr

Read sheets from S3 Objects / Excel

Usage

s3_excel_sheets(bucket, object_key, access_key, secret_key)

Arguments

bucket: S3 Bucket
object_key: S3 Object Key
access_key: S3 Access Key
secret_key: S3 Secret Key

Value

Excel sheets as data frame

Examples

if (FALSE) { # \dontrun{
s3_objects(
    bucket = "sample-bucket",
    prefix = "ddc/xyz/ABC") %>%
  filter(str_detect(key, "^HFR")) %>%
  pull(key) %>%
  first() %>%
  s3_excel_sheets(bucket = "<sample-bucket>", object_key = .)} # }