Example file deaths.xlsx

This spreadsheet is one of the example spreadsheets provided in the readxl package. We can use the readxl_example() function to locate the spreadsheet on your system in the directory where the package is installed.

deaths_path <- readxl_example("deaths.xlsx")

deaths <- read_excel(deaths_path)
## New names:
## • `` -> `...2`
## • `` -> `...3`
## • `` -> `...4`
## • `` -> `...5`
## • `` -> `...6`
deaths
## # A tibble: 18 × 6
##    `Lots of people`             ...2                     ...3  ...4  ...5  ...6 
##    <chr>                        <chr>                    <chr> <chr> <chr> <chr>
##  1 simply cannot resist writing <NA>                     <NA>  <NA>  <NA>  some…
##  2 at                           the                      top   <NA>  of    thei…
##  3 or                           merging                  <NA>  <NA>  <NA>  cells
##  4 Name                         Profession               Age   Has … Date… Date…
##  5 David Bowie                  musician                 69    TRUE  17175 42379
##  6 Carrie Fisher                actor                    60    TRUE  20749 42731
##  7 Chuck Berry                  musician                 90    TRUE  9788  42812
##  8 Bill Paxton                  actor                    61    TRUE  20226 42791
##  9 Prince                       musician                 57    TRUE  21343 42481
## 10 Alan Rickman                 actor                    69    FALSE 16854 42383
## 11 Florence Henderson           actor                    82    TRUE  12464 42698
## 12 Harper Lee                   author                   89    FALSE 9615  42419
## 13 Zsa Zsa Gábor                actor                    99    TRUE  6247  42722
## 14 George Michael               musician                 53    FALSE 23187 42729
## 15 Some                         <NA>                     <NA>  <NA>  <NA>  <NA> 
## 16 <NA>                         also like to write stuff <NA>  <NA>  <NA>  <NA> 
## 17 <NA>                         <NA>                     at t… bott… <NA>  <NA> 
## 18 <NA>                         <NA>                     <NA>  <NA>  <NA>  too!