[R] how to open excel 2007 (.xlsx) file in R

Erich Neuwirth erich.neuwirth at univie.ac.at
Tue Jan 19 14:23:42 CET 2010


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.shimpi at 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 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.
>> 
> 
> ______________________________________________
> 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.
> 



More information about the R-help mailing list