PamelaBotrel
2012-Sep-04 20:52 UTC
[R] 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: http://r.789695.n4.nabble.com/How-can-I-export-a-big-data-frame-to-excel-2010-file-xlsx-tp4642223.html Sent from the R help mailing list archive at Nabble.com.
Hasan Diwan
2012-Sep-04 21:26 UTC
[R] How can I export a big data.frame to excel 2010 - file.xlsx?
Ms. Botrel, On 4 September 2012 13:52, PamelaBotrel <pamela.botrel@hotmail.com> wrote:> 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! >Several options... 1. write.csv import into Excel and save to an XLSX 2. there is an xlsx package on cran that also, theoretically works. I say, theoretically, because I have no use for Excel on my systems. Let me know how you get on... -- H -- Sent from my mobile device Envoyait de mon portable [[alternative HTML version deleted]]
Rui Barradas
2012-Sep-04 21:45 UTC
[R] How can I export a big data.frame to excel 2010 - file.xlsx?
Hello, Try package XLConnect. The vignette has several examples, and so do the help pages, for instance, ?XLConnect You should also get rid of excel and use R for serious work. And even not so serious. Hope this helps, Rui Barradas Em 04-09-2012 21:52, PamelaBotrel escreveu:> 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: http://r.789695.n4.nabble.com/How-can-I-export-a-big-data-frame-to-excel-2010-file-xlsx-tp4642223.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.