+1 vote
in Programming Languages by (45.3k points)

I want to find all the sheets in an xlsx file using R. Is there any R library/function that I can use for it?

1 Answer

+3 votes
by (176k points)
selected by
 
Best answer

You can use the excel_sheets() function of the readxl library to find all the sheets in a given xlsx file.

Here is an examples:

library("readxl")

all_sheets <- excel_sheets(xlsx_file)

where, xlsx_file: your xlsx file with complete path. 


...