search for: rjavatools

...ted shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream > read.xlsx2(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl,...

...g 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 3.0.1 (2013-05-16) Platform: x86_64-w64-mingw32/x64 (64-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 [3...

I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all populated but getting the following error: Please advise as to how to get around this issue. > res <- read.xlsx("c:\\BSE_v2.xlsx",1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space Here is the session info: > sessionInfo() R version 2.12.1 (2010-12-16) Platform: i386-pc-mingw32/i386 (32-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=Eng...

Dear list, I'm running windows xp with R 2.12.0. I'm trying to load a excel spreadsheet into R using the xlsx package. I posted my code below with the error I get. > res <- read.xlsx("Copy of test_excel_input_data.xlsx", 6) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalStateException: Cannot get a numeric value from a text cell There are 6 sheets in that file. 5 of them are read into a dataframe without problem. For the 6th one(the one I actually need) I get this error mes...

...ings\\dmenezes\\Desktop") info<- read.xlsx("test_file.xlsx",sheetName="johnny",rowIndex=1:2,header=FALSE) info However, when I try to apply this to my real, large workbook, things go wrong, with the following error message. Any ideas/workarounds? Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space

...odrí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 space* De manera que no puedo abrir/importar el archivo en excel y seguir trabajando. Entiendo que se trata de un problema en la memoria de Java, pero no se como solucionarlo. ¿Alguien ha...

...t;google.gif" ) trying URL 'http://www.google.fr/intl/en_en/images/logo.gif' Content type 'image/gif' length 8558 bytes opened URL ================================================== downloaded 8558 bytes > image = IJ$openImage( "google.gif" ) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.InternalError: Can't start the AWT because Java was started on the first thread. Make sure StartOnFirstThread is not specified in your application's Info.plist or on the command line starting httpd help se...

...d rJython. Here is my latest snag: > library(rJython) Loading required package: rJava Loading required package: rjson > library(rSymPy) > rJython <- rJython() > x <- "x" > y <- "y" > rJython$exec("from sympy import *") Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : Traceback (most recent call last): File "<string>", line 1, in <module> ImportError: No module named sympy > This is on Windows 32 bit, with Version 3.0.1 of R and python 2.7.5. Also, sypmy is...

...r doing Var("x,y,z") ) > sympyq(4+4) sympy("4 + 4") [1] "8" > sympyq(3*x+4*y+89*z-6*x) sympy("3 * x + 4 * y + 89 * z - 6 * x") [1] "-3*x + 4*y + 89*z" > But then: > sympyq( (x+y)**2 ) sympy("(x + y)^2") Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : Traceback (most recent call last): File "<string>", line 1, in <module> TypeError: unsupported operand type(s) for ^: 'Add' and 'int' Note that R has changed the syntax **2 to ^2, whi...

...help at r-project.org> Betreff:?Re: [R] write.xlsx error message ? Thu, 14 Mar 2024 14:12:12 +0000 Subia Thomas OI-US-LIV5 <Thomas.Subia at draexlmaier.com> ?????: > Using write.xlsx to extract data from an Excel file, I get this error > message. > > > Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", > cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded There seems to be a default limit of 512 megabytes for the Java heap size: library(rJava) getOption('java.parameters') # [1] "-Xmx512m" Does if hel...

...> Java Exception <no description because toString() failed>.jarray(v)<S4 > > object of class "jobjRef"> > > > saveWorkbook(exc) > > Error in .jcheck() : > > Java Exception <no description because toString() > > failed>.jcall("RJavaTools", "Z", "hasMethod", .jcast(x, > > "java/lang/Object"), name)<S4 object of class "jobjRef"> > > > > El 26 de julio de 2016, 13:25, Javier Martínez-López < > > javier.martinez en bc3research.org> escribió: > > >...

...o: > > 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 space* > > De manera que no puedo abrir/importar el archivo en excel y seguir trabajando. Entiendo que se trata de un problema en la memoria de Java, pero no se como solucionarlo....

Colleagues, Using write.xlsx to extract data from an Excel file, I get this error message. Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded I was thinking that this might be a RAM issue but with 16 GB RAM, I wasn't expecting this error message. Any guidance would be appreciated. Mit freundlichen Gruess...

? Thu, 14 Mar 2024 14:12:12 +0000 Subia Thomas OI-US-LIV5 <Thomas.Subia at draexlmaier.com> ?????: > Using write.xlsx to extract data from an Excel file, I get this error > message. > > > Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", > cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded There seems to be a default limit of 512 megabytes for the Java heap size: library(rJava) getOption('java.parameters') # [1] "-Xmx512m" Does if he...

...nnect(log.level="finest") R version 2.14.2 (2012-02-29) rJava Version 0.9-3 RBloomberg Version 0.4-151 Java environment initialized successfully. Looking for most recent blpapi3.jar file... Adding C:\blp\API\APIv3\JavaAPI\v3.4.6.6\lib\blpapi3.jar to Java classpath Error in .jcall("RJavaTools", "Z", "classHasField", x, name, static) : RcallMethod: cannot determine object class Anyone got a clue about this one? Can't seem to find the same error message elsewhere. -- View this message in context: http://r.789695.n4.nabble.com/Problem-using-RBloomberg-blpC...

...s = "-Xms=3670K") > writeWorksheet(wb, SP, sheet = "SP") alos this one options(java.parameters = "-Xmx1000m") > writeWorksheet(wb, SP, sheet = "SP") Erreur dans .jcheck() : Java Exception <no description because toString() failed>.jcall("RJavaTools", "Z", "hasField", .jcast(x, "java/lang/Object"), name)<S4 object of class "jobjRef"> The size of my data is very very huge ( i have to create 3187 sheets of xlsx to pute the label of variables -- View this message in context: http://r.789695.n...

...odrí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 space* De manera que no puedo abrir/importar el archivo en excel y seguir trabajando. Entiendo que se trata de un problema en la memoria de Java, pero no se como solucionarlo. ¿Alguien ha...

Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado 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)

offline? te lo envío a tu email, pq no creo que a toda la lista sea buena idea. El 15 de agosto de 2014, 9:47, Jorge I Velez <jorgeivanvelez en gmail.com> escribió: > De nada, Miguel. Es posible que me envies el archivo offline? --JIV > > > > 2014-08-15 17:45 GMT+10:00 Miguel Fiandor Gutiérrez < > miguel.fiandor.gutierrez en gmail.com>: > > Gracias