List all sheets in an excel spreadsheet

excel_sheets(path)

Arguments

path

Path to the xls/xlsx file.

Examples

excel_sheets(readxl_example("datasets.xlsx"))
#> [1] "iris" "mtcars" "chickwts" "quakes"
excel_sheets(readxl_example("datasets.xls"))
#> [1] "iris" "mtcars" "chickwts" "quakes"
# To load all sheets in a workbook, use lapply path <- readxl_example("datasets.xls") lapply(excel_sheets(path), read_excel, path = path)
#> [[1]] #> # A tibble: 150 x 5 #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> <dbl> <dbl> <dbl> <dbl> <chr> #> 1 5.10 3.50 1.40 0.200 setosa #> 2 4.90 3.00 1.40 0.200 setosa #> 3 4.70 3.20 1.30 0.200 setosa #> 4 4.60 3.10 1.50 0.200 setosa #> 5 5.00 3.60 1.40 0.200 setosa #> 6 5.40 3.90 1.70 0.400 setosa #> 7 4.60 3.40 1.40 0.300 setosa #> 8 5.00 3.40 1.50 0.200 setosa #> 9 4.40 2.90 1.40 0.200 setosa #> 10 4.90 3.10 1.50 0.100 setosa #> # ... with 140 more rows #> #> [[2]] #> # A tibble: 32 x 11 #> mpg cyl disp hp drat wt qsec vs am gear carb #> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> #> 1 21.0 6. 160. 110. 3.90 2.62 16.5 0. 1. 4. 4. #> 2 21.0 6. 160. 110. 3.90 2.88 17.0 0. 1. 4. 4. #> 3 22.8 4. 108. 93. 3.85 2.32 18.6 1. 1. 4. 1. #> 4 21.4 6. 258. 110. 3.08 3.22 19.4 1. 0. 3. 1. #> 5 18.7 8. 360. 175. 3.15 3.44 17.0 0. 0. 3. 2. #> 6 18.1 6. 225. 105. 2.76 3.46 20.2 1. 0. 3. 1. #> 7 14.3 8. 360. 245. 3.21 3.57 15.8 0. 0. 3. 4. #> 8 24.4 4. 147. 62. 3.69 3.19 20.0 1. 0. 4. 2. #> 9 22.8 4. 141. 95. 3.92 3.15 22.9 1. 0. 4. 2. #> 10 19.2 6. 168. 123. 3.92 3.44 18.3 1. 0. 4. 4. #> # ... with 22 more rows #> #> [[3]] #> # A tibble: 71 x 2 #> weight feed #> <dbl> <chr> #> 1 179. horsebean #> 2 160. horsebean #> 3 136. horsebean #> 4 227. horsebean #> 5 217. horsebean #> 6 168. horsebean #> 7 108. horsebean #> 8 124. horsebean #> 9 143. horsebean #> 10 140. horsebean #> # ... with 61 more rows #> #> [[4]] #> # A tibble: 1,000 x 5 #> lat long depth mag stations #> <dbl> <dbl> <dbl> <dbl> <dbl> #> 1 -20.4 182. 562. 4.80 41. #> 2 -20.6 181. 650. 4.20 15. #> 3 -26.0 184. 42. 5.40 43. #> 4 -18.0 182. 626. 4.10 19. #> 5 -20.4 182. 649. 4.00 11. #> 6 -19.7 184. 195. 4.00 12. #> 7 -11.7 166. 82. 4.80 43. #> 8 -28.1 182. 194. 4.40 15. #> 9 -28.7 182. 211. 4.70 35. #> 10 -17.5 180. 622. 4.30 19. #> # ... with 990 more rows #>