RExcel mention in the link below can transfer data from Excel 2007 to R. But you have to be on Windows, and you probably have to have Excel 2007. it might work if you have Excel 2003 with the (free) compatibility package installed.
On Jan 19, 2010, at 2:09 PM, Gabor Grothendieck wrote: > See > http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows > Most of the methods there work with xls files only but a few work with xlsx. > > On Tue, Jan 19, 2010 at 12:15 AM, vikrant <vikrant.shi...@tcs.com> wrote: >> >> 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. >> >> ______________________________________________ >> 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. > ______________________________________________ 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.
