Learn R Programming

googlesheets (version 0.3.0)

gs_upload: Upload a file and convert it to a Google Sheet

Description

Google supports the following file types to be converted to a Google spreadsheet: .xls, .xlsx, .csv, .tsv, .txt, .tab, .xlsm, .xlt, .xltx, .xltm, .ods. The newly uploaded file will appear in your Google Sheets home screen. This function calls the Google Drive API.

Usage

gs_upload(file, sheet_title = NULL, verbose = TRUE, overwrite = FALSE)

Arguments

file

path to the file to upload

sheet_title

the title of the spreadsheet; optional, if not specified then the name of the file will be used

verbose

logical; do you want informative messages?

overwrite

whether to overwrite an existing Sheet with the same title

Examples

Run this code
# NOT RUN {
write.csv(head(iris, 5), "iris.csv", row.names = FALSE)
iris_ss <- gs_upload("iris.csv")
iris_ss
gs_read(iris_ss)
file.remove("iris.csv")
gs_delete(iris_ss)
# }
# NOT RUN {
# }

Run the code above in your browser using DataLab