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: http://r.789695.n4.nabble.com/data-frame-and-import-to-xlsx-tp4659486.html Sent from the R help mailing list archive at Nabble.com.
data.frame and import to xlsx
3 messages · sisi26, Rui Barradas, jim holtman
Hello, I'm not sure I understand the question. You want to import an xlxs sheet to R? Look at package XLConnect. The vignette explains several ways of doing it. And as for the frame, the import functions in XLConnect (and the several read.* functions in base R) return data.frames so the problem should be solved. Hope this helps, Rui Barradas Em 23-02-2013 22:14, sisi26 escreveu:
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: http://r.789695.n4.nabble.com/data-frame-and-import-to-xlsx-tp4659486.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.
If you are going to use XLConnect to read in the .xlsx files, I would suggest that you might want to convert them to .xls files. Run a performance test to see if you have a problem. I use a lot of EXCEL files and have found that the performance (in both time and memory) is much better with .xls files.
On Sat, Feb 23, 2013 at 5:14 PM, sisi26 <benzakour_s at ymail.com> wrote:
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: http://r.789695.n4.nabble.com/data-frame-and-import-to-xlsx-tp4659486.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.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.