Description Usage Arguments See Also
Read an Entire Excel Workbook into a list of dataframes named by the original spreadsheet name. Arguments are passed to read_excel
for each sheet.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
file |
File path. |
col_names |
|
col_types |
Either |
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 |
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 |
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
|
.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 |
log |
(Deprecated) Log this function call to a log.md file? |
log_details |
(Deprecated) If log is TRUE, additional notes to include with the log entry. |
excel_sheets
,read_excel
set_names
,map
Other excel functions:
is_excel()
,
write_full_excel()
,
write_temp_xlsx()
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.