Get names of worksheets — getSheetNames • openxlsx

Returns the worksheet names within an xlsx file

getSheetNames(file)

Arguments

file: An xlsx or xlsm file.

Value

Character vector of worksheet names.

Author

Alexander Walker

Examples

getSheetNames(system.file("extdata", "readTest.xlsx", package = "openxlsx"))
#>  [1] "Sheet1"  "Sheet2"  "Sheet 3" "Sheet 4" "Sheet 5" "Sheet 6" "1"      
#>  [8] "11"      "111"     "1111"    "11111"   "111111"