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

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 > h

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

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 wrote: > > i am unable to open a file which is saved as .xlsx format in R . The file > contains approximat

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

vikrant wrote: > > i am unable to open a file which is saved as .xlsx format in R . The file > contains approximately 1,50,000 > rows. > Use odbcConnectExcel2007 in package RODBC to read these data. >>So I m not able to save it as csv file. I do not understand why you want to use R to c

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

Dear V.K., 1. http://www.R-project.org/posting-guide.html 2. it is - in general - good someone that write to the list identify your self. It is a polite way of participate of the list. bests milton On Tue, Jan 19, 2010 at 12:15 AM, vikrant wrote:

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

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-tp1017273p101