readxl_online: Read an Excel file from a URL

In poldham/oldhammisc: Miscellaneous functions, mainly for tidying and wrangling data

Description

Read an online excel file where the URL contains the file extension or a zip file. The type argument attempts to address cases where the file extension is known but is not found in the url itself.

Usage

readxl_online(url, type = NULL, ...)

Arguments

url	A url containing an excel .xls or xlsx or .zip file extension
type	.xls or .xlsx or other excel type (not tested)
...	Other arguments to readxl::read_excel

Value

data.frame

Examples

## Not run:  dfxls <- readxl_online("https://github.com/wipo-analytics/opensource-patent-analytics/blob/master/2_datasets/pizza_all_24294/patentscope_pizza_1940_2005_9659.xls?raw=true")

dfxlsx <- readxl_online("https://github.com/wipo-analytics/opensource-patent-analytics/blob/master/2_datasets/ewaste/ewaste.xlsx?raw=true")

dfzip <- readxl_online("https://github.com/poldham/opensource-patent-analytics/blob/master/2_datasets/taxonomy_final.zip?raw=true")

## End(Not run)

poldham/oldhammisc documentation built on May 25, 2019, 11:23 a.m.