Helper function for parsing an Excel file hosted on a website or FTP server.

parse_remote_excel(path, ...)

Arguments

path

The URL or FTP directory of the Excel file.

...

Other arguments to pass to readxl::read_excel()

Value

A dataframe.

Note

This function will be defunct once readxl::read_excel() supports reading from more general inputs.

Examples

if (FALSE) { parse_remote_excel(paste0("https://github.com/", "InteragencyEcologicalProgram/Status-and-Trends/blob/", "9d1ba8ec3f475e96dbdd7788b45c26fb0fc55b0b/data/", "EMPMysidBPUEMatrixAug2019.xlsx?raw=true"), sheet = "MysidBPUEMatrix1972-2018", guess_max = 100000) }