Read simple table from csv or xls or xlsx.
For excel format, must be simple table on first tab,
one row for header (column names),
data itself starting in first cell of second row, like A2, and
all other rows and columns must be empty.
Usage
read_csv_or_xl(fname = NULL, show_col_types = FALSE, rowsize_warn = 30 * 1000)
Arguments
- fname
full path to folder and filename
- show_col_types
FALSE makes it print less to console as it reads using readr::read_csv()
- rowsize_warn
Give warning if there are more than this many rows in the table
Value
data.frame with contents of table it read
Details
If in RStudio, interactively can select file from local drive. Also used by EJAM shiny app for file uploads.
