similar to: Java memory error when reading a small xlsx file

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 =

Hola, estoy trabajando con el paquete xlsx y el xlConnect y ambos presentan este mismo error. Error in .jcall(cell, "V", "setCellValue", value) : java.lang.OutOfMemoryError: Java heap space Alguien conoce una solución. Alguien conoce otro paquete para guardar documento de excel y que no involucre el uso de Java. -- *Wilmer Contreras Sepulveda* *Grupo de Investigación

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:

I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue. Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc. ? ? Gesendet:?Freitag, 15.

Hola, @javier, me gustaría no tener que hacer nada de forma manual, ni por fuera de r, rstudio. Es decir, el típico comando de linux que me convierta de xls a csv prefiero no usarlo. Me gustaría hacerlo todo desde R. @jorge -> Con RODBC me salta -> Error: could not find function "odbcConnectExcel" Lo que creo que es inevitable en Ubuntu

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

Gracias Jorge por contestar tan rápido. Con gdata hago eso del path, y directamente con el fichero, lo vi en una web, y he intentado todas las opcioens que he visto. En vez de install.packages('rJava', type = 'source') he hecho install.packages('rJava') Ahora probaré, y lo mismo con scan y readLines. He visto en stackoverflow que mi problema puede ser actualizar java,

I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"

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

Estimada Lorena Creo que lo comentado por Miguel y su interpretación de memoria son correctos, pero me permito una prueba, desde Rcmdr hay una opción para importar datos de Excel, esa alternativa ¿también falla?. Me refiero a intentar abrir un archivo con los datos que necesita, por las dudas en que aparezca algún mensaje distinto, que no creo, pero son solo 10 segundos de prueba. ¿Puede

Hi, i want to create xlsx sheet, all things seems to be perfect until this erro message Erreur : OutOfMemoryError (Java): Java heap space i have xp system, (32bit) I tried the following syntax > options(java.parameters = "-Xmx1000m") > options(java.parameters = "-Xms=3670K") > writeWorksheet(wb, SP, sheet = "SP") alos this one options(java.parameters =

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 =

Buenas tardes, Solicito por favor ayuda con este error: Error: OutOfMemoryError (Java): Java heap space Estoy trabajando con matrices de grandes dimensiones y el programa no logra completarse porque dice le falta memoria. Gracias [unnamed] Sara Suarez Zapata Estudiante en práctica - Unidad Gestion Bolsa de Energia. Tel: (574) 380 61 18 Correo: sara.suarez en

Hi experts, I want to read data from an excel data like this: for the fifth column, from first row until 140 but only 1,3,5,7,.....139 (only 70 values), How can I do it in R? thanks [[alternative HTML version deleted]]

Any ideas of what is happening when I attempt to load XLConnect? I think I installed everything correctly. I posted what I get when I installed rJava as well as when I attempted to load rJava directly. Thanks in advance for any help you can give on this. library(XLConnect) Loading required package: XLConnectJars Loading required package: rJava Error : .onLoad failed in loadNamespace() for

All, I am trying to get the XLConnect package to work on one of my servers and I am getting an error that XLConnectJars cannot create the java virtual machine. The server is a 32-bit Windows Server 2003 machine with R 2.15.1. The version of Java installed on the server is J2SE Environment 5.0 update 8. I know this not the latest version of Java, and I will try to update it when I get

Hi, I tried to read xlsx files by "XLConnect" packages, but the dates are one day earlier than it is supposed to be. I moved from California to Taiwan (Eastern Asia), and it worked well in California, but not in Taiwan. Even if I adjust my Mac time to California time zone, it gives the wrong dates. I don't know which part of the setting (in RStudio or in my Mac?) I should adjust.

? 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

> On Sep 23, 2017, at 6:30 AM, Eric Berger <ericjberger at gmail.com> wrote: > > Jim, > I don't see how that link could be related to John's issue. Symptoms > related to your link involve discrepancies of four years whereas John is > seeing discrepancies of one day. > The MS Excel starting point was off by one day. R does not repeat that error. MS claims that

Jim, I don't see how that link could be related to John's issue. Symptoms related to your link involve discrepancies of four years whereas John is seeing discrepancies of one day. John, I do not see any attached files. Regards On Sat, Sep 23, 2017 at 1:30 PM, Jim Lemon <drjimlemon at gmail.com> wrote: > Hi John, > It could be due to this: > >