Read Excel Allsheets

Read in all sheets in an Excel file.

read_excel_allsheets(filename)

Arguments

filename

Name of Excel file

Value

Dataframe

Examples

read_excel_allsheets(readxl::readxl_example("clippy.xls"))
#> $`list-column`
#> # A tibble: 4 × 2
#>   name                 value              
#>   <chr>                <chr>              
#> 1 Name                 Clippy             
#> 2 Species              paperclip          
#> 3 Approx date of death 39083              
#> 4 Weight in grams      0.90000000000000002
#> 
#> $`two-row-header`
#> # A tibble: 2 × 4
#>   name       species              death                 weight             
#>   <chr>      <chr>                <chr>                 <chr>              
#> 1 (at birth) (office supply type) (date is approximate) (in grams)         
#> 2 Clippy     paperclip            39083                 0.90000000000000002
#>