Get names of worksheets

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"