How to read xlsb files?

Question

I am trying to read a range into a data frame from a xlsb workbook. Can I do this with the xlsx package in R? If not, does anyone know of a way to do it?

Answer 1

Have a look at the excel.linkpackage here. It allows you to write / read data easily like so :

df<-xl[a1:b2] # if the file is open

or

df<-xl.read.file('filename.xlsb',header=TRUE, top.left.cell="A1") # if the file isn't open