To read excel file from SharePoint

General
1

I tried to read an excel file from SharePoint using the library (readxl) as follows;

library("readxl")
df<-read_excel("//sharepoint.com/:t:/s/sites/Resistent/_travel/12/Doc.aspx?sourcedoc=%8tr-62t-666r-TT42-TyrEE%8T&file=Team.xlsx&action=default&mobileredirect=true",'Team1',skip = 1)

But I am getting error as path does not exist.
Any help..
2

You could try to map your SharePoint as a network drive:

https://www.clouddirect.net/knowledge-base/KB0011543/mapping-a-sharepoint-site-as-a-network-drive

Your files are then accessible via your file directory and you should be able to open them in R.

3

sure thank you let me try this option.

4

Yes I tried this option and it works [noveld]. Thank you so much for your help.