Reading xlsx file in R

Question

I have used this code:

library(openxlsx)
fileUrl <- "http://d396qusza40orc.cloudfront.net/getdata%2Fdata%2FDATA.gov_NGAP.xlsx"
d <- download.file(fileUrl,destfile = "C:/Users/skoma/Desktop/data/dat.xlsx")
data <- read.xlsx("dat.xlsx")

This is the error coming up:

Error in file(con, "r") : invalid 'description' argument In addition: Warning message: In unzip(xlsxFile, exdir = xmlDir) : internal error in 'unz' code

Try getting rid of `d<-` that has you assigning the actions of `download.file()` to a variable. It may work after than provided you are in the right working directory — sconfluentus, May 12 '20 at 07:45

score 1 · Answer 1 · edited Sep 22 '20 at 05:26

1

First, you should not passing download.file to a variable (d). Then, you want to download that particulary xlsx as a binary file to work. So try this

download.file(fileUrl,destfile = "C:/Users/skoma/Desktop/data/dat.xlsx",mode = "wb")

where mode = "wb" is for binary. It works for me.

edited Sep 22 '20 at 05:26

David Buck

3,752
35
31
35

answered Sep 21 '20 at 22:53

Sebastian Parra Contreras

11
3

score 0 · Answer 2 · answered May 12 '20 at 09:27

0

Try this

library(openxlsx)

fileUrl <- "http://d396qusza40orc.cloudfront.net/getdata%2Fdata%2FDATA.gov_NGAP.xlsx"

data <- read.xlsx (fileUrl) #read excel file 

write.xlsx(data, "data.xlsx") # write excel file to source

answered May 12 '20 at 09:27

Arun kumar mahesh

2,289
2
14
22

Reading xlsx file in R

2 Answers2