Read table of data from .csv or .xlsx Excel file

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,
  path = NULL,
  show_col_types = FALSE,
  rowsize_warn = 30 * 1000
)

Arguments

fname

full path to folder and filename

path

optional, ignored if name provided or !interactive(). If fname NOT provided, and interactive(), the folder to look in by default when interactively picking a file to read.

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.