We are planning to automate some excel tasks using R. For that, we need this
Even, we have tried Import dataset option, also.
Error: 'Permission denied', however we are having access to those sharepoint files.
Error using Import option: HTTP Error 401
I am able to access all my local files in R, but not the files in cloud.
Code:
install.packages("RCurl")
install.packages("XML")
install.packages("data.table")
install.packages("RMySQL")
library(RCurl)
library(XML)
library(data.table)
library(RMySQL)
library(DBI)
url <- "LINK WILL BE SPECIFIED HERE (Link is confidential)"
setwd(file.path("C:/"))
local <- file.path("new task")
download.file(url,local)
System Information:
- RStudio Edition: Desktop
- RStudio Version: 1.1.453
- OS Version: Windows 10 Enterprise
- R Version: 3.5.1 patched