readxl
readxl copied to clipboard
Provide some way to read multiple sheets in one function call
Like vroom::vroom()
and readr::read_csv()
when given a vector of file names; readxl should have something similar for sheet names. And maybe for sheets?
In my use case, I also need to read all sheets from a file and the number or names of sheets are unknown.
For example, I need to transform each sheet of an Excel workbook into a new data frame, but there does not seem to be a way to know how many sheets are in the workbook from readxl functions.
@renkun-ken Have a look at excel_sheets()
@jennybc Thanks a lot!