read_excel_allsheets: Read all excel sheets
In tengku-hanis/niceFunction: These are random nice functions that I found
Description
Usage
Arguments
Examples
View source: R/read_excel_allsheets.R
Description
read_excel_allsheets read all excel sheets. Function was adapted from https://stackoverflow.com/a/12945838/11215767
Usage
1
read_excel_allsheets(filename, pages = sheets, tibble = FALSE)
Arguments
filename
excel files
pages
number of order of sheets in the excel (to select certain sheets)
tibble
set to TRUE for tibble format (default is FALSE)
Examples
1
2
3
4
5
6
## Read all excel sheets
## Not run: read_excel_allsheets("datasets")
## Read several excel sheets
## Not run: read_excel_allsheets("datasets", pages = 2:5)
tengku-hanis/niceFunction documentation built on Oct. 27, 2021, 7:41 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 Examples
View source: R/read_excel_allsheets.R
Description
read_excel_allsheets read all excel sheets. Function was adapted from https://stackoverflow.com/a/12945838/11215767
Usage
1 | read_excel_allsheets(filename, pages = sheets, tibble = FALSE)
|
Arguments
filename |
excel files |
pages |
number of order of sheets in the excel (to select certain sheets) |
tibble |
set to TRUE for tibble format (default is FALSE) |
Examples
1 2 3 4 5 6 | ## Read all excel sheets
## Not run: read_excel_allsheets("datasets")
## Read several excel sheets
## Not run: read_excel_allsheets("datasets", pages = 2:5)
|
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.