Displaying 20 results from an estimated 2000 matches similar to: "How can I export a big data.frame to excel 2010 - file.xlsx?"
2012 Feb 01
1
R-squared, how can I do to put this in a vector?
I'm needing to remove the R-squared , and put this in a vector. It's the same
that I do with the Beta or alfa in a linear regression:
beta <- vector() ## beta
for (i in 1:ncol(ret)){
beta[i] <- summary(lm((ret[,i] - ret.selic.ibov[,1]) ~ rmrf[,1] +
max[,1]))*$coef[[2]]*
}
So, I need to know what I'll put after* $*.
Thanks.
--
View this message in context:
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:
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
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 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
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
2012 Dec 03
5
xlsx file read in R
Dear all,
How can I read .xlsx files in R
Regards Nico
[[alternative HTML version deleted]]
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
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:
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.
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
2010 Sep 06
1
Help on write.xlsx library(xlsx)
Hi Adrian,
dat=data.frame(matrix(0,3,3))
write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F)
write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F)
The above code works and creates new worksheets. But if I want to append
to an existing worksheet I seem to get an error.
2011 Aug 15
3
how can I read a xlsx file
Hello,
How can I read a xlsx file using xlsx package?
Thanks
Albert
[[alternative HTML version deleted]]
2009 Apr 27
1
RODBC - XLSX files - dropping/clearing sheets
Hi!
I'm manipulating XLSX data using RODBC, however a limitation which appears
to be driver based is that you can't clear or drop sheets from the XLSX
files, as per the following example:
> library(RODBC)
> xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,
*.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx;
ReadOnly=False")
>
2010 Feb 12
2
Help on loading "xlsx" package
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
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.
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:
2011 Mar 28
2
xlsx problem
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
2011 Aug 23
1
NA in last row while reading xlsx file
Hi,
I am using this script to read a xlsx file to a data frame:
library(xlsx)
File <- file.path("d:", "car ", "car95-99.xlsx")
B_car <- read.xlsx(File, "raw_data")
Car2x <- data.frame(month = B_car$Date,Ch = B_car$Ch.des,
lat=B_car$Latitude)
The last row in the data.frame is always NA, how can I remove it?
Thx.
--
View this message in