Get names of worksheets

Returns the worksheet names within an xlsx file

Usage

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"