Upload a file and convert it to a Google Sheet

Share:

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

1
gs_upload(file, sheet_title = NULL, verbose = TRUE)

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?

Examples

1
2
3
4
5
6
7
8
9
## 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)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.