Extract the number of sheets from an Excel workbook in R (without XLConnect)

r excel xlconnect
Kaveh Dianati picture Kaveh Dianati · Nov 11, 2016 · Viewed 9.2k times · Source

I'm relatively new to R (and programming). I have an Excel workbook with 36 sheets, but suppose that I don't know how many sheets there are and I want my code to find that out for me. I have tried something like:

options(java.parameters = "-Xmx6g")
library(XLConnect)
myWorkbook <- loadWorkbook(filename)
numberofsheets <- length(getSheets(myWorkbook))

But even though I set my memory to 6GB I still run into memory errors with XLConnect, so I would like to use other packages (e.g. xlsx, openxlsx). Is there a way to find out the number of sheets in an Excel workbook without using XLConnect? Thanks for your help.

Answer

rosscova picture rosscova · Nov 11, 2016

Maybe try:

library( readxl )
length( excel_sheets( filename ) )

Related questions

Read all worksheets in an Excel workbook into an R list with data.frames

I understand that XLConnect can be used to read an Excel worksheet into R. For example, this would read the first worksheet in a workbook called test.xls into R. library(XLConnect) readWorksheetFromFile('test.xls', sheet = 1) I have an Excel …

Read More
How to fix OutOfMemoryError (Java): GC overhead limit exceeded in r?

I have to read a file in a list of folders and save data in R. I use following code for my test data and it works. When I use the code for the actual data then I get this …

Read More
How to extract sheet names from Excel file in R

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&…

Read More