Unable to read xlsb excel file into R studio

Hi All,

i am facing issue while importing excel database file (xlsb) in R studio.am getting (expecting < ) error .
Kindly advise what can i do to read such type of format files in R.

If you're in windows you can use the excel.link package. You can also connect to the xlsb file using odbc. Others have told me the odbc connection is generally slower.

xlsb are a binary format that is notoriously hard to interact with.

You can also access them via pyxlsb which is a python library so you'll need to use the anaconda R package in order to use it.

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.