How to find all the sheets in a spreadsheet using R?

Question

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?

Answer 1

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.