We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parenta4e59f7 commit6f6f77eCopy full SHA for 6f6f77e
R/gsheet2text.R
@@ -27,7 +27,7 @@ gsheet2text <- function(url, format='csv', sheetid = NULL){
27
if(is.null(sheetid)&stringr::str_detect(url,'gid=[[:digit:]]+')){
28
sheetid<-url %>%stringr::str_extract('gid=[[:digit:]]+') %>%stringr::str_extract('[[:digit:]]+') %>% as.numeric()
29
}
30
-address<- paste0('https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=',key,'&exportFormat=',format)
+address<- paste0('https://docs.google.com/spreadsheets/export?id=',key,'&format=',format)
31
if(!is.null(sheetid)){
32
address<- paste0(address,'&gid=',sheetid)
33