java解析xlsb文件,如何在R中打开.xlsb文件？

I'm trying to open an .xlsb file in R and keep getting similar errors.

Any recommendations on how to solve this issue without having to download the data and save it in a different formate?

read.xlsx(paste(OutputLocation,FileName, sep=""), sheetName = "Master Data")

Error messages:

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :

org.apache.poi.xssf.XLSBUnsupportedException: .XLSB Binary Workbooks are not supported

rigDataWB

Error messages:

Error: XLSBUnsupportedException (Java): .XLSB Binary Workbooks are not supported

Please note:

I cannot install Perl libraries.

I'm running 64bit R.

解决方案

Use the RODBC package:

library(RODBC)

wb

con2

data

nrow(data)