similar to: data.frame and import to xlsx

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"

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 =

Dear r helpers; I'm interested in reading from and writing to large .xlsx files fairly regularly. (Why, the naysayers may ask - and the answer is basically colleagues and clients who prefer that format). I've tried out the XLConnect and xlsx libraries, but the java implementation they use just takes too much RAM for the files I'm working with. gdata leverages perl and works really

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

Hi, I tried to read a (small) xlsx file by "readWorksheetFromFile" function of "XLConnect" package and "read.xlsx" function in "xlsx" package, but I got this error message: Error: OutOfMemoryError (Java): Java heap space I tried to follow the solution on the web

Hi, I need some help to export a data frame with 83 rows and 1411 colums. I have used the package RODBC until now. But now, I have 1411 colums that I can't send to the old excel. If anybody knows a package to convert my data frame in xlsx tell me! Thanks for help in advance! Pamela Botrel -- View this message in context:

Dear all, How can I read .xlsx files in R Regards Nico [[alternative HTML version deleted]]

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Hi, I hope you guys can help me, I already posted this question on stackoverflow but did not get any help (which worked). And I need to solve this problem as quick as possible: In our firm we migrated to windows 7 (64-bit) and also updated the java packages (1.6.0_24) and also R (to 2.15). Then I tried to install my packages which i use daily and one of em is the xlsx package. But if I load the

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.

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

Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here:

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

Hi, I have two questions on the function "readNamedRegionFromFile" in XLConnect pacakge. 1. In the documentation, # multiregion xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/multiregion.xlsx", package = "XLConnect") # Load a single named region into a single data.frame. df

Dear R Discussion List, I would like to save my data as a xlsx file. But at first I need to split it and then save each series into a Excel column. Please take a look at the following code: dados <- data.frame(matrix(c("2012-01-01","2012-02-01", "2012-03-01","2012-04-01","2012-05-01","2012-06-01",

Hola amigos, buenos días Esto sigue avanzando. Estoy ahora tratando de establecer la conectividad de R con Excel y he seguido dos viídeos en YouTube de una profesora llamada Bebilda que se explica muy bien. Con ambos tengo el mismo problema así que planteo uno de ellos, éste es: https://youtu.be/_pSJQO_9I4k?list=PL7DA3FDA21A1A6310 Pero os lo explico brevemente: Cargo el paquete RODBC >

Hi all, I experience a segfault when calling gplots::heatmap.2(), but only when certain other packages are loaded. I am not sure for the correct place to send this bug report. Should I send it to the package maintainers directly? If R-help is the wrong place, please feel free to direct me to the correct one. I am on debian (testing) linux 64 with the binary R distribution from the

Hi all, I experience a segfault when calling gplots::heatmap.2(), but only when certain other packages are loaded. I am not sure for the correct place to send this bug report. Should I send it to the package maintainers directly? If R-help is the wrong place, please feel free to direct me to the correct one. I am on debian (testing) linux 64 with the binary R distribution from the

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

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.