search for: dataframes2xls

Hi R users: I don't know if you have had the following problem trying to export to an "xls" format file in a non windows platform. I try to use the following packages: 1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1) 2. WriteXLS (version 1.9.0) (with perl and testPerl working) Even "xlsx" package that take too long and do not finish. The data frame I try to export has 269363 row and 116 columns. In the first one (dataframe2xls) I get this message: Traceback...

...y be of interest to other people as well. Thank you for your answer, although it disappointed me a bit. I had already spent quite some time building a stand-alone windows binary of a new package "write2xls". This package provides the same R interface to Python as the other package "dataframes2xls". As you know it enable users to create xls files. The special thing about "write2xls" is that it does not have any dependencies at all. It is so-to-speak a turn-key solution. Of course I should have read a bit more before I started. Only after your mail I read the pdf-file "W...

Hello R users, I want to export to an xls or .csv some predictions I produced with the auto.arima and forecast functions. A detail of all my work is presented below. I loaded a package called dataframes2xls and tried to use the function write.xls without any success. Can anybody help me figure this out? How could I get R to export the output to an xls file? Any help will be greatly appreciated. > dryfit<-auto.arima(testing1$pcumsdry) > dryfit Series: testing1$pcumsdry ARIMA(2,1,1) with d...

Hi, I try to use write.xls from dataframes2xls inside a function. The write.xls work normally in console, but inside a function it dont find the object. Look this example: > library(dataframes2xls) > test <- function(x){ + a <- data.frame(A=c(1,2),B=c(10,11)) + write.xls(a,file="a.xls") + } > test() Erro em g...

...hen I do so all the data is merged into a single column in excel. I Would like the columns of my data frame in separate columns in excel as well but it doesn't work. I tried to download the package WriteXLS and installed Perl on my computer just like it was recommended. I also tried downloading dataframes2xls but none of them work. Is there an easier way of solving this? Would be very thankful for a reply! [[alternative HTML version deleted]]

...e facilities to write Excel files with multiple sheets. Unfortunately, I can't get any of them to work consistently for me. Below please find test cases that illustrate the problems. Any suggestions for how to solve this problem will be appreciated. Thanks, Spencer library(dataframes2xls) df1 <- data.frame(c1=1:2, c2=3:4, c3=5:6) df2 <- data.frame(c21=c(10.10101010101,20, 3), c22=c(50E50,60, 3) ) outFile <- 'df12.xls' write.xls(c(df1,df2), outFile) # works do.call(write.xls, list(c(df1, df2), outFile)) # Error in get(s[i]) : object 'structure(list(c1=1:2'...

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]]

CRAN (and crantastic) updates this week New packages ------------ Updated packages ---------------- New reviews ----------- This email provided as a service for the R community by http://crantastic.org. Like it? Hate it? Please let us know: cranatic at gmail.com.