## Not run:
# gap_ss <- gs_gap()
# oceania_csv <- gs_read(gap_ss, ws = "Oceania")
# str(oceania_csv)
# oceania_csv
#
# gs_read(gap_ss, ws = "Europe", n_max = 4, col_types = c("cccccc"))
#
# gs_read(gap_ss, ws = "Oceania", range = "A1:C4")
# gs_read(gap_ss, ws = "Oceania", range = "R1C1:R4C3")
# gs_read(gap_ss, ws = "Oceania", range = "R2C1:R4C3", col_names = FALSE)
# gs_read(gap_ss, ws = "Oceania", range = "R2C5:R4C6",
# col_names = c("thing_one", "thing_two"))
# gs_read(gap_ss, ws = "Oceania", range = cell_limits(c(1, 3), c(1, 4)),
# col_names = FALSE)
# gs_read(gap_ss, ws = "Oceania", range = cell_rows(1:5))
# gs_read(gap_ss, ws = "Oceania", range = cell_cols(4:6))
# gs_read(gap_ss, ws = "Oceania", range = cell_cols("A:D"))
#
# ff_ss <- gs_ff() # register example sheet with formulas and formatted nums
# gs_read(ff_ss) # almost all vars are character
# gs_read(ff_ss, literal = FALSE) # more vars are properly numeric
# ## End(Not run)
Run the code above in your browser using DataLab