search for: xlsxjar

Dear R users, Im trying to load *"xlsx"* package which depends on *"xlsxjars"* and * "rJava"* packages. All the 3 packages (zipped files) are installed successfully in windows. I have added "C:\Program Files\Java\jre1.6.0_03\bin\client" to the PATH variable to get rJava working. However, the following error message results after inputting 'l...

HI, I was trying to install xlsx package for reading in Excel 2007 files. The installation went smoothly. But when I tried to load the library, I got the following error message: > library(xlsx) Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'xlsxjars', details: call: .jinit() error: cannot obtain Class.getSimpleName method ID Error: package 'xlsxjars' could not be loaded The help page of the xlsx package has a note "NOTE: You may...

Hi all, I am trying to run the package xlsx to read Excel 2007 files and I am getting the error below. > library(xlsx) Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'xlsxjars', details: call: .jinit() error: cannot obtain Class.getSimpleName method ID Error: package 'xlsxjars' could not be loaded By looking up this in the mailing list I have seen that it is an e...

....1/XLConnect?Warning in install.packages : installation of package ?XLConnect? had non-zero exit status Con xlsReadWrite -> me dice que no está disponible para R 3.1.1 Con xlsx -> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?xlsxjars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/xlsxjars?Warning in install.packages : installation of package ?xlsxjars? had non-zero exit statusERROR: dependency ?xlsxjars? is not available for package ?xlsx?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/xlsx?Warning...

...tatus >>>> >>>> Con xlsReadWrite -> me dice que no está disponible para R 3.1.1 Con >>>> xlsx -> >>>> >>>> >>>> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?xlsxjars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/xlsxjars?Warning in install.packages : >>>> installation of package ?xlsxjars? had non-zero exit statusERROR: dependency ?xlsxjars? is not available for package ?xlsx?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library...

...ation of package ?XLConnect? had non-zero exit status >> >> Con xlsReadWrite -> me dice que no está disponible para R 3.1.1 Con xlsx >> -> >> >> >> Error : package ?rJava? was built before R 3.0.0: please re-install itERROR: lazy loading failed for package ?xlsxjars?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/xlsxjars?Warning in install.packages : >> installation of package ?xlsxjars? had non-zero exit statusERROR: dependency ?xlsxjars? is not available for package ?xlsx?* removing ?/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/xls...

Hi Hilmar, weird. The memory problem seems be due to recursion (my R, version 3.3.3, says: Error: evaluation nested too deeply: infinite recursion / options(expressions=)?, just write traceback() to see how it happens), but why does it segfault with xlsx? Nb xlsx is the culprit: neither rJava nor xlsxjars cause the problem. On the other hand, quick googling for r+xlsx+segfault returns tons of reports of how xlsx crashes in dozens of situations. See for example http://r.789695.n4.nabble.com/segfault-in-gplots-heatmap-2-td4641808.html. Also, the problem might be platform-specific. It would be intere...

...de internet y después de prepararla un poco necesito exportarla a Excel he intentando con las dos opciones que mencionaré al final pero ninguna funciona, de qué otra manera puedo exportar esos datos a Excel... muchas gracias por su ayuda y pronta respuesta! 1) library(xlsx) library(rJava) library(xlsxjars) write.xlsx(mydata, file="mydata.xlsx") 2) library(xlsReadWrite) #abrimos el paquete write.xls(prueba, file="datanueva.xls",sheet="lapop10") [[alternative HTML version deleted]]

...or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > library(limma) > library(xlsx) Loading required package: rJava Loading required package: xlsxjars > > sessionInfo() R version 3.3.0 (2016-05-03) Platform: x86_64-pc-linux-gnu (64-bit) Running under: Ubuntu 14.04.5 LTS locale: [1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8 [4] LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8 [7] L...

Hi, I am facing trouble when trying to read large xlsx file into R. please find the code and error below. The file I was trying to read has 36,500 rows X 188 col, ~ 37 MB size. > options( java.parameters = "-Xmx4g" ) > library(xlsx) Loading required package: xlsxjars Loading required package: rJava > cftc = read.xlsx("d:\\Krishna\\Research\\CFTC_COT\\cftcdata.xlsx", 1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space > sessionInfo() R version...

...representation("list") > ) > ma = new("FOOCLASS", list(M=matrix(rnorm(300), 30,10))) > >> ma * ma$M > Error: C stack usage 7970512 is too close to the limit > >> library(xlsx) > Loading required package: rJava > Loading required package: xlsxjars >> ma * ma$M > ---> Crash > > xlsx seems to act like a catalyst here, with the product operator > running in a deep nested iteration, exhausting the stack. Valgrind shows > thousands of invalid stack accesses when loading xslx, which might > contribute to the problem. Pa...

Buenos días, Me gustaría compartir una duda con la que me acabo de encontrar y no se como solucionar, por si podrías echarme una mano: Trabajo con bases de datos en R que importo de excel. Cargando las librerías de: rJava , xlsxjars y xlsx. Al principio no parecía haber ningún inconveniente, pero después de un tiempo de trabajo me aparece el siguiente error en la consola de datos: *Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap sp...

...memory problem seems be due to recursion (my R, version > 3.3.3, says: Error: evaluation nested too deeply: infinite recursion / > options(expressions=)?, just write traceback() to see how it happens), > but why does it segfault with xlsx? Nb xlsx is the culprit: neither > rJava nor xlsxjars cause the problem. > > On the other hand, quick googling for r+xlsx+segfault returns tons of > reports of how xlsx crashes in dozens of situations. See for example > http://r.789695.n4.nabble.com/segfault-in-gplots-heatmap-2-td4641808.html. > Also, the problem might be platform-s...

...######## #or ######## options(java.parameters = "-Xmx1000m") ####### but it did not work. I wonder if I need to detach the packages before adding that line ######## detach("package:XLConnect", unload=TRUE) detach("package:xlsx", unload=TRUE) detach("package:xlsxjars", unload=TRUE) detach("package:XLConnectJars", unload=TRUE) detach("package:rJava", unload=TRUE) options(java.parameters = "-Xmx8000m") library(XLConnect) library(xlsx) ####### but it did not work. I am on a Mac, with very new OS and very new R version. R v...

...Where it says: install rJava 0.9.2. rJava.dll is located in the file path indicated by the error message below. Not sure why it's now saying "The specified path is invalid" Does anyone now the fix to this problem? > library(xlsx) Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'rJava', details: call: inDL(x, as.logical(local), as.logical(now), ...) error: unable to load shared object 'C:/R/R-2.15.1/library/rJava/libs/i386/rJava.dll': LoadLibrary failure: The specified pa...

Hola, Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con mi problema en internet, y que las soluciones ofrecidas no terminan de funcionar. Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes y nada: require(RODBC) conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file sqlTables(conn)$TABLE_NAME # show all sheets df =

...d, mode = "wb", ...) : downloaded length 9027584 != reported length 9041607 2: In unzip(zipname, exdir = dest) : error 1 in extracting from zip file 3: In read.dcf(file.path(pkgname, "DESCRIPTION"), c("Package", "Type")) : cannot open compressed file 'xlsxjars/DESCRIPTION', probable reason 'No such file or directory' Has anyone else experienced this. Any way round it? Thanks -- View this message in context: http://r.789695.n4.nabble.com/Cannot-install-package-xlsx-tp4643054.html Sent from the R help mailing list archive at Nabble.com.

...MMA: setClass("FOOCLASS", representation("list") ) ma = new("FOOCLASS", list(M=matrix(rnorm(300), 30,10))) > ma * ma$M Error: C stack usage 7970512 is too close to the limit > library(xlsx) Loading required package: rJava Loading required package: xlsxjars > ma * ma$M ---> Crash xlsx seems to act like a catalyst here, with the product operator running in a deep nested iteration, exhausting the stack. Valgrind shows thousands of invalid stack accesses when loading xslx, which might contribute to the problem. Package xlsx has not been updat...

...t;> ma = new("FOOCLASS", list(M=matrix(rnorm(300), 30,10))) >> >>> ma * ma$M >> >> Error: C stack usage 7970512 is too close to the limit >> >>> library(xlsx) >> >> Loading required package: rJava >> Loading required package: xlsxjars >>> >>> ma * ma$M >> >> ---> Crash >> >> xlsx seems to act like a catalyst here, with the product operator >> running in a deep nested iteration, exhausting the stack. Valgrind shows >> thousands of invalid stack accesses when loading xslx,...

Buenos días, Gracias Carlos, siguiendo el ejemplo que comentas, esto es lo que he introducido en el Scrip de RStudio: *library(xlsx)* *library(xlsxjars)* *library(rJava)* *library(aod)* *R<-read.csv("2002.CSV", sep=";", dec=",", header=T)* *attach(R)* *group<-gl(2,670,1340,labels= c("AVE", "Log.Imports.Value.in.1000.USD"))* *weight<-c(AVE,Log.Imports.Value.in.1000.USD)* *TUN<-lm(weig...