DownloadXLSX: Download and read Excel (.xlsx) file

Description Usage Arguments

View source: R/Excel.R

Description

Download and read Excel (.xlsx) file

Usage

1
2
3
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 May 7, 2019, 6:20 p.m.