tidyverse / googlesheets4

Google Spreadsheets R API (reboot of the googlesheets package)
https://googlesheets4.tidyverse.org
Other
360 stars 53 forks source link

Import from range-bearing URL #5

Open jennybc opened 6 years ago

jennybc commented 6 years ago

If you select a range in Google Sheets and control click, you can copy its URL to the clipboard.

Exploit that.

Here's what such a URL might look like:

https://docs.google.com/spreadsheets/d/1cMH-nYGhhYlBU3wbi9OQ0hJDJn5qb8_kIvfNsGmX7UQ/edit#gid=558631835&range=A5:F15

Likewise, any browsing function should be prepared to do the inverse, ie. navigate to a specific sheet or range.

jennybc commented 4 years ago

Also applies to a URL that just contains (work)sheet ID.

ha0ye commented 11 months ago

I would like this feature!