Read single worksheet
You can read a single worksheet from a spreadsheet with the sheet argument in read_excel(). The default, which we’ve been relying on up until now, is the first sheet.
## # A tibble: 52 × 8
## species island bill_length_mm bill_depth_mm flipper_length_mm body_mass_g
## <chr> <chr> <chr> <chr> <chr> <chr>
## 1 Adelie Torgersen 39.1 18.7 181 3750
## 2 Adelie Torgersen 39.5 17.399999999… 186 3800
## 3 Adelie Torgersen 40.29999999999… 18 195 3250
## 4 Adelie Torgersen NA NA NA NA
## 5 Adelie Torgersen 36.70000000000… 19.3 193 3450
## 6 Adelie Torgersen 39.29999999999… 20.6 190 3650
## 7 Adelie Torgersen 38.9 17.8 181 3625
## 8 Adelie Torgersen 39.20000000000… 19.600000000… 195 4675
## 9 Adelie Torgersen 34.1 18.100000000… 193 3475
## 10 Adelie Torgersen 42 20.2 190 4250
## # ℹ 42 more rows
## # ℹ 2 more variables: sex <chr>, year <dbl>