R xlsx package error

Question

Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,  : 
  java.util.zip.ZipException: invalid code -- missing end-of-block

Does anyone have this error when you try to use

dat <- read.xlsx("data.xlsx", sheetIndex=1, colIndex=colIndex, rowIndex=rowIndex)?

Having the same problem. Taking the same course :) Too bad the those Coursera instructors from JH don't seem to have much time to update slides or correct questions. The solution by @Deep-B fixed my problem. The download must corrupt the file somehow so it can't be read properly. Using WB fixed it. — Rick Henderson, Mar 04 '16 at 18:24
@user3758532 - Were you able to solve this issue? I am facing this with `tabulizer()` in `R` — Chetan Arvind Patil, Oct 17 '18 at 03:18

score 52 · Answer 1 · answered Feb 11 '15 at 00:03

I had this problem with a file downloaded from the internet using R command line, for an online course. Found that apparently the download mode needs to be set properly as write-binary (wb) since xlsx is basically a binary file (zip). Who knew?

If that's what you did too, re-download the file with the mode set properly; like:

download.file(fileUrl, destfile='./data/sample.xlsx', mode='wb')

score 1 · Answer 2 · answered Feb 05 '15 at 17:43

1

The version of java you have installed is likely incompatible with the xslx package. Try replacing your default java with the 64 bit version: https://www.java.com/en/download/faq/java_win64bit.xml.

answered Feb 05 '15 at 17:43

Richard Border

3,209
16
30

R xlsx package error

2 Answers2

Linked

Related