DownloadXLSX: Download and read Excel (.xlsx) file

In NumbersInternational/flipAPI: Web APIs tools

Download and read Excel (.xlsx) file

Description

Download and read Excel (.xlsx) file

Usage

DownloadXLSX(
  url,
  sheet = 1,
  want.data.frame = FALSE,
  want.factors = TRUE,
  want.col.names = NULL,
  want.row.names = NULL,
  us.format = TRUE,
  ...
)

Arguments

url	Link to XLSX file. Can also be the path to a file on your local machine.
sheet	Sheet of excel workbook to read from. By default only the first worksheet is read
want.data.frame	Whether to return a data frame instead of a matrix or vector. If this is set to FALSE (default), then the function will return the simplest data structure it can.
want.factors	Whether a text variable should be converted to a factor in a data frame.
want.col.names	Whether to interpret the first row as column names in a data frame. This is ignored if want.data.frame is FALSE.
want.row.names	Whether to interpret the first col as row names in a data frame. This is ignored if want.data.frame is FALSE.
us.format	Whether to use the US convention when parsing dates in a data frame.
...	Other parameters to pass to readxl::read_excel

NumbersInternational/flipAPI documentation built on April 17, 2024, 2:46 p.m.