How to extract sheet names from Excel file in R

excel, r, xlconnect

Solution

You are looking for `getSheets`

Returns all worksheet names in a workbook.

Problem

I have loaded a workbook into R and read in the worksheets using xlConnect, but I was wondering if there was a way of extracting the names of the sheets perhaps in a vector? So far my code is: ``` dataIn<-loadWorkbook(file.path(filenames[1],sep="")) lst = readWorksheet(dataIn, sheet = getSheets(dataIn), startRow=1, startCol=1, header=TRUE) ``` ...and I want to extract the sheet names of the sheets in `lst`.

Original source