Search code examples
rshinysharepoint-onlineonedrivemicrosoft365r

open a OneDrive file with r

Im tring to create a shiny app that read and online onedrive xlsx file and show some things, but for the moment Im unable to read the onedrive xlsx file, I already explore the Microsoft365R and I can conect to my onedrive and I even can open the fil but... what it does is from r open a tab in chrome with the excel file.

I need the file in the local enviroment of r.. this its beacause the shiny app must be deploy in a web server, that every time the app runs it reads the update the file.

library(Microsfot365R)

odb <- get_business_onedrive()
odb$open_file("lcursos.xlsx")

Also this its a business account, so I also have to put the username and key to acces each file, that its beacause use the simple url doesnt work, it says Error 403 FORBIDEEN.

Any ideas? Thank you so much!

Solution

  • In 2021, I was unable to do follow your answer, so I use Google googledrive library in that time to solve the problem. Now I face the same challenge, so I checking it, and I find the way to solve it.

    Thanks

    library(Microsoft365R)
library(AzureGraph)

od <- get_business_onedrive()
od$list_files()

dest <- tempfile(fileext = ".xlsx")

od$download_file("Documentos/lcursos.xlsx", dest=dest,overwrite = T)

open_in_r<-readxl::read_excel(dest)