Download and read Excel sheets from R

onedriveR.R

library(Microsoft365R)
library(tidyverse)
library(readxl)

odb <- get_business_onedrive(app = "d44a05d5-c6a5-4bbb-82d2-443123722380")

### Check files
odb$list_items()

### Check files in "Documents"
odb$list_items("Documents")


### Download one excel file in the roots
odb$download_file("DemographicsTemplate_CHD.xlsx", dest = "~/test.xlsx")

f <- tempfile(fileext = ".xlsx")
odb$download_file("DemographicsTemplate_CHD.xlsx",
                  dest = f,
                  overwrite = TRUE)
df <- read_excel(f)