Java – illegalargumentexception when trying to import xlsx data into R

When importing the xlsx file into R, I faced the following errors –

mydata <- read.xlsx("C:\\Users\\aniruddha\\Downloads\\failingExample.xlsx",1)
Error in .jcall(row[[ir]],"Lorg/apache/poi/ss/usermodel/Cell;","getCell",:
    java.lang.IllegalArgumentException: Cell index must be >= 0

Can you tell me the reason and possible solutions?

Solution

Please try:

mydata <-read.xlsx2("C:\\Users\\aniruddha\\Downloads\\failingExample.xlsx",1)
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>