Read sheet names from a xlsb file

Asked Jan 22 '21 at 20:56

Active Jan 22 '21 at 21:49

Viewed 626 times

I've been trying to read xlsb files into R. I've tried using excel.link and readxlsb packages and they do work for reading the file but i also need to read the sheet names.

For a normal xlsx i would go gor GetSheets but it does not work for XLSB.

Any suggestion?

Thanks

edited Jan 22 '21 at 21:49

Phil

7,287
3
36
66

asked Jan 22 '21 at 20:56

user3639100

Have you tried using `readxl` package? – Víctor Cortés Jan 22 '21 at 21:28
Try the `readxlsb` package available on CRAN: https://cran.r-project.org/web/packages/readxlsb/vignettes/read-xlsb-workbook.html – Phil Jan 22 '21 at 21:55
how can i read the sheet names with that? – user3639100 Jan 22 '21 at 22:58

Read sheet names from a xlsb file

0 Answers0