Displaying 20 results from an estimated 10000 matches similar to: "xlsx file read in R"
2011 Jul 13
7
Error when writing to Excel files using the packages xlsx and xlsx2
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
2013 Jan 09
2
writing to .xlsx
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
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following:
library(RODBC)
> channel <- odbcConnectExcel("results.xlsx")
Error in odbcConnectExcel("results.xlsx") :
odbcConnectExcel is only usable with 32-bit Windows # ok this is
clear why it doesn't work
> channel
2013 Feb 23
3
data.frame and import to xlsx
Hi,
i have a very huge number of data with the size 2375ko, i want to import
them for R to xlsx
but the size of excel is limited
How can i resolve this problem?
And please how can i define the frame
Note that i have a table
rows times c(1.....100) columns WLc(200...1000) and inside S c(15,.........)
the table it is full values
--
View this message in context:
2012 May 09
4
Can't read xlsx file into R. Seem, Seem to have XLConnect loaded.
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"
2013 Jul 22
1
problem loading large xlsx file into r
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 =
2017 Nov 30
4
xlsx Fuera de memoria
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
2016 Apr 23
1
Java memory error when reading a small xlsx file
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
2011 Aug 12
1
Extract named regions from an Excel file using XLConnect?
Hi Everybody
In R, the XLConnect package can read and write named region to and from
Excel. In order to read a named region with the readNamedRegion function you
need to know it's name. You can check is a name exists with existsName, but
you still have to know the name. Is there a way to actually get a list of
the named regions in XLConnect sinilar to getRanges in the xlsx package.
On that
2010 Jan 19
4
how to open excel 2007 (.xlsx) file in R
i am unable to open a file which is saved as .xlsx format in R . The file
contains approximately 1,50,000
rows. So I m not able to save it as csv file.Please suggest ways to open
this file
--
View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html
Sent from the R help mailing list archive at Nabble.com.
2012 Sep 04
2
How can I export a big data.frame to excel 2010 - file.xlsx?
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:
2011 Feb 09
3
Problem with xlsx package
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:
2012 May 25
1
Java problem - XLConnect/xlsx package
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
2024 Mar 15
1
write.xlsx error message
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.
2015 Nov 12
3
Problema con la lectura de datos
Otra opción es importar directamente los datos que necesites usando
XLConnect (sin llevarlos a CSV).
Ese paquete permite hacer cosas muy potentes desde el propio fichero de
Excel.
https://cran.r-project.org/web/packages/XLConnect/index.html
Recomiendo, encarecidamente, la lectura de sus dos vignettes.
Un Saludo,
--
Miguel Ángel Rodríguez Muíños
Dirección Xeral de Saúde Pública
Consellería de
2012 Oct 16
1
Problems with xlsx and rjava
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:
2011 Jun 24
3
extract worksheet names from an Excel file
Hi list,
Is there a R function I can use to extract the worksheet names from an Excel file?? If no, any other automatic ways (not using R) to do this?
thanks!
...Tao
2011 Jun 23
3
trying to import xls or xlsx files
library(xlsReadWrite)
mydata<-read.xls("file path", header=TRUE)
however if I change xls to csv it works just fine. Any ideas what I'm doing
wrong? I have have also using the package gdata with the exact same error.
Below is the error that pops up.
Error in findPerl(verbose = verbose) :
perl executable not found. Use perl= argument to specify the correct path.
Error in
2010 Apr 07
1
Exporting data to .xlsx file
I imported data from teradata to R data frames.Now i want to export this
data to .xlsx file ( not .xls since it doesn't support large data set).
I have tried dataframes2xls package but it needs python/perl which I don't
have on my computer.
Could any one help me resolve this issue.
Thanks
Sumit
[[alternative HTML version deleted]]
2011 Nov 30
3
importar simultaneamente varios archivos excel
Hola.
En un cierto directorio tengo archivos excel y de otros tipos.
Cada uno de ellos corresponde a una encuesta a una empresa X.
Me gustaria importar los datos de ciertas celdas de ciertas hojas de
todos los archivos excel en una sola pasada.
¿Hay alguna forma de hacerlo?
Yo se que la variable Z está siempre en la celda X de la hora tanto.
Me gustaría ingresarlo todo en una matriz en que