CODEWITHSUNDEEP
rxlsx
Helmy Heshmat Helmy
Helmy Heshmat Helmy

Reputation: 1

Getting "invalid entry size" when trying to import Excel xlsx file to R

Every time I enter this line 

cameradata <- read.xlsx("./data/cameras.xlsx" , 1)

I get error:

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.util.zip.ZipException: invalid entry size (expected 500 but got 502 bytes)

I have tried to clear RAM but file size is 10kp

Upvotes: 0

Views: 2498

Answers (3)

user911734
user911734

Reputation: 359

I had experience exactly the same issue. What I did to resolve the problem was:

  1. I had defined separate variable "fileURL2" and assigned "XLSX" download link
  2. I had defined separate variable "cameraData2" and loaded XLSX file to it
  3. I had downloaded file directly with Firefox and open it with MS Excel to assure it is OK, then I had save it to the working directory of "R" overwriting existing "cameras.xlsx" file
  4. After new attempt to read the file with "R" read.xlsx() - was successful

In conclusion it seems that "R" had corrupted XLSX file during the download - which might be caused by a BUG inside of current version of the language.

Upvotes: 0

jatin kashyap
jatin kashyap

Reputation: 93

Try this :- May be this can work. It worked for me

1) when downloading the xlsx file, use this download.file(fileURL, destfile="./whatever", mode="wb")

2) Switched to regular R, not R Studio,

Upvotes: 2

qinghua tong
qinghua tong

Reputation: 1

The xlsx file you are trying to read maybe damaged. Try redownload the file or read another "healthy" xlsx file.

Upvotes: 0

Related Questions