List available sheets within a file

Useful when reading an Excel file to quickly check what other sheets are available.

Usage

sheets(x)

Arguments

x

a dataframe, presumably returned by smart_read

Value

vector of sheet names, or NULL if the file was not an Excel workbook

Author

Tom Elliott

Examples

cas_file <- system.file("extdata/cas500.xls", package = "iNZightTools")
cas <- smart_read(cas_file)
#> Warning: There were 5 warnings in `mutate()`.
#> The first warning was:
#> ℹ In argument: `rightfoot = .Primitive("as.double")(rightfoot)`.
#> Caused by warning:
#> ! NAs introduced by coercion
#> ℹ Run `dplyr::last_dplyr_warnings()` to see the 4 remaining warnings.
sheets(cas)
#> [1] "Census at School-500"