read_excel_allsheets: read all excel sheets
In emilBeBri/dttools: Useful Tools Built Around Data.Table
Description
Usage
Arguments
Value
View source: R/read_excel_allsheets.R
Description
read all excel sheets
Usage
1
read_excel_allsheets(filename, tibble = FALSE)
Arguments
filename
location of the excel file
na.strings
case sensitive strings that will be coverted to NA. The function will do a trimws(x,'both') before conversion. If NULL, do only trimws, no conversion to NA.
Value
Returns a vector trimws (always for factor, character) and NA converted (if matching na.strings). Attributes will also be kept ('label','labels', 'value.labels').
emilBeBri/dttools documentation built on April 21, 2021, 5:44 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value
View source: R/read_excel_allsheets.R
Description
read all excel sheets
Usage
1 | read_excel_allsheets(filename, tibble = FALSE)
|
Arguments
filename |
location of the excel file |
na.strings |
case sensitive strings that will be coverted to NA. The function will do a trimws(x,'both') before conversion. If NULL, do only trimws, no conversion to NA. |
Value
Returns a vector trimws (always for factor, character) and NA converted (if matching na.strings). Attributes will also be kept ('label','labels', 'value.labels').
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.