read_excel_url: Read excel files from URL
In eysteinmeese91/magimisc: What the Package Does (One Line, Title Case)

Description Usage Arguments Value Examples

View source: R/read_excel_url.R

This function use readxl::read_excel to read files directly from a URL. Other arguments are passed directly to read_excel. See read_excel. The function use GET from the httr-package to download the file and write_disk from the same package to write the file.

read_excel_url(
  path,
  sheet = NULL,
  range = NULL,
  col_names = TRUE,
  col_types = NULL,
  na = "",
  trim_ws = TRUE,
  skip = 0,
  n_max = Inf,
  guess_max = min(1000, n_max),
  progress = readxl::readxl_progress(),
  .name_repair = "unique"
)

`path`	String to the path, Will only work with valid and open URLs
`sheet`	Sheet to read. Either a string (the name of a sheet), or an integer (the position of the sheet). Ignored if the sheet is specified via `range`. If neither argument specifies the sheet, defaults to the first sheet.
`range`	A cell range to read from, as described in cell-specification. Includes typical Excel ranges like "B3:D87", possibly including the sheet name like "Budget!B2:G14", and more. Interpreted strictly, even if the range forces the inclusion of leading or trailing empty rows or columns. Takes precedence over `skip`, `n_max` and `sheet`.
`col_names`	`TRUE` to use the first row as column names, `FALSE` to get default names, or a character vector giving a name for each column. If user provides `col_types` as a vector, `col_names` can have one entry per column, i.e. have the same length as `col_types`, or one entry per unskipped column.
`col_types`	Either `NULL` to guess all from the spreadsheet or a character vector containing one entry per column from these options: "skip", "guess", "logical", "numeric", "date", "text" or "list". If exactly one `col_type` is specified, it will be recycled. The content of a cell in a skipped column is never read and that column will not appear in the data frame output. A list cell loads a column as a list of length 1 vectors, which are typed using the type guessing logic from `col_types = NULL`, but on a cell-by-cell basis.
`na`	Character vector of strings to interpret as missing values. By default, readxl treats blank cells as missing data.
`trim_ws`	Should leading and trailing whitespace be trimmed?
`skip`	Minimum number of rows to skip before reading anything, be it column names or data. Leading empty rows are automatically skipped, so this is a lower bound. Ignored if `range` is given.
`n_max`	Maximum number of data rows to read. Trailing empty rows are automatically skipped, so this is an upper bound on the number of rows in the returned tibble. Ignored if `range` is given.
`guess_max`	Maximum number of data rows to use for guessing column types.
`progress`	Display a progress spinner? By default, the spinner appears only in an interactive session, outside the context of knitting a document, and when the call is likely to run for several seconds or more. See `readxl_progress()` for more details.
`.name_repair`	Handling of column names. By default, readxl ensures column names are not empty and are unique. If the tibble package version is recent enough, there is full support for `.name_repair` as documented in `tibble::tibble()`. If an older version of tibble is present, readxl falls back to name repair in the style of tibble v1.4.2.