Readin .xlsx file into R -
im trying read excel file r. it's following file in cwd:
> list.files() [1] "keuren_op_afspraak.xlsx" i installed xlconnect , doing following:
library(xlconnect) demoexcelfile <- system.file("keuren_op_afspraak.xlsx", package = "xlconnect") wb <- loadworkbook(demoexcelfile) but gives me error:
error: filenotfoundexception (java): file '' not found - may specify automatically create file if not existing. but dont understand coming from. thoughts?
i prefer using readxl package. written in c faster. seems handle large files better. command be:
library(readxl) wb <- read_excel("keuren_op_afspraak.xlsx")
Comments
Post a Comment