[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. __ R-help@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.
Re: [R] How can I export a big data.frame to excel 2010 - file.xlsx?
Ms. Botrel, On 4 September 2012 13:52, PamelaBotrel pamela.bot...@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]] __ R-help@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.
Re: [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@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. __ R-help@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.