Accessing Excel file from Sharepoint with R
I use
library(readxl)
read_excel('//companySharepointSite/project/.../ExcelFilename.xlsx', 'Sheet1', skip=1)
Note, no https:
, and sometimes I have to open the file first (i.e., cut and paste //companySharepointSite/project/.../ExcelFilename.xlsx
into my browser's address bar)
Import file from Sharepoint to R
Got it! .xlsb did not work but .xlsx and .csv work fine. Moreover, I needed the "?Web=0" extension at the end of my url for the sharepoint.
Related Topics
Loop Character Values in Ggtitle
Importing Data into R from Google Spreadsheet
Enter New Column Names as String in Dplyr's Rename Function
Detect Non Ascii Characters in a String
Run R Script from .Bat (Batch File)
Read CSV with Dates and Numbers
Grouped Barplot with Cut Y Axis
Dplyr::N() Returns "Error: This Function Should Not Be Called Directly"
Subtracting Values Group-Wise by the Average of Each Group in R
Doing a Plyr Operation on Every Row of a Data Frame in R
How to Use the Row.Names Attribute to Order the Rows of My Dataframe in R
How to Generate Ascii "Graphical Output" from R
How to Write an R Function That Evaluates an Expression Within a Data-Frame