Import mapping each spreadsheet of an excel file to a dataframe in a list.

Import mapping each spreadsheet of an excel file to a dataframe in a list.

xlsheets_list(path)

Arguments

path	A path to a single excel file.

Source

Adapted from an article by Jenny Bryan (https://goo.gl/ah8qkX).

Value

A list of dataframes.

Examples

xlsheets_list(misc_example("multiple_sheets.xlsx"))
#> $Sheet1
#> # A tibble: 3 x 2
#>   numbers letters
#>     <dbl> <chr>  
#> 1       1 a      
#> 2       2 b      
#> 3       3 c      
#> 
#> $Sheet2
#> # A tibble: 3 x 2
#>   numbers letters
#>     <dbl>   <dbl>
#> 1       4       7
#> 2       5       8
#> 3       6       9
#>