readxl icon indicating copy to clipboard operation
readxl copied to clipboard

Provide some way to read multiple sheets in one function call

Open hadley opened this issue 2 years ago • 3 comments

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?

hadley avatar Oct 01 '21 14:10 hadley

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 avatar Apr 01 '22 01:04 renkun-ken

@renkun-ken Have a look at excel_sheets()

jennybc avatar Apr 01 '22 04:04 jennybc

@jennybc Thanks a lot!

renkun-ken avatar Apr 01 '22 06:04 renkun-ken