Description Usage Arguments Value
View source: R/read.xlsx.all.R
Read an entire Excel file workbook (using openxlsx functions)
1 2 3 4 5 6 7 | read.xlsx.all(
xlsxFile,
save2env = FALSE,
names = "",
startRow = 1,
detectDates = TRUE
)
|
xlsxFile |
Path to the xls/xlsx file |
save2env |
Either TRUE to save each worksheet to the environment or FALSE to return a list of worksheets, which can be saved to the environment |
names |
A vector of character data representing preferred sheet names |
startRow |
first row to begin looking for data. Empty rows at the top of a file are always skipped, regardless of the value of startRow. |
detectDates |
If TRUE, attempt to recognise dates and perform conversion. |
If there is more than one worksheet, then a list of data frames that represent each worksheet. If there is only one worksheet, then a data frame.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.