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

In googlesheets: Manage Google Spreadsheets from R

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

## 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)

## End(Not run)

googlesheets documentation built on May 2, 2019, 1:57 p.m.