Read '.xlsx' files stored in a SharePoint — SharePoint_xlsx • read365

This function reads '.xlsx' files stored in a SharePoint

Usage

SharePoint_xlsx(SharePoint, drive, file, ...)

Arguments

SharePoint: url
drive: SharePoint drive
file: '.xlsx' file path
...: readxl::read_excel() arguments

Note

You may read several 'xlsx' sheets using sheet = c('sheet1', 'sheet2')

Examples

if (FALSE) {
SharePoint_xlsx(
  SharePoint = "https://page.sharepoint.com",
  drive = "Documents",
  file = "Book.xlsx",
  sheet = c("Sheet1", "Sheet2")
  )
}