+1 vote
in Programming Languages by (63.4k 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 (271k 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:


all_sheets <- excel_sheets(xlsx_file)

where, xlsx_file: your xlsx file with complete path.